Sql Server Database Administrator

Location:

Plano, TX

Posted:

May 07, 2025

Contact this candidate

Resume:

Sridhar Sakamuri

Email: ******.*********@*****.***

Telephone (M): 214-***-****

Linked in: https://www.linkedin.com/in/sridhar-sakamuri/

Objective

Certified Azure Database Administrator and SQL Database with 15+ years of experience managing SQL Server production and non prod Databases highly skilled at database maintenance, performance tuning and Optimizations; On-premise databases to Cloud Migration, High Availability and Disaster Recovery Solutions I am a passionate contributor to team success with records of empowering teams. A self-starter who is always motivated to learn, grow, and stay current

Certifications

Microsoft Azure certified

MCP (Microsoft Certified Professional)

MCTS (Microsoft Certified Technology Specialist

ITIL® V3 Foundation.

Technical Skill Set

Databases: SQL Server 2022, SQL Server 2019, SQL Server 2014 and SQL 2012, SQL Server 2008, AWS, Cache database,AZURE and PostgreSQL

Scripting: PowerShell, and T-SQL

Domain Knowledge: Healthcare, Banking, Telecom, Logistics, Chemical and Insurance

Backup Tools: Tivoli, TDP SQL, NetBackup, Red Gate, DDBoost and Commvault

Ticketing Tool: Service now, Manage now, Maximo, HP Service center, remedy, and impact.

Monitoring tools: Tivoli Monitoring, Spotlight, BMC, Fog-light, Dynatrace and Foglight

Healthcare experience, experience with SOX, HIPPA regulations and Compliance data

Academic qualification

Bachelor of Technology from JNTU

Career Highlights

1)Working as Sr Database Administrator for ELXR technologies from Sep 2024 to till date

2)Worked as Sr Database Administrator for IMAGEVISION AI LLC from Nov2021 to Sep 2024)

3)Worked as Infra Ops Specialist (Sr SQL Database Administrator) for Cognizant Technology Solutions from OCT 2014 to 4th OCT 2021

4)Worked as Prof 1: Sr SQL Database Administrator for DXC technology formerly CSC from July 2011 to OCT 2014.

5)Worked as Operations lead specialist (SQL DBA) for IBM from July 2008 to July 2011.

Experience Summary

●15+ years of experience in Administering SQL Server databases in On-premises and cloud production environments

●Install and configure SQL Server database in a standalone/cluster environment with availability groups.

●Design and develop new database physical and logical structures and assess for new application functionality

●Maintain data availability for applications that are running 24x7

●Monitor and improve system health

●Hands-on experience with ITIL processes and practices

●Hands-on experience with Microsoft SQL Server 2008 and up in a production environment with replication, clustering, database mirroring and Always-On

●Thorough understanding of Microsoft SQL Server Best Practices

●Working with replication, clustering, database mirroring and Always-On

●Database Specialization –SQL Server, PostgreSQL, AWS and Azure platforms.

●Specialized as Administrator in

MS SQL Server Installation

oAll version of the MS SQL Server related to standalone and clustered Always On servers, Configure the Always On

Migration Planning and Design:

oCollaborated with cross-functional teams to assess existing on-premises infrastructure and applications for migration suitability.

oDesign and architect Azure-based solutions that align with business goals and requirements.

oDeveloped migration strategies, considering factors such as data transfer, networking, security, compliance, and application dependencies.

Migration Execution:

oLead the team for the actual migration process, including setting up Azure resources, configuring networking, and managing data transfer.

oDeploy, configure, and optimize Azure services and resources, ensuring high availability, scalability, and security.

oCollaborate with application owners to address any technical challenges during the migration process.

oExecute the migration while minimizing downtime and impact on end-users.

Database Configuration

oResolving Blocking, Deadlock, and SQL performance-related issues.

oHands-on experience of high high-availability SQL Server Solutions, including log shipping, Database Mirroring, SQL Server Clustering, and Always On availability groups.

oAWS and Azure SQL Database

Security and Compliance:

oImplemented security best practices in Azure, including identity and access management, network security, encryption, and compliance controls.

oEnsured adherence to industry standards and regulatory requirements during the migration process.

Backup and Recovery

oSet up the backup and restore strategy for production and test environments.

oExperienced with SQL Server and Oracle disaster recovery procedures.

oWorked in Disaster recovery practice to set up remote SQL Server and restore the backups and transaction log backups.

MS SQL Server Upgrades

oHands-on Experience in SQL and Oracle upgradation \migration of SQL lower versions to higher versions.

Documentation and Knowledge Sharing:

oCreated the comprehensive documentation of migration processes, architecture, and configurations.

