Oracle PL/SQL + Postgres Developer
Zensar
Full Time4+ yearsPosted 14 days ago
Let the right jobs find you
Get personalised suggestions from verified company career pages, matched to your role, location, level, and skills.
Overview
Position Type
Full Time
Experience
4+ years
Job 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