Senior SQL DBA with Cloud & automation expertise

RAJESWARREDDY

Sr.DatabaseAdministrator

CT,USA +1-618-***-**** *********.*****@*****.***

SUMMARY

Experienced Database Administrator with over 13 years of expertise in MS SQL Server (2005–2022) and 3 years in PostgreSQL administration. Proven skills in installing, configuring, and migrating databases across on-premise SQL Servers

, Azure (IaaS/PaaS), and AWS (EC2/RDS) platforms. Proficient in DevOps and CI/CD automation with expertise in Terraform, Ansible, GitHub, and Jenkins. Specialized in HA/DR solutions including Always On, Clustering, Replication, and Log Shipping. Strong background in performance tuning, T-SQL development, index optimization, and query troubleshooting using tools like SQL Profiler, Extended Events, DMVs and Query Store. Hands-on with SSIS, SSRS, SSAS, PowerShell scripting, and managing large- scale databases (>12TB). Skilled in data modeling (Erwin), cloud migration, security automation (CyberArk), SQL automation (PowerShell) and monitoring tools like Fog light, Idera, Splunk, Grafana . 24x7 production support, with a strong understanding of both SQL Server and PostgreSQL architectures.

SKILLS

Database Platforms: Microsoft SQL Server (2005–2022), Azure SQL Database, Azure SQL Managed Instance, AWS EC2 & RDS (SQL Server, PostgreSQL), PostgreSQL

Cloud Automation: Terraform, Ansible, PowerShell

High Availability & Disaster Recovery: Always On Availability Groups, Distributed AGs, Failover Clustering, Log Shipping, Replication, Database Mirroring

Performance Tuning: Query Optimization, Execution Plans, Index Tuning (Filtered, Column store), Statistics Maintenance, TempDB Optimization, Parameter Sniffing Mitigation, DMVs, Extended Events

Automation & Scripting: PowerShell, T-SQL, SQLCMD, Batch Scripts, Azure DevOps Pipelines, Terraform (IaC), CI/CD

ETL & Reporting: SSIS, SSRS, SSAS, Data Migration Assistant (DMA), SQL Server Data Tools (SSDT), Change Data Capture (CDC), Master Data Services (MDS), Data Quality Services (DQS)

Security & Compliance: Transparent Data Encryption (TDE), Row-Level Security (RLS), Credential Vaulting (CyberArk), SSL/TLS Encryption, Role-Based Access Control (RBAC), Vulnerability Assessment, Audit Trail Setup

Monitoring & Diagnostics, Tools : Idera SQL Diagnostic Manager, SolarWinds, Foglight, Splunk, SQL Profiler, Query Store, Execution Plan Analysis, Performance Monitor, used PUTTY Tool to access linux servers

Backup Solutions: IBM Tivoli Storage Manager (TSM), Native SQL Backups, Azure Backup, Automated Patch Management

Cloud Platforms: Microsoft Azure (IaaS, PaaS), AWS EC2 & RDS, Azure Data Factory (ADF), Azure DevOps, AWS Data Migration Service (DMS)

Version Control & DevOps: Team Foundation Server (TFS), Git, PowerShell Automation, Release Management

CERTIFICATIONS

Azure Database Administrator Associate certification.

WORKEXPERIENCE

Client: Hartford Insurance (Hartford, Connecticut) Jun 2025 – Present

Implementation Partner: Cognizant

Sr. Database Administrator/Cloud DBA

•Designed, configured, and managed SQL Server 2022 Always on Availability Groups with multi-subnet failover and automatic page repair, supporting high availability and disaster recovery (HADR).

•Built and deployed server infrastructure by developing code in Visual Studio, configuring Terraform files, pushing to GitHub via GitHub Desktop; automated builds using Jenkins’s pipeline and resolved failures by troubleshooting Terraform workspace errors.

•Migrated high-impact prod databases from SQL Server 2016 on-premises to AWS EC2 and RDS instance using native backups and AWS Database Migration Service (DMS), minimizing application downtime during the cutover window.

•Improved query performance by analyzing execution plans, indexing strategies, Query Store insights; leveraged Dynamic Management Views (DMVs) and Extended Events to identify parameter sniffing, missing indexes, and I/O bottlenecks.

•Worked on database assessments for on premises SQL environments using AWS Schema Conversion Tool (SCT),Fog light reports leveraged findings to successfully migrate application databases to Amazon Aurora PostgreSQL and AWS EC2

•Diagnosed resolved transactional replication latency and reinitialization issues by tuning distributor/agent profiles, monitoring latency using Replication Monitor, and refactoring publication articles to support real-time analytics and reporting pipelines.

