PLSQL Developer

First Meridian Business Services; Hyderabad, Pune District, Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Job summary

First Meridian Business Services in Hyderabad, India seeks a Senior Oracle PL/SQL Database Developer to design, develop and maintain Oracle database applications and services, with a strong emphasis on performance tuning and data processing.

The role requires developing and maintaining complex PL/SQL packages, procedures, functions, triggers, views and materialized views; writing and optimizing SQL queries; managing ETL processes across on-premise and cloud environments; supporting deployments

Qualifications

• Design, develop, enhance and support Oracle database applications and services.
• Develop and maintain complex PL/SQL Packages, Procedures, Functions, Triggers, Views and Materialized Views.
• Write and optimize complex SQL queries, database scripts and data manipulation processes.
• Perform SQL/PLSQL performance tuning, query optimization, indexing and database efficiency improvements.
• Design and maintain logical and physical data models.
• Work on ETL processes, data extraction, transformation and loading across on-premise and cloud-based data environments.
• Support database/application deployments, version control, release management and database change activities.
• Troubleshoot critical production issues, perform root-cause analysis (RCA) and implement fixes.
• Handle manual system processes including test file validation, reruns and exception handling.
• Collaborate with business and technical stakeholders to understand data requirements and application dependencies.
• Support business processes involving OTC, P2P and PIM.
• Ensure reliable data movement and integration between applications, databases, ETL platforms and data warehouses.
• Provide technical guidance and mentorship to junior database developers.

Responsibilities

• Design, develop, enhance and support Oracle database applications and services.
• Develop and maintain complex PL/SQL Packages, Procedures, Functions, Triggers, Views and Materialized Views.
• Write and optimize complex SQL queries, database scripts and data manipulation processes.
• Perform SQL/PLSQL performance tuning, query optimization, indexing and database efficiency improvements.
• Design and maintain logical and physical data models.
• Work on ETL processes, data extraction, transformation and loading across on-premise and cloud-based data environments.
• Support database/application deployments, version control, release management and database change activities.
• Troubleshoot critical production issues, perform root-cause analysis (RCA) and implement fixes.
• Handle manual system processes including test file validation, reruns and exception handling.
• Collaborate with business and technical stakeholders to understand data requirements and application dependencies.
• Support business processes involving OTC, P2P and PIM.
• Ensure reliable data movement and integration between applications, databases, ETL platforms and data warehouses.
• Provide technical guidance and mentorship to junior database developers.

Skills

Oracle PL/SQL

SQL

Performance tuning

ETL processes

Data modeling

Production support

RCA

Mentorship

Tools

Oracle Database

Oracle SQL Developer

Job description

Job Description

We are looking for a Senior Oracle PL/SQL Database Developer with strong experience in Oracle database development, performance tuning, data processing and production support.Role & responsibilities

Key Responsibilities

• Design, develop, enhance and support Oracle database applications and services.
• Develop and maintain complex PL/SQL Packages, Procedures, Functions, Triggers, Views and Materialized Views.
• Write and optimize complex SQL queries, database scripts and data manipulation processes.
• Perform SQL/PLSQL performance tuning, query optimization, indexing and database efficiency improvements.
• Design and maintain logical and physical data models.
• Work on ETL processes, data extraction, transformation and loading across on-premise and cloud-based data environments.
• Support database/application deployments, version control, release management and database change activities.
• Troubleshoot critical production issues, perform root-cause analysis (RCA) and implement fixes.
• Handle manual system processes including test file validation, reruns and exception handling.
• Collaborate with business and technical stakeholders to understand data requirements and application dependencies.
• Support business processes involving OTC, P2P and PIM.
• Ensure reliable data movement and integration between applications, databases, ETL platforms and data warehouses.
• Provide technical guidance and mentorship to junior database developers.