Develop, upgrade, and modify databases per client specifications. Migrate SQL servers in clustered and non-clustered production environments. Oversee data transformation, partitioning, and statistics updates. Predict and plan for future storage requirements of large, complex databases. Implement failover clustering, log shipping, database mirroring, and AlwaysOn availability group configuration to ensure High Availability (HA) and Disaster Recovery (DR). Advise on technical matters throughout production phases.• Orchestrated multi-terabyte database platform in a mission critical environment.• Operated SQL server that ran on Hyper-V virtual machine.• Formulated data conversion processes for customization, testing, and production.• Automated management tasks using PowerShell.

Converted SQL Server 2012 to 2016 edition during testing and production. Instituted database mirroring for DR, and scheduled replication for updating parallel servers. Engineered DTS packages to extract data. Facilitated control flow and data flow operations, and data flow transformation using SQL Server Integration Services (SSIS) 2005. Composed reports using SQL Server 2005 Reporting Services, and oversaw installation and management. • Organized migration of the database to completion and optimized performance.• Developed and initiated comprehensive backup plans and DR strategies.• Refined indexes and introduced constraints, including primary Key, foreign Keys, check, and NOT NULL.

Designed and administered application support architecture using techniques including constraints, compression, HA/DR, replication and mirroring, and point-in-time recovery testing. Installed and configured SQL Server 2008R2 and 2005 on production and non-production servers. Tested and observed database integrity on recurrent basis by scripting Database Consistency Checks (DBCC), scheduling reports, and installing SQL Server Reporting Services (SSRS). Conferred with users to gather new requirements, improved system based on feedback, and produced supporting documentation. • Devised suite of database objects such as indexes, stored procedures and functions, views, and tables.• Upgraded queries using T-SQL to enhance user operability.• Eliminated occurrences of common front-end troubleshooting issues including connection timeouts, pooling problems, and memory leaks

Migrated SQL Server Database to a higher version, introduced automated processes, designed physical infrastructure, and upgraded as needed per client and application demands. Calculated disc storage requirements, employed Active Directory for instance security, and conducted acceptance testing. Coordinated with OS administrators and stakeholders on database design and client access to servers and database objects, while maintaining HIPPA compliance. • Launched SQL Server upgrade using a virtual machine.• Spearheaded full production of successful database backup and recovery strategy.