Oracle PL/SQL

Oracle PL/SQL | Oracle SQL | Stored Procedures | Functions | Packages | Triggers | Query Optimization | Performance Tuning | GitHub Copilot | Claude | Analytical Skills

Job Summary

We are looking for an experienced Oracle PL/SQL Developer with strong expertise in database programming, stored procedures, and query optimization. The ideal candidate should possess excellent analytical and problem-solving skills, along with hands-on experience using AI-powered development tools such as GitHub Copilot and Claude to improve development productivity.

Key Responsibilities

• Design, develop, maintain, and optimize Oracle PL/SQL programs.

• Write and maintain complex stored procedures, functions, packages, and triggers.

• Develop and optimize complex SQL queries for improved database performance.

• Perform database troubleshooting, debugging, and performance tuning.

• Analyze business requirements and translate them into efficient database solutions.

• Identify and resolve database-related issues and performance bottlenecks.

• Collaborate with application developers, business analysts, and technical teams.

• Leverage AI-powered tools such as GitHub Copilot and Claude for code generation, debugging, query optimization, and development assistance.

• Review AI-generated code for accuracy, security, performance, and coding standards.

• Maintain technical documentation and follow development best practices.

Required Skills & Qualifications

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

• Excellent experience writing and maintaining complex Stored Procedures.

• Good knowledge of Functions, Packages, Triggers, Cursors, and Exception Handling.

• Strong understanding of SQL query optimization and performance tuning.

• Experience with Oracle database architecture and data modeling.

• Excellent analytical, logical reasoning, and problem-solving skills.

• Experience using AI development assistants such as GitHub Copilot and Claude.

• Ability to leverage AI tools for SQL development, debugging, and code optimization.

• Strong communication and collaboration skills.

Preferred Qualifications

• Experience working in Agile development environments.

• Knowledge of database performance monitoring and troubleshooting.

• Experience with large-scale database applications.

• Familiarity with version control tools such as Git.