Senior Oracle Developer

Our client, a leading public sector organization, is seeking a Senior Oracle Developer.

Apply today for consideration!

Job Title: Senior Oracle Developer
Location: Downey, CA - Remote
Duration: 12+ Month
Pay range: $55 to $60 per hour (DOE)


Job Description:

• Design, develop, and maintain Oracle database solutions using Oracle 19c, PL/SQL, SQL*Plus, and TOAD.
• Develop, optimize, and troubleshoot complex PL/SQL packages, procedures, functions, triggers, and SQL queries.
• Design and implement efficient database schemas, data models, and performance optimization strategies.
• Monitor and tune Oracle databases using Query Optimizer, Execution Plans, Indexing, and database statistics.
• Develop and maintain Unix/Linux shell scripts to automate database operations and execute SQL scripts.
• Implement database backup, recovery, and disaster recovery strategies to ensure data availability.
• Work with advanced Oracle features including Table Partitioning, Materialized Views, Table Functions, Collections, Analytical Functions, Query Rewrite, and Transportable Tablespaces.
• Support data warehouse initiatives and ETL processes using tools such as Actian/Pentaho.
• Install, configure, administer, maintain, and troubleshoot Oracle and other database management systems.
• Collaborate with cross-functional teams to support database development, maintenance, and production environments.

Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• 5+ years of experience as an Oracle PL/SQL Developer.
• 5+ years of hands-on experience with Oracle 19c, PL/SQL, SQL*Plus, TOAD, and client-server application development.
• Strong experience with Oracle performance tuning including Query Optimizer, Execution Plans, SQL optimization, and Indexing.
• Experience with advanced Oracle database features including Table Functions, Table Partitioning, Materialized Views, Collections, Analytical Functions, Query Rewrite, and Transportable Tablespaces.
• 3+ years of experience developing Unix/Linux Shell Scripts (Bash, KornShell, Bourne Shell, or C Shell).
• 2+ years of experience with Data Warehouse concepts and ETL processes.
• Experience with database administration, backup and recovery, disaster recovery, database design, and data modeling.
• Familiarity with Microsoft SQL Server, MySQL, PostgreSQL, and MongoDB is a plus.
• Excellent verbal and written communication skills.

Russell Tobin offers eligible employee's comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance and hospital indemnity), 401(k)-retirement savings, life & disability insurance, an employee assistance program, legal support, auto, home insurance, pet insurance and employee discounts with preferred vendors.

Equal Employment Opportunity
Russell Tobin is an equal opportunity employer. We do not discriminate on the basis of the race, religious creed, color, national origin, ancestry, physical disability, mental disability, reproductive health decision making, medical condition, genetic information, marital status, sex, gender, gender identity, gender expression, age, sexual orientation, veteran or military status, or any other characteristic protected by applicable federal, state, or local law.


Fair Chance Employment
Russell Tobin is a Fair Chance employer. We consider all qualified applicants, including those with criminal histories, in a manner consistent with applicable state and local Fair Chance laws and ordinances, including, the California Fair Chance Act and all applicable local Fair Chance ordinances.


Accommodations
We are committed to providing reasonable accommodations to applicants and employees with disabilities. If you require a reasonable accommodation to participate in the application or interview process, or to perform the essential functions of this role, please contact us.


Only applicable for San Francisco Candidates: Under the San Francisco Lactation in the Workplace Ordinance, we will provide written notice of lactation accommodation rights, and this notice will automatically be given upon hiring, any inquiry of parental leave or lactation accommodation.

#LI-GS3
#RTA
#RTA-ZR