Oracle pl/sql + postgres developer

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

At Zensar, we’re “experience-led everything”. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus.

Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar here and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.

We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.