EXPERIENCE SUMMARY:

• Currently working as a SQL Server DBA Lead with 8 years of experience in Information Technology.
• Core areas of skill are SQL SERVER Administration, maintenance and Development.
• Experience in installing and configuring MS SQL 2014, 2012,2008R2, 2008 and 2005 Servers and MS Sql clustered servers and service packs & hotfixes.
• Experience in installing and configuring MS SQL 2008R2, 2008 and 2005 Integration and Reporting services.
• Experience in configuring TDE using a certificate as well as using an Extensible key management provider.
• Experience in installing and configuring Red Gate’s SqlBackup tool and configuring it on cluster and standalone servers
• Experience in installing and configuring SqlLiteSpeed and configuring it on cluster and standalone servers.
• Setting up of Log shipping. This includes native, customized and RedGate and SqlLitespeed enabled Log shipping.
• Helping the application/operational team with deploying applications with or without the help of deployment tools.
• Providing solutions for the issues like Storage IO,Network congestion, High CPU/RAM utilization, DB corruptions and tuning the queries running for a longer time than expected(For both pre and post migrations)
• Having good hands on experience in Migrating and upgrading the SQL Server clusters/patching/Adding storage/RAM/CPU to existing clusters.
• Hands on experience in building/troubleshooting/maintaining and configuring the Microsoft SQL Clusters on all the versions including the latest SQL 2014.
• Configuration and Maintenance of SAN Snaps.
• Migrated servers from 7.0/ R2/2012.
• Experience in building and upgrading the existing SQL Clusters/standalone server to SQL 2012
• Aware of configuration of Always on Availability groups.
• Aware of new concepts implemented in sql 2012/2014 like AAG,In - Memory OLTP,Resource governace of IO,coloumn store indexes etc.
• Designing and building new infrastructure, capacity analysis and planning, SAN requirement and analysis.
• Experience in applying service packs and installation using unattended installation.
• Developing and deploying server and database maintenance procedures.
• Setting up and maintaining Mirroring, Log shipping and replication.
• System Performance monitoring and tuning and query and stored procedure tuning.
• Documenting all regular Sql DBA tasks and sharing them with the team
• Preparing monthly and weekly metrics
• Preparing Technical documents and sharing with the team members.

TECHNICAL SKILLS:

Operating Systems: Window Server 2000/2, UNIX

Primary Skill: SQL Server 2000/14

Secondary Skill: Remedy,SSIS,SSRS,ITIL

PROFESSIONAL EXPERIENCE:

Confidential, Michigan

Operating System: Windows 2000/2012, AIX 5.3 & Windows client versions

Tools: Service-Desk, OVO

Responsibilities:

• Installing and configuring MS SQL 2014, 2012,2008R2, 2008 and 2005 Servers and MS Sql clustered servers and service packs & hotfixes.
• Installing and configuring MS SQL 2008R2, 2008 and 2005 Integration and Reporting services.
• Installing and configuring SqlLiteSpeed and configuring it on cluster and standalone servers.
• Setting up of Log shipping. This includes native, customized SqlLitespeed enabled Log shipping.
• Helping the application/operational team with deploying applications with or without the help of deployment tools.
• Providing solutions for the issues like Storage IO,Network congestion, High CPU/RAM utilization, DB corruptions and tuning the queries running for a longer time than expected(For both pre and post migrations)
• Having good hands on experience in Migrating and upgrading the SQL Server clusters/patching/Adding storage/RAM/CPU to existing clusters.
• Hands on experience in building/troubleshooting/maintaining and configuring the Microsoft SQL Clusters on all the versions including the latest SQL 2014.
• Migrated servers from 7.0/ R2/2012.
• Designing and building new infrastructure, capacity analysis and planning, SAN requirement and analysis.
• Developing and deploying SSIS packages and SSRS reports.
• Developing and deploying server and database maintenance procedures.
• System Performance monitoring and tuning and query and stored procedure tuning.
• Documenting all regular Sql DBA tasks and sharing them with the team
• Preparing Technical documents and sharing with the team members.

Confidential, Westlake, Texas

Operating System: Windows 2000/2012, AIX 5.3 & Windows client versions

Tools: Service-Online, OPAS, DBAConsole

Team lead

Responsibilities:

• Installing and configuring MS SQL 2014, 2012,2008R2, 2008 and 2005 Servers and MS Sql clustered servers and service packs & hotfixes.
• Installing and configuring MS SQL 2008R2, 2008 and 2005 Integration and Reporting services.
• Installing and configuring Red Gate’s SqlBackup tool and configuring it on cluster and standalone servers
• Installing and configuring SqlLiteSpeed and configuring it on cluster and standalone servers.
• Setting up of Log shipping. This includes native, customized and RedGate and SqlLitespeed enabled Log shipping.
• Helping the application/operational team with deploying applications with or without the help of deployment tools.
• Providing solutions for the issues like Storage IO,Network congestion, High CPU/RAM utilization, DB corruptions and tuning the queries running for a longer time than expected(For both pre and post migrations)
• Having good hands on experience in Migrating and upgrading the SQL Server clusters/patching/Adding storage/RAM/CPU to existing clusters.
• Hands on experience in building/troubleshooting/maintaining and configuring the Microsoft SQL Clusters on all the versions including the latest SQL 2014.
• Configuration and Maintenance of SAN Snaps.
• Migrated servers from 7.0/ R2/2012.
• Designing and building new infrastructure, capacity analysis and planning, SAN requirement and analysis.
• Developing and deploying SSIS packages and SSRS reports.
• Developing and deploying server and database maintenance procedures.
• Setting up and maintaining Mirroring, Log shipping and replication.
• System Performance monitoring and tuning and query and stored procedure tuning.
• Documenting all regular Sql DBA tasks and sharing them with the team
• Preparing monthly and weekly metrics
• Preparing Technical documents and sharing with the team members.

