Senior Oracle PL/SQL Developer Database Developer

Job Summary

We are seeking Senior Oracle PL/SQL Developers with approximately 10–15 years of experience and, most importantly, deep, current, hands-on PL/SQL development expertise.

This role is highly technical. Candidates should be able to demonstrate strong practical knowledge during technical interviews and provide thoughtful solutions to real-world, day-to-day engineering problems. This is not a management-focused position; the team is specifically looking for engineers who remain actively hands-on with Oracle SQL/PLSQL development.

Key Responsibilities

• Design, develop, test, and maintain complex Oracle SQL and PL/SQL solutions.

• Develop complex stored procedures, packages, database business logic, custom data types, and transactional data models.

• Perform advanced SQL development, data analysis, data modeling, and data manipulation.

• Design and implement data APIs and database-centric solutions.

• Analyze and optimize database performance.

• Develop and maintain batch processing jobs using technologies such as ETL/Informatica and Autosys.

• Translate business requirements, storyboards, and use cases into scalable and maintainable software solutions.

• Participate in application design, design reviews, and code reviews.

• Develop automated test cases and participate in regression testing.

• Contribute to engineering practices involving ATDD, CI/CD, and continuous delivery.

• Collaborate with distributed/global development teams.

• Provide technical guidance and mentorship to other team members.

• Contribute directly to the codebase while working with cross-functional teams and stakeholders.

Must-Have Skills

Oracle PL/SQL Engineering

• Strong hands-on experience developing Oracle SQL and PL/SQL.

• Development of complex:

  • Stored procedures

  • Packages

  • Database business logic

  • Custom data types

  • Transactional data models

Advanced SQL & Data Manipulation

• Analytical and windowing functions.

• Complex joins and aggregations.

• Set operators.

• Subqueries and query optimization.

• Strong data analysis and data modeling capabilities.

Database Performance Tuning

• Query optimization.

• Reading and analyzing execution plans.

• Database diagnostics.

• PGA memory tuning.

• Partitioning strategies.

Additional Technical Experience

• ETL / Informatica.

• Autosys and batch job development.

• Data API design and implementation.

• Understanding of scalable application design principles.

• Knowledge of mid-tier technologies such as Java.

• Familiarity with messaging technologies and web containers.

• Understanding of how mid-tier technologies interact with databases.

• CI/CD processes and tools.

• Agile software development.

Ideal Candidate

The ideal candidate is a senior-level engineer who is still 100% hands-on with PL/SQL and can confidently engage in deep technical discussions.

Candidates should be able to:

• Solve practical database and software engineering problems.

• Explain technical decisions and trade-offs.

• Demonstrate current, deep PL/SQL expertise.

• Work independently while collaborating effectively with a global team.

• Contribute to engineering excellence and continuous improvement.

• Mentor team members while remaining actively involved in development.

Requirements