Job Title: 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.
If you want, I can prepare a short JD, LinkedIn-ready version, or bullet points for a job post.