Abdul M. C Email and Phone Number

Responsibilities:• 24/7 Production Database Administration, Supported and Monitored to ensure a proactive problem recognition and resolution of database issues.• Installed of SQL in standalone and Clustered environment.• Provided DBA support and technical expertise for multiple applications in development, test, QA and production SQL Server, 2008, and 2012, 2014,2016,2017,2019 environments.• Configured High Availability Solution- Always On Cluster, Traditional Failover Clustering, and Log Shipping• Upgraded Databases from lower versions of SQL to a higher version• Implemented Vertical and horizontal migration in SQL Server – Standalone and Cluster• Administered, managed, developed and configured SQL Server database design following best practices• Troubleshot and resolved issues that may arise with SQL Server• Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud.• Developed and Implemented Disaster Recovery (DR) Plan.• Tested, Implemented different Physical and Logical Backup and Recovery methods - Point-in Time, Media Recovery.• Implemented maintenance jobs • Daily Health Check-up of all Databases.• Performance Tuning for optimized results using tools like, Sentry one, and Solar Winds Monitoring Tools• Database Design/Data Modeling.• Documenting all my processes in a step- by -step manner to keep up with a good knowledge sharing policy within the team and the entire company• Database Cloning from Production to Test and Development Environments.• Configured and Maintained huge OLTP Databases.• Monitoring Hit Ratios and Tuning the System Global Area(SGA) accordingly.• Provided Support on Performance Issues during Project Development, resulting in improved response times and reduced contention.• Deployed Database Security Policy and Installation, using Passwords, Privileges and User Profiles. • Documented processes for installations, clustering, availability group setup, and patching

Responsibilities:• SQL Server 2008/2012/2012R/2016/2017/2019 Administration• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.• Managed the migration of SQL Server 2012 databases to SQL Server 2016• Created and maintained databases, users, logins, tables, indexes, stored procedures, roles, permissions and other schema objects.• Designed and implemented comprehensive backup plan and disaster recovery strategies.• Rebuilt the indexes at regular intervals for better performance.• Responsible for stored procedures optimization, performance tuning & index tuning.• Used performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.• Used log shipping for synchronization of database.• Reviewed and optimized virtual machines environments, and optimized storage.• Responsible for monitoring and troubleshooting log shipping.• Used data partitioning and implements Snapshot isolation in SQL server.• Updated statistics, database integrity check and backup operations.• Created and maintained database maintenance plans.• Configured High Availability and Disaster Recovery solution, Always On, and Log Shipping.• Installed SQL Server 2012 on advanced servers, applied security fixes.• SQL Server profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance

Responsibilities:• Installed and configured SQL Server following MS best practices• Ability to quickly troubleshoot and resolve complex problems in live environments• Worked with backups, restores and database recovery models and resolving backup issues• Monitored, evaluated, and performed administration for local network servers• Performed database failovers/recoveries• Worked in proficiency on setting up backup recovery strategies supporting High Availability and Disaster Recovery• Migrated databases from SQL Server 2012 to SQL Server 2016 and SQL Server 2019• Worked on database refresh by taking backup from production database to development servers.• Implemented High Availability and Disaster Recovery Setup on the various servers using windows clustering, replication, log shipping, Always on Availability Group setup• Implemented and tested the point in time recovery of the production databases.• Managed SQL Server that running in a Hyper-V virtual machine• Resolved blockings, locks, and deadlocks using Activity Monitor, Sp_Who2, DMVs and SQL profiler.• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.• Estimated disk storage requirements for databases software, database files & database administration needs.• Participated in meetings impacting databases physical design• Managed databases and SQL server instance security by suing Active Directory• Experienced in automating process by creating jobs, and error reporting using alerts, mail agent.