at Capgemini
ConsultanciesPosted a month ago
No clicks
**MS SQL Server Administrator:** Lead SQL Server environments (2008 R2 to 2016) for 850+ production servers. Manage backups (full, differential, log), replication, mirroring, clustering. Monitor & troubleshoot issues, create jobs using SQL Mail, ensure data consistency. Offer 24/7 production support. Requires 9-12 years' experience in MS SQL Server administration, Backup & Restore, HA/DR, Windows Server, monitoring. Familiarity with Azure SQL beneficial. Collaborate globally with teams and clients.
- Compensation
- Not specified
- City
- Mumbai
- Country
- India
Currency: Not specified
Full 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.
Your Role
• Total 9 t o12 years of experience into installation and Configuration of SQL server versions 2008 R2; 2012; 2014;2016 (both Stand alone and cluster Instances)User and monitoring ticket management and ensuring teams adherence to SLA.
• This is for an inventory of almost 1200 servers for each client. 850 of them being production.
• Protecting the databases by taking different kinds of Backups such as Full; Differential; and Transactional log backups.
• Maintained \& Monitored Alert/Schedule to make smooth replication process.
• Performing data refresh activities from production to Dev/Test on need basis Working closely with application development and support team to understand their requirements and provide timely solutions; for both current and future projects.
• Configuring replication; mirroring; SQL clusters and troubleshooting issues.
• Creating Jobs and Sending Alerts using SQL Mail.
• Ensuring Data consistency in the database through DBCC commands.
• Repetitive issues analysis and proposals for permanent resolutions.
• Monitoring SQL Server agent jobs/maintenance plans Provide 24 \* 7 Production support for the database and application issues.
Your Profile
- MS SQL Server Administration
- Backup \& Restore; Performance tuning; HA/DR; Windows Server; Monitoring.
- Installation, configuration, and upgrading of SQL Server instances.
- Database creation, maintenance, and storage management.
- Managing SQL Server security, logins, roles, and permissions.
What will you love working at Capgemini
- Exposure to Always On Availability Groups, Replication, and DR solutions.
- Opportunities to work on Azure SQL and cloud migration projects.
- Strong focus on automation, monitoring, and performance optimization.
- Collaboration with global teams and enterprise customers.
Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.
Make it real | www.capgemini.com
