SUMMARY

• Microsoft Certified Professional in Administering SQL Server 2012 with 5+ 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 implementETLdevelopment standards and procedures for data warehouse environment.
• Adept in designing and implementing Backup and Recovery Strategies.
• Developing reports onSSRSon 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.
• Designed, tested and debugged external and DB2 native stored procedures
• Deep KnowledgeSQL Server Integration Services(SSIS) and SQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS).
• Designed DR plans while satisfying SLA requirements and conducted DR tests.
• Knowledge in Third party tools like TOAD, Remedy and Foglight.
• 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.
• Expertise in SQL server technologies for Clustering, non-clustering, High Availability and Disaster Recovery.
• 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

SQL Server DBA

Confidential, Santa Fe, NM

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.
• Installed and maintained MS SQL Server 2000 on Windows 2003 Server. Worked on SQL Server 2000 failover clustering which is built on top of a Windows 2003 server cluster.
• 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.
• Supported application programmers and users in their daily interactions with DB2.
• Responsible for On-call support and support escalation from offshore.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Working with Offshore team on pending issues and coordinating migration project activities to meet the project deadlines.
• Monitor database systems performance, capacity and availability.
• Database capacity planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting.
• Solid experience onhigh availabilitySQL Server solutions, includingReplication Models(Snapshot/Transactional) andSQL Server clustering(Active-Active, Active-Passive).
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Configuring, maintaining and troubleshooting Windows Server 2008 R2, SCCM 2007/2012 .
• Performing regular SCCM Health Checks of Site Server.
• For data mining applications, worked with SQL Server Analysis Services.
• Responsible for database refresh and coordinating with QA Team.
• Developed Documentation using Microsoft Office.
• Used the tool BMC Remedy user by the BMC software in resolving the incidents in the development servers and the production servers
• 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 , SSIS, SSRS, Microsoft Office.

SQL Server DBA

Confidential, Wilmington, DE

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.
• Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Recovered databases in the event of a disaster by developing and maintaining relational structures including backup/recovery and log shipping procedures.
• Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest FogLight.
• Reviewed andoptimized SQL queries, CDC,stored procedures, functions, Indexes, views and triggers.
• Experience with third party tools like FogLight and Veritas Netbackup.
• Configured 43 Production servers using FogLight monitoring tool.
• Created ad-hoc reports.
• Created and managed clustering environment such as active/passive clustering.
• 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.
• Involved in the design and development of the SSAS cubes.
• 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.

SQL Server DBA

Confidential

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