Baji Hussain Shaik

Khammam

Summary

Experienced SQL Server Database Administrator with 4+ Years of dedicated service in managing, optimizing, and securing database environments ensuring data integrity, enhancing performance, and implementing high-availability solutions. Seeking a challenging DBA role to leverage my expertise and contribute to the success of an innovative organization, driving database excellence and efficiency.

Overview

years of professional experience

Work History

SQL DBA Level2 (BDO)

Sundaram Home Finance

12.2019 - 12.2022

Sundaram Finance has the future of hire-purchase finance in India
Started with the primary objective of financing the purchase of commercial vehicles has today grown into one of the most trusted financial services groups in India
Sundaram Finance Limited has a diversified presence in Mutual Funds, Housing Finance, General Insurance, Information Technology, Business Process Outsourcing and Retail Distribution of a wide array of financial services and products
We support Sundaram Home Finance databases.

SQL DBA Level1 (DO)

Cholamandalam Investment and Finance

08.2018 - 12.2019

Cholamandalam Investment and Finance Company Limited (Chola) is a financial services arm of the Murugappa Group
Chola commenced business as an equipment financing company and has today emerged as a comprehensive financial services provider offering vehicle finance, home loans, loan against property, SME loans, secured business personal loans (SBPL), consumer & small enterprises loans (CSEL) and a variety of other financial services to customers.

Education

B. Tech (Civil) -

JNTU, Hyderabad

Skills

Azure SQL Server DBA

Installation, Configuration,Patching,Slip streaming & Trouble shooting of Microsoft SQL Server
Creation of Login, Users, Roles, Permissions, Linked Servers & managing security at Instance and Database Level
Recovery Models and Types of Recovery, Backups & Types, Encrypted Backups, Backup Strategies & Fine Tuning Backups, Restorations
System & User Database Corruptions, Suspect DB issues
SQL Server Editions and licensing terms (Server-CAL, Core-Based & Volume Licenses)
Alerts, Jobs, Database mail & Maintenance Plan Configurations
Logshipping configurations,troubleshooting errors like 14420 & 14421
Mirroring configuration, troubleshoot errors like 1418
Active Directory and Domain Knowledge for VM'S setup
Windows failover cluster configuration, adding nodes, adding disks, patching, troubleshooting issues, Multi Subnet Failover Cluster
Quorums and Different Types of Quorums
Always on AG & Read intent replicas configurations and various types of AG options like Auto Seeding, full database and log backups on AG, join only option
Distributed AG & Contained AG configuration
Replication, Snapshot, Transactional, Merge & P2P replications & Their Implementation
Understanding of SQL Server, Log & Query Architecture
Indexes and Non Clustered Indexes and their implementation

ACID properties of SQL Server
Isolation, types & usage for minimize blockings
Lock, Block and Dead Blocks ,identify and resolve
Upgradation, Migration in SQL Servers
Roll Back Plan for Upgradation & Migration
Adequate Knowledge on ITIL & Usage of ITIL in daily activities
Handling issues like Page drop, negative TLog, log file full, TempDB full issues
Hands on in identifying and resolving High CPU, Memory, I/O utilization issues

Microsoft Azure

Creating Azure Virtual Machines and installing SQL Server in them
Azure VMs Always-On AG with listeners and load balancers
Creating Azure SQL Databases and exporting BACPAC from On-Prem to Azure for migration
Experience in DMA, Azure Data Studio & Cloud Migration
Understanding of Regions, Availability Zones & Availability Sets
Experience in Creating Multi Sub Net failover cluster
Experience in Distributed AG, Contained AG, Replication in Azure VM’s

Residence

Khammam, Hyderabad

Skill Exposure

SQL Server DBA + Azure
Installation, monitoring, upgrading, patching, slipstreaming & troubleshooting both in graphical and command modes.
Understanding of editions & licensing terms (Server-CAL, Core-Based & Volume Licenses)
Creating and managing security at Instance, database, schema level.
Creation of logins, users, roles and managing orphan users.
Hands on experience in assigning roles and permissions to logins.
Configured linked servers between same/different SQL versions.
Backups, backup encryptions, restoration and recovery models.
Designing backup strategies and fine-tuning backups.
Resolved corruption of system/user databases, suspect DB issues.
Setting up contained databases and utilizing them for migrations.
Configured alerts, database mail, jobs and maintenance plans.
Log shipping and Mirroring configuration, errors in log shipping like 14420,14421, scenarios of Mirroring Like Switch Over.
Configuring Active Directory and adding VM’s to Domain.
Configured Failover Clustering, adding node, adding disks, patching, troubleshoot issues, multi-sub net failover cluster.
Hands on experience in Quorum and different types of Quorums.
Understanding on Storage area networks, Data Banks.
Hands on experience in Distributed AG, Contained AG.
Configured Always on AG and read intend replicas.
Hands on experience in performing various types of AG options like Auto Seeding, full database and log backups on AG, join only option.
Implemented replication snapshot, transactional, merge & P2P.
Understanding of SQL server, log and query architecture.
Blockings and Deadlocks using Extended Events and giving recommendations on Isolation Levels, Indexes to minimize blockings.
Having good experience in clustered and non-clustered indexes.
Identifying and resolving high CPU, Memory, I/O utilization issues.
Knowledge of ITIL foundation and implementing in daily activities.
Working as part of a team to provide 24x7 support.
Hands on experience in Upgradation and Migration in SQL servers.
Good at Roll back plan for upgradation and Migration.
Working knowledge of ITIL foundation and implementing in daily activities.
Microsoft Azure
Creating Azure Virtual Machines and installing SQL Server in them.
Azure VMs Always-On AG with listeners and load balancers.
Creating Azure SQL Databases and exporting BACPAC from On-Prem to Azure for migration.
Hands on Experience in DMA, Azure Data Studio and Cloud Migration.
Understanding of Regions, Availability Zones and Availability Sets.
Hands on Experience in Creating Multi Sub Net failover cluster.
Experience in Distributed AG, Contained AG, Replication in Azure VM’s

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
Handling Outage Notifications, production maintenance/production down issues
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
Recovering the databases from backup in disaster situations
Performing SQL server daily health check and preparing a report based on it
Monitoring Disk Space of servers and freeing up space i.e., Older Backups, Unused Files
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 Server Agent Error Logs.

Personal Information

Marital Status: Married

Timeline