Mohammed Farhan

+97-050*******

adyj0q@r.postjobfree.com

WhatsApp: +91-630*******

Objective

Working as a Consultant and having more than 7 years of experience in MSSQL Core Database Administration

Skills

T-SQL, SQL Server DBA, Azure SQL DB and Windows Server

Work Experience

Designation: Consultant

Company: ANB Bank (Arab National Bank, KSA)

Period: Feb, 2023 to July, 2023

Roles and Responsibilities:

Proven experience in day-to-day database administration activities for operational databases and Database Administration of Microsoft SQL server 2019/2016/2014/2012/2008 R2 onwards.

Experience with Azure cloud environments.

Experience in build a new infrastructure of SQL servers

Exposure in Database Backups and Restore manual and Automation

Create Clustered and Non clustered indexes to improve read queries

Expertise in High Availability (HA) and Disaster Recovery (DR) (Always On), Windows Failover Cluster Instance (FCI) and Storage Replication).

Perform switchover and switch back activities in (Failover Instances (FCI,) Always on Databases and Storage replication Stand-alone SQL Databases.

Experience in SQL database Replication using Storage Replication between Primary and DR sites.

Create and Manage SQL Logins, users with Roles and permissions with limited access.

Good experience in SQL Server Migrations and Upgrades.

SQL Database Design and Development.

High service management and application of change management principles.

Monitor and tune performance of Database and systems resources and query throughput.

Monitor and maintain database storage resources

Monitor and maintain database maintenance plans for Backups, index rebuild/Defragment, and Database statistics.

Install Database software service packs and cumulative updates as necessary.

Maintain Database documentation as required.

Perform Database Ad hoc backups and restores.

Troubleshoot and resolve Database connectivity issue.

Follow problem management processes to troubleshoot and resolve recurring issues.

Proactively monitor and respond to MSSQL Database Alerts.

On call requirements to ensure 24/7 supports of Database operations.

Designation: Consultant

Company: Persistent Systems Limited (Hyderabad, India)

Period: Feb, 2022 – March 2023

Roles and Responsibilities:

Proven experience in day-to-day database administration activities for operational databases and Database Administration of Microsoft SQL server 2019/2016/2014/2012/2008 R2 onwards, Performance Tuning and Troubleshooting.

Experience with Azure cloud environments.

Experience in Installing and configuring SQL servers.

Expertise in Backup and Recovery Tasks.

Experience in Stored Procedures, Views, Triggers and Indexing.

Writing T-SQL including troubleshooting and tuning.

Expertise in High Availability (HA) and Disaster Recovery (DR) Technologies Like (Always On, Windows Failover Cluster, DB mirroring and Log shipping).

Experience in SQL database Replication.

Defining Database Server Security, User Creation, Roles and Permission.

Good experience in SQL Server Migrations and Upgrades.

SQL Database Design and Development.

High service management and application of change management principles.

Monitor performance of Database systems resources and query throughput.

Monitor and maintain database storage resources

Monitor and maintain database maintenance plans for Backups, index rebuild/Defragment, and Database statistics.

Install Database software service packs and cumulative updates as necessary.

Maintain Database documentation as required.

Perform Database Ad hoc backups and restores.

Troubleshoot and resolve Database connectivity issue.

Follow problem management processes to troubleshoot and resolve recurring issues.

Proactively monitor and respond to MSSQL Database Alerts.

On call requirements to ensure 24/7 supports of Database operations.

Designation: Consultant (MSSQL Server)

Company: DATA GLOVE IT SOLUTIONS PVT LTD

Period: April 2018 – Feb 2022

Roles and Responsibilities:

Database administration activities like Installation, Configuration, Backup

Recovery, database security, troubleshooting the MSI and MSP files missing and SQL Server Performance.

SQL Server installation in production servers & non-prod servers.

Creating of logins, user administration.

Implementation of Log Shipping, Clustering and Configure with Always On high availability on WSFC.

Hands on with Linked Servers (SQL to SQL & SQL to Oracle) from remote SQL Server and also other Data sources from SQL server ODBC connectors.

Work with SQL Server Up gradation, SQL Server Migration and SQL Server Patching.

Work on creating of clustered, Non-clustered Indexes and creating of Maintenance plans for the Index Rebuild and Reorganize, Backup maintenance plans, update statistics, Checking database integrity check and their retention period.

Work experience on Azure Scheduling Jobs, Creating databases, various SQL server versions migration on Azure.

Reading SQL error log and event log for initial investigation.

Working with DMVS and DMF’S in retrieving the information from the server.

Monitor system's health and performance, Ensure high levels of performance, availability, sustainability and security

Provide 24x7 supports for critical production systems and on call support.

Perform scheduled maintenance and support release deployment activities after hours

Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner

Designation: Associate Consultant (SQL DBA)

Company: DATA GLOVE IT SOLUTIONS PVT LTD

Period: May 2015 to July 2017

Roles and Responsibilities:

Installation, database upgrades, patching, setup, configuration (Clustered and Standalone) of SQL server 2008R2 and 2012

Implementing backup/recovery procedures

Implement monitoring procedures and respond to alerts generated

Manage monitoring / capacity management processes to ensure appropriate scale of growth

Manage and resolve technical issues related to the implementation of MS SQL Server (software releases, patch management tools and capacity planning backup and recovery strategies)

Maintain documentation

Education

Completed Bachelor of Technology in Computer Science and Engineering

Contact this candidate