Principal Consultant – Oracle DBA
Genpact
5 - 10 years
nan
Posted: 4/15/2025
Job Description
Responsibilities
: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 rotations
Qualifications:
Minimum Qualifications / Skills
Bachelor's 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 team
Preferred 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 team
About Company
Genpact is a global professional services firm that offers a wide range of digital transformation services and solutions. With a presence in over 30 countries, Genpact leverages its deep domain expertise in operations and analytics to help businesses transform their operations, improve efficiency, and enhance customer experience. The company combines digital technology, data science, and operational excellence to deliver business outcomes across various industries, including banking, insurance, manufacturing, and healthcare. Founded in 1997 as a subsidiary of GE, Genpact has grown into an independent, NYSE-listed company with a diverse workforce of over 90,000 employees globally.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).