Mohammed Salmaan

Address: Buraidah, KSA

Contact: +966-********* (M)

E-mail: ady2jv@r.postjobfree.com

Linked IN: https://www.linkedin.com/in/mohammed-salmaan-8b140118/ Objective: Aspiring management/leadership challenges, to drive Project or DBA initiatives, utilizing rich skills

& experience, thus achieving Comprehensive Growth along with total client satisfaction Senior DBA

About me: An achievement-oriented Technocrat turned IT Professional, offering 9 years of skilled & Versatile experience of Database Management, including Administration on Large and Complex Production databases, having Migration and Upgradation of Databases. Further possessing expertise on multiple technologies (HA/Backup & Recovery/Performance Tuning/etc.) as well as in troubleshooting production issues and raising high availability.

Core Competence

Database Administration (DBA)

Large/ Complex Production

Databases

Migration and Upgradation

Project Delivery Management

High Availability Technologies

Failover Cluster (WSFC), Replication,

Mirroring & Log Shipping

Always on Availability Group (AOAG)

Performance Tuning & Optimization

Backup & Recovery/Integration

Certified Scrum Master

SSRS & JDE Reporting

ERP (SAP & Oracle-JDE)

MS SharePoint HR

Analytical & Problem Solving

Team Leadership/Management

Profile Summary

Currently engaged as Database Administrator (DBA) for Qassim Cement Company, KSA. Providing Service Support (24x7 productions) for MS SQL Server databases, specifically on Clustered Servers (with sizes ranging from 1 to 2 Terabytes) for achieving maximum performance and uptime in the production environment.

An experienced Database Administrator, having very strong analytical & debugging skills which includes controlling of the data in the organization, Data Definition, Data Manipulation, Query monitoring & optimization, Data Security & Integrity, Data Recovery

& Concurrency, Support Data Dictionary, monitor/optimize Performance and Service Support for the continuous availability of the database.

Possessing detailed experience on all kinds of Windows (OS) platforms, along with expertise in AOAG, Failover Cluster (WSFC), HA Solutions, Performance Tuning, Managing Backup and implementing Disaster Recovery.

Further expertise in creating test environments using Azure Services

(PaaS) as well as in managing content and configuration databases of SharePoint.

A result-oriented Team Leader, leading the team to performance excellence with vision/mission, while being skilled at Knowledge Transfer for Skill upgrade, Motivation and Mentoring.

A cohesive Team Player, with analytical & problem-solving expertise along with innovation, negotiation, planning, decision making, multi-tasking, communication & interpersonal skills. Qualifications

Education

B. Tech. (Electronics & Communication), from Jawaharlal Nehru Technological University, India Accreditation

Microsoft Certified Professional (MCP-Azure Database Fundamentals)

Oracle Certified Associate (OCP)

Certified Scrum Master (CSM)

Oracle Partner Training on Oracle – HRMS

Oracle Training on Procurement & Material Requirement Planning

Attended Workshop on Knowledge Manager - Manufacturing specific Technical Skills:

Virtualization: VMware, Hyper-V

Operating Systems: WIN (Server 2019/2016/2012/2008/2003)

Cloud Platform: Azure Services (PaaS/IaaS)

Languages: SQL, ABAP, JDE

Databases: MS SQL Server (2019/2017/2014/2012/2008), Oracle 9i/10g

Other Tools: ETL, Power BI

Reporting Tools: SSRS, SSIS, JDE Reporting

Third-Party Tools: Symantec, VERITAS

ERP: SAP, ORACLE – JDE

Detailed Work Experience & Achievements

QASSIM CEMENT COMPANY, KSA

SQL Database Administrator (May 2014)

Responsibilities:

Reporting to the IT Chief & supervising one resource to provide production support (24x7 ) for MS SQL Server databases.

Implementing the support services on Clustered Servers (for 1 to 2 Terabytes data sizes), achieving maximum performance and high uptime, in a production environment.

Fine Tuning the Databases using Performance Tuning & Optimization techniques – Extended Events, SQL Profiler, Database Tuning Advisor (DTA), Query Tuning and Index Analysis.

Designed & implemented a comprehensive Backup plan and disaster recovery strategies as per the RTO and RPO stipulated by the business.

Managed HA Technologies – Always On Availability Group (AOAG), Failover Cluster (WSFC), Replication, Log Shipping.

Creating a stand-alone database for reporting purposes by implementing Database Mirroring

Initiating SQL Logins, Roles & Authentication Modes to implement Security Policies for various categories of users.

Monitoring database activities such as DB Status, Logs, Capacity Planning, Blockings, Locks, Corruption, applying/updating patches and many more.

Developing Maintenance Plans for database monitoring activities such as Backup, Statistics, Server Health, Database Health, alerts, notifications, etc.

Conducting training for juniors, enabling smooth production operations. Achievements:

Tuning the process to reduce the processing time of HR Time Attendance from 20 hours to 4 hours

Successfully integrated the SharePoint Application with JDE replacing the web services

Delivered SQL Failover Cluster (in time), when the system administrator (suppose to implement windows cluster) was on leave, thus handled the windows clustering part, as well

Re-Designed Databases (that were deadly slow due to poor configuration settings) & improved the performance Project Summary

Following projects were executed for Qassim Cement Company, KSA: Project Implementing Fail-Over, Merge Replication & RFQ Form Duration 30 Days

Team Size 4

Details The aim of this project was to implement Fail-Over Cluster. Further configured Merge Replication to enable communication between the supplier and vendor via Website and also to develop RFQ Form.

Role Project Lead

Responsibilities Designed Fail-over

Assisted Junior DBA in Merge Replication

Project Upgradation & Migration of ERP (JD Edwards) Duration 90 Days

Team Size 7

Environment Windows Server 2008, MS SQL Server 2012, ERP - JD Edwards Details A Project to Upgrade JD Edwards Enterprise-One, Modules involved - HR, Supply Chain &, Finance. Migration of Databases, Application, Deployment, Web Server and UBE Reporting & Enterprise & Business Servers was also involved.

Role SQL DBA - Team member

Responsibilities Upgraded the SQL Server 2008 to 2012 Configured Failover Cluster (WSFC)

Transferred All Logins, All Jobs, Server Configurations & Linked Servers Database restored successfully

Project SharePoint Portal Revamping

Duration 120 Days

Team Size 3

Details This project was to modify all the forms dynamically, to give the digital impression and conduct Performance Tuning of all Databases and Portal revamping. Role SQL DBA

Responsibilities Migrated all the Microsoft SharePoint Databases to the newly staged servers Performed Performance Tuning for better results as the databases were very slow Ongoing Project

Project DR Implementation

Duration 60 Days

Team Size 5

Environment MS SQL Server 2012/2014, JDE, SharePoint, VERITAS Backup Exec, Windows Server 2012 Details This project had the scope of DR Implementation, to reduce the risk of disaster & continue the business (HA), putting down everything needed for the business up and running in the off-site location.

Role SQL DBA - Team member

Responsibilities Failover Installation of SQL Server Add the Always on Availability Group (AOAG), to the existing failover Cluster Replicate the data both synchronous & asynchronous way, as per the criticality of the data Personal Details

Languages known: English, Urdu and Telugu

Location Preference: KSA

Nationality: Indian

Passport details: K7912951

Visa status: Transferable

Contact this candidate