Oracle pl/sql developer

job summary:
Job Summary

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.

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.

location: Pennington, New Jersey
job type: Solutions
work hours: 8am to 5pm
education: Bachelors


responsibilities:

Key Responsibilities

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

Required Technical Skills

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)

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact View email address on click.appcast.io.


Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).


This posting is open for thirty (30) days.