SQL DBA (Database administrator/Lead)

Job Description

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way youd like, where youll be supported and inspired by a collaborative community of colleagues around the world, and where youll be able to reimagine whats possible. Join us and help the worlds leading organizations unlock the value of technology and build a more sustainable, more inclusive world.As a SQL Database Administrator at Capgemini, your primary responsibility will be to monitor and maintain SQL Server databases, specifically versions 2012 and above. Your role will involve performing routine database backups, restores, and recovery procedures, troubleshooting and resolving database performance issues using tools like SQL Profiler, Extended Events, and DMVs, implementing and maintaining database security including roles, permissions, and encryption, assisting in database deployments, patching, and upgrades, as well as designing and implementing high availability (HA) and disaster recovery (DR) solutions such as AlwaysOn, Log Shipping, Replication, and Clustering.Key Responsibilities:- Monitor and maintain SQL Server databases (2012 and above)- Perform routine database backups, restores, and recovery procedures- Troubleshoot and resolve database performance issues using tools like SQL Profiler, Extended Events, and DMVs- Implement and maintain database security (roles, permissions, encryption)- Assist in database deployments, patching, and upgrades- Design and implement high availability (HA) and disaster recovery (DR) solutions (AlwaysOn, Log Shipping, Replication, Clustering)Qualifications Required:- 4 - 12 years of experience as a SQL Database Administrator- Strong knowledge of Microsoft SQL Server (2012/2019/2022)- Proficiency in T-SQL, indexing strategies, and query optimization- Understanding of database backup strategies and recovery models- Familiarity with monitoring tools such as Redgate, SolarWinds, SentryOneCapgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. With a diverse group of 340,000 team members in more than 50 countries, Capgemini has a strong over 55-year heritage and is trusted by its clients to unlock the value of technology across their business needs. The company delivers end-to-end services and solutions with strengths ranging from strategy and design to engineering, leveraging capabilities in AI, cloud, data, and industry expertise. Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way youd like, where youll be supported and inspired by a collaborative community of colleagues around the world, and where youll be able to reimagine whats possible. Join us and help the worlds leading organizations unlock the value of technology and build a more sustainable, more inclusive world.As a SQL Database Administrator at Capgemini, your primary responsibility will be to monitor and maintain SQL Server databases, specifically versions 2012 and above. Your role will involve performing routine database backups, restores, and recovery procedures, troubleshooting and resolving database performance issues using tools like SQL Profiler, Extended Events, and DMVs, implementing and maintaining database security including roles, permissions, and encryption, assisting in database deployments, patching, and upgrades, as well as designing and implementing high availability (HA) and disaster recovery (DR) solutions such as AlwaysOn, Log Shipping, Replication, and Clustering.Key Responsibilities:- Monitor and maintain SQL Server databases (2012 and above)- Perform routine database backups, restores, and recovery procedures- Troubleshoot and resolve database performance issues using tools like SQL Profiler, Extended Events, and DMVs- Implement and maintain database security (roles, permissions, encryption)- Assist in database deployments, patching, and upgrades- Design and implement high availability (HA) and disaster recovery (DR) solutions (AlwaysOn, Log Shipping, Replication, Clustering)Qualifications Required:- 4 - 12 years of experience as a SQL Database Administrator- Strong knowledge of Microsoft SQL Server (2012/2019/2022)- Proficiency in T-SQL, indexing strategies, and query optimization- Understanding of database backup strategies and recovery models- Familiarity with monitoring tools such as Redgate, SolarWinds, SentryOneCapgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. With a diverse group of 340,000 team members in more than 50 countries, Capgemini has a strong over 55-year heritage and is trusted by its clients to unlock the value of technology across t

Keyskills :
Microsoft SQL ServerTSQLQuery optimizationMonitoring toolsIndexing strategiesDatabase backup strategies