Sql Server Manager
Resume:
Address:
Ramnagar, Hyderabad,
Telengana - 500020.
Ashwini Pagidakula
(SQL Server DBA – Database Administrator)
(Contact: Mob – (91-970*******)
(Email: **************@*****.***)
SPECIALIZATION & KEY SKILLS:
Database Administration MS SQL SERVER 2005 & 2008
Good knowledge of:
Scripting using T-SQL.
DATABASES:
Microsoft SQL Server 2005 / 2008 & 2012
OPERATING SYSTEM(S):
Windows 2008 / 2003 .
OFFICE PRODUCTIVITY TOOLS:
Microsoft Office (MS Excel, MS Word, MS Access, MS Outlook etc.)
TECHNICAL DOCUMENTATION:
Good at preparing documents for the management and maintenance to facilitate project support.
SOPs & Technical Handbook
Monitoring and Ticketing Tools:
MOM, SCOM, HPSM,ITSM Support Central & Remedy, Cumvalut backup tool
Personal Data
Date of Birth: 12th February 1988
Sex: Female
Nationality: Indian
Marital Status: Married
Languages: English/Hindi/
Telugu
PROFILE:
Having around 3 years 4 months of SQL DBA production support experience in Microsoft SQL Server 2005, 2008 & 2012 Database Administration.
SKILLS SUMMARY:
Good knowledge in Microsoft SQL Server (2005, 2008 & 2012) Database Administration.
Installing, upgrading and configuring Microsoft SQL Server 2008 & 2012 instances and its various components like Integration Services, Reporting Services, Client and Connectivity Tools and Analysis Services etc.
Good knowledge on managing SQL Logins, DB users, Roles and Authentication Modes, SQL Service packs & Hot fixes as a part of Security Policies for various categories
Expertise in Backing Up, Restoring, and Moving Databases between servers.
Ensuring Point in Time and to the point of failure recovery of databases by implementing appropriate Backup and Recovery strategies.
Migrating or moving databases from one server to the other using Backup/Restore, Linked Servers
Experience in Data migration between Oracle and SQL Server using Linked Servers
Good knowledge of T-SQL and scripting to Manage Databases.
Handling and administering large SQL Server databases.
Successfully resolving SQL Server problems, which involves in-depth knowledge of SQL Server Architecture, Connectivity, Replication, DTS, Backup/Restore, Database corruption, Security, T-SQL Programming etc. ensuring high customer satisfaction rates.
Troubleshooting all database related problems and errors
Monitoring and Troubleshooting SQL Server Performance issues and fine-tuning queries.
Implementing high availability solutions using the following techniques:
oBackup / Recovery
oLog Shipping
oReplication
oDatabase Mirroring (SQL Server 2005/2008/2012)
oSQL Server 2008/2012 Failover Clustering
Good knowledge in using the following SQL Server Tools:
oSQL Server Management Studio
oSQL Server Profiler
oDatabase Engine Tuning Advisor (SQL 2005/2008 & 2012)
oEnterprise Manager
oSQL Query Analyzer
Configuration Tools (SQL 2005/2008 & 2012):
oSQL Server Configuration Manager
oSQL Server Surface Area Configuration
Creating and managing Maintenance Plans for database backup types and also for cleanup and database integrity and optimization tasks.
A good team player with excellent communication, analytical and inter-personal skills
EMPLOYMENT HISTORY
Currently working as Database Administrator at Cybermate Infotech Pvt. Ltd. from 22nd April, 2013 – Till Date
ACADEMIC QUALIFICATIONS:
Master of Computer Applications (MCA) from Sai Sudhir PG College, affiliated to Osmania University, Hyderabad, Telengana.
Bachelor of Science (B.Sc) with stream as MPC from Degree College, affiliated to Kakathiya University, Telengana.
Intermediate (MPC) from S.S.R Junior College, Board of Intermediate, Telangana.
S.S.C from ZPS School, Board of Secondary Education, Telengana.
PROJECTS SUMMARY:
Current Project:
Project # 1
Project Title : SQL Server 2012 DBA
Client : US
Role : SQL Server DBA
Environment : MS SQL Server 2008 and 2012, Win Server 2008 & 2012 R2, Citrix tools
Duration : 22nd April, 2013 – Till Date
Job Responsibility
24 x 7 Production Database on Call Support.
Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
Restoring database from production to development and test servers as per requests.
Created and maintained users and user groups
Performed daily backups and developed recovery procedures.
Checking of the database consistency using DBCC commands to minimize complexity.
Rebuilding/Monitoring the indexes at regular intervals for better performance.
Monitoring the SQL Server and OS lever issues by setting Pefrmon counters.
Involved in generating Workload file to analyze SQL server performance using SQL Server Profiler.
Tuned the SQL queries using performance monitoring tools. & involved in tuning the database.
Capturing and tuning the long time running query’s thru Use full DMVs.
Maintaining and Managing the Database Mirroring & Replication.
Maintaining the issues in ticketing tools.
Project # 2
Project Title : Database Administrator
Client : US
Role : SQL Server DBA
Environment : MS SQL Server 2008 and 2012, Win Server 2008 & 2012 R2,
Citrix tools
Duration : 22nd April, 2013 – Till Date
Job Responsibility
Providing 24x7 support for production SQL Server database and maintenance.
Installation of SQL server software and related Products.
Creating SQL Logins, Assigning Roles for the requested users.
Performed daily backups and developed recovery procedures.
Checking of the database consistency using DBCC commands to minimize complexity.
Tuned the SQL queries using performance monitoring tools. & involved in tuning the database.
Performed Log Shipping and implemented Replication as High Availability techniques.
Maintaining and Managing the Database Mirroring.
Coordinating with onsite DBA’s for necessary troubleshooting to resolve the problem.
Rebuilding the indexes at regular intervals for better performance.
PLACE: Hyderabad
DATE : (Ashwini Pagidakula)
Contact this candidate