Oracle PL/SQL + Postgres Developer

Description

Key Responsibilities:

• Develop and maintain SQL queries, stored procedures, functions, packages, and triggers 
• Design and optimize database objects (tables, views, indexes) 
• Perform query performance tuning and troubleshooting 
• Handle bulk data processing and data migrations 
• Implement exception handling, validations, and database security practices 
• Support application integration and production issues 

Required Skills:

• Strong knowledge of SQL (DDL, DML, joins, subqueries, analytical functions, Table Partitioning) 
• Proficiency in PL/SQL (functions, procedures, packages, cursors, collections, triggers, views, Materialized Views) 
• Experience in performance tuning and query optimization using Explain Plan, AWR reports, TKPROF, and SQL Trac and query rewriting and optimizer hints
• Good understanding of database design concepts 

Added Advantage:

• Experience with PostgreSQL

Responsibilities ok

Qualifications ok