oShare knowledge and best practices with the broader technical team to foster continuous improvement.

Application DBA support for end to end up to application Go live

Managing and and administering Snowflake accounts

Managing and and administering Snowflake data security and governance

Perform database monitoring and tuning for Snowflake

SQL Azure: Migrated the SQL Database to AWS Cloud

Administer disaster recovery, back-up, and data replication

maintenance, installation, and support of cache databases, Maintaining and securing databases, Working with developers to design and implement new features, and Troubleshooting issues

Database Creation, Space Management, and User Management of multiple terabytes of databases and servers

Hands Experience in managing, monitoring and troubleshooting all version of SQL Server issues multiple terabytes databases and servers

Scheduling and monitoring the SQL maintenance Jobs (Integrity, Optimization and backups) as per the client’s requirements.

Performing Database Backup and refreshment using tools like TSM, TDP SQL, Red gate and NetBackup

Performing daily backups using Tivoli Storage manager (TSM) and TDP SQL

Performing Security Health checks and ensuring SQL as per compliance standards. HIPPA and SOX compliance standards

Migrated to the database to Higher version and Cloud

New project transition end to end support

Supported all activities associated with PostgreSQL databases DBA activities, Backup and Recovery, Patching, cloning, Migration, Performance management.

Experience with PostgreSQL tools/utilities, extensions including psql/pg_Admin

PG_dump and PG_Restore.

Worked on PostgreSQL Database replication, clustering, backups and crash recovery

Healthcare experience, experience with SOX, HIPPA regulations and Compliance data

Performing daily activities including Application support, Database monitoring and performance tuning and fixing Performance related issues for data warehouse databases.

Understanding the client requirements and designing the databases by doing capacity planning.

PowerShell Scripting for Process Automation and Health checks reports

Database migration from on-premises databases to AWS RDS and Azure

Enabling audit and security to all production, QA and Development databases. Supporting and tuning application jobs and loads.

Creating scripts to check file system utilizations on servers and purging log files, trace files and old dump files after retention period.

Maintaining peak performance of all primary databases by providing advanced tuning methods and tips to developers so that server resources are used optimally to best.

Experience on HP Polyserv and Window clustered environment

Migrating & upgrading databases to higher versions across platforms and installing CPU patches. Rebuilding indexes.

Installing & configuring new SQL Servers for various environments (Prod/DEV/QA).

Upgrading SQL Server instances (including stand-alone & Failover Cluster) to different versions/editions to meet business demands.

Configuring SQL Server maintenance plans for DB backups and housekeeping tasks automation.

Performing database refreshes between various DB environments and exporting tables

Installing SQL Server integration services and deploying the SSIS packages through SQL Agent jobs, troubleshooting the execution failures.

Dealing with regular and common issues reported by the application support teams includes slowness, timeouts, deadlocks etc.

Plan and Develop roadmaps and deliverables to advance the migration of existing solutions on-premise databases to Azure

Plan and Develop roadmaps and deliverables to advance the migration of existing solutions on-premise database to Azure cloud

propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure

experience with MS SQL Server Integration Services (SSIS),T-SQL skills, stored procedures and triggers

Ensures compliance to server specific architectural standards and implementation Practices

creates and maintains Disaster Recovery procedures and participates in periodic disaster recovery testing

Created Azure SQL database, performed monitoring and restoring of Azure SQL database.

Performed migration of Microsoft SQL server to Azure SQL database.

Advise on cost efficiency for future usage and cost optimization for current infrastructure

Establish, design and support an enterprise Cloud SQL architecture that provides the required capacity, control and supports the long-term strategic goals for enterprise database solution Azure Data Factory(ADF),Integration Run Time(IR),File System Data Ingestion, Relational Data Ingestion

designed and implementation of the High Availability(HA) systems (24x7x365) and Disaster Recovery models(DR): including Setup, Configuration, and Monitoring of Database Recovery strategies such as AlwaysOn, Failover Clustering, Replication, Log Shipping and Database Mirroring

Migrated the existing SQL Server instances to Azure SQL or provision a new Azure SQL database.

Backup and restore Azure SQL databases.

Monitor and optimize the performance of your cloud database to meet your needs.

Automate common management tasks using PowerShell.

Modernize your existing applications with Azure SQL Managed Instance.

Project Profile in Imagevision.ai LLC,and ELXR technologies

Clients: Kaiser Permanente

Account Domains: HEALTH CARE

Project Duration: Nov 2021 to till date

Roles and Responsibilities

Set up and manage Always-On High Availability for HA/DR, Log shipping to automate and Synchronize Backups to a secondary server for Disaster recovery as additional security for Mission Critical databases in our environment

