SMRITI SINGH

SQL Server DBA

Capgemini India

Bengaluru

10.2021 - Current

Company Overview: Capgemini is a global leader in consulting, digital transformation, technology and engineering services
Administered over 1000 SQL Server instances across production, UAT, and development environments.
Performed health checks, server patching, and maintenance for optimal performance.
Automated monitoring using PowerShell and T SQL.
Designed and implemented disaster recovery strategies using native SQL Server backups, Log Shipping, and Always On Availability Groups.
Performed point-in-time recovery for critical production databases minimizing downtime and data loss.
Analyzed slow-running queries and optimized them using indexing strategies, query refactoring, and execution plan analysis.
Reduced index fragmentation through custom PowerShell scripts and maintenance plans to improve performance.
Developed PowerShell scripts for drive space monitoring, index fragmentation reports, and job status notifications.
Leveraged dbatools and SQLCMD to manage large SQL estates efficiently. Implemented SQL Server alerts and Database Mail for proactive issue detection.
Worked with Always On Availability Groups and SQL Server Failover Clustering to ensure high availability and data redundancy.
Managed database-level security by creating and auditing logins, roles, and permissions.
Supported internal and external audit processes by ensuring compliance with data governance policies.
Supported database code deployments using Redgate tools or manual scripts through change management processes.
Validated deployment scripts and collaborated with development teams for smooth release cycles.
Capgemini is a global leader in consulting, digital transformation, technology and engineering services

Similar Profiles