Sql Server Database Administrator
Resume:
Gouthami Donuru
SQL Server Database Administrator ********.******@*****.***
SUMMARY
* ***** ** ********** ** IT on MS SQL SERVER Database Administration (DBA).
Experience in Design, Capacity planning, DB configuration and Disaster Recovery Procedures.
Proficient experience on SQL Server Administration [2005, 2008, 2008R2, 2012 and 2014 with SP].
Experience in Installation, Configuration & Maintenance of MS SQL Server
(DB Engine, SSRS, SSIS, SSAS) 2014/2012/2008/2005 Versions.
Hands on Experience on High Availability solutions Transactional Replication, clustering,
Always-On.
Experience in solving disk space, log file full related issues.
Good Experience on SQL server clustering [Active-Active and Active- Passive].
Good Experience on Always-on Failover group (synchronous and asynchronous modes).
Good Experience in Database Migration and upgrade Management.
Experience in implementing SQL encryption mechanism (SSL and TDE).
Attaching and Detaching the Database files.
Movement of Database files (System and User defined DB’s) to other drive locations.
Applying latest service packs and cumulative updates.
Experience on Veritas NetBackup utilities for MS SQL Server.
Knowledge in configuring and managing Linked Server.
Have good knowledge on Incident management and change management
Experience in configuration of DNS and Load balanced request for IIS 7.5 and IIS 8 websites.
Experience in applying SSL certificates, exporting and importing the certificates on windows server 2008 R2 and 2012.
IIS website creation.
Experience on HP SM9 service management tool .
CERTIFICATIONS
70-432 Microsoft SQL Server 2008, Implementation and Maintenance
70-450 Pro: Designing, optimizing, and maintaining a database administrative solution using Microsoft SQL Server 2008
TECHNICAL SKILLS
Database Tools: SQL SERVER MANAGEMENT STUDIO, REPORT BUILDER SSDT
Web Servers: Microsoft Internet Information Services (IIS) 7.5/8.0
Programming skills: T-SQL
Microsoft Tools: MS Excel/Word/PowerPoint/, Visio.
Operating Systems: Windows Server 2003/2008 R2/ 2012
PROFESSIONAL EXPERIENCE
Company: Tata Consultancy Services March 2011 – FEB 2016
Client: PricewaterhouseCoopers
Role: SQL Database Administrator
PricewaterhouseCoopers is one of the world’s largest professional services firm and is one of the Big Four auditing firm, along with Deloitte, EY and KPMG.
Environment: SQL server 2005/2008 R2/2012/2014 (DEV, Test, Stage and PROD)
Responsibilities:
The primary responsibility handle Individual project and design Infrastructure in a tier based architecture.
Analyzing Client’s requirement and provide appropriate solution as per the requirement.
Infrastructure Design, capacity planning,Implementation
Maintenance of SQL Infra providing Level 3 Support
Carried out the following activities:
Involved in all phases of the project (Requirement gathering, Designing Infrastructure & Implementation and maintenance).
Implemented DR for SQL infrastructure.
Configuration of Always-on Failover group for reporting purpose (Synchronous and asynchronous).
Installation, configuration and troubleshooting of SQL Server single node cluster, two node clusters and Geo clusters.
Deployed and administered Microsoft SQL Server in standalone and clustered environments of SQL server 2005/2008 R2/2012/2014.
Installation, configuration and troubleshooting of SSIS/SSAS/SSRS features
Applying SQL server services packs, hotfixes and fixing issues in applying patches.
Implemented SSRS Scale out deployment with 4 SSRS servers.
Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server
Backup and Restore as per requirement.
Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
Restoration of DB backups for SQL Database using NetBackup tool with GUI and script.
Export or Import data from other data sources like flat files using Import/Export wizard.
Implemented SQL encryption mechanism (SSL and TDE) depending upon data classification.
Implemented SSRS Scale out deployment with 4 SSRS servers.
Reorg/Rebuilding the indexes at regular intervals for better performance.
Worked on Side by Side upgrade as part of Windows Migration projects considering the performance.
Configured Transactional replication.
Working with customers on Application rollouts and server migrations
Troubleshooting SQL server issues, like TempDB and User DB’s Log file full, Permissions, Clustering, Backup and restore, Always-on etc.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
Worked on DB deployments on production environment.
Registered SPN's at Active directory level to configured Kerberos authentication delegation for SSRS servers.
Worked on configuration of Windows clustering for Virtual and physical servers.
Configured DNS and Load balanced request for IIS 7.5 and IIS 8 websites.
Applying SSL certificates, exporting and importing the certificates on windows server 2008 R2 and 2012.
Personal Details
Date of Birth April 8th 1989
Sex Female
Nationality Indian
Work Authorization L2 EAD
Valid upto date : Sep 7th 2018
Contact this candidate