Post Job Free
Sign in

Azure & SQL Server Database Administrator

Location:
Alexandria, VA
Salary:
110000
Posted:
March 02, 2023

Contact this candidate

Resume:

Khyber Jalalzai

SQL & Azure Database Administrator

: +1-571-***-****

: ******.*******@*****.***

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



Contact this candidate