PLSQL Developer

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.