SUMMARY

• Over 10+ years of experience in IT industry, as an SQL Production DBA, project Associate, Sr.Consultant, Performance Tuning Engineer with SQL Server versions 2000/2005/2008/2012/2014 , also worked on SQL Azure Databases.
• Excellent Experience in MS SQL Server installation and configuration, performance Tuning, Upgrades, Backup/Recovery and Managing Security. Excellent knowledge of Microsoft Cluster, SQL Server Replication, Log Shipping, Mirroring, Always on Availability (HADR) and SQL Server 2012/2014.
• Expertise in installing, configuring and maintaining of Stand - alone servers and Clustered Servers.
• Experience in HA (High Availability) & DR (Disaster Recovery) Management.
• Experience with Performance tuning, troubleshooting production issues and provides on-call support.
• Expertise in handling very large databases ( > 6 TB) and managed more than 170 SQL server instances.
• Defined and Administered Database Standards, Controls, Procedures and Documented the same and monitoring the development of SQL Server Automated
• Experience in Assigning & following up on Incident, Change management and Request tickets based on SLA/Critical.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Created Linked Servers between SQL Server & Oracle. Worked in creating Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors, and T-SQL queries. Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Working knowledge in SQL Server Reporting Services (SSRS) and hands on experience in working with SQL Server Integration Services (SSIS). Strong experience in mentoring team members and writing documentation.

PROFESSIONAL EXPERIENCE

Operating Systems: Windows server 2003/2008/R2, Linux, VMware servers

Databases: MS SQL Server 2000/2005/2008/2012/2014 /2016, SQL Azure

Languages: C, PowerShell

Tools: Spotlight, Netbackups, Erwin.

Frame Work: ITIL Foundation V3

ETL Tools: SSIS, SSRS

Storage: Netapp

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server DBA

Responsibilities:

• Improved critical database (6 TB) performance.
• Configuring database, server level auditing and automation of this process.
• Troubleshooting performance issues, Monitoring server status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Building the new servers and consolidating critical production servers.
• Configuring performance alerts and data collection sets for performance trouble shoot.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Configuring Resource governor for capping and throttling the resources for better performance.
• Creating linked servers to connect to other data sources and remote SQL servers.
• Performing major DB refresh and database failover tasks with minimal latency.
• Troubleshooting complex queries.
• Implemented database and server level triggers on critical servers to audit and protect data.
• Troubleshooting data warehousing SSIS packages.
• Develops and maintains technical documentation and operational procedures for areas of responsibility.
• Handling work orders and change requests.
• Creating SSIS packages for job status reports, connections report and for performance reports.
• Design the T-SQL scripts for data masking and data security.
• Expert in Using extended events, DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters. Rebuilding / monitoring the indexes at regular intervals for better performance.
• Performing Baseline test and analysis with test results time to time.
• Providing on-call support for critical application databases.

Environment: Windows Server 2012/2008 R2/2008/2003, SQL Server 2014/2012/2008 R2/2008/2005, Netezza.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Maintains application performance and scalability focus on performance tuning SQL queries, indexing, query plan analysis.
• Develops and maintains technical documentation and operational procedures for areas of responsibility.
• Applyed latest Service Pack in all the SQL Server Version. Configuring SQL Server Cluster setup. Installing & Configuring TSM for Backup & Restore. Handling Incident, Change, Service Request, Work order & Problem ticket.
• Created SSIS packages for automation of incremental data loads, FTP and Test connections.
• Design the T-SQL scripts for automation works and performance testing.
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters. Rebuilding / monitoring the indexes at regular intervals for better performance.
• Performed Baseline test and analysis with test results time to time.
• Investigated performance issues using Perfmon and DMV’s and working on to fix those issues.
• Configuring and troubleshooting high availabilities like mirroring and replication. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities. Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Provided on-call support for critical application databases.

Environment: Windows Server 2008 R2/2008/2003, SQL Server 2012/2008R2/2008/2005, SSIS, HP Load Runner, SharePoint.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Upgraded SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition. Upgraded SQL server 2005 to SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition. Installed and administered Two-Node cluster Active/Passive.
• Installed and configured SQL Servers on physical and virtual servers.
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters. Rebuilding / monitoring the indexes at regular intervals for better performance. Deploying monitoring tools like Spotlight on SQL server and Quest diagnostic monitoring tools.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Successfully deployed several database change scripts provided my third party vendors.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA). Created many Cascaded parameters in the reports using T-SQL. Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Configuring and troubleshooting high availabilities like mirroring and replication. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities. Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Performed installations of SQL server 2012 SP1, 2008 R2 SP2 and 2005 SP4. Extracted data from different sources (Access, Oracle 10g, Excel spreadsheets and CSV files) to SQL Server databases using SQL Server Integration Services (SSIS).
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build. Working in 24X7 production support with a rotation basis.

Environment: Windows Server 2008 R2/2008/2003, SQL Server 2012/2008R2/2008/2005, SSRS, SSIS, T-SQL, Quest Diagnostic tool, spotlight,VMware.

Confidential

SQL Server DBA

Responsibilities:

• Installed SQL Server 2005 and SQL Server 2008 on Windows 2003 advanced server. Upgraded and migrated the servers from SQL Server 2000 to SQL Server 2005/2008.
• Scheduling and monitoring SQL Server jobs, and resolving issues, monitoring health of the database servers, storage, memory & CPU utilization as well as work with systems administrators to ensure optimal database performance.
• Suggested Disk Capacity, Processors and Memory based on the Capacity planning. Configure and Maintenance, Monitoring, Installation, patches, DBA tools and Clustering . Loading & extracting of data to/from the servers, planning & executing database backup and recovery tasks.
• Capacity allocations for migration databases. Implemented Replication and Log Shipping to overcome Disaster Recovery plan. Monitoring the server for High availability of the servers. Solving the request raised by user support. Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments. Meet the SLA (Service Level Agreement) established. Execute procedures to accomplish short-term business goals.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users. Using database level triggers code for database consistency, integrity and security.
• Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis. Documentation of daily tasks and scripting them.

Environment: Windows Server 2008/2003, SQL Server 2008R2/2008/2005, SSIS, Idera’s SQL Diagnostic manager