Capgemini—MS SQL Server Administrator

Job description

Description: Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s 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 ProfileMS SQL Server AdministrationBackup \& 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 CapgeminiExposure 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