RESUME
Email: [email protected]
Mbl: +91-9949726976
Professional Summary:
4+ years of IT experience in Database Administration and Support of MS SQL Server
2012/2008R2/2008/2005/2000 in Production, Staging, Test, Dev, and Cluster Server Environments.
Installing SQL Server 2005/2008/2008 R2/2012 Enterprise\Developer editions on production,
development, test and staging servers.
Installing hot fixes and service packs in standalone & SQL Clustered and upgrades when required.
Experience in Disaster Recovery Planning, Execution and Testing at remote side.
Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008/2012, MS SQL Server
2005 to MS SQL Server 2008/2012.
Experience in Database administration activities for DB Security (creating logins, users, roles, and
assigning permission to them).
Experience with implementing DR solution, High Availability of database servers using Database
mirroring and Log Shipping.
Experience in implementing SQL Server security and Object permissions like maintaining Database
authentication modes, creation of users, configuring permissions and assigning roles to users.
Troubleshooting production issues and raising high availability.
Managing cluster nodes and failover and failback of services and applications when required.
Checking status of backup, troubleshooting the failed backups and restoration& recovery of databases.
Daily checking and resolving the tickets depends on the priority levels.
Monitoring database server disk space and taking corrective actions/generating automated alerts.
Monitoring jobs, troubleshooting on failure and addressing alerts
Restoring databases from backups done on test servers to production servers
Providing 24x7 Off-Shore Production On-Call Support for timely resolution on severity incidents &
Emergency Change Requests.
Qualification:
Master of Computer Applications from Netaji Institute of Engineering And Technology, affiliated to Jawaharlal
Nehru Technological University, Hyderabad, India.
Technical Expertise:
Windows 2012/2008/2003 Servers
Operating System
MS SQL Server 2014,2012,2008,2008 R2, 2005 & 2000
Databases
SQL Server Tools SSMS, Profiler, Performance Monitor, Clustering Services (MSCS)
VPC Tools Citrix
Ticketing Tools: Service-now, HPSM
Monitoring Tools: Idera Diagnostic Tool
Work Experience:
Working as "SQL Server DBA" with "Avyaya IT Solutions Pvt Ltd", Hyderabad from April 2013 to till date.
#1
Company: IBM
Client : Xerox
Role : SQL Server DBA
Location : Hyderabad
Duration: November 2016 to Till date.
Responsibilities:
Installing SQL Server 2012/2008/2005 editions on production, development, test and staging servers.
Migrated SQL server 2005 to SQL Server 2008/2012 in Microsoft Windows Server 2012 Enterprise Edition.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security.
Working on Changes as per the business requirement.
Rebuilding / monitoring the indexes at regular intervals for better performance.
Checking status of backup, troubleshooting the failed backups and restoration& recovery of databases.
Recovering the databases from backup in disaster situations.
Daily checking and resolving the incidents depends on the priority levels.
Monitoring database server disk space and taking corrective actions/generating automated alerts.
Monitoring jobs, troubleshooting on failure and addressing alerts
Troubleshooting production issues and raising high availability
Performing SQL Server service pack installation.
Recovering the databases from backup in case of disasters.
Monitoring the server for High availability of the servers.
Solving the request raised by user support.
Performing Backup and Recovery tasks and Restoring databases.
Monitoring Disk Space of all the Servers and freeing up space as per SQL Server.
Supporting for 24/7 database maintenance.
Environment: SQL Server 2012/2008/2005/2000,Windows 2012/2008/2003 Server,
SSMS, Configuration Manager.
#2
Company: Wipro
Client: CAH, USA
Role: SQL Server DBA
Location: Bangalore.
Duration: April 2013 to October 2016
Responsibilities:
Installing SQL Server 2012/2008/2005 editions on production, development, test and staging servers.
Installing hot fixes and service packs in standalone & SQL Clustered and upgrades when required.
Migrated SQL server 2005 to SQL Server 2008/2012 in Windows Server 2008/2012 Enterprise Edition.
Working on Changes as per the business requirement.
Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
Checking status of backup, troubleshooting the failed backups and restoration & recovery of databases.
Recovering the databases from backup in disaster situations.
Daily checking and resolving the tickets depends on the priority levels.
Monitoring database server disk space and taking corrective actions/generating automated alerts.
Monitoring jobs, troubleshooting on failure and addressing alerts
Scheduled and maintained routine Jobs, Alerts and Maintenance Plans.
Resolving blocking and deadlock Issues.
Troubleshooting production issues and raising high availability
Performing SQL Server service pack installation.
Perform database refreshment from Prod to UAT on demand.
Supporting for 24/7 database maintenance.
Environment: SQL Server 2012/2008/2005 Enterprise, Windows Enterprise Server 2012/2008/2003.
(Suresh P)
