SUMMARY

• Over 11 years of IT experience in Administration, Upgrades & Performance Tuning for very large and complex databases in MSSQL Server 2012, SQL Server 2008R2, 2005 and 2000.Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Experience in configuring and maintenance of SQL Server Clustering.
• Assisted application development teams on infrastructure capacity planning and system design.
• Experience in Configuring Always - On, Log shipping, Mirroring and Replication.
• Implemented proactive monitoring using native T-SQL scripts for production databases.
• Experience in Database Backup, Restore and recovery using native SQL Backups and 3rd party tools.
• Experience in Database upgrade from SQL 2000/2005/2008 R2 to SQL 2012.
• Experience in Managing SSRS Reports by providing necessary permissions, creating new data-driven subscriptions and scheduling automated report generation.
• Experience in implementing SQL server Policy based management solutions using custom facets.
• Identify and resolve locks / long running queries and performance related issues using SQL DMVs.
• Experience in working on 3rd party tools such as Litespeed, TSM, Precise i3and Reporting Services Scripting tools.
• Comprehensive knowledge on SQL Server running on VMWare and Microsoft Hypervisor.
• Comprehensive knowledge on working with PowerShell scripts to replace some of the manual DBA tasks.
• Adequate development experience in developing stored procedures, functions, triggers using T-SQL.
• Worked on 24x7 database maintenance projects and provided end to end application DB support.
• Comprehensive knowledge on SQL Server instances hosted in AWS cloud platform.
• Experience in working with Windows 2012/2008/2003 operating systems.

TECHNICAL SKILLS

• Hardware OS
• MS SQL Versions
• Special Software
• Windows 2012/2008/2003
• SQL Server 2012 / 2008R2/ 2005 & 2000
• IBM Tivoli Storage Manager(TSM)
• SQL Litespeed
• Fog light
• TDPSQL

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Technical Lead - Database Administrator

Responsibilities:

• Managing 5000+ SQL instances of SQL 2008/2008R2, 2012 hosting VLDB up to 5 TB
• Managing 400+ SQL 2000/2005/2008 /2008R2/2012 servers (standalone and clustered).
• Database Administration on production servers with server configuration, performance tuning and maintenance.
• Administering SQL Server High Availability (Failover Clustering, Availability Group, Replication &Log Shipping).
• Administrating SQL Server instances hosted on AWS EC2.
• Comprehensive knowledge on AWS services such as EC2, RDS and S3.
• Monitoring SQL server with third party toolsNetcool, Precise i3.
• Experience using VERITAS Netbackup and native SQL server backups for Backup & Restore activities.
• Identify performance bottlenecks, propose & execute changes for improvement.
• Provide technical recommendations on current and future SQL server requirements, impact analysis for inter-related applications environment.
• Provide options for data archiving, purging, partitioning, data backup strategy & point in time recovery methods.
• Define baseline performance index for SQL servers, analyse performance & identify key improvement factors.
• Provide effective solutions to development teams during the application development stage by identifying, analysing and resolving performance and database related issues.
• Assist development teams with production migration and continuing support of all SQL platforms.
• Document database related architecture, best practices and standards of development.
• Establish processes & procedures required for change management, database security evaluation.

Confidential, Birmingham, AL

Senior Database Administrator

Responsibilities:

• Involved in SQL Server 2012 build/configure the new standalone and Windows Cluster servers.
• Involved in deploying the necessary SQL Maintenance jobs on the newly built servers.
• Implemented High Availability groups for those applicationdatabases who’s SLAsare very critical.
• Implemented most of the migration DBA activities with the help of PowerShell scripts.
• Implemented the changes as requested by the application teams through Service requests.
• Worked on incidents that might occur during the business hours and resolving it within the SLA timelines.
• Worked on SQL Server tools such as SQL Sentry, Precise i3.
• Helped application teams in migrating their SSRS reports from lower environment to UAT & Production with the help of Reporting Services Scripting Tool.
• Managed the necessary permissions for all the SSRS reports which includes creating new data sources, data-driven subscriptions and scheduling the reports.
• Involved in Performance tuning T-SQL scripts which takes longer execution time using DMV’s.
• Worked on Identifying space issues using native SQL Scripts and requesting the storage team to facilitate with additional storage space.
• Worked on day-to-day login issues and new access requests based on the guidelines provided by the Management.
• Implemented slipstream install of SQL Server 2008R2 on Windows Server 2012.
• Worked on migrating the SSIS packages from lower environment to UAT & Production as per application team request.
• Involved in writing T-SQL scripts for in house DBA activities.
• Supported the backup and recovery for both native SQL backups as well as Litespeed Backups with appropriate retention policies.
• Worked on Database refresh from Production to Non Prod environments using PowerShell scripts.
• Implemented custom scripts for SQL Server Policy Based Management to help baseline server configurations from central management server.
• Involved in documenting most of the day to day activities and also about any new solutions implemented.