Confidential

Offshore Lead

Responsibilities:

• As part of Confidential we moved nearly 600 SQL servers to the new DC's.
• Majorly involved in reviewing, recommending, and building the SQL Servers and the migration strategies used are Greenfield and V2V.
• Extensive knowledge in doing capacity planning and defining configurations for the new servers.
• Developing security standard procedures policies and implementing them across the Organization’s SQL servers (Implemented TDE for SQL Server using Encryption Key management as well as certificate)
• Hands on experience in handling a complete data center outage and working with concerned teams for restoration of services.
• Providing solutions for the issues like Storage IO,Network congestion, High CPU/RAM utilization, DB corruptions and tuning the queries running for a longer time than expected(For both pre and post migrations)
• Having good hands on experience in Migrating and upgrading the SQL Server clusters/patching/Adding storage/RAM/CPU to existing clusters.
• Hands on experience in building/troubleshooting/maintaining and configuring the Microsoft SQL Clusters on all the versions including the latest SQL 2014.
• Configuration and Maintenance of SAN Snaps.
• Migrated servers from 7.0/ R2/2012.
• Reconfigured the replication and logshipping in the newly built servers.
• Auditing server and database usages post migration.
• Performing the DR Tests in the new environment and Preparing docs for new tasks
• Upgraded many servers to the next versions, Built 20 clusters as a part of it.
• Reviewing the migration plan created by the Confidential Database Architects
• Work with Application teams to do initial migration and testing.
• Perform data refreshes as and when requested.
• Perform migration on go-live date.
• Provide support to Confidential teams where required.
• Working with DELL to resolve any infrastructure issues.
• Making sure that all NetIQ and monitoring in place ( as is)
• Performing SAN/standalone server migrations/upgrades
• Reviewing and raising tickets for server decommission
• As a part of reviewing the existing servers, prepared wrapper script for sql 2000/2005/2008 versions which consolidates all the details of server from end to end such as sql version, edition, port, high availabilities configured in the server, IP or hostnames used in any objects, any jobs, any sp’s, databases list, services and their status along with service account with which it is running, last databases backup and many other sql configurations.
• In order to make sure that we are doing a 100% like to like migration without any misses compiled and followed a DBA Post migration checklist which consists of all the checks right from comparing the server time zone.
• Maintaining high availability of the databases by replication, log shipping, mirroring and clustering of sql servers.
• Have been using RedGate’s SqlBackup to log ship databases.
• Regular database backup & restores.
• Participating in DR Tests.
• Developing security standard procedures policies and implementing them across the Organization’s Sql servers.
• Creating Server and Database users, roles and assigning permissions.
• Auditing server and database usages.

Confidential

Sr.System engineer

Platform: AIX and windows 2003 & XP

Software: SQL Server R2 and Oracle 9i

Responsibilities:

• Involved in Monitoring and Managing the 17 Production Database Server's Health and Tuning Accordingly.
• Involved in Managing 6 Test Environments Database Servers.
• Involved in managing day to day operation like Log Shrinking, Health Check’s, Backup checks, Reporting Box Refresh Check and Error Log Check etc.
• Involved in all kinds of incident handling (Major & minor) related on Databases and OS.
• Managing and Configuring Cluster Boxes and Log shipping for Production Databases.
• Backups and data recovery and Troubleshooting.
• Involved In Migration Tasks.
• Involved In major Data Exports and Imports.
• Responsible for building, Installation, configuring and Regular maintenance of Production and test environments.
• Installing and Upgrading SQL Server.
• All the Production and test environment releases.
• Act as First point of Contact between Client and Developers through SOC.
• Managing Database Users and Security.
• Databases and objects administration (Store Procedure and Views).
• Scheduled jobs (tasks) and SSIS management.
• Data transfers and replication management.
• Refreshing and Replicating the Test instance.
• Implementing the Data fixes scripts on production environment.
• Generating reports based on the requirement of the client.
• Production rollbacks in case required.
• Supporting testing teams during test phase.
• Supporting development teams during development phase.

Confidential

Responsibilities:

• Responsible for Shadow Environment building process.
• Involved in Support of production, test environments across all the stacks from release prospective.
• Responsible for Test environment management and availability.
• Deployment of Authorized Version’s of RFC’s and store scripts and implementation plans in DSL. Ensure if implementation plan includes post implementation checks and Back out plan.
• Maintaining records of the all deployments done on Production as Test Servers.
• Configuration and functionality checks of in-house built software and tools assisting in the project BAU tasks.
• Attend CAB meeting for decisions on deployment of any significant changes or for scheduled changes during the week.
• Plan for rollback of implementation, if there were any issues post implementation.
• Keeping a Track and request license keys from third party software’s.
• Preparing of Metrics and Charts for all success and failure deployments on weekly and Monthly basis.