HIZB ASHNA Silver Spring, MD 202-***-**** adm13d@r.postjobfree.com

SUMMARY

Microsoft Certified MCSA- SQL Database Administrator (DBA. Highly motivated SQL database Administrator with over 7 years of experience in IT, particularily in advanced SQL Server Databases Installation, Configuration, Migration, Maintenance, Performance Tuning, High Availability, Disaster Recovery, Security, SSIS, SSRS, TSQL programming, development, report design, ETL development using SSIS, data analysis and visualization using Microsoft Excel, Power BI and SSRS.

SKILLS

Excellent interpersonal communication skills, strong organizational abilities, professional conduct, and attitude

Microsoft Database and BI: SSIS, SSRS, ETL, SQL (T-SQL), DDL, DML, DCL.

Operating System: Windows Server 2008, 2012, 2016 Datacenter, PowerShell, troubleshooting, data processing.

Languages SQL (T-SQL), Power shell, SQLCMD.

Database development: queries, stored procedures, functions, and triggers

System management: support, maintain and configure, patching, upgrade, database migration, jobs creation, backups, disaster recovery procedures, mirroring, server clustering, high availability/load-balancing design.

EXPERIENCE

SQL Administrator State Farm - Remote April-202-Feb - Feb 21

Installed, configured, and upgraded installations of SQL server 2012/2014/2016.

Involved in planning and administration of Failover clustered environment.

Involved in performance tuning for the optimization of slow running queries and index maintenance.

Automated SQL Server Agent jobs for Periodic Backups with Backup Devices and Database Maintenance Plan.

Manage back-ups and recovery procedures.

Performed security administration including creating various user groups and assigning the accessibility according to requirement, monitoring the user accounts, creating user accounts, granting the privileges to users and groups.

Good ETL/Extract, transform, and load data, and develop robust ETL packages.

SQL Server Administrator Targeted Technology Institute, Silver Spring MD Aug 2017 – April-2020

SQL Server Installation, Monitor and maintain database storage resources and monitor database server systems resources performance.

Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics.

Install database software service packs and cumulative updates as necessary and Maintained database documentation as required.

Created T-SQL Stored Procedures, User Defined Functions, Indexes, Views, Constraints, Triggers and wrote complex queries using Joins, Aggregate Functions, Sub-queries, Derived tables and CTEs.

Responsible for weekly full, daily differential and hourly Log backups.

Proactively monitor and respond to MSSQL database Alerts.

Good ETL/Extract, transform, and load data, and develop robust ETL packages.

Data extraction from multiple sources, including data warehouses, various databases, etc.

Troubleshooting the reporting database environment and reports.

Create and deploy SSIS packages, improve monitoring capability error logging and error recovery capability of ETL jobs.

Develop database objects such as tables, views, common table expressions, dynamic SQL, foreign key constraints, and stored procedures.

Created reports with SQL Server Reporting Services.

SQL Server administrator Afghanistan Justice Sector Support Program / Kabul, Afghanistan May 2014 - March 2017

Install and configure new SQL Servers.

Troubleshoot and resolve database problems.

Designing databases and ensuring their stability, reliability, and performance.

Perform scheduled maintenance and support release deployment activities after hours.

Handle common database procedures such as upgrade, backup, recovery, migration, etc.

Monitor database performance, implement changes, and apply new patches and versions when required.

Analyze, solve, and correct issues in real time and document the company’s database environment.

Create SQL Server logins, database users, assign permissions, move security between servers, and implement database encryption TDE, dynamic data masking (DDM).

LANGUAGES and CERTIFICATIONS

English (fluent), Pashto (native), Dari (native), Persian (fluent).

MCSA Developing Microsoft SQL Server Administrator Certification 2020, Microsoft BI (SSIS, SSAS, SSRS) training

Splunk (training)

Azure training in progress.

EDUCATION

Kardan University Kabul, Afghanistan

Bachelor of Information Technology

Dec 2013

Contact this candidate