MOHAMMED ALI

Bachelor of Technology (B-Tech) Computer Science of Engineering.

Nationality: Indian

Address: Riyadh, Kingdom of Saudi Arabia.

Phone number: +966-*********, whts app: 009*********** Email address: adxmqy@r.postjobfree.com

OBJECTIVE

IT professional with over 5 of experience on SQL Server, working as Database Administrator and I am constantly challenged, can walk into a new environment and adapt to new situations, configurations, and technologies. EDUCATION

Bachelor of Technology (B-Tech) in Computer Science of Engineering from Jawaharlal Nehru Technological University (JNTU), Hyderabad, INDIA.

Diploma in SQL Server & Azure DBA from KDSSG – Bangalore, India.

Diploma in Microsoft Certified Solution Expert (MCSE) from Netmatric Solution- Hyderabad, India. CERTIFICATIONS

• Microsoft Certified : Azure Database Administrator Associate

• Microsoft Certified : Azure Administrator Associate

• Microsoft Certified : Microsoft Certified Solution Expert (MCSE) PROFESSIONAL EXPERIENCE

Working as a SQL Server DBA with DBAMAZE Technologies INC from March 2018 to till-date CORE TECHNICAL SKILLS EXPOSURE

• Having around 5+ years of experience as SQL Database Administrator

• Installing, configuring, managing, monitoring and troubleshooting SQL 2005 – SQL 2019 Performing unattended installations.

• Handled Slipstream installations. And Installing Service Packs, Cumulative Updates, Hotfixes.

• Upgrading/Migrating SQL Server from older (from SQL 2005) to newer (till SQL 2019).

• Granting permissions also adding logins/users to roles in SQL Server Security

• Creating and Configuring Databases as per requirement of Application Teams..

• Backup Types (Full/Differential/Log) & Restore Scenarios (Point-in-Time/Piecemeal/Page).

• Increasing Backup Buffers & Split backups to make backups run faster.

• Good Knowledge on Configuration of Encryption backups/databases

• Handling Master, Model, MSDB,TEMPDB and Resource database corruptions.

• Knowledge on configuring Active Directory and adding VMs/Servers to Domain..

• Good Exposure on Configuring HADR like Log Shipping, Mirroring, Clustering, Always-On AG, (DAG) & Replication.

• Good knowledge on all scenarios and troubleshooting of HADR like (Logshipping, mirroring, clustering, AOAG,

(DAG),Replication

• SQL Server Architecture knowledge on overall Architecture

• Understanding of Advanced SQL Server Architecture (Relational & Storage Engines).

• Background process exploration of Checkpoint, Lazy writer, Eager writer, Log Write.

• Ability to Create Indexes on tables to improve the performance as per Dev/App team.

• Handling 18456 errors and troubleshooting connectivity issues of Users to SQL Server

• Implementing best practices through SQL Server Hardening methods.

• Comfortable raising ticket with Microsoft for any advanced troubleshooting if unresolved.

• Providing 24/7 support and On-Call responsibilities for the production databases and servers.

• MS SQL Installation of SQL Server 2008/2012/2014/2016/2019, Configuring Availability Groups, and applying service packs.

• Exploring new features like Resource Governor, Policy Based Management, Auditing, Transparent Data Encryption, Always Encrypted, In Memory OLTP & Query Store.

• Comfortable raising ticket with Microsoft for any advanced troubleshooting if unresolved.

• Work as part of a team and provide 24x7 support

• Interacting and collaborating with Management, Development teams, Functional teams, network teams and Systems administrators.

• Focused towards ITIL Framework (Incident/Change/Problem Management)

• Handling/attending meetings and preparing Minutes-of-Meeting as needed.

• Mentoring team members for technical issues as approached. Project-1

Client : Apttus Corp (Conga)

Duration : Mar-2021 to Till-Date

Role : SQL Server DBA Level-2

Team Size : 11

Apttus Corporation (Conga) is an American business-to-business software provider specializing in business process automation and Contract Lifecycle Management (CLM) tools. The company provides "Middle Office" solutions, utilizing artificial intelligence to optimize various financial and commercial functions, such as quote-to-cash, revenue management, and e-commerce management. Apttus Software has been integrated with Microsoft Azure and IBM Cloud. Project-2

MS Database Cluster

• Implementation of MS Database cluster

• Implementation of FCI Cluster for Databases

• Implementation of Always on Cluster for Databases Upgradation and Migration

• configure upgradation and migration of sql server 2012 to 2019

• Performing On-Prem database migrations to Azure using DMA ROLES AND RESPONSIBILITIES

• Involved in Installing SQL Server and its service packs, and also client installations

• Checking the status of backup, troubleshooting the failed backups and restoration

• On-Call responsibilities for Production database systems

• Monitoring SQL Server performance using extended events/profiler

• Creating Indexes on tables to improve the performance as per Dev/App teams

• Performing SQL server daily health check and preparing a report based on it

• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans

• Monitoring the Logs for successful execution of all the specified jobs

• Reviewing SQL Server and SQL Agent Error Logs.

Microsoft Azure (Iaas)

• Creating Azure Virtual Machines both Windows/Linux and installing SQL Server on them.

• Configured Always-On AG with listeners and load balancers in Azure VMs

• Creating/configuring Azure SQL Databases (PaaS/DBaaS)

• Exporting BACPAC from Azure SQL Databases.

• Taking On-Prem backups to Azure Blob Containers.

• Performing On-Prem database migrations to Azure using DMA TECHNICAL SKILLS

Database: SQL Server 2005, 2008R2, 2012, 2014, 2016, 2017 & 2019 Operating Systems: Windows 7/8/10, Windows Server 2008R2/2012/2016/2019 Tools: SSMS, Perfmon, Profiler, Configuration Manager, DMA, Oracle Virtual Box PERSONAL DETAILS

• Name : Mohammed Ali

• Date Of Birth : 30/05/1999

• Nationality : Indian

• Languages Known : English,Urdu,Telugu

• Marital Status : Single

• Passport Number : W2982538

DECLARATION

I hereby declare that the above furnished details are true to the best of my knowledge and belief. Date : 05-04-2023

Place : Riyadh, KSA

Contact this candidate