SUMMARY:

• Senior SQL DBA 8+ years of Total IT Experience in Production Support Database Administration in Windows Environments and also Application support experience using Microsoft SQL Server 7.0, 2000, 2005, 2008/2008 R2, 2012, 2014, and 2016 and 2005 & DB2 Z/OS.
• Worked on SQL Server Upgrades from 2000/2005 to SQL Server 2008 RTM/R2 to SQL Server 2012 and to SQL Server 2014. Both Side - by-Side and in-place upgrades.
• Installed/upgraded 300+ SQL Instances of 2005/2008/2008 R2/2012/2014 of Dev/QA/UAT/Production Environments until date.
• Handled and maintained the largest database of 3 TB in size.
• Extensively worked on Database Backups, Restores, and Disaster Recovery procedures.
• Created and updated KB Articles to help team resolve issues at the L1/L2/L3 level.
• Aware of Change Management Process and REMEDY.
• Specialist in resolving issues relating to SQL Server Install/Upgrade failures.
• Worked closely with customer to help them in setting up there migration plans.
• Worked Extensively on Performance Tuning and Query Optimization of TSQL queries/procedures.
• Worked Extensively on SSIS Package designs for Import/Export from various data source like flat file and Excel to MS SQL Server and vice versa.
• Escalassions support provided to customer with MSIT.
• Créâtes Windows Batch Files and automated tasks as per customer requirements.
• Worked Extensively on SSRS reports, designed and deployed the reports into the Reporting Server and automating the e-mails to the customer.
• Installation and configuration of SSIS, SSRS, and SSAS Servers.
• Installation and configuration of SSAS PowerPivot and intégration with SharePoint 2010.
• Working knowledge on DB2 ZOS.
• Individual Contributor and good team player, strong interpersonnel and Communication skills combined with self motivation, initiative and ability to think outside the box.

TECHNICAL SKILLS:

Databases: MS SQL Server 2016,2014,2012, 2008 R2,2008, MS SQL Server 2005, DB2 Z/os

Programming: SQL, JCL

DBA: Database administration of MS SQL Server 2012,2008, 2005, Database Administration of DB2 Z/OS V7,V8,V10

Operating System: Windows 2012,2008/2003 Advanced Server, NT & Windows 9x, Z/OS

Other Software: Windows 2012,2008/2003 Advanced Server, NT & Windows 9x

Tools: Remedy, SNOW, Visio, BMC DB2 Products, CA7, OMEGAMON, Toad for SQL server, SSMS,SSRS,, DB Artisan, Abend Aid, File Aid

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Domain Knowledge: Automotive

PROFESSIONAL EXPERIENCE:

Confidential, Franklin, TN

Senior Database administrator

Responsibilities:

• Manage database administration team and technical expertise for more than 2,500 SQL Server instances ranging in size up to 25 terabytes, including all types of complex data replication.
• Supervise 9 offshore DBA’s as the primary managed services contact, providing training and technical support, as well as publishing and enforcing standard operating procedures.
• Develop strategic recommendations to business leadership partners, presenting information to deliver world-class database solutions.
• Architect large SQL Server database projects, compiling business requirements and providing additional engineering and end-user support.
• Design standards related to database administration, performance evaluation and technologies used for maintenance and data replication.
• Served as project lead for the development of company's retail pharmacy systems mainframe interface, engineering a SQL Server database infrastructure that serves as central repository for 900 retail pharmacies.
• Engineered and implemented a central database server infrastructure that included a 7-node SQL Server cluster serving as a load-balanced replication re-publisher for pushing data to the pharmacies and transactional replication distributors for trickle-feeding data from the stores.
• Initiated multiple SQL Server upgrades, first from, then to SQL Server 2008R2, including engineering and orchestrating hardware and other infrastructure upgrades.
• Aim of the project is to upgrade all SQL server 2012/2008 to SQL server 2016 and Windows 2008 servers to Windows 2012

Environment: SQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2016

Confidential

SQL Migration Consultant

Responsibilities:

• Getting requirement from Application teams on upgrading the database
• Communicating and planning of upgrade
• Coordinating with different teams about the project input
• Validate availability of permission on target DB servers. Install SQL 2012 on Database servers
• Perform full backup of database on source server
• Restore database into target database server
• Configure database on target database server
• Setup user account similar to source database in new database server
• Configure security similar to source database in new database server
• Configure the database to run as per the new port configuration standard
• Collaborate with application team during application testing
• Create Test Cases and scripts for functional and regression testing
• Perform application functional and regression testing
• Engage 3rd party application vendor as required
• Any effort required for remediation of application code to comply with the migration will be additional effort and will be estimated when such situation occurs
• Participate in final migration.

Environment: SQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2016

Confidential

DB2 LUW & MySQL DBA, Team Lead

Responsibilities:

