MS SQL Server Administrator

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.