Shaik Ashfaq Ul Hasan

"Aim to be associated with a progressive organization that gives me scope to apply my knowledge and skills along with my hard work and patience and to be involved as a part of a team that dynamically works towards the growth of the organization"

Professional Summary

• Over 12+ years of focused experience as Database Administrator extensive acquaintance with ETL, Design, Configuration Management, Setup, Maintenance and Support.
• Worked on MS SQL Server 2005/2008/2008 R2/2012/2014/2016/2017 and 2019 Administration. Worked on Oracle 10G,11G and 12c Level - 2 Support.
• Minimal exposure and working on MongoDB,MySQL and PostgreSQL. Experience in supporting mission critical application databases in 24/7 environment.
• Strong experience on MS SQL Server Database design, solution, Installation, Configuration, Migration that includes AZURE cloud environment, Consolidation, Virtualization, Upgrade, Performance Tuning & Monitoring, Security Enhancement, Administration.
• Administer & Support mission-critical databases and provide production support. High Availability - Rich knowledge and experience on Log Shipping, Replication, Clustering, Always on Availability and Mirroring. DR Plans - Designing DR plans and perform DR drill and DR exercise.
• Tuning the databases and improve the performance of the database server. Database version control and change management. Defining schema standards - Database objects naming conventions and coding standards.
• ETL - Experience in SSIS packages and advanced error handling mechanism in transformations.
• Experience in third party backup tools that includes BMC Backtrack, Tivoli Data Protector for SQL, Litespeed, EMC Networker, and NetBackup.
• Work with Application team for application performance issues and assisting on the Database design.
• Writing various scripts for Database components monitoring when necessary monitoring tool is not in place.
• Maintain reliance relationship with clients with commitment and communication.
• Co-ordinate between IT and Operation teams regarding Server Hardware related issue.
• SQL DBA Training Experience - Conducted SQL Server trainings on various topics.
• Domain Experience - Healthcare, Finance, Retail, hotels and resorts.
• Process Experience - Very strong in ITIL processes on Change Management, Problem Management, Incident Management, SLA, OLA and ITIL Process related activities. Experienced in T-SQL and power shell programming.

• MCSA (Microsoft Certified Solutions Associate) SQL Server 2016
• OCA (Oracle Certified Associate) Oracle 10G

• Oracle 10G Fundamentals and Performance Tuning
• SQL 2014,2016 from Microsoft
• Soft Skills Trainings
• Software Testing