Fakhrodin Mirkhail

Alexandria, Virginia

301-***-****, adkhp0@r.postjobfree.com

Career Summary

* ***** ** * ********* SQL Server Database Administrator. Skilled in the areas of Maintenance, Migration, Backup, DR Planning, Performance Tuning, Security, Installation and Configuration SSIS, SSRS, ETL, TSQL, Data Modeling and design. Detail oriented hardworking professional with an effective combination of logical, analytical, communication and documentation skills.

PROFESSIONAL EXPERIENCE

DELL Inc

MS SQL SERVER DBA Mar 2015 – Present

Manage SQL Servers that hold the CRM, Sales, Productivity, and Inventory databases of the BUDR applications

Experienced in installation and configuration of SQL Server 2008, 2012, 2016, (SSRS, SSIS)

Experienced in working with Always on Solution for both High Availability (HA) and Disaster Recovery (DR) options.

Strong working experience in SQL native database Backup and restore as well as used Ola Hallengren Maintenance solution

Proactively monitor the production database(s) and optimize stored procedures for better performance and resolve deadlock, block, and locking conflicts and resource utilization

Identify and analyze long running slow queries and tune the same to optimize application and system performance

Experience with data replication from on-prem to Azure

Migrate databases from physical servers and VMs to Azure

Experienced in recovering databases from backup during disasters with Point-in-Time Recovery option

Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery

Take necessary actions to prevent data corruption and maintain data integrity using DBCC CHECKDB

Restoring single page from backup using DBCC write page

DynCorp International

SQL DATABASE ADMINISTRATOR July 2015 – Feb 2017

Analyzed, tested, configured and implemented methods of improvements for SQL Server, database, transaction, and query performance in relation with Input/Output /CPU /Memory /Network /TempDb optimization.

Suggested and implemented database performance monitoring and performance tuning practices; troubleshoot and resolve database design and performance issues.

Query optimization, index management

Active in all phases of system development; planning and analysis, design, development, and testing

Developed and maintained technical documentation and operational procedures for areas of responsibility.

Created SQL Server Job Agents to assist with report creation and database maintenance jobs.

Performance monitoring via Native Tools such as Activity Monitor, Extended Events, PerfMonitor, DMV, Trace flag, Data Tuning Advisor (DTA), and SQL Profiler.

Experience with Export/ Import data to and from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, Access, ODBC/ OLEDB data sources

Installed, Configured and Maintained Database Mirroring using automatic fail-over as High Availability (HA) solution

Configured and implemented Log Shipping as Disaster Recovery (DR) solution

Applied Patches and Service packs to update different versions of MS SQL server and windows server

Implemented SQL Server 2012 ALWAYS-ON High Availability groups with two secondary nodes.

Applying patches and hot fixes on Always-On Failover Cluster (FCI) production as well as non-production environment

EDUCATION

Bachelor Degree, Business Administration

Maiwand university of higher education (MIHE) 2010-2014

TECHNICAL SKILLS

Excellent communication skills with upper management, vendors and end users.

Implement and maintain database security; TDE, DDM and CDC

Database Upgraded (development, testing and production environment): SQL Server 2008 R2 to SQL server 2012

Experience in implementing (High availability, Load balancing and DR) for mission critical data’s using Log shipping, Database Mirroring, Replication, AlwaysOn Availability Group and SQL Server Failover Clustering.

Operating Systems: Microsoft Windows Server /Windows XP/Windows Vista

RDBMS/DBMS: Microsoft – SQL Server 2008/2008R/2012/2014/2016

SQL Tools: Solarwinds

ETL Tools: SSIS

Reporting: SSRS (SQL Server Reporting Services/Server)

Scripting Language: T-SQL, PowerShell, TSQL, CMD

TRAINING & CERTIFICATION

MCITP: Microsoft Certified Technology Specialist on SQL Server

MCSA: Querying Microsoft SQL server

Azure Administrator Associate

Training on Database High Availability Solutions

Training on Performance Tuning

Training on Cloud computing ( AWS/AZURE)

Contact this candidate