PRINCIPAL CONSULTANT – ORACLE DBA

Genpact (NYSE.
G) is a global professional services and solutions firm delivering outcomes that shape the future.
Our + 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 Principal Consultant - Oracle DBAIn this role you are responsible for design, developing and implementing new technologies for various projects, requiring effective work in a fast-paced environment and good communication skills.
The role demands minimal supervision on multiple concurrent projectsResponsibilities:• Participate in functional test planning and testing for the assigned application(s), functional area(s) or project(s)• Participate in problem solving and troubleshooting for the assigned application(s), functional area(s) or project(s)• Share knowledge by effectively documenting work• Respond quickly and effectively to production issues and take responsibility for seeing those issues through resolution.• Resolve database performance issues, database capacity issues, replication, and other distributed data issues.• Install and maintain database software.• Manage backup and recovery of databases using RMAN and/or Network Appliance Snapshots.• Manage security of database structures and corporate data held within databases.• Develop database procedures, triggers and SQL scripts for development teams.• Assist in the definition and implementation of database standards.• Review scripts submitted by the Development team to ensure that all standards are met.• Monitor databases for errors and perform problem determination when necessary.• Design and implement highly available production systems using the following technologies.
Hot Standby/Data Guard, Oracle Goldengate, Advanced Queuing, Real Application Cluster (RAC) and Oracle Enterprise Manager• Participate in on-call rotationsQualifications.
inimum Qualifications / Skills• Bachelor%27s degree or equivalent work experience• Soft Skills.
Excellent problem-solving and analytical skills, strong communication and collaboration abilities, ability to work independently and as part of a teamPreferred Qualifications / Skills• Experience developing Ansible playbooks• Experience with high volume websites that use multi-tier architectures• Hands-on experience in Oracle database technologies• Prior experience writing PL/SQL triggers and/or procedures• Experience with Database SQL and Database tuning• Experience with Oracle GoldenGate• Experience supporting Database infrastructure in the cloud (OCI, AWS, Azure)• Ability to work with minimal direction, yet also able to work in a team environment• Working knowledge of LINUX and shell scripting• Experience configuring database network connectivity• Understanding of database backup and recovery techniques using RMAN and Network Appliance filers• Understanding or experience using Oracle Real Application Clusters and implementation best practices• Ability to analyze existing systems and make recommendations on technology for high availability, Disaster Recovery, or high performance• Experience setting up and managing OEM 13c• Excellent problem-solving and analytical skills• Strong communication and collaboration abilities• Ability to work independently and as part of a teamGenpact 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.
For more information, visit www.
enpact.
om.
Follow us on Twitter, Facebook, LinkedIn, and YouTube.
urthermore, 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 %27starter kit,%27 paying to apply, or purchasing equipment or training.