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 .
Key Skills
Administration And Accounting,Events,ERP Sales,Access Control,Autocad Design,Inventory Management
Employment Type : Full Time
Experience : years
Vacancy : 1
Software Engineer • Toronto, Ontario, Canada