Confidential, Jersey City, NJ

Senior Database Administrator

Responsibilities:

• The project was executed in 2 phases. Seed Phase covering the Application discovery, Impact Analysis and Remediation path and Core phase covering the execution and implementation.
• Executed the SQL 2008 Upgrade Advisor Report in order to identify the pre and post migration activities.
• Converted more than 700+ DTS packages to SSIS packages using the native conversion tool available in BIDS.
• Worked along with the application for remediating the packages which are having VB scripts and Active-x scripts either by modifying them into their .Net equivalent or using the appropriate equivalent task in SSIS.
• Implemented the production upgrade for all the application only after the successful completion of their corresponding non-prod instance upgrades.
• Configured the linked servers to point to the appropriate remote servers from the new SQL 2008 instance.
• Implemented the SQL Server 2008R2 based maintenance plans for all the upgraded instances.
• Scripted all the SQL Agent jobs and deployed the same in the upgrade SQL 2008R2 instance.
• For DTS based jobs, their equivalent jobs are recreated to use the SQL Server Integration Services for their package execution.
• Ensured for the Data consistency by creating the script which would provide the complete Object and Row count in both source SQL 2000 as well as SQL 2008R2 instance.
• Login migration was implemented by scripting the logins from SQL 2000 instance and deploying the scripts in SQL 2008R2 instance. Also validated all the logins by checking for orphan users.
• Database refresh was done as per the request from application teams for their testing phase.
• Implemented the standard backup strategy for all the upgraded instances. Weekly Full Backup, Daily Differential and hourly Transactional backups on to TSM using SQL litespeed scripts
• Implemented the POC for implementing the backup to TSM using TDPSQL instead of SQL Litespeed.
• Ensured end to end support for all the upgraded application databases.

Confidential, Jersey City, NJ

Senior Database Administrator

Responsibilities:

• The project was executed in 2 phases. Seed Phase covering the Application discovery, Impact Analysis and Remediation path and Core phase covering the execution and implementation.
• Once the server setup is completed in the Virtual box(VM Host), we installed all the necessary SQL components and other dependent components such as Oracle client, Neon Client (for DB2), SQL Litespeedand Tivoli Storage Manager.
• Modified the backup scripts in the new VM instance to use the updated TSM configuration file (dsm.opt)
• Established the SQL Log shipping between the Source Physical instance and the Destination VM instances.
• During the day of cut over we stopped the existing log shipping and applied the tail log backup on to the secondary instance in VM Host there by bringing them as primary instance.
• We avoided the sync-up of logins between the source and destination by restoring the system databases from source to destination.
• Ensured all the SQL Objects are consistent across the destination VM instance by verifying with help of the artifacts created before each implementation.
• Validated all the logins and made sure there were no orphan users.
• Worked closely with the application team in identifying the issues connecting to the new destination instances hosted in VM.
• Created the alias for the entire new instance and helped the application team to perform their initial testing by making the necessary changes to the connection strings.
• In order to help further, the old alias names were also retained along with the help of the network team.
• Provide post implementation support.

Confidential, Jersey City, NJ

Senior Database Administrator

Responsibilities:

• The project was executed in 2 phases. Phase-I covering the datacenter transformation of less and medium critical application database servers and Core phase covering the highly critical applications.
• Once the server is built as per the specification, we ensured that the server is like-to-like with respect to hardware, software and the storage.
• The initial setup includes the validation of windows cluster and setting up of SQL Cluster on top of windows cluster.
• Restored the system databases from Source server instance to Destination server instance.
• Established Log shipping between the primary server instance in source and destination and also between the DR server instance in source and destination.
• During the time of cutover, we stopped the log shipping and applied the tail log backup from source to destination and made the secondary as primary.
• Once the application checkout is completed, we implemented the DBA Maintenance jobs such as Database Consistency check, Index defragmentation using SQL Agent.
• We had also scheduled to ship the logins and jobs information from primary server instance to DR and made sure all the necessary information is available to recover the database in secondary in case of failover.
• As part of the application DBA support, we helped application team by refreshing the production data to their non-prod environments.
• Supported the application team in case of the SQL query slowness or for any performance issues.
• Adhered with Change Management and Quality Management
• Report to Project Manager/Coordinator about the progress of work assigned, issues and concerns, if any.
• Coordinating the onsite client DBA team and also with the offshore team