Job Summary

We are seeking an experienced Oracle PL/SQL Developer with 5+ years of hands-on experience in Oracle database development, performance tuning, and enterprise application support. The ideal candidate should possess strong expertise in Oracle Database (12c/19c or higher), PL/SQL programming, Oracle Forms, GUI development, database optimization, and performance monitoring. The candidate should be capable of analyzing database performance using AWR reports and implementing solutions to improve system efficiency and reliability.

Key Responsibilities

- Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and database objects.
- Develop and enhance applications using Oracle Forms and related GUI technologies.
- Work extensively with Oracle Database 12c/19c and above, ensuring database integrity, security, and performance.
- Create and maintain efficient data models, database schemas, indexes, and scripts.
- Monitor and optimize database performance through query tuning, indexing strategies, and execution plan analysis.
- Analyze and interpret Automatic Workload Repository (AWR) reports to identify performance bottlenecks and recommend improvements.
- Develop data migration, data validation, and data integration scripts as required.
- Collaborate with business analysts, application developers, and QA teams to understand and translate business requirements into technical solutions.
- Troubleshoot production issues, perform root cause analysis, and implement corrective actions.
- Ensure adherence to coding standards, database security policies, and best practices.
- Participate in code reviews, technical discussions, and knowledge-sharing sessions.

Required Skills & Qualifications

Technical Skills





- Minimum 5 years of experience in Oracle PL/SQL Development.
- Minimum 3+ years of experience working with Oracle Database 19c or higher.
- Strong expertise in:
- Oracle PL/SQL
- Oracle Forms Development
- GUI/Application Development
- SQL Query Optimization
- Stored Procedures, Functions, Packages, and Triggers

- Experience with:

- Oracle Database 12c/19c or higher
- Data Modeling and Database Design
- Database Scripting and Automation
- Index Management and Performance Optimization
- Performance Monitoring and Troubleshooting

- Ability to analyze and interpret AWR Reports, ASH Reports, and Oracle Performance Metrics.
- Strong understanding of execution plans, indexing strategies, and database tuning techniques.

Preferred Skills

- Knowledge of Oracle Reports and Oracle Application Framework.
- Experience with Unix/Linux Shell Scripting.
- Familiarity with version control systems such as Git.
- Exposure to Agile/Scrum development methodologies.
- Experience supporting mission-critical enterprise applications.

Educational Qualifications

- Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related field.
- Oracle Certifications will be an added advantage.

Key Competencies

- Robust analytical and problem-solving skills.
- Excellent debugging and troubleshooting capabilities.
- Good communication and stakeholder management skills.
- Ability to work independently and collaboratively in a team environment.
- Strong attention to detail and commitment to quality.

Nice to Have

- Experience in regulated industries such as Gaming, Banking, Financial Services, Healthcare, or Telecom.
- Exposure to database migration and modernization projects.
- Experience working with high-volume transactional systems.

📌 Oracle PL/SQL Developer (Bengaluru)
🏢 SG Lottery India
📍 Bengaluru