Microsoft SQL Database Administrator

About the role

The Capgemini Financial Services (FS) DCX Marketing Agency is seeking a highly experienced Microsoft SQL Database Administrator to join our Software Engineering team.

Responsibilities

• Manage and maintain Microsoft SQL Server instances across on-premises and cloud environments.
• Monitor and optimize database performance; troubleshoot and resolve performance issues.
• Implement and maintain high availability (HA), disaster recovery (DR), and security protocols.
• Plan and execute database upgrades, patches, and migrations.
• Develop and manage backup and recovery strategies aligned with RPO and RTO requirements.
• Conduct regular data integrity checks and restore testing.
• Enforce data security through encryption, access control, and auditing.
• Use tools such as SQL Server Profiler, Extended Events, and third-party monitoring solutions to proactively monitor database health.
• Identify and resolve bottlenecks, deadlocks, and long-running queries.
• Design and develop database objects including stored procedures, views, triggers, and functions.
• Collaborate with development teams to optimize database schemas and queries.
• Automate administrative tasks using PowerShell, T-SQL, or other scripting tools.
• Manage and optimize SQL Server databases hosted on AWS RDS.
• Support the migration of on-premises databases to cloud platforms like AWS RDS.

Requirements

• Experience: 5+ years of hands-on experience as a Microsoft SQL Server Administrator.
• Must have experience with both SQL coding and MS SQL Server administration.
• Deep expertise in SQL Server administration, performance tuning, backup/recovery, and security.
• Strong understanding of SQL Server HA/DR solutions (e.g., AlwaysOn, Mirroring, Log Shipping).
• Proficient in T-SQL and experienced in developing stored procedures and other SQL components.
• Experience with PowerShell or similar scripting tools.
• Familiarity with AWS RDS or other cloud database services (preferred).

Qualifications

• Microsoft certifications (e.g., MCSA, MCSE) in SQL Server.
• Experience with AWS cloud platforms.
• Hands-on experience migrating databases to cloud environments.
• Familiarity with DevOps practices and CI/CD pipelines for database deployments.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and ability to work independently.
• Effective communication and collaboration skills.
• Ability to manage multiple priorities and projects simultaneously.

Benefits

Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:

• Paid time off based on employee grade (A-F).
• Vacation: 12-25 days, depending on grade.
• Company paid holidays.
• Personal Days.
• Sick Leave.
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada).
• Retail savings plans (e.g., 401(k) in the U.S., RRSP in Canada).
• Life and disability insurance.
• Employee assistance programs.
• Other benefits as provided by local policy and eligibility.