Principal Consultant SQL DBA
Principal Consultant SQL DBA
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125000 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 SQL DBA
Genpact is hiring a senior SQL DBA who will be responsible for recommending implementing and supporting current and new SQL Server DB technologies as required to support the technical capabilities . To be successful in this role one must be able to work effectively in a fluid fastpaced environment. This role requires good communication skills both with team members and business contacts. In addition the successful SR Database Administrator must be able to work with minimal supervision on multiple concurrent projects.
Responsibilities
Diagnose and Resolve problems around database performance capacity replication TSQL etc.
Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB ongoing issues on all CAI environments DEV/QA/PROD.
Maintain/Monitor systems OnPrem 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/Snap Manager for SQL Idera SQLSafe or Native SQL Server Backup/recovery Tools.
Perform advanced database administration activities including but not limited to: DB Performance Tuning TSQL tuning Backup and recovery and DB disaster recovery solutions.
Create/update CAIs 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 oncall rotations.
Qualifications we seek in you!
Minimum Qualifications / Skills
Bachelors degree or equivalent work experience
Hands on experience in Microsoft Windows/ SQL Server Technologies .Net development.
Experience working in 24x7 environments oriented towards a zerodowntime target.
Working knowledge or previous administration of SQL 2016SQL 2022 and Windows Server 2019.
Experience with ETL DTS TSQL and SSRS SSIS.
Ability to work with minimal direction in a team environment.
Performance tuning for SQL server queries stored procedures views etc.
Hands on experience with configuring and administering Log Shipping and SQL Availability Groups.
Experience with SQL in virtual physical and cloudbased environments.
Proven ability to quickly learn and implement new technologies
Experience with Sentry One a plus.
Ability to code PowerShell commands.
Preferred Qualifications/ Skills
Excellent problemsolving and analytical skills.
Strong communication and collaboration abilities.
Ability to work independently and as part of a team.
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 and on LinkedIn X YouTube and Facebook.
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.
Required Experience:
Staff IC
Employment Type
Full-Time
