Oracle PL/SQL Software Engineer

Oracle PL/SQL Software Engineer

Location: Remote

Job Summary

We are seeking a highly experienced Oracle PL/SQL Engineer with 9+ years of hands-on experience to join our distributed agile team. You will work on a multi-tenant cloud SaaS solution in the Human Resources domain, contributing to high-performance database components and complex application logic. The ideal candidate has deep expertise in Oracle PL/SQL, Oracle RDBMS tuning, and best practices. A shift-left development approach and the ability to leverage AI tools for productivity are essential.

Key Responsibilities

• Design, develop, optimize, and maintain complex PL/SQL packages, procedures, functions, triggers, and scripts.

• Contribute to the architecture and development of a multi-tenant cloud-based SaaS HR platform.

• Perform advanced performance tuning, query optimization, and troubleshooting for Oracle databases.

• Implement and enforce best practices for database design, indexing, partitioning, and scalability.

• Own the full lifecycle of development using agile methodologies, including testing and validation.

• Adopt a shift-left approach—ensuring code quality, unit testing, and correctness of all deliverables.

• Collaborate closely with product managers, architects, QA, and cross-functional engineering teams.

• Use AI productivity tools (GitHub Copilot, Claude Code, etc.) to accelerate development.

• Diagnose and resolve high-complexity database and performance issues.

• Maintain documentation and ensure adherence to security and coding standards.

Required Skills & Qualifications

• 9+ years of experience in Oracle PL/SQL development.

• Deep expertise in Oracle RDBMS concepts, performance tuning, indexing strategies, and explain plans.

• Proven ability to write high-performance, scalable, and maintainable PL/SQL code.

• Strong understanding of database architecture, multi-tenant systems, and large-scale environments.

• Hands-on experience in agile or distributed team environments.

• Strong analytical, debugging, and problem-solving skills.

• Commitment to quality with hands-on experience in unit testing and validation.

• Experience using AI-based development tools (Copilot, Claude Code, etc.) preferred.

Preferred Qualifications

• Experience with cloud platforms such as Oracle Cloud, AWS, or Azure.

• Knowledge of CI/CD pipelines, DevOps practices, or automated testing frameworks.

• HR domain knowledge or experience with HR applications is an advantage.