Summary
Overview
Work History
Education
Skills
Timeline
Generic

Hamayoon Tariq Abbasi

Ringwood,IL

Summary

  • 5+ years of experience in Database Administration for large databases in SQL Server 2005, SQL Server 2008,2008 R2,2012,2014 and 2016.
  • Systematic and organized SQL DBA trained in database systems management using a variety of technology platforms.
  • Qualified SQL DBA committed to data integrity.
  • Experienced Database Administrator on Production Servers using SSCM,SSMS, performance tuning tools such as profiler,DTA.
  • Hands on experience on SQL Server Replication, Backup/Restore, Disaster recovery and planning.
  • Having hands on experience in Log Shipping and Database Mirroring.
  • Troubleshoot performance problems, fine-tuning of databases and index Analysis.
  • Excellent communication skill, critical thinking and problem solving skills.
  • Experience in Batch processes, Import/Export, Database Monitoring tools and Application support.
  • 24/7 Production Database on Call Support.
  • Microsoft SQL DBA certified

Overview

7
7
years of professional experience

Work History

SQL DBA

Fast Solutions
04.2022 - Current
  • Responsible for installation, configuration and complete administration of different versions of SQL Server (2008 to 2014)
  • Apply Service Pack (SP) and hot fixes on SQL server 2008R2,2012 ,2014
  • Configure log shipping for multiple databases as a part of Disaster Recovery.
  • Configure Replication and Database mirroring.
  • Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
  • Extensively work with SQL Profiler, Activity monitor, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.
  • Analyze long running slow queries and tune the same to optimize application and system performance.
  • Configuring and maintaining Log-Shipping and troubleshooting the issues.
  • Reorganize/Rebuilding the indexes at regular intervals for better performance.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Involved in troubleshooting and fine-tuning of databases for its performance.
  • Improve the performance of SQL Queries and stored procedures using SQL Profiler.
  • Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
  • Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.
  • Provide 24/7 technical database support for SQL Database systems.
  • Worked effectively in fast-paced environments.
  • Gained extensive knowledge in data entry, analysis and reporting.

SQL Server DBA

Sumitomo Mitsui Banking
10.2020 - 02.2022



  • Installation, configuration and upgrading of SQL Server 2008/2008R2,2012 with service packs and hot fixes.
  • Upgrading SQL Server 2008/2008R2 to SQL Server 2012 (Side by side upgrade).
  • Providing On-Call support during business hours.
  • Monitoring Daily backup jobs and automation of daily restores of development databases.
  • Monitoring the Disk Space of all the Servers.
  • Configuring and Monitoring log shipping and Database mirroring on Disaster recovery Servers.
  • Database snapshot creation for the synchronized databases for Reporting Purposes.
  • Capturing the events using sql profiler for poor performing queries, deadlocks and blocks and studying the execution plans and fine tuning the applications.
  • Automating Server Side Tracing in SQL Server and identifying SQL Server performance issues, by analyzing Profiler output.
  • Disaster Recovery setup and testing it in regular intervals.
  • Reporting and resolving serious SQL Server alerts.
  • Implement and Maintain database Security (Create and maintain users and roles, assign privileges)
  • Working with workflows for any changes on staging and development environment. Involved in the internal and external audits and participating in the business continuity plans of the company.
  • Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
  • Designed strategic plan for component development practices to support future projects.

Junior SQL DBA

Northwell
03.2017 - 09.2020


  • Administered database and server security by creating and maintaining SQL server logins,permissions and privileges.
  • Worked with Developers and QA team to resolve any database or application issues.
  • Provided ongoing maintenance and administration of assigned systems.
  • Configured and validated database backup routines and recovery of lost or corrupted data.
  • Maintained data security and integrity through user authentication and authorization.
  • Optimized database performance through database performance tuning.
  • Developed test sets for monitoring database functionality through 24X7 monitoring systems.
  • Solved the request raised by user support.
  • Participated in implementation of new releases into production.
  • Involved in Day-to-day administration of live SQL Servers.

Education

Bachelor of Science - Computer Science

University of Lahore
Lahore Pakistan

Skills

  • Log-shipping
  • Replication
  • Mirroring
  • Database schema creation and management
  • Backup and recovery
  • Ensuring data integrity
  • Performance management and tuning
  • High Availability
  • Data security
  • General database management
  • Extensible data type administration
  • Excellent diagnostic skills
  • Enterprise technologies
  • Excellent communication skills
  • Data privacy applications
  • Excellent problem-solving abilities
  • Database design

Timeline

SQL DBA

Fast Solutions
04.2022 - Current

SQL Server DBA

Sumitomo Mitsui Banking
10.2020 - 02.2022

Junior SQL DBA

Northwell
03.2017 - 09.2020

Bachelor of Science - Computer Science

University of Lahore

Similar Profiles

CREATE PROFILE
Hamayoon Tariq Abbasi