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 Progres DBA
With a startup spirit and 100,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. Now, we’re calling all you rule-breakers and risk-takers who see the world differently and are bold enough to reinvent it. Come, transform with us.
Responsibilities
o Thorough knowledge of Database binaries installation, configurations, troubleshooting, performance tuning skills required.
o Experience implementing and managing Clustering, High Availability systems and Disaster recovery systems.
o Strong experience on Oracle versions 11g, 12c and 19c along with Linux, RHEL and OUL.
o Strong experience on Postgres 9x, 10x, 11x, 12x, 13x and 14x versions
o Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers).
o Must have strong experience with shell scripting and Python as optional
o Ability to implement automation to reduce manual administrative tasks through use of jobs or other technologies.
o Experience in database upgrade/migrate, patching, backup recovery of large databases.
o Plan and implement major upgrades, ensuring system integrity and monitoring
o Extensive hands-on experience in Database migrations from lower to higher versions in
o Database Backup & Recovery, replication in bi-direction.
o Own database maintenance plans, including rebuilding/reorganizing indexes, integrity checks, and others
o Experience with Enterprise environment change control procedure.
o Work with developers to improve database performance, slow running queries / processing
o Ensure high levels of performance, availability, sustainability and security
o Environments Setup High Availability as part Disaster Recovery Strategy for the Databases
o Implement and maintain database security
o Analyze, solve, and prepare RCA for production outages.
o Debug and troubleshoot database system failures and provide solutions quickly.
o Participate in planning efforts with stakeholders and IT groups.
o Analyze business process application requirements to produce formal analysis and design documents with minimal supervision.
o Provide cost/time estimates, capacity planning of database environments.
o Institute process for continuous improvement, perform other related duties as assigned.
o Assist on critical production issues, identify root cause and provide mitigation plan.
o Manage relationship with customers to understand customer and project needs and priorities
o Work with various product/application teams across the company
o 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.
Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values respect and integrity, customer focus, and innovation. Get to know us at www.genpact.com and on X, Facebook, LinkedIn, and YouTube.
Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a 'starter kit,' paying to apply, or purchasing equipment or training.
Read Full Description