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