Zensar Technologies·IT Services·1 day ago
1 day agoBe an early applicant
Oracle PL/SQL + Postgres Developer
Sign up free to see how well your resume matches this role.
What you'll do
- 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
What they're looking for
- 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
Nice to have
- Experience with PostgreSQL
Summarised by NextRaise from the employer’s description, which follows in full below.
Full description from employer
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
IT Services
Company
Zensar TechnologiesIT Services
India
Company facts come from this company's own listings. We only show what the postings themselves carry.