DIGITAIN

• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). • Participate in On Call weekly shift supporting off hours and weekend activity. This is rotating assignment shared with other members of the team as necessary. • Having Experience on Data center servers and handling 24 TB databases. • Maintain highly available SQL Server databases using SQL Database Mirroring/Log Shipping and SQL Always-On Technology. • Maintain highly secure SQL Server databases using SQL Transparent Data Encryption, SQL Line Encryption, and enhanced SQL Server Auditing features. • Strong backup and recovery experience in SQL Server 2008R2/2012/2014/2016 and SQL 2019. • Installed and configured MySQL\PostgreSQL on Linux and Windows environments. • Managing/Troubleshooting MySQL 5.5 and 5.6 in production and developer environments on Linux Debian/Centos 8. • Increased database performance by utilizing MySQL\PostgreSQL config changes, multiple instances and by upgrading hardware. • Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor. • Performed MySQL\PostgreSQL Replication setup and administration on Master- Slave. • Configuring/Installing/Troubleshooting PHP/Apache/Nginx. • Shell script is being used for some data migration and backend work management.

DIGITAIN

• Install, configure and maintain Microsoft SQL Server 2008R2/2012/2014/2016 and 2019 in Windows 2008 and Windows 2012R2/2016/2019 server environment. • Installed, configured SQL Server Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment. • Tune database configuration for optimal system performance. • Ensure proper setting of system memory and system parameters in consultation with windows administrators. • Create and maintain application databases with optimal data file and log file sizes. • Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the MS SQL Server environments. Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs. • Provide backup and restore functions for MS SQL Server databases. • Migrated SQL server 2008 to SQL Server 2012 (2014 to 2016) in Microsoft Windows Server 2016 Enterprise Edition. • Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server. • Transferring the data (ETL/ELT) to Data Warehouse by SSIS. • Periodically refresh development and test databases using copy of production system.

Altacode LLC

• Install, configure and maintain Microsoft SQL Server 2008R2 and 2012 in Windows 2008 and Windows 2012 server environment. • Ensure proper setting of system memory and system parameters in consultation with windows administrators. • Create and maintain application databases with optimal data file and log file sizes. • Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the MS SQL Server environments. • Provide backup and restore functions for MS SQL Server databases. • Periodically refresh development and test databases using copy of production system. • Participate in On Call weekly shift supporting off hours and weekend activity. This is rotating assignment shared with other members of the team as necessary. • Having Experience on Data center servers and handling 1.4 TB databases. • Maintain highly secure SQL Server databases using SQL Transparent Data Encryption, SQL Line Encryption, and enhanced SQL Server Auditing features. • Strong backup and recovery experience in SQL Server 2008R2 and SQL 2012. • SQL Server deployment in SharePoint environment. • Cloud deployment experience.