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._
- _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._
*_ _*
- responsibilities_
- _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.e. 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's degree or equivalent work experience_
- _excellent problem-solving and analytical skills._
- _strong communication and collaboration abilities._
- preferred qualifications/ skills_
- _ability to work independently and as part of a team._
- _ability to work with mínimal 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._
*_ _*
*_
job_*_lead consultant_
*_ primary location_*_mexico-zapopan_
*_ schedule_*_full-time_
*_ education level_*_bachelor's / graduation / equivalent_
*_ job posting_*_apr 9, 2025, 5:24:38 pm_
*_ unposting date_*_ongoing_
- master skills list_consulting_
- job category_full time_