PROFESSIONAL SUMMARY:

• I have total 12 years of IT experience with 9 years of SQL Server DBA. As SQL Server DBA, I worked on very large enterprise environment to support & maintenance over 700 SQL server instances with database in Terabytes.
• I have worked in different on projects like database migration, SQL server consolidation, application and infrastructure (writing SQL Server solutions for SQL) projects.
• My experience includes working with government and non - government clients.
• Worked on SQL Server 2000/2005/2008/2008 R2 & SQL Server 2012.
• Installation of SQL Servers, with new releases and service packs.
• Install configure and support SQL Server cluster
• Manage and support SQL cluster server, resources and troubleshoot errors.
• Worked Replication, log shipping, DB mirroring and troubleshoot SQL Server performance etc.
• 24*7 Production Support.
• Create, configure, manage, and troubleshoot all SQL Server components.
• Review and optimize database changes prior to production deployment.
• Identify performance bottlenecks and recommend corrective course of action.
• Conduct growth analysis and capacity planning.
• Plan and implements database security policy.
• Working ITIL framework
• Experience on NetApp storage and SQL Snap manager.
• Experience on enterprise scheduler Control M
• Worked for setup of more than 700 Production/Development/ UAT/QA/C&R Servers spread across the globe.
• Worked in SSIS (ETL) & SSRS
• Experience in data migration and worked on complete life cycle for data migration like define the data migration strategy, assessment, analysis, design, execution, data validation and testing. I also worked on data profiling, data cleansing & scrubbing.
• Possess strong trouble shooting and problem solving skills.
• Experience in performance tuning.
• Implemented projects with complete development life cycle.
• Have very good knowledge of manufacturing industry
• Have implemented ERP in 3 big Manufacturing MNC companies (Engineering, Store, Purchase & Commercial, Marketing & Sales, and Costing, Planning modules).
• Self-motivated, creative team player with effective communication and Leadership qualities.

TECHNICAL SKILLS:

Operating Systems: Windows (9x/NT/XP/2000, 2003, 2008R2), MS DOS, UNIX, Client/Server, Internet HTML

Languages: Visual Basic 6.0, ASP, HTML, FoxPro, C

Databases: MS SQL 2000, SQL Server 2005 & 2008 & 2008R2, Sybase 11.5 Oracle 10g, Teradata 7.2

GUI: Visual Basic 6.0

Case Tools: Erwin

Tools: & Utilities: VSS, Erwin, Farpoint 3.0, Crystal report 8.0, TSM, AutoSys, Remedy, Precise, SQL Lite, SQL Server Reporting 2005, Control M Scheduler.

EXPERIENCE:

Confidential

Lead DBA

Responsibilities

• I am also responsible for design & implement new SQL Database infrastructure solution.
• As part of this project HP is supporting above 40 SQL Servers in different environments..
• I am responsible for SQL Server database availability as per SLA, ongoing implementation of new projects, servers/environment, and coordination with customer and HP internal teams related to change management, Incident management, problem Management to maintain Service level agreement

Confidential

DBA

Responsibilities:

• SQL Server Support for multiple Confidential agencies and commercial clients.
• Design and implementation of new solutions and build new SQL Servers.
• My responsibility also includes Day to day SQL Support, DB maintenance and implementation of new environments/maintenance of existing environments.

Confidential

Lead DBA

Responsibilities:

• I am responsible for migration above 40 SQL Server to new hardware/environment and SQL Server consolidation.
• Define the strategy and solution to migrate SQL server to new environment and hardware.
• Liaise with multiple team (application, windows team, storage team, network etc.) to complete the migration and task on time.
• Complete UAT for all servers and ensure all functionality on servers is same as in old environment.
• Confidential has different type of replication to all branch servers and central servers.
• Also some other server has replication to different server and Confidential servers supported.
• That required lots of planning and technical expertise to migrate in new environments.
• I completed the Confidential hardware refresh project successfully and got very good feedback and appreciation from client.

Confidential

Lead SQL DBA

Responsibilities:

• My responsibility includes delivering maintenance & support from database team.
• Make sure team coordination and execution of PRRs (Production releases request) in time.

Confidential

SQL DBA

Responsibilities:

• Design of Database standards and roadmaps
• Database Technology Upgrades and Installations ( Installation of SQL Servers, with new releases and service packs)
• Create and maintain appropriate technology, process and related procedural documentation
• Participate in the ongoing capacity management of the relevant technology
• Product and service innovation and improvement
• Change, Incident and Problem Management
• Disaster Recovery Strategy Design and Testing
• SQL Programming (stored procedures, triggers, etc.) and SQL Performance Tuning

Confidential

Project Lead

Responsibilities:

• Define project strategy, project assessment/estimation, analysis the project scope and understand business requirement to migrate data from SQL Server to Oracle and work with testing and other stake holders to validate the same.

Confidential

Tech Lead/DBA

Responsibilities:

• Provide technical guidance to team, Preparation of RCA (Root Cause Analysis).
• Coordinate with Confidential Management, preparation performance report etc.

Confidential

Module Leader

Responsibilities:

• I was Module Leader for Purchase and Engineering Module.
• He did system study for Purchase, engineering, Inventory, Production Planning and Costing module.
• He was responsible for Purchase and Engineering module database design, development schedule work and assign to team member.