Role overview

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
Strong experience with Oracle performance tuning including Query Optimizer, Execution Plans, SQL optimization, and Indexing
3+ years of experience developing Unix/Linux Shell Scripts (Bash, KornShell, Bourne Shell, or C Shell)

Responsibilities

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
Monitor and tune Oracle databases using Query Optimizer, Execution Plans, Indexing, and database statistics
Implement database backup, recovery, and disaster recovery strategies to ensure data availability

Key facts

Remote from: California (USA)
Full time
Senior (5-10 years)
English

Hard skills

PL/SQL SQL*Plus Database Tuning Oracle Toad MySQL PostgreSQL MongoDB

Other skills

Communication

About the company

Russell Tobin

Human Resources, Staffing & Recruiting

Bring Top Talent With Your Company With Russell Tobin Headquartered in New York City with offices throughout the United States, United Kingdom, Ireland, The Netherlands, Brazil, Canada, India, and Singapore, Russell Tobin—a division of Pride Global—offers total staffing and recruitment solutions across a wide range of industries. Our team of highly skilled recruiters, sourcers, and subject-matter experts understand exactly how to find world-class candidates that will fit your company’s precise needs. Whether you need skilled professionals ready to deliver results in complex sectors such as banking or technology, or you’re looking to build out your own staffing efforts with a recruiter-for-recruiters (R4R) model, Russell Tobin can make the connections. Our Bespoke Approach to Connecting Talent With Companies When an organization comes on board as a client, Russell Tobin takes the time to understand the company from the inside out. We work directly with you and your leadership team to create an end-to-end solution capable of handling the full recruitment lifecycle, tailored to your company’s needs and culture. After gathering the critical data we need to seek exactly the right candidates for your hiring strategy, our recruiters take over, using their deep understanding of your industry to build out talent pools and discover game-changing new hires. A Proud Member of a Decidedly Diverse Network of Companies As part of Pride Global, Russell Tobin serves as one of industry’s only minority-owned payroll and staffing organizations, giving you the opportunity to satisfy Tier 1 diversity spending requirements. We’ve also taken this commitment much further through our Decidedly Diverse initiative, which seeks to create greater diversity, equity, and inclusion across our workforce and workplace, as well as the wider world in which we live. Learn more at https://decidedlydiverse.com.

Company details

Company typeSME

IndustryHuman Resources, Staffing & Recruiting

Company size201 - 500

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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