•Automated infrastructure provisioning for SQL Server clusters in AWS EC2 by deploying Terraform modules and Ansible playbooks; enforced enterprise naming standards

•Resolved Always on AG synchronization issues, ensuring data consistency and high availability.

•Developed PowerShell scripts to monitor SQL Server performance (CPU, memory, I/O) and generate daily health check reports

•Performed all DBA Tasks on SQL servers, Resolving Database, CPU/memory performance, blocking, and deadlock issues

•Created CTE’S, temp tables and Modified Tables, stored procedure, Views as per the requirement, resolved blocking issues.

•Used Rubrik tool to perform automated database backups and recovery, ensuring data protection and business continuity.

•Worked on supporting DR test activities for SQL applications, Performed Failover/Failback for Always ON AG servers

Client: State of Arkansas Department of Finance and Administration (Little Rock, Arkansas) June 2024 – MAY 2025

Sr. Database Administrator/Cloud DBA

•Configured and administered SQL Server 2022 Always On Availability Groups, resolving synchronization, failover, blocking, and deadlock issues.

•Improved overall SQL Server performance by identifying bottlenecks, tuning stored procedures, optimizing indexes/queries, and fixing long-running queries and high CPU/memory utilization problems.

•Designed and optimized database structures including CTEs, temporary tables, tables, views, and stored procedures to meet application and performance requirements.

•Implemented Transparent Data Encryption (TDE) on production databases to enhance data security and compliance.

•Managed and troubleshot Transactional Replication, ensuring stable and low-latency data synchronization.

•Built and configured AWS EC2 servers, migrated on premises SQL Server 2016 databases to SQL Server 2022 on EC2.

•Managed SSIS deployments, ETL configurations, and resolved ETL job failures for continuous data pipeline reliability.

•Managed all DBA tasks including job failure resolution, space management, timeout troubleshooting, SQL job optimization.

•Automated server builds, SQL installations, patching, and update rollouts using PowerShell; applied patches to SQL/application servers and resolved post-patch service issues.

•Utilized Terraform, Ansible, GitHub, and Jenkins for Infrastructure as Code (IaC), CI/CD automation, and deployment orchestration.

•Migrated SQL 2016 databases from on premises to SQL Server 2022 on Azure SQL Managed Instance, leveraging PaaS features for automated patching, high availability.

•Designed and implemented end-to-end ETL pipelines using SSIS, enabling incremental data loads, complex transformations, robust error handling, and automated reconciliation between SQL Server OLTP systems

•Provided 24x7 support for production database environments, led weekly capacity planning and performance review meetings, and mentored junior DBAs on high availability, DR, and advanced troubleshooting practices.

Client: DELL Technologies (Austin, Texas) Feb 2023 – April 2024

Implementation Partner: UST Global

Sr. Database Administrator/Cloud DBA

•Led enterprise-scale database migrations to Azure SQL MI and Azure Virtual Machines (IaaS) using Azure DMS, Azure Data Factory, native backup/restore strategies, streamlining cloud adoption with zero data loss minimal business disruption.

•Architected and managed Always On Availability Groups (AGs) and Distributed AGs spanning multiple Azure regions and on-prem data centers, optimizing Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for critical systems.

•deployment across environments, login audits, and compliance reporting, significantly reducing manual overhead and improving operational efficiency.

•Installation & Maintenance of SQL 2022/2019/2017/2016/2014/2012 servers, Upgraded SQL server versions to latest patches and automated SQL installations using PowerShell scripts.

•Developed and scheduled automated PowerShell scripts for SQL Server cumulative updates, service pack rollouts, and agent job deployment, integrated into Azure DevOps CI/CD pipelines, achieving zero manual intervention and audit-compliant patching cycles.

•Used Azure data factory with Data factory pipelines transferred data from on-premises to Azure.

•Optimized database performance and significantly reduced query latency by implementing index redesign, statistics updates, MAXDOP tuning, parallelism adjustments and tempdb reconfiguration for high-transaction OLTP workloads.

•Utilized Extended Events, SQL Profiler, Query Store, and Idera Diagnostic Manager to monitor long-running queries, resolve deadlocks, trace blocking sessions, and analyze historical performance trends across environments.

•Engineered table partitioning and filegroup strategies for multi-terabyte OLAP and archival tables to improve query parallelism, data purging efficiency, and maintenance plan scalability.

•Collaborated with DevOps teams to build CI/CD pipelines for database deployments using Terraform modules, Azure DevOps YAML pipelines,schema drift detection,pre-deployment validations, enabling controlled auditable DB changes.

