Senior Oracle PL/SQL Developer

Opstree Global; Hyderabad; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Opstree Global is seeking a Senior Oracle PL/SQL Developer to join our engineering team in India. You will design, develop and optimize Oracle PL/SQL code, run performance tuning, and collaborate with application teams.

Ideal candidates have 6+ years of hands-on Oracle database development, strong SQL/PL-SQL skills, and experience with packages, procedures, functions, triggers, and data modeling. Knowledge of Unix/Linux scripting is a plus. Hyderabad/Bengaluru.

Qualifications

• 6+ years of hands-on experience in Oracle PL/SQL Development.
• Strong expertise in Oracle SQL and PL/SQL programming.
• Experience with packages, procedures, functions, triggers, cursors, collections, and exception handling.
• Strong knowledge of query optimization and performance tuning.
• Experience with Oracle database design and data modeling concepts.
• Familiarity with indexing, execution plans, and database performance analysis.
• Experience with version control tools such as Git is preferred.
• Good analytical, troubleshooting, and problem-solving skills.

Responsibilities

• Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.
• Write complex SQL queries and optimize them for performance.
• Analyze, troubleshoot, and resolve database-related issues.
• Perform query tuning and database performance optimization.
• Develop and maintain stored procedures and database objects.
• Collaborate with application development teams to support database integration.
• Participate in code reviews and ensure adherence to coding standards.
• Support database deployments, migrations, and production releases.
• Create technical documentation for database objects and processes.

Skills

Oracle PL/SQL Development

Oracle SQL

PL/SQL programming

Query optimization

Performance tuning

Database design

Data modeling

Git version control

Troubleshooting

Analytical skills

Education

Bachelor's degree in Computer Science/IT

Oracle Certification

Tools

Git

Job description

Job Title: Senior Oracle PL/SQL Developer

Location: Hyderabad / Bengaluru
Experience: 6+ Years

About the Role

We are looking for an experienced Oracle PL/SQL Developer to join our engineering team. The ideal candidate should have strong expertise in Oracle database development, writing efficient PL/SQL code, query optimization, and performance tuning. You will work closely with application developers and business stakeholders to design, develop, and maintain robust database solutions.

Key Responsibilities

• Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, and views.

• Write complex SQL queries and optimize them for performance.

• Analyze, troubleshoot, and resolve database-related issues.

• Perform query tuning and database performance optimization.

• Develop and maintain stored procedures and database objects.

• Collaborate with application development teams to support database integration.

• Participate in code reviews and ensure adherence to coding standards.

• Support database deployments, migrations, and production releases.

• Create technical documentation for database objects and processes.

Required Skills

• 6+ years of hands-on experience in Oracle PL/SQL Development.

• Strong expertise in Oracle SQL and PL/SQL programming.

• Experience with packages, procedures, functions, triggers, cursors, collections, and exception handling.

• Strong knowledge of query optimization and performance tuning.

• Experience with Oracle database design and data modeling concepts.

• Familiarity with indexing, execution plans, and database performance analysis.

• Experience with version control tools such as Git is preferred.

• Good analytical, troubleshooting, and problem-solving skills.

Preferred Skills

• Experience with Oracle Forms/Reports or Oracle APEX is a plus.

• Exposure to Unix/Linux shell scripting.

• Knowledge of Agile development methodologies.

• Experience working in enterprise-scale database environments.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.

• Oracle Certification is an added advantage.