Sql Server Ms

Fakhrodin mirkhail

SQL Server Database Administrator

Fredericksburg VA 22405

301-***-****), **********@*****.***

Professional summary

Over 8 years of experience in Database Administration, System Analysis, Design, development, and Support of MS SQL Server 2022/2019/2016/2014/2012/2008 R2 in Production, Test, Development, Stage Environments.

Expertise in Database Administration on Production Servers with Server Configuration, Performance Tuning, and maintenance with outstanding troubleshooting capabilities

Experience on High Availability /Disaster Recovery (HADR) solutions; Failover Clusters and Always on Availability Groups, Replication, Log Shipping and Mirroring

Experience in Upgrade/Migration

Experienced in Backup and Recovery, query Optimization

Experienced in monitoring the health and performance of SQL servers as well as home grown applications using SQL Server native tools and several other third-party solutions

Created various SSIS Packages to serve company needs

Expert in using Extended Events/PerfMon/SQL Profiler/ Scripts and other third party tools to resolve bottlenecks, dead locks and slow running queries

Responsible for securing SQL Server, user management, assigning permissions and roles.

Strong System Administration background in Windows.

Expert in problem solving, analysis and conflict resolutions

Skill

Databases: MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, MS Access,

Cloud: AWS, AZURE

ETL Tools: MS SQL Server Integration Services (SSIS)

Reporting Tools: MS SQL Server Reporting Services (SSRS), Report builder

Programming Languages: T-SQL, PowerShell, CMD

Operating Systems: Windows 2016/2012server

Other Tools: MS SQL Server Migration Assistant (SSMA) and ODBC/DB Link, MS Always On, MS Azure, MS SQL Server Clustering and Performance Tuning, Red Gate, ServiceNow, Jira, Splunk

Education

Bachelor Degree, Business Administration

Maiwand University of Higher education (MIHE) 2010-2014

Certificate

Microsoft Certified Solutions Associate (MCSA)

Microsoft Azure Associate

Training:

Always on High Availability group

Training on Database Performance tuning

Training on Azure Database

EXPERIENCE

Tata Consultancy Services TCS Inc. March 2021- Present

SQL SERVER DATABASE Administrator

Provide Customer support

Designed and developed SSIS packages to extract, transform, and load (ETL) data from various source, and SSRS.

Provide technical support to client to manage BestBuy databases

Database refresh

Migration from on premises to Azure & On premises to On premises

Migration from Azure to AWS

Implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications.

Ensuring operational readiness (security, health and performance), executing data loads in development and production environment

Capable of working independently and collaboratively.

Verify that the design and execution of database server configuration, and maintenance fulfill SLA goals.

Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers

Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company’s databases and systems

Extensive experience setting up and troubleshooting SQL Server Availability Groups.

Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization

Managing SQL Server Database both on-perm and Azure

Advance performance tuning and T-SQL code

DynCorp International March 2019- March 2021 (Dallas, TX)

SQL SERVER Database Administrator

Proficiency in SQL server database Backup/Recovery, Refresh, Maintenance, Export/Import/ Performance monitoring/tuning, Security management, SQL Programming, with work experience on different version on SQL server database example 2008,2012,2014,2016,2019

Configure and maintained High Availability (HADR) solutions, Failover Clusters and Always on Availability Groups, Replication, Log Shipping and Mirroring.

Applying patches and Perform database upgrades/migrations

Troubleshoot complex systems to identify bottlenecks (SQL, IO, hardware, query related, etc.); Resolve database related issues.

Provide production support in time sensitive situations in addition to providing support for multiple high-profile applications/projects.

T/SQL, SQL, DML, DDL and DCL Experience, Manage connectivity to other RDBMS.

Assist clients with fine tuning indexing and tune queries.

Generate performance and efficiency metrics and offer expert advice to clients.

Perform regular security and access reviews;

Azure/SQL Server DBA Experience in an IaaS/PaaS environment

Implementing and maintaining data security protocols for sensitive data & PII.

Azure/SQL Server monitoring and performance tuning, installation, administration, and maintenance

Working of Agile methodology.

Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.).

Effectively prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision.

Drive results and leverage past experiences to improve the environment and related processes.

Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps.

AID MEDICAL INTERNATIONAL, Inc. March 2017- March 2019

SQL SERVER Database Administrator

Assist team with Migration from on-premises to on Azure, IaaS.

Provided support for data migration projects, including data cleansing, validation, and reconciliation tasks.

Managing SQL Server Databases both on-prem and Azure using (IaaS) for production environment.

Database refreshes and cloning using Delphix and native SQL backup and restore.

Hands on experience with schemas, loading data, data retrieval and reporting.

Root Cause Analysis (RCA) of Incident, Monitoring of Production, Dev and Test on-prem and Azure environment of SQL Server and analyzed the root cause and factors impacted database performance.

Involve with database upgrades, patching, and migrations in windows environments.

Working in Database related day-to-day Activities.

Create SQL Server logins, database users, assigning permissions, moving security between servers and implementing database encryption TDE, dynamic data masking (DDM).

Creating Alerts for growth and usage of mission critical database files

Creating SOP’s and performing monitoring task with team.

Ensuring solution and operations reliability.

Designing and planning a cloud solution architecture

Working in an Automation team that delivers a high availability service.

Excellent in Performance Tuning including monitoring, troubleshooting, and optimizing performance of the databases as well as high availability service.

24 X 7 Production Database on Call Support.

Contact this candidate