RESUME
VISHWATEJA REDDY .L
Email: vishwateja450@gmail.com
Mobile: +91-7729941420
CAREER OBJECTIVE
To work in a responsible position applying my knowledge and skills as an SQL SERVER DBA and skil-
fully accomplish projects involving Database management with an extensive use of SQL SERVER
technology.
PROFILE SUMMARY
Overall 4+ years of experience as a Database Administrator in production environments.
Work experience in 24x7 Production support for SQL Server
2008/2008R2/2012/2014/2016/2017.
Installing and Configuring the SQL Server 2008, 2008R2, 2012, 2014.
Applying SQL Server patches and hot fixes.
Verifying and resolving the SQL Server Blocking issues and Finding and fixing the root cause.
Resolving the Disk space issues and finding the root cause and permanent fixes.
Expertise in Database backup, Recovery, Restoration and Disaster Recovery Plans.
Restoring the Databases from Production to test environment and vice versa.
Experience in User Management activities like adding the user and managing the permissions.
Experience in Creating and scheduling the jobs and troubleshooting the failed jobs.
Good Experience in Performance tuning activities like verifying the slow running queries and
identifying missing indexes and also usage of statistics.
Experience in usage of DBCC commands and DMV’s for troubleshooting.
Executing the deploying the scripts in prod environment.
Configuring, monitoring and troubleshooting the REPLICATION and DR activities.
Good experience in Cluster installation and adding the nodes in the respective servers in SQL
Server 2005, 2008R2.
Performing the Failover and Failback operations in the cluster environment and troubleshooting
activities.
Configuring and Maintaining and troubleshooting the Database mirroring and also experience in
Mirroring DR activities.
Configuring and Maintaining and troubleshooting the Database Log Shipping and also experi-
ence in Mirroring DR activities.
Perform Server level tuning, performance monitoring, Index Tuning, Query Tuning.
Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update sta-
tistics and monthly maintenance plans such as clean up history etc. to run the databases effi-
ciently.
Experience in migration and upgrade process from SQL 2005 to 2008 and from 2008R2 to 2012.
Basic knowledge on Microsoft azure.
Professional Profile 1
Education Qualification:
Graduate from JNTU Hyderabad.
Professional Experience
Working as a Database Administrator in UNOSIS IT SOLUTIONS Pvt Ltd from JAN 2020 to
till date.
TECHNICAL SKILLS
Operating Systems: WINDOWS SERVER 2003 and 2008
Programming languages: T-SQL
Database Technologies: MS SQL Server 2017,2016,2014,2012, 2008, 2008 R2.
Tools: Zoho,Redgate
PROJECT DETAILS
Organization : UNOSIS IT SOLUTIONS PVT LTD
Role : SQL DBA
Skills :SQL Server2005/2008R2, 2012, 2014, Windows servers, Zoho, Red gate
Responsibilities:
SQL Server 2008/20012/2014 Database Administration.
Installation and Configuration of MS SQL Server 2014 on Windows 2012 R2 Servers.
Installed service packs and security fix on production, test and development servers.
Performed Migration of data from SQL Server 2008 to SQL Server 2014Edition.
Performed database backups for production, test and development servers and restored
backups onto test servers to ensure that we had good backups.
Additionally designed and implemented a disaster recovery system. Involved in disaster re-
covery procedures and restoring the production database.
Involved in SQL security and planning; administrating and creating user accounts for proper
access, SQL/Server system databases and tables, SQL Profiler and Enterprise Manag-
er/Management Studio, and Server monitoring and capacity planning to ensure adequate
CPU, disk space, and memory on all SQL servers.
Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Moni-
tor connections, locks and performance of SQL server.
Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
Provided 24x7 on-call supports. Supported systems beyond regular hours/ weekends/ holi-
days.
Periodically monitored performance using both System Monitor and SQL Profiler Trace.
Documented changes made to the servers, including documentation of performance issues.
Regularly checked OS Event Logs and SQL Server Logs for unusual events.
Professional Profile 2
Implemented Database Mirroring, Log Shipping on SQL 2014Servers for high availability and
maintaining Disaster Recovery sites.
Setting up and Automatic/Forced fail over for the production servers using Log Shipping,
Database Mirroring.
Performed compression of historic data for VLDB and compressed backups to reduce
amount of space it takes on disk.
DECLARATION
The above statements are true and correct for the best of my knowledge and belief.
Date:
(VISHWATEJA REDDY.L)
Professional Profile 3
