Consultant - Oracle Progres DBA

Genpact (NYSE : G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients.Powered by our purpose - the relentless pursuit of a world that works better for people - we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.

Inviting applications for the role of Consultant - Oracle ProgresDBA

Responsibilities

Thorough knowledge of Database binaries installation, configurations, troubleshooting, performance tuning skills required.

Experience implementing and managing Clustering, High Availability systems and Disaster recovery systems.

Strong experience on Oracle versions 11g, 12c and 19c along with Linux, RHEL and OUL.

Strong experience on Postgres 9x, 10x, 11x, 12x, 13x and 14x versions

Ability to diagnose problems and triage / resolve issues across various tiers (application, network, database, server, or storage tiers).

Must have strong experience with shell scripting and Python as optional

Ability to implement automation to reduce manual administrative tasks through use of jobs or other technologies.

Experience in database upgrade / migrate, patching, backup recovery of large databases.

Plan and implement major upgrades, ensuring system integrity and monitoring

Extensive hands-on experience in Database migrations from lower to higher versions in

Database Backup & Recovery, replication in bi-direction.

Own database maintenance plans, including rebuilding / reorganizing indexes, integrity checks, and others

Experience with Enterprise environment change control procedure.

Work with developers to improve database performance, slow running queries / processing

Ensure high levels of performance, availability, sustainability and security

Environments Setup High Availability as part Disaster Recovery Strategy for the Databases

Implement and maintain database security

Analyze, solve, and prepare RCA for production outages.

Debug and troubleshoot database system failures and provide solutions quickly.

Participate in planning efforts with stakeholders and IT groups.

Analyze business process application requirements to produce formal analysis and design documents with minimal supervision.

Provide cost / time estimates, capacity planning of database environments.

Institute process for continuous improvement, perform other related duties as assigned.

Assist on critical production issues, identify root cause and provide mitigation plan.

Manage relationship with customers to understand customer and project needs and priorities

Work with various product / application teams across the company

Understand the product architecture and prepare Service Improvement for efficiency.

Qualifications we seek in you!

Minimum Qualifications / Skills

Bachelor’s degree required.

Experience on multiple database technologies primarily Oracle and Postgres.

Experience in implementing and managing database clustering and HA / DR systems.

Ability to develop SQL and PL / SQL scripts and Strong Automation mindset / experience.

Preferred Qualifications / Skills

Strong communicator – English in spoken and written form

Should be flexible and open to work in 24x7 environment in any shifts, willing to work on holidays, over weekends as per the demand from Project.