•Implemented backup, disaster recovery across environments using native backups Azure Recovery Services Vault.

•Worked on performing PostgreSQL database maintenance tasks, Postgres Database failover as part of maintenance activity

Client: SAP Concur (Bellevue, WA) Dec 2021 – Feb 2023

Implementation Partner: Accenture

Sr. Database Administrator

•Migrated SQL Server 2012/2014 instances to SQL Server 2019 and Azure SQL Databases using native backup/restore, Data Migration Assistant (DMA), and Azure Data Factory (ADF) pipelines, ensuring zero data loss and minimal downtime.

•Designed and deployed Windows Server Failover Clustering (WSFC) with two-node Always on Availability Groups, configuring quorum modes, availability mode, listener-based routing for seamless failover and read-scaling and handled clustering issues

•Worked on fixing long running queries and reduced the runtime of the queries and jobs.

•Created, deployed and managed reports using SQL Server Reporting Services (SSRS).

•Extensively used the native tools like Extended Events, SQL Server Profiler, Performance Monitor, Query store

•Created fully automated scripts using PowerShell, SQLCMD and batch utilities to manage SSL certificate renewals, agent job

•Migration of databases from on premise to Azure Cloud environment (PAAS, IAAS).

•Installed & Managed SQL 2019/2017/2016/2014/2012 Servers. and applied latest SQL patches

•Worked on fixing vulnerability issues on SQL Servers based on the Splunk scan report.

•Worked on using Tivoli storage manager (TSM) for Database backups and Database restores

•Create and configure SQL servers, databases, elastic pools in Azure Cloud PAAS.

•Worked as onsite DBA lead and managed offshore DBA team and coordinated with Application and support teams.

•Worked in Managing Client's MS Azure based IAAS & PAAS (Azure DB model managed instance).

•Implemented TDE (Transparent Data Encryption) on Production DB’s to secure customer data.

•Migrated Databases from on Prem SQL Environments to Amazon RDS SQL Server (AWS).

Client: Premera Blue Cross (Bellevue,WA)) Jun 2021 – Dec 2021

Implementation Partner: Cognizant

Sr. Database Administrator

•Worked on Database Migration project and migrated old SQL versions to latest SQL 2019 version

•Worked on configuring and installing standalone and clustered servers as part of migration project

•Migrated SQL server 2008R2/2012 database servers to SQL 2019 Servers.

•Migrated databases from on prem to Azure cloud (IAAS)

•Worked on Deployments, change tickets and worked on server and database issue alerts

•Worked on SSL certificate issues on SQL Servers.

•Worked on fixing and high CPU and memory usage alerts on the SQL Servers.

•Involved in all the DBA activities and helped the team in solving the daily issues on priority.

•Documenting all the issues encountered and activities accomplished in environment.

Client: Equitable (Jersey City,NJ) Apr 2020 – Apr 2021

Implementation Partner: DXC technology

Sr. Database Administrator

•Executed seamless migration of business-critical workloads to Azure SQL Database using Azure Data Migration Service (DMS), Data Sync, PowerShell- validation scripts, ensuring referential integrity and zero data discrepancies post-migration.

•Designed and deployed Always On Availability Groups (AGs) with distributed replicas across multiple availability zones, including read-only routing configurations for offloading reporting workloads to secondary nodes without affecting OLTP.

•Investigated and resolved memory dumps, unexpected failovers, and resource contention by fine-tuning instance-level settings including min/max server memory, cost threshold for parallelism, and MAXDOP, improving cluster stability and performance under load.

•Utilized SolarWinds Database Performance Analyzer (DPA),Fog light to proactively monitor SQL performance, identify blocking sessions, track deadlocks, and conduct capacity planning and license usage audits across hybrid environments.

•Performed regular disaster recovery testing, validating point-in-time restores, native backup chains, and TSM-based offsite backups; created automated restore verification tasks to meet internal RTO/RPO compliance targets.

•Hardened identity and service account management by integrating CyberArk for privileged access control, rotating service credentials, and applying Active Directory Group Policy Objects (GPOs) to enforce least-privilege access models.

•Significantly reduced CPU usage on high-load transactional systems by refactoring queries, creating indexed views, filtered indexes, and applying optimizer hints and query plan forcing to ensure consistent and efficient execution patterns.

•Managed end-to-end deployment scheduling, change request documentation, and rollback planning through close collaboration with DevOps engineers, PMO stakeholders, and application owners, ensuring zero-impact release cycles across QA, staging, and production environments.

Client: Corteva Agriscience (Johnston, IA) Apr 2016 – Mar 2020

Implementation Partner: TCS

Sr. SQL Server DBA

