SUMMARY

• Microsoft Certified Professional in Administering SQL Server 2012 with 7+ years of experience as a SQL Server DBA in managing production and non - production environment.
• Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database issues.
• Extensive experience in managing MS SQL Server on Windows 2000/2003/2008/2012 Servers.
• Used DMVs and DMFs for monitoring and troubleshooting performance issues.
• Expert level knowledge in Server Consolidation and Data Center migrations.
• Implemented Database Mirroring and Log Shipping configuration to provide HA/DR solution.
• Managed SQL Servers running on VMWare ESX hosts.
• Define and implement ETL development standards and procedures for data warehouse environment.
• Adept in designing and implementing Backup and Recovery Strategies.
• Developing reports on SSRS on SQL Server.
• Implemented different types of Replication models like Transactional and Snapshot.
• Proficient in upgrading (In-place Upgrades) and migrating databases from MS SQL Server and SQL Server /2012/2014.
• Create Database(s) on SQL AZURE.
• Deep Knowledge SQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS)with good knowledge on SQL Server Analysis Services(SSAS).
• Designed DR plans while satisfying SLA requirements and conducted DR tests.
• Worked in production support role to provide 24/7 on-call support.
• Proficient in migrating databases from SQL Server to Oracle.
• Hands on Experience in installing and configuring Active/Passive Cluster.
• Worked with tools like SQL Profiler, Windows Perfmon and Performance counters for Monitoring and Tuning MS SQL Server Performance.
• Sound understanding of change control and helpdesk ticketing processes.
• Applied Service packs and hotfixes during off hours.
• Skilled in using LiteSpeed and Redgate to backup and restore the SQL databases.
• Conversant with all phases of Software Development Life Cycle (SDLC).
• Flexible and enthusiastic team player with excellent communication and leadership skills.

TECHNICAL SKILLS

Languages: T-SQL, Visual Basic, Java, C#.NET, VB Script, Java script

RDBMS: MS SQL Server 2014/2012/2008/2005/2000 and Oracle 11g

Web Servers: IIS, Weblogic

Operating Systems: Windows 2012/20, Windows NT

Backup and Restore Tools: Idera SQLSafe, Redgate, Litespeed

Monitoring Tools: Spotlight for SQL Server

Others: Microsoft Office Suite, Microsoft Visio, Trello, Tableau,Microsoft Project

PROFESSIONAL EXPERIENCE

Confidential, Santa Fe, NM

SQL Server DBA

Responsibilities:

• Responsible for Installing SQL Server on new servers (2008/2012/2014 ).
• Upgrading existing 2005/2008 Production Server to SQL Server 2012/2014 Version.
• Moving several of the existing SQL 2005/2008 Production databases, jobs, packages, linked server and logins to new versions of SQL server.
• Upgrading SSIS Packages to SQL Server 2012 version.
• Designed Schemas using Microsoft Visio.
• Handling day to day support tickets and development issues.
• Set up linked servers between SQL servers and oracle data sources.
• Responsible for On-call support and support escalation from offshore.
• Working with Offshore team on pending issues and coordinating migration project activities to meet the project deadlines.
• For data mining applications, worked with SQL Server Analysis Services.
• Responsible for database refresh and coordinating with QA Team.
• Developed Documentation using Microsoft Office.
• Developed and deployed SSIS packages and SSRS Reports.
• Extracted data from internal data warehouse system to SSRS.
• Proactive monitoring of SQL server known issues related to performance.
• Writing Custom scripts to refresh tables and monitoring jobs.
• Troubleshooting performance issues in production and non-production servers.
• Providing support for database mirroring, always on and log shipping implementation.

Environment: MS SQL Server 2014/2012/2008 R2/2005, Redgate, T-SQL, Windows Server 2012/2008/2003

Confidential, Wilmington, DE

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server R2 in production and development.
• Upgraded SQL Server 2000 to SQL server 2005/2008 in 32 and 64-bit environment.
• Actively involved in installing and managing multiple 2 node failover cluster set up in active/passive environments as a High Availability mechanism.
• Successfully implemented database mirroring with high availability mode for critical systems.
• Implemented log shipping from primary server to standby server to support DR solution.
• Troubleshoot database performance issues and tune database objects. Set up traces and profiler to troubleshoot performance issues.
• Created ad-hoc reports.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Configured transactional Replication from multiple subscribers for reporting purposes.
• Involved in performance tuning, optimization of stored procedures and queries.
• Proficient in working with change management and change control procedure.
• Created and maintained various databases for Production, Development and Testing using SQL Server 2005. Planning the location of data, index, and Transaction log files on the disk.
• Solved issues related to server performance and disk space.
• Supported Development team in deploying and testing the application.
• Experienced in contacting Microsoft and other vendors for product and technical support.
• Provided 24*7 support to SQL application developers in implementing the applications on production server.
• Conducted root cause analysis of application availability and narrowed down to issues related to coding practices, database bottlenecks, or network latency.

Environment: Microsoft Windows Server bit, Microsoft SQL Server 2000/2005/2008 and Microsoft Visual Studio, Performance Monitor, Profiler and DTA.

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008.
• Upgraded SQL 2000 and 2005 Server to SQL 2008 (In place and Side-by-Side) server for high volume processing databases.
• Worked closely with application owners, development teams and other teams for planning and implementation of the migration.
• Designed and Implemented Disaster Recovery Procedures.
• Implemented High Performance Database mirroring on SQL 2005 database servers.
• Automated database refresh from production to test using custom scripts.
• Created custom jobs to back up the databases, maintenance tasks using custom scripts.
• Estimated disk storage requirements for database software, database files.
• Created databases, Logins, Roles and granted appropriate permissions.
• Configured Database Mail and created profiles for business applications to send out notifications.
• Developed and deployed SSIS packages and SSRS Reports.
• Installed and Configured 2- node High availability SQL Active/Passive clusters.
• Worked with 3rd party vendors to resolve database issues.
• Configured Log Shipping for high availability on SQL Server 2008
• Responsible for applying service packs and hotfixes
• Refreshed databases from production to test, stage and development environments.
• Provided on-call support.

Environment: MS SQL Server 2008 R2/2005/2000, Idera SQLSafe, T-SQL, Windows Server 2008/2003, TSM

Confidential

SQL Server DBA

Responsibilities:

• Created Databases, Tables, Indexes and Views.
• Worked with developers to identify performance issues and helped them optimizing the code.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.
• Calculated disk space and table space requirements.
• Used SQL Profiler and identified long running queries.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Published high-level technical documentation to set standards, guidelines and best practices for SQL Server Database Installation, Administration, Backup & Restore Procedures, Database Security, SQL Database Development and Access database upgrades across the enterprise
• Designed logical and physical databases and the development of SQL Server Database.
• Performed Database testing, maintained data and wrote procedures.

Environment: SQL Server, T-SQL, SQL Query Analyzer, DTS, Windows NT, MS Access, MS Excel.