LEAD CONSULTANT – SQL 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 Lead Consultant - SQL DBA• In this role, you will be responsible for recommending, implementing, and supporting SQL Server DB technologies in a fast-paced environment, requiring good communication skills and the ability to work independently on multiple projects.
esponsibilities• Diagnose and Resolve problems around database performance, capacity, replication, T-SQL, etc.• Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB on-going issues on all CAI environments DEV/QA/PROD.• Maintain/Monitor systems On-Prem or in AWS/Azure.• Coordinate and schedule DB downtimes to perform DB maintenance procedures.
i.
.
DB patching, upgrades, etc.• Define Backup and Recovery strategies using technologies used at CAI.
Netapp Snapshots, SnapCenter/SnapManager for SQL, Idera SQLSafe or Native SQL Server Backup/recovery Tools.• Perform advanced database administration activities including but not limited to.
DB Performance Tuning, T-SQL tuning, Backup and recovery and DB disaster recovery solutions.• Create/update CAI's database documentation about standard procedures, DB technology features, or production issue troubleshooting.• Stay current with changes in the technical area of expertise.• Support highly available production systems using the following technologies.
Database Mirroring, Log Shipping, Windows/SQL clustering, Availability Groups.• Work with development teams to deploy code in production when needed.• Participate in on-call rotations.• Qualifications we seek in you!Minimum Qualifications / Skills:• Bachelor%27s degree or equivalent work experience• Excellent problem-solving and analytical skills.• Strong communication and collaboration abilities.
referred Qualifications/ Skills• Ability to work independently and as part of a team.• 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.• Experience with high volume websites that use multi-tier architectures is a significant plus.• Understanding or experience using Oracle Real Application Cluster's and implementation best-practices• 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 developing ansible playbooks is a plus.• Experience supporting Database infrastructure in the cloud (OCI, AWS, Azure).• Ability to analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, Disaster Recovery or high performance.• Experience setting up and Managing OEM 13c.
enpact 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 genpact.
om and on LinkedIn, X, YouTube, and Facebook.
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.