•Led the modernization of legacy systems by migrating SQL 2008 R2/2012 instances to SQL 2016/2017, hosted on Azure, Data Migration Assistant (DMA), custom data validation scripts, ensuring data integrity regulatory compliance process.

•Worked in Managing Client's Microsoft Azure based PaaS and IAAS environment

•Configured and Managed Active passive cluster, Transactional and Merge Replication and handled replication issues

•Worked on deploying databases in SQL azure and managed security on SQL azure Servers.

•Configured SQL server 2017 Always on availability groups with one secondary replica

•Migrated SQL Server Databases from on-premises to Azure SQL server.

•Maintained high availability DR (Log shipping, Database mirroring)

•Created, Deployed and processed OLAP cubes and Managed SQL server Analysis server (SSAS).

•Worked on fixing SQL certificate and SPN issues on the SQL Servers.

•Created and Used power shell scripts for daily DBA activities, Performed Table Partitioning on SQL server databases

•Migrated SQL server databases from 2008R2/2012 SQL Servers. to 2016/2017 Servers.

•Involved in Database migration from on Prem SQL to Amazon RDS SQL Server (AWS).

•Used batch scripts to install SQL Servers. and to configure database maintenance plans

•Troubleshooting issues occurred with the databases in Azure cloud environment.

Client: Chevron (Bakersfield, CA) Aug 2015 – Feb 2016

Implementation Partner :L&T Infotech

SQL Server DBA

•Installed, configured, maintained SQL 2005 through 2014 environments, ensuring high availability using Always On Availability Groups (AGs), log shipping, and transactional replication for critical oil & gas applications.

•Developed and deployed custom monitoring dashboards in Idera SQL Diagnostic Manager and Splunk, tracking key metrics such as SQL job failures, backup success rates, I/O latency, blocking sessions, enabling proactive incident management.

•Configured and maintained Transactional Replication.

•Executed recovery operations for corrupted or non-responsive SQL Server instances by restoring system databases (master, msdb), rebuilding SQL binaries, and applying emergency fixes with minimal downtime.

•Tuned complex large-volume transactional queries stored procedures by analyzing execution plans, using Dynamic Management Views (DMVs), and applying parameter sniffing and forced recompilations.

•automated certificate renewal rotation processes via PowerShell scripting to ensure compliance with security policies.

•Improved efficiency in incident resolution and routine maintenance tasks by automating processes such as index rebuilds, alert reviews and tempdb file cleanup using PowerShell and SQL Agent jobs.

Client: Estes Express Lines (Richmond, VA) Aug 2013 – Jul 2015

SQL Server DBA

•Deployed and administered SQL 2008 R2/2012, managing high availability (HA) and disaster recovery (DR) through Always On Availability Groups (AGs), database mirroring, and log shipping for critical transportation logistics systems.

•Implemented and managed the clustering environment like Active/Passive.

•Worked on migrating 2008r2 databases and ETL packages to SQL 2012 using TFS server.

•Worked on high availability SQL Server solutions, including Log shipping, Mirroring, Replication.

•Worked on (TFS), created team projects and builds to deploy databases, ETL Packages, SQL jobs.

•Worked on rebuilding SQL server due to unexpected crash by Rebuilding Master Database in Server as a part of recovery

•Installed configured master data services (MDS), IIS, SQL Server Data Quality Services (DQS)

•Involved in Capacity Planning and adding new storage space as needed

•Involved in recovery databases from damaged or suspect mode conditions.

•Implemented CDC (Change data capture) and Database encryption (TDE)

•Worked on tools like Idera diagnostic manager, pragmatic works doc xpress.

Client: PNC Bank (Columbus, Ohio) Sep 2012 – May 2013

SQL Server DBA/Developer

•Installed, configured, and maintained SQL Server 2008, 2008 R2, and 2012 instances.

•Performed data import across multiple instances using BULK INSERT and BCP utilities

•Designed and executed ETL processes to extract, transform, and load data from heterogeneous sources using SSIS

•Developed automated scripts for database backups and DBCC checks to ensure data integrity and availability.

•Created complex stored procedures, views, triggers and tables to support business logic and application requirements.

•Migrated databases between SQL Server environments using backup/restore and import/export methods.

•Migrated legacy DTS packages to SQL Server 2005 Integration Services and resolved associated SSIS package issues.

•Analyzed and established table relationships and enforced referential integrity using foreign key constraints.

EDUCATION

Master’s in electrical and computer Engineering Southern

Illinois university Carbondale - Aug 2012

Bachelor in Electronics and Communication JNTUH, INDIA – May 2010

Contact this candidate