Fateh Ahmed

Fredericksburg,VA

Summary

Microsoft Certified MCSA, SQL DBA (Database Administrator) and have over 6 years of experience in SQL server Database with intensive knowledge of SQL Server 2008R2/2012/2014/2016/2017/2019 databases, seeking a position as MS SQL Server Database Administrator. Experience entails different aspects of SQL Server Databases in Installation, Configuration, Migration, Maintenance, Performance Tuning, Security, SSIS, SSRS, ETL, Data Modeling and design, as well as development of database objects including stored procedures, triggers, views, functions, constraints etc. Highly skilled in completing projects and achieving company goals within budget and deadline. Critical thinker and problem-solving skills, Team player, excellent time-management skills, and have great communication skills.

Overview

years of professional experience

Certification

Work History

SQL Server Database Administrator

ECU Health

01.2022 - Current

Ensure database security, integrity, stability, and system availability
Manage, monitor, and maintain database performance and resource utilization, including performance tuning and query optimization
Installed, Configured, VM Machines, and Managed Database Instances in Virtual Environment
Ensure data synchronization is in a healthy state
Maintain backup procedure of databases associated with AG, Test failover scenario
Maintain all database instances across development, staging, and production environments, handling installations, migrations and configurations as needed
Establish and maintain database provisioning standards
Understand and follow established change management procedures
Assist in design and documentation of technical recovery procedures
Maintain in-depth knowledge of latest trends and best practices
Perform other duties and responsibilities as required or assigned
Strong understanding of high-availability solutions and architecture
Participate as a subject matter expert within organizational projects or initiatives
Monitor SQL servers using Redgate
Monitor database system details within the database, including stored procedures and execution time
Implemented SQL Server 2016 ALWAYS-ON High Availability groups and distributed availability group
Monitor, optimize, and allocate physical data storage for database systems
Create/generate data reports from SQL Server databases
Adding nodes to already existing clustered servers as a part of High availability
Create login synchronization process on AAG nodes, which include a creation of database, tables, stored procedures and job to run appropriate stored procedure based on replication role
Deploy reports in particular format, Migrate databases from physical servers and VMs to Azure.

SQL Server Developer

Carolina Insurance Agency

04.2018 - 12.2021

Configure cluster environment, installing of standalone SQL server, and configure always on
Monitor system's health and performance before and after HA/DR
Advanced knowledge of database security, backup and recovery, and performance monitoring standards
Ensure high levels of performance, availability, and security
Manage databases within availability groups, and ensure data synchronization is in a healthy state
Installs and configures database software across development, staging, and production environments
Installs updates and new patches within the programs
Transfers the old data to new systems when deployed
Backs up/restore databases, including recovery of corrupted data
Monitors database security, integrity, and access controls
Maintain backup procedure of databases associated with AG, Test failover scenario
Monitor SQL server using windows and SQL server native tools and Redgate SQL Monitor
Monitor database system details within the database, including stored procedures and execution time
Write TSQL script to create DAG (distributed availability group)
Find and Resolve the issue when WSFC cluster service is offline or Availability group is offline
Perform regular database maintenance tasks such as rebuilding indexes, update statistics, database integrity check, storage management, monitoring performances, etc
Apply Hot Fixes, Patches, Cumulative Updates, Service Packs, Upgrades
Manage backup and recovery systems to maintain disaster recovery planning
Monitor database system resources and performance
Applying patches and hot fixes on Always-On Failover Cluster (FCI) production as well as the non-production environment
Configured Transactional Replication
Provide 24x7-production support
Support responsibilities have rotated among the members of the Production Support team.

Education

Bachelor’s of Science -

Missouri State University

05.2019

Skills

Databases: MS SQL Server 2019,2017,2016,2012,2008
MS Access, MySQL (501)
ETL Tools: MS SQL Server Integration Services (SSIS)
Reporting Tools: MS SQL Server Reporting Services (SSRS)
Programming Languages: T-SQL, CMD, PowerShell
Windows: 2022 to 2012, Active Directory, Backup/Recovery
Log shipping, Replication, Clustering, Always on Availability group
Database security, TDE, Always Encrypted, Data Masking
Backup and recovery
Capacity Planning
SQL Profiler
Query Optimization

Index Maintenance
Database monitoring
Apply patched, hotfixes, service packs, cumulative updates
Database Performance Tuning
Database upgrade/migration
Windows Troubleshooting
Customer Service Skills
AZURE
Red Gate
Toad Data Modeler
Jira
Service Now

Websites

www.linkedin.com/in/fateh-ahmed-292804310

Citizenship

US Citizen