Oracle PL/SQL Developer

Randstad
Pennington, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Pennington, United States of America

Tech stack

Adobe InDesign
API
Data analysis
Azure
Big Data
Cloud Computing
Databases
Continuous Integration
Data Governance
Data Integrity
ETL
Data Security
Data Systems
Data Warehousing
Database Design
Database Development
Oracle Data Guard
DevOps
Middleware
Entity Relationship Models
Oracle Exadata
Python
Liquibase
Oracle
Oracle Applications
Performance Tuning
Scrum
Systems Development Life Cycle
PL-SQL
SQL Databases
Data Logging
Scripting (Bash/Python/Go/Ruby)
System Availability
Database Optimization
GIT
Amazon Web Services (AWS)
Low Latency
Bitbucket
Data Management
Oracle Cloud Infrastructure
Software Version Control

Job description

We are looking for a highly experienced Oracle Database Developer with 8+ years of hands-on expertise in designing, developing, optimizing, and supporting complex Oracle database solutions. The ideal candidate will play a critical role in database development, performance tuning, and data integrity for mission critical systems, working closely with application developers, architects, and business stakeholders., Database Development & Design

  • Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers, and views
  • Translate business and application requirements into efficient database designs
  • Develop reusable, well-documented, and maintainable database components
  • Implement data models (logical and physical) aligned with enterprise standards

Performance & Optimization

  • Perform SQL and PL/SQL performance tuning using execution plans, AWR, ASH, and SQL Trace
  • Optimize indexing strategies, partitioning, and query execution paths
  • Identify and resolve performance bottlenecks in high volume, low latency systems

Data Management & Reliability

  • Ensure data integrity, consistency, and availability across systems
  • Support large-scale data migrations, schema evolution, and version upgrades
  • Implement robust error handling, logging, and recovery mechanisms

Collaboration & Integration

  • Partner with application developers, architects, and DevOps teams to support end to end solutions
  • Support integration with middleware, APIs, and batch frameworks
  • Participate in design reviews and contribute to architecture decisions

Production Support & Governance

  • Provide Level 3 production support for database-related issues
  • Follow SDLC, change management, and regulatory compliance standards
  • Support audit, security, and data governance requirements

Requirements

This role requires strong PL/SQL skills, deep understanding of Oracle database internals, and the ability to build scalable, high performance data solutions in enterprise environments., Core Oracle & Database Skills (Must Have)

  • 8+ years of hands-on Oracle Database development experience
  • Advanced PL/SQL (packages, bulk collect, FORALL, autonomous transactions)
  • Strong SQL expertise, including complex joins, subqueries, analytics functions
  • Oracle versions: Oracle 11g / 12c / 19c (at least one enterprise deployment)
  • Strong understanding of:
  • Indexes, partitions, constraints
  • Transactions and locking
  • Cost-based optimizer (CBO)
  • Experience with performance tuning tools (AWR, ASH, Explain Plan, SQL Monitor)

Data & Architecture

  • Data modeling (ER modeling, normalization/denormalization)
  • Experience handling large datasets and high-throughput databases
  • Knowledge of data warehousing concepts (slowly changing dimensions, facts/dimensions)
  • Experience with materialized views, advanced queues, or scheduler (plus)

DevOps, Tools & Automation

  • Experience with version control (Git, Bitbucket, etc.)
  • Familiarity with CI/CD for database deployments (Liquibase, Flyway, custom scripts)
  • Strong scripting skills (Shell, Python or similar)
  • Experience working in Agile / Scrum teams

Nice to Have / Preferred Skills

  • Experience in financial services / banking / regulated environments
  • Exposure to Exadata, RAC, Data Guard
  • Knowledge of cloud platforms (OCI, AWS RDS for Oracle, Azure)
  • Experience with ETL tools (Informatica, ODI) or Big Data integration
  • Knowledge of data security, encryption, and access control
  • Experience migrating legacy databases to newer Oracle versions or cloud

Soft Skills & Leadership

  • Strong analytical and problem solving abilities
  • Ability to work independently and drive solutions end to end
  • Clear communication with both technical and nontechnical stakeholders
  • Mentorship of junior developers and influence on best practices
  • Comfortable working in fast paced, high availability environments

#LI-MN1

qualifications:

8+ years of hands-on Oracle Database development experience

Advanced PL/SQL (packages, bulk collect, FORALL, autonomous transactions)

Strong SQL expertise, including complex joins, subqueries, analytics functions

Oracle versions: Oracle 11g / 12c / 19c (at least one enterprise deployment)

Strong understanding of:

Indexes, partitions, constraints

Transactions and locking

Cost-based optimizer (CBO)

Experience with performance tuning tools (AWR, ASH, Explain Plan, SQL Monitor)

Apply for this position