PLSQL Developer

Clover Infotech; Pune District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Clover Infotech in Pune, India is seeking a skilled PL/SQL Developer to develop, test, and maintain PL/SQL procedures, functions, packages, and triggers, while crafting optimized SQL queries for data retrieval.

You will design and manage database objects, analyze performance, perform data validation and migration, build batch jobs, resolve production incidents, and collaborate with developers, QA, and analysts to ensure robust deployments across environments.

Qualifications

• Experience developing PL/SQL procedures, functions, packages, and triggers.
• Ability to write complex and optimized SQL queries for data retrieval and processing.
• Design and maintain database objects such as tables, views, indexes, sequences, and synonyms.
• Analyze and optimize SQL/PL-SQL code for performance improvements.
• Perform data analysis, data validation, and migration activities.

Responsibilities

• Develop, test, and maintain PL/SQL procedures, functions, packages, and triggers.
• Write complex and optimized SQL queries for data retrieval and processing.
• Design and maintain database objects including tables, views, indexes, sequences, and synonyms.
• Analyze and optimize SQL queries and PL/SQL code for better performance.
• Perform data analysis, data validation, and data migration activities.
• Develop batch jobs and automated database processes.
• Troubleshoot database issues and provide root-cause analysis.
• Handle production incidents and provide timely resolutions.
• Work closely with application developers, business analysts, QA teams, and other stakeholders.
• Participate in code reviews and ensure adherence to coding and database development standards.
• Create and maintain technical documentation for database processes and solutions.
• Support database deployments across development, testing, and production environments.

Skills

PL/SQL

SQL queries

Data analysis

Data migration

Troubleshooting

Code reviews

Documentation

Job description

• Develop, test, and maintain PL/SQL procedures, functions, packages, and triggers.
• Write complex and optimized SQL queries for data retrieval and processing.
• Design and maintain database objects including tables, views, indexes, sequences, and synonyms.
• Analyze and optimize SQL queries and PL/SQL code for better performance.
• Perform data analysis, data validation, and data migration activities.
• Develop batch jobs and automated database processes.
• Troubleshoot database issues and provide root-cause analysis.
• Handle production incidents and provide timely resolutions.
• Work closely with application developers, business analysts, QA teams, and other stakeholders.
• Participate in code reviews and ensure adherence to coding and database development standards.
• Create and maintain technical documentation for database processes and solutions.
• Support database deployments across development, testing, and production environments.