Oracle PLSQL Developer

VGreenTek; Hyderabad; On-site; INR 1,200,000 - 1,600,000; Full time

Job summary

VGreenTek in Hyderabad, India, seeks an experienced Oracle PL/SQL Developer to join our team. The ideal candidate will design, develop, and optimize PL/SQL code with focus on performance and reliability.

You will work on complex SQL, maintain packages and triggers, and collaborate with cross-functional teams on data migrations and analytics. A strong background in Oracle DB (11g/12c/19c+) and version control is required.

Qualifications

• 4+ years hands-on Oracle PL/SQL development.
• Strong SQL optimization and performance tuning.
• Experience with Oracle 11g/12c/19c or higher.
• Proficient in writing stored procedures, functions, packages, cursors, and triggers.
• Familiar with indexing, partitioning, and execution plans.
• Experience with Git/SVN for version control.
• Understanding of data modeling and normalization concepts.
• Unix/Linux shell scripting is a plus; ODI/ETL exposure beneficial.

Responsibilities

• Design, develop, and maintain PL/SQL packages, procedures, functions, and triggers.
• Write and optimize complex SQL queries for performance.
• Perform code reviews and ensure adherence to best practices.
• Troubleshoot and resolve database performance issues.
• Work with cross-functional teams to gather requirements and design database solutions.
• Handle data migration, ETL processes, and batch job scheduling.
• Prepare technical documentation for database processes.
• Support production issues and provide root cause analysis.

Skills

Oracle PL/SQL

SQL optimization

Oracle database

Stored procedures & triggers

Indexing & partitioning

Data modeling

Unix/Linux scripting

ETL/ODI exposure

Education

Bachelor's degree in Computer Science / IT

Tools

Git

SVN

Job description

We are looking for an experienced Oracle PL/SQL Developer to join our team. The ideal candidate will have strong hands-on experience in database development, performance tuning, and writing efficient PL/SQL code.

Key Responsibilities:

• Design, develop, and maintain PL/SQL packages, procedures, functions, and triggers
• Write and optimize complex SQL queries for performance
• Perform code reviews and ensure adherence to best practices
• Troubleshoot and resolve database performance issues
• Work with cross-functional teams to gather requirements and design database solutions
• Handle data migration, ETL processes, and batch job scheduling
• Prepare technical documentation for database processes and solutions
• Support production issues and provide root cause analysis

Required Skills:

• 4+ years of hands-on experience in Oracle PL/SQL development
• Strong knowledge of SQL query optimization and performance tuning
• Experience with Oracle database (11g/12c/19c or higher)
• Proficiency in writing stored procedures, functions, packages, cursors, and triggers
• Familiarity with indexing, partitioning, and execution plans
• Experience with version control tools (Git/SVN)
• Good understanding of data modeling and normalization concepts
• Knowledge of Unix/Linux shell scripting is a plus
• Exposure to ETL tools or ODI is an added advantage

Good to Have:

• Experience with Oracle APEX
• Knowledge of Agile/Scrum methodologies
• Exposure to CI/CD pipelines for database deployments

Education:

Bachelor's degree in Computer Science, IT, or related field