Swathi S

SQL Server DBA with 12+ years of experience across SQL Server 2012–2022, specializing in database administration, design, migration, and production support. Strong expertise in installation, configuration, performance tuning, and maintenance of mission-critical database environments. Hands-on experience with High Availability & Disaster Recovery (HA/DR) solutions including Always On, Failover Clustering, Log Shipping, Replication, and Mirroring.

Strong expertise in SQL Server, Redis, and Azure Cosmos DB, experienced in managing both relational and NoSQL databases in cloud environments. Skilled in performance tuning, automation using PowerShell/Python, and ensuring high availability, scalability, and data security. Proven ability to support production systems, troubleshoot critical issues, and optimize database performance for distributed applications.

Proven track record in large-scale database migrations and upgrades (in-place and side-by-side) across multiple SQL Server versions. Skilled in database performance optimization using indexing strategies, query tuning, DBCC utilities, and proactive monitoring.

Experience managing high-volume production environments with 100+ databases per server across distributed locations. Strong exposure to AWS cloud services and hybrid infrastructure support. Expertise in backup, recovery, and disaster management, ensuring data integrity and business continuity and proficient in SQL Server security administration, including user access management, roles, and permissions.

Hands-on experience with Windows Clustering, Active Directory integration, and server monitoring. Expertise in SQL Server Agent, SSMS, and Profiler for job automation, monitoring, and performance diagnostics. Hands-on experience with Extended Events and Dynamic Management Views (DMVs) for deep performance analysis and troubleshooting.

Proficient in PowerShell scripting for automating database administration tasks and deployments and experience in implementing Always On Availability Groups (AG) for high availability and failover strategies. Strong experience with Azure Data Studio and SQLCMD utilities for cross-platform database management and skilled in storage and capacity planning, optimizing disk I/O using RAID configurations and filegroup strategies.

Experience with data compression (row/page) and partitioning techniques to improve performance and manage large datasets. Hands-on experience in database auditing and compliance, ensuring adherence to security and regulatory standards. Proficient in ETL support using SSIS, handling data loads, transformations, and troubleshooting package failures and experience in query execution plan analysis and resolving blocking, deadlocks, and long-running queries.

Strong knowledge of tempdb optimization and resolving contention issues in high-concurrency environments and experience in configuring and maintaining Database Mail, Alerts, and Operators for proactive monitoring. Hands-on experience in index fra

Senior SQL Server DBA - Charles Schwab - Westlake, TX

(2024-04)

The project focused on managing and optimizing a high-availability SQL Server environment supporting real-time banking and financial transactions, ensuring performance, security, and zero downtime through robust HA/DR solutions and cloud migrations.

• Administering and maintaining highly available SQL Server databases supporting trading, brokerage, and financial transaction systems in a 24/7 production environment.
• Administered and maintained SQL Server databases, ensuring high availability, performance, and data integrity across production and non-production environments. Managed and optimized Redis caching systems, improving application response times and reducing database load.
• Designing, implementing, and managing High Availability & Disaster Recovery (HA/DR) solutions using Always On Availability Groups, Failover Clustering, Log Shipping, and Replication.
• Monitoring database performance and proactively performing query optimization, indexing strategies, and execution plan tuning to improve system efficiency and reduce latency for high-volume transactions.
• Managing database migrations and upgrades across environments (on-prem to Azure/AWS cloud), ensuring minimal downtime and zero data loss.
• Designed, deployed, and maintained Azure Cosmos DB solutions for globally distributed, low-latency applications. Implemented performance tuning techniques (indexing, query optimization, execution plan analysis) to enhance database efficiency.
• Performing capacity planning, storage optimization, and resource utilization analysis to support large-scale financial data growth and ensure optimal database performance.
• Collaborating with development teams to review complex SQL queries, stored procedures, triggers, and ETL processes, ensuring adherence to best practices and performance standards.
• Ensuring data security and compliance with financial regulations by implementing encryption (TDE), role-based access control, auditing, and vulnerability assessments.
• Monitored database health and performance using tools like Azure Monitor, Query Store, and DMVs, proactively resolving bottlenecks.
• Supporting production incidents and root cause analysis (RCA), resolving critical database issues within SLA timelines and minimizing business impact.
• Automating routine DBA tasks using PowerShell, T-SQL scripts, and SQL Agent Jobs, improving operational efficiency and reducing manual intervention.
• Managing and maintaining database monitoring tools (such as SQL Profiler, Extended Events, and third-party tools) to track system health and performance metrics.
• Coordinating with cross-functional teams for release management, deployment activities, and change management processes in Agile/Scrum environments.
• Implementing and maintaining data integrity, consistency, and governance standards across multiple financial applications and reporting systems.
• Automated routine DBA tasks using PowerShell and Python scripting, improving operational efficiency and reducing manual effort.
• Configured and maintained backup and recovery strategies, ensuring compliance with RPO/RTO requirements.
• Supporting data warehouse and reporting systems, ensuring optimized data loads and query performance for business intelligence tools like Power BI and Tableau.
• Conducting database patching, upgrades, and security hardening, ensuring compliance with organizational and regulatory standards.

Senior SQL Server DBA - BNY - New York, NY

(2021-03 - 2024-03)

The project focused on managing and optimizing mission-critical SQL Server databases in a banking environment, ensuring high availability, performance, and data security across Production, UAT, and DR systems while supporting cloud migrations and continuous database improvements.

• Managed and supported mission-critical SQL Server databases across Production, UAT, and DR environments, ensuring high availability and system reliability for financial applications.
• Administered SQL Server 2