Senior Oracle PL/SQL Developer (Los Angeles Locals only) at Los Angeles, California, USA |
Email: hr@shayaancorp.com |
https://shorturl.at/zCvmO https://jobs.nvoids.com/job_details.jsp?id=2222168&uid= Job Title: Senior Oracle PL/SQL Developer (12+ Years of Experience) Location: Los Angeles, CA (Hybrid) Only Los Angeles, Local Candidates Rate: $72/hr on C2C Job Summary: We are looking for a highly experienced Senior Oracle PL/SQL Developer with over 12 years of hands-on experience in designing, developing, and optimizing Oracle database solutions. The ideal candidate will have a strong background in Oracle PL/SQL programming, database architecture, and performance tuning. This role requires expertise in developing complex stored procedures, functions, and packages, as well as the ability to lead projects, mentor junior developers, and collaborate with cross-functional teams to deliver robust database solutions. Key Responsibilities: Design, develop, and maintain complex Oracle PL/SQL code, including stored procedures, functions, packages, and triggers. Optimize SQL queries and PL/SQL code for performance, scalability, and reliability in high-volume environments. Collaborate with database architects, analysts, and application developers to design and implement efficient database schemas and data models. Develop and maintain ETL processes to integrate data from various sources into Oracle databases. Troubleshoot and resolve database performance issues, query optimization, and data integrity challenges. Create and maintain technical documentation, including database design, data flow diagrams, and process workflows. Lead and mentor junior developers, providing guidance on best practices and advanced PL/SQL techniques. Work closely with application teams to ensure seamless integration between Oracle databases and applications. Implement and enforce database security measures, including access controls, roles, and privileges. Stay updated with the latest Oracle database technologies, tools, and trends, and recommend improvements to existing systems. Participate in code reviews, ensuring adherence to coding standards and best practices. Qualifications: Education: Bachelors or Masters degree in Computer Science, Information Technology, or a related field. Experience: 12+ years of professional experience as an Oracle PL/SQL Developer or in a similar role. Technical Skills: Expert-level proficiency in Oracle PL/SQL programming. Strong experience with Oracle Database (11g, 12c, 19c, or later). Advanced knowledge of database design, normalization, indexing, and partitioning. Hands-on experience with performance tuning, query optimization, and execution plan analysis. Proficiency in developing and maintaining ETL processes using tools like Oracle Data Integrator (ODI) or SQL*Loader. Experience with Oracle Advanced Queuing (AQ), Materialized Views, and Analytic Functions. Familiarity with Oracle Cloud Infrastructure (OCI) and Autonomous Database is a plus. Knowledge of scripting languages (e.g., , Python) for automation and data processing. Experience with version control systems (e.g., Git, SVN) and CI/CD pipelines. Preferred Qualifications: Oracle certifications (e.g., Oracle PL/SQL Developer Certified Professional, Oracle Database Administrator Certified Professional). Experience with other relational databases (e.g., SQL Server, MySQL, PostgreSQL). Knowledge of data warehousing concepts and tools (e.g., Oracle Exadata, Snowflake). Familiarity with Agile/Scrum methodologies. Regards: Vamsi hr@shayaancorp.com | O. 732 798 5943 Shayaan Corporation -- Keywords: continuous integration continuous deployment information technology procedural language California Senior Oracle PL/SQL Developer (Los Angeles Locals only) hr@shayaancorp.com https://shorturl.at/zCvmO https://jobs.nvoids.com/job_details.jsp?id=2222168&uid= |
hr@shayaancorp.com View All |
12:42 AM 04-Mar-25 |