Role & responsibilities:
- Develop, enhance, and maintain database applications using Oracle PL/SQL, including stored procedures, packages, functions, triggers, and cursors.
- Design and optimize complex SQL queries for high-performance data processing and reporting.
- Work on data modeling, database design, and schema management to support business applications.
- Develop and support ETL processes, data migration, and integration solutions.
- Analyze and resolve database performance issues using tools such as Oracle SQL Tuning Advisor, Explain Plan, and AWR Reports.
- Collaborate with application development teams to integrate database solutions with enterprise applications.
- Ensure database security, data integrity, backup, and recovery standards are followed.
- Perform code reviews, unit testing,
and deployment of database objects across environments.
- Support production systems, troubleshoot incidents, and provide timely resolutions.
- Robust experience in Oracle Database, PL/SQL, SQL Performance Tuning, Data Modeling, ETL, and Database Development is required.
Experience: 5 to 15 Years
Primary Skills: Oracle PL/SQL, SQL, Performance Tuning, Stored Procedures, Packages, Triggers, Query Optimization, Data Modeling, ETL, Oracle Database 11g/12c/19c.
Good to Have: Unix/Linux Shell Scripting, Oracle Forms & Reports, Informatica, ODI, Banking/Finance domain experience.
Tailor this for 5 years experience
📌 PLSQL Developer (Pune)
🏢 Infosys
📍 Pune