Sql Server Dba
Resume:
Suresh Nadipineni
E-mail: ****.**********@*****.***
Mobile: 469-***-****
Professional Summary:
Having around 9.5 years of experience in Database Administration and Production Support as SQL DBA with proficiency in SQL Server 2005/2008/2008 R2, 2012, 2016, 2017, 2019 & 2022
Installation, configuration and maintenance of SQL Server 2005/2008, 2008 R2, 2012 and 2016, 2017,
2019 & 2022
Experience in implementing and managing backup strategies.
Experience in administering SQL Server High Availability and Disaster Recovery Strategies using. Always On, Replication, Mirroring and Log Shipping.
Hands on experience in Database Backups, Restores, Attach and Detach databases, shrinking Log files etc.
Experience in configuring database mail for SQL server alerts.
Experience in planning and implementing MS SQL server security and database permissions.
Good experience in Migration of databases between Servers
Experience in configure Log shipping from on prim server to AWS instances.
Experience in Migrating the data from oracle cloud to SQL SERVER & and configured Always on High Availability.
Experience on Migrating the data from Oracle Schema to SQL Server DB by using SSMA Tool.
Experience in PowerShell scripting while using configure the Always on High availability concepts implemented from source to destination servers.
Experience on AZURE SQL Database, AZURE SQL DB Managed instance & SQL SERVER on AZURE VM.
Experience on AWS EC2 and RDS server.
Good Experience on IAM, S3, EBS, Cloud metrics, Cloud watch, Route 53, Cloud Formation.
Experience on creating maintenance plans like database backups, update statics and rebuild indexes, reorganize indexes based on Fragmentation.
Experience in SQL Server tools, including Management Studio, Query Editor, Profiler, SQL Server Agent.
Managing the Disk Space and Memory management and maintaining the daily checkup of Systems.
Refreshes from Production backup to Test and Development environments.
Scheduling jobs in SQL Server Supporting huge production databases, troubleshooting the problems.
Managing Security, creating users, logins and roles and granting permissions.
Configured the Transactional replication.
Worked on Import and Export tables in OLEDB.
Extensively involved in Performance and tuning.
Experience in using DBCC commands, Dynamic Management View’s and Stored procedures.
Experience in 2 node failover clustering.
Experience ITIL Process change, problem and Incident management.
Provided 24/7 Supports for Production, Development & Test Servers of MSSQL Servers.
Education Summary:
MCA- 2012 from JNTU Kakinada,
Work Experience:
SQL SERVER DBA with Think Logic Systems Inc, From March 2025 to till date
SQL SERVER DBA with Cognizant, From Dec 2022 to March 2025
SQL SERVER DBA with Sonata software Limited, From Jan 2020 to July 2022.
SQL SERVER DBA with L & T Infotech, From November 2018 to Jan 2020.
SQL SERVER DBA with WIPRO Limited, From March 2017 to May 2018.
SQL SERVER DBA with IBM India Pvt. Ltd, From May 2015 to Feb 2017
Certifications:
70-764: Administering a SQL Database Infrastructure.
70-765: Provisioning SQL Databases.
AZ-900 - Microsoft Azure Fundamentals.
Technical Skills:
Databases : MS SQL Server 2005/2008/2008 R2, 2012, 2016, 2019 & 2022
Operating System : Windows server 2003/2008/2008 R2/2012.
Languages : T-SQL
Other Tools : BMC Remedy
Project 1:
Client : Hartford
Team Size : 8
Role : SQL Server DBA.
Environment : SQL Server 2005/2008/2008R2/2012, 2016, 2019 & 2022
Duration : December 2022– Till Date
Job Responsibilities:
Involved in all aspects of Database Administration in MS-SQL Server 2005/2008/R2 and 2012, 2016, 2019 & 2022
Installed MS SQL Servers 2008, 2008 R2 and 2012, 2016, 2019 & 2022
SQL Server High Availability and Disaster Recovery Strategies using. Always On, Replication, Mirroring and Log Shipping.
Administered and managed AWS cloud environments, including EC2 instances, VPCs, IAM, S3, and RDS, ensuring optimal performance and cost efficiency.
Designed, implemented, and maintained highly available and fault-tolerant systems on AWS using services such as Elastic Load Balancing (ELB), Auto Scaling, and Route 53.
Configured and managed IAM roles, policies, and user permissions to ensure secure and compliant access to AWS resources.
Implemented disaster recovery strategies using AWS services like AWS Backup, EC2 snapshots, and S3 Glacier to ensure data durability and availability.
Implemented disaster recovery strategies using AWS services like AWS Backup, EC2 snapshots, and S3 Glacier to ensure data durability and availability.
Creating and scheduling jobs for Database Maintenance.
Checking specific back up and restoration files are storing specified drives are not.
Recovering the databases from backup in disasters.
Checking the database data file and log file is located specific drive and observe the available free space.
Configuring database mail for SQL server alerts
Checking Alerts and resolve issues to take appropriate action as needed.
Configure the maintenance plan for backups and cleanups.
Responsible for monitoring and making recommendations for performance improvement in hosted databases.
File group modifications, Implementation of SQL Logins, Roles and Authentication Modes.
Managing space for data files and log files. Implementing Cluster & Always On setup.
Add the databases to Availability replicas in Always On groups.
Experience in Migrating the data from oracle cloud to SQL SERVER & and configured Always on High Availability.
Experience on Migrating the data from Oracle Schema to SQL Server DB by using SSMA Tool.
Experience in Migrating the databases from on prime server to AWS Environment.
Project 2:
Client : Microsoft.
Team Size : 4
Role : SQL Server DBA.
Environment : SQL Server 2005/2008/2008R2/2012, 2016n & 2019
Duration : January 2020– July 2022
Job Responsibilities:
Involved in all aspects of Database Administration in MS-SQL Server 2005/2008/R2 and 2012 & 2016.
Installed MS SQL Servers 2008, 2008 R2 and 2012, 2016 & 2019.
SQL Server High Availability and Disaster Recovery Strategies using. Always On, Replication, Mirroring and Log Shipping.
Creating and scheduling jobs for Database Maintenance.
Checking specific back up and restoration files are storing specified drives are not.
Recovering the databases from backup in disasters.
Checking the database data file and log file is located specific drive and observe the available free space.
Configuring database mail for SQL server alerts
Checking Alerts and resolve issues to take appropriate action as needed.
Configure the maintenance plan for backups and cleanups.
Good experience in Migration of databases between Servers.
Experience in Migrating the data from oracle cloud to SQL SERVER & and configured Always on High Availability.
Experience on Migrating the data from Oracle Schema to SQL Server DB by using SSMA Tool.
Experience on AZURE SQL Database, AZURE SQL DB Managed instance & SQL SERVER on AZURE VM.
Experience in PowerShell scripting while using configure the Always on High availability concepts implemented from source to destination servers.
Responsible for monitoring and making recommendations for performance improvement in hosted databases.
File group modifications, Implementation of SQL Logins, Roles and Authentication Modes.
Managing space for data files and log files. Implementing Cluster & Always On setup.
Add the databases to Availability replicas in Always On groups
Project 3:
Client : SCANIA.
Team Size : 8
Role : SQL Server DBA.
Environment : SQL Server 2005/2008/2008R2/2012 & 2016.
Duration : November 2018 – Jan 2020
Job Responsibilities:
Involved in all aspects of Database Administration in MS-SQL Server 2005/2008/R2 and 2012 & 2016.
Installed MS SQL Servers 2008, 2008 R2 and 2012, 2016 & 2019
SQL Server High Availability and Disaster Recovery Strategies using Always On, Replication, Mirroring and Log Shipping.
Creating and scheduling jobs for Database Maintenance.
Checking specific back up and restoration files are storing specified drives are not.
Recovering the databases from backup in disasters.
Checking the database data file and log file is located specific drive and observe the available free space.
Configuring database mail for SQL server alerts
Checking Alerts and resolve issues to take appropriate action as needed.
Configure the maintenance plan for backups and cleanups.
Responsible for monitoring and making recommendations for performance improvement in hosted databases.
File group modifications, Implementation of SQL Logins, Roles and Authentication Modes.
Managing space for data files and log files. Implementing Cluster & Always On setup.
Add the databases to Availability replicas in Always On groups
Project 4:
Client : Suzlon Energy Limited.
Team Size : 1
Role : SQL Server DBA.
Environment : SQL Server 2005/2008/2008R2/2012 & 2016.
Duration : March 2017 – May 2018
Job Responsibilities:
Involved in all aspects of Database Administration in MS-SQL Server 2005/2008/R2 and 2012 & 2016.
Installed MS SQL Servers 2008, 2008 R2 and 2012 & 2016
Designing a data restoration Strategies depending upon the business needs (Full, Simple and Bulk logged Models).
Creating and scheduling jobs for Database Maintenance.
Checking specific back up and restoration files are storing specified drives are not.
Recovering the databases from backup in disasters.
Checking the database data file and log file is located specific drive and observe the available free space.
Configuring database mail for SQL server alerts.
Monitoring and resolving issues related to Log shipping, mirroring and Replication.
Used Red gate for backup and restore operations.
Checking Alerts and resolve issues to take appropriate action as needed.
Configure the maintenance plan for backups and cleanups.
Responsible for monitoring and making recommendations for performance improvement in hosted databases.
File group modifications, Implementation of SQL Logins, Roles and Authentication Modes.
Managing space for data files and log files.
Implementing Cluster & Always On setup.
Add the databases to Availability replicas in Always On groups.
Project 5:
Client : State Street Corporation
Team Size : 14
Role : SQL DBA.
Environment : SQL Server 2005/2008/2008R2/2012. Duration : May 2015 – Feb 2017.
Job Responsibilities:
Involved in all aspects of Database Administration in MS-SQL Server 2005/2008/R2 and 2012.
Creating and implementing Change Requests.
Creating and monitoring the jobs and resolving the job failures if any.
Recovering the databases from backup in disasters.
Monitoring the disk space alerts closely and take an appropriate action on these issues.
Configuring database mail for SQL server alerts.
Configured Log shipping and Replication to improve the performance and monitoring them with high priority.
Involved in Database refresh activity.
Involved index modification, adding scheduled jobs to re-index and update statistics for the respective databases.
Implemented SQL Logins, Roles and Authentication Modes.
Experience on failover clustering.
As a part of the DBA team providing 24x7 production support to the clients.
Checking Alerts and resolving the issues.
Configure the maintenance plan for backups and cleanups.
Managing space for data files and log files.
Contact this candidate