Khyber Jalalzai
SQL & Azure Database Administrator
: ******.*******@*****.***
www.linkedin.com/in/khyber-jalalzai
PROFESSIONAL SUMMARY
I am a Certified Microsoft SQL Server Database Administrator (DBA) with over five years of professional experience performing database maintenance, monitoring, and SQL development. Now I am seeking a full-time MS SQL Server database administrator. I am a self-motivated, meticulous professional who has demonstrated a high level of performance and accountability in prior roles at high-profile corporate entities. Detail-oriented professional with an effective combination of logical, analytical, communication and documentation skills.
SKILLS
Databases: MS SQL Server 2019/ 2017/2016/ 2012 & 2008
MS Access
ETL Tools: MS SQL Server Integration Services (SSIS)
Reporting Tools: MS SQL Server Reporting Services (SSRS)
Windows Server 2016/2012
Raid, Active directory
Jira
Customer Service Skills
MS SQL Server Migration Assistant (SSMA)
Configure HA & DR (Always On, Log Shipping, Mirroring & Replication)
Azure
Red Gate
Visual Studio
Programming Languages: T-SQL, CMD, PowerShell
PROFESONAL EXPERIENCE
Allied Universal, Alexandria, VA Feb 2020-Present
SQL & Azure Database Administrator
Migrate SQL Server databases to Azure.
Experience with server consolidation, data migration, and maintenance in unstructured data platforms.
Install, monitor, and support various High Availability and Disaster Recovery solutions.
Implemented SQL Server ALWAYS-ON High Availability groups with multiple secondary nodes.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server and expertise in closing, backup strategies, patching, and AAG.
Responsible for implementing and supporting solutions to ensure high availability and data recovery with minimal data loss.
Responsible for documenting and maintaining a Disaster Recovery plan for each supported system/application.
Experience with Always on Availability Groups and applying patches and hotfixes on Always-On Failover Cluster production.
Experience in configuring and maintaining SQL Server Replication.
Experience implementing optional automation using scripts.
Creating Alerts for growth and usage of mission-critical database files.
Install, patch, and maintain all SQL Server databases.
Keep track of performance metrics to provide solutions to improving performance.
Optimize data performance using SQL and database tuning.
Monitor and optimize the performance of cloud databases.
Create extended events sessions/triggers/traces to monitor performance.
Understanding of SQL tuning and optimization of query plans.
Experience supporting MS-SQL within Azure.
Install and support SQL server instances including SSIS, SSRS, and SSAS components.
Experience in maintaining, supporting, and securing SSIS solutions, SQL Jobs, SSRS instances, and data warehouse solutions.
Understanding of configuring SSRS and SSIS Services, Supporting and deploying reports, and SSIS Packages.
Automate common management tasks using tools such as PowerShell.
Using PowerShell to Migrate SQL Logins Jobs and objects, Backup and resolve issues.
Troubleshooting major failover cluster issues.
Database migration from Oracle to SQL Server and vice versa.
NYU Langone Health, New York, NY Oct 2017 –Jan 2020
Database Administrator
Database installs, upgrades, patching, security, troubleshooting, issue resolution, backup procedures, and performance tuning.
Monitor and report on database availability and performance.
Optimize stored procedures, triggers, and functions.
Optimize database schemas, views, and indexes.
Ability to create, understands, and follows processes to ensure the successful execution of critical maintenance procedures.
Performance Tuning and Optimization using Native Monitoring and Troubleshooting Tools.
Applying patches and hotfixes on Always-On Failover Cluster (FCI) production as well as the non-production environment.
Find and Resolve the issue when the WSFC cluster service is offline or Availability group is offline.
Create and manage ETL processes using SSIS.
Design and development of advanced ETL packages used in data migration.
Modify/Create/maintain and optimize ETL processes using SSIS.
Write/implement stored procedures, T-SQL, and/or SSIS packages as the need arises.
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes or index/query changes.
Troubleshoot database issues and maintain database systems availability and scalability within production environments.
Experience in maintaining, supporting, and securing SSIS solutions, SQL Jobs, SSRS instances, and data warehouse solutions.
DBA experience administering on-premises, cloud, and hybrid data platforms including Azure Data Services and SQL Server.
Experience in configuring and maintaining SQL Server Replication.
Advanced knowledge of database security, backup, recovery, and performance monitoring standards.
EDUCATION
Bachelor of Science in Economics March 2017
TRAINING & CERTIFICATE
Microsoft Database Administration (MCSA)
Microsoft Certified Administering Microsoft SQL Server
Microsoft Certified Administering Relational Databases on Microsoft Azure
Microsoft Certified Provisioning SQL Databases
Training on Database Performance Tuning
Training on Database High availability and SSIS, SSRS
Training on Database Azure
Training on Upgrade/Migration