• Working on Single & DPF Environment.
• Handles the authorizations of DB2 & MySQL objects to users, applications and Utilities.
• Creating views and other DB2 & MySQL objects depending upon the application group requirement.
• Alteration of objects definitions.
• Regular Backup and Recovery.
• Load and Unload utilities.
• Starting and stopping DB2 & MySQL subsystems.
• Monitoring production databases
• SQL Query tuning for performance enhancement.
• Change Request implementation
• Support application Team in business/non business hours
• Weekly maintenance in weekends as well as weekdays
• UNIX shell scripting.
• Support for Production, Staging, Report, etc. databases.
• Database Maintenance for Production, Testing, Development.
• Database, tablespace and DB objects creation and maintenance.
• Data Refresh from Production to non-production environments.
• Running Reorg, Runstats and various utilities daily and upon request. / OPTIMIZE in MySQL.
• Handling the incidents/Changes/PRM tickets.
• Attend daily/weekly team meetings with clients.

Environment: DB2 UDB v9.5, v9.7, MySQL 5.5 & 5.6, Linux, AIX, ITIL

Confidential

DB2 UDB DBA

Responsibilities:

• As a team lead, I coordinate with offshore team throughout the project.
• Understanding the requirement from Infra team
• Working on analysis on the DB2 V7 to upgrade to DB2 V8 CM
• Working on single and DPF environment.
• Handling DMS Tablespaces and Granting and Revoking database privileges.
• Managing DB2 Audit and DB2 Governor.
• Creation of Database objects (Tables, Views, Store Procedure and Indexes etc).
• Weekly Database Maintenance (Reorgchk, Reorg, and Runstats).
• Taking care for Backup and Restoration of Database on DEV/UAT.
• Configuring and managing TSM and NETWORKER for database backup and archive logs.
• Reviewing application performance and as and when request.
• Monitoring production databases with monitoring tool FOGLIGHT.
• Monitoring and managing DB2 Audit and DB2 Governor.
• Perform Load and Import operation as per requirement on production.
• Preparing shell scripts for Database backup and for database maintenance.
• Participated in DR exercise 2012.

Environment: DB2 UDB v9.1, v9.5, v9.7, TOAD for DB2, FOGLIGHT, Linux, AIX

Confidential

Lead Database administrator

Responsibilities:

• Providing RTB support for the Confidential North America on SQL Server & DB2 Z/OS.
• Helping application team to configure database parameters in the application
• Creating database objects as per application specification
• Backup and restore activity on databases.
• Worked on MOCK DRE to ensure the preparation for DRE
• Configuring Backup jobs for tablespaces in DB2
• Capacity planning on SQL server Databases
• Providing Access & revoke access to databases
• Providing suggestions on index creation
• Performance tuning of database and application related to database access
• Planning monthly, weekly & daily database Maintenance activity
• Performing Reorg and rebuild index on databases.

Confidential

SQL/DB2 DBA

Responsibilities:

• Migrate Data from Vendor database to SQL server 2008
• Understanding the requirement from client
• Extracting the data from vendor sight, creating database objects based on vendor data model.
• Loading data from excel to SQL server database based on data mapping
• Helping application team to extract data for Audit purpose.
• End of the project period, helped to migrate data from SQL to Oracle.
• Handling Onsite and On-call requests.
• 24/7 support (Weekends On-Call Support).
• Database bifurcation tasks.
• Working in Clustered Environment active/active, Active/Passive nodes.
• Installation and configuration of MySQL on Windows.
• Automating backup jobs on MySQL Servers.
• Implemented replication in MySQL on Windows Environment.
• Creation of Events in MYSQL to automate the job schedules.
• Creation of Users and assigning roles for the same in the MySQL.
• Backup and Restore task of MySQL

Environment: SQL SERVER 2000/ 2005/2008/2008 R2, MySQL 5.1/5.5

Confidential

SQL/DB2 DBA

Responsibilities:

• To provide 24/7 support for DB2 Z/OS Subsystems and SQL servers.
• Analysis of the specifications provided by the clients
• Granted READ, WRITE and other privileges to users on database objects
• Resolve incidents on a daily basis, perform root cause analysis, propose and provide fix within the agreed SLAs to the production problems.
• Do housekeeping and maintenance on the production systems. Make sure all the databases have regular back-ups.
• Refresh and update of development regions and migration of objects and data from one region to other.
• Creation of Database objects.
• Participated in 7 Mock DRE exercises and much aware of the DRE process
• Support to application teams in providing access to the database objects and helping them in various phases of testing
• Helps application team in there testing by doing data refresh, creating tables and other database objects as per their request
• Performs Database Migrations from Lower version to higher version, MS Access to MS SQL server
• Performs table level, database level refreshes.
• Used RUNSTATS and REORG to enhance application performance