Mange Azure SQL Databases and Azure Migration Engineer

Create Data Models for new and modernized legacy Databases, implement database design following best practices to maximize performance and reduce data redundancy.

Maintain Database Security and Consistency in SQL Server by running database validation Checks with consistency checks with DBCC and DMVs proactively

Hands-on experience with ITIL processes and practices

Healthcare experience, experience with SOX, HIPPA regulations and Compliance data

Experience in Automation and Deployment and handling SOX and HIPPA Compliance data

Always On Configuration and troubleshooting issues

Managing and and administering Snowflake accounts

Managing and and administering Snowflake data security and governance

Perform database monitoring and tuning for Snowflake

PowerShell Scripting for Process Automation and Health checks reports

Hands-on experience with clustering, database mirroring, and Always-On

Thorough understanding of Microsoft SQL Server Best Practices

Performing daily activities including Application Support, Database monitoring, and performance tuning and fixing Performance-related issues for data warehouse databases.

Migrate existing SQL Server instances to Azure SQL or provision a new Azure SQL database.

Backup and restore in Azure SQL databases.

Experience with PostgreSQL tools/utilities, extensions including psql/pgAdmin,PG_dump, PG_Restore.

Worked on PostgreSQL Database replication, clustering, backups and crash recovery, PITR.

Implemented test backup and disaster recovery strategies.

maintenance, installation, and support of cache databases, Maintaining and securing databases, Working with developers to design and implement new features, and Troubleshooting issues

Develop and maintain recovery plans and procedures.

Performed periodic disaster recovery drills.

Manage user access, roles,and permissions Regularly audit and patch database vulnerabilities.

Worked on applying database security service principles and access control

Responsible for database administration including database system configuration, database creation, security patches, performance tuning and monitoring.

Supported all activities associated with PostgreSQL databases DBA activities, Backup and Recovery, Patching, cloning, Migration, Performance management.

Involves activities Backups, Crash Recovery, PITR, Minor/Major Patching and upgrade, Migrations

Worked on extensions - pg_repack, pg_partman, pg_audit.

Foreign Data Wrappers of PostgreSQL (postgres_fdw, oracle_fdw, tde_fdw, file_fdw).

Monitor and optimize the performance of your cloud database to meet your needs.

Automate common management tasks using PowerShell.

Ensure your data and applications are highly available and have disaster recovery.

Modernize your existing applications with Azure SQL Managed Instance.

Understanding the client requirements and designing the databases by doing capacity planning.

Enabling audit and security to all production databases. Supporting and tuning application jobs and loads.

Creating scripts to check file system utilization on servers and purging log files, trace files and old dump files after the retention period.

Experience in data modeling and application database design

Maintaining peak performance of all primary databases by providing advanced tuning methods and tips to developers so that server resources are used optimally to best.

Migrating & upgrading databases to higher versions across platforms and installing CU patches

Experience on sql database, backup, restore and maintenance

Installing & configuring new SQL Servers and PostgreSQL for various environments (Prod/DEV/QA).

Upgrading SQL Server instances (including stand-alone & Failover clusters) to different versions/editions to meet business demands.

Configuring SQL Server maintenance plans for DB backups and housekeeping tasks automation.

Performing database refreshes between various DB environments (UAT, Dev and Test)

Using Terraform to create a script that builds some EC2 Servers and a RDS (using AWS Amazon Provider)

Installing SQL Server integration services and deploying the SSIS packages through SQL Agent jobs, troubleshooting the execution failures.

Dealing with regular and common issues reported by the application support teams including slowness, timeouts, deadlocks, etc.

Experience in migrating databases from on premise to AWS and Azure cloud environments.

Design and develop new database physical and logical structures and assess for new application functionality multiple terabytes databases and servers

Migrate SQL Server Databases to Microsoft Azure-hosted DBs, Managed instances. Configured High Availability Solution; Always-On, Log Shipping, migration, patching, troubleshooting, optimization, maintenance (modeling, High-Availability (HA), and Disaster Recovery (DR)).

Performed Database Migration from On-Premises SQL environment to Azure Database in the cloud Manage database security and users in Active Directory, ensure Database Integrity and set up maintenance plans via SQL Agent. Stored Procedures,

Experience with Agile, Continuous Integration, Continuous Deployment and leading project delivery

supporting applications following system development life cycle and SDLC

Automated and reduce workflow with the help of store procedures, scripts, Redgate, and Microsoft Integration services, which run daily to reorganize, rebuild, update statistics, and Backup.

Configured Transparent Data Encryption using AES256 Algorithm to make sure that all databases are fully encrypted and secure from Hackers and Malicious users