Mani Subash B Email: bmsubhash1992@gmail.

com
(Sr Database Administrator) Ph. No.: +91-9502829994

-------------------------------------------------------------------------------------------------------------------------------------
Professional Summary:
❖ Having 5.3 Years of experience in IT industry having strong skills in SQL Server Database
Administration Production support.
❖ Installing, Configuring and administrating the SQL Server 2008R2,2012,2014 and 2016 on cluster
and standalone machines.
❖ Applying SQL Server patches and hot fixes.
❖ Expertise in creating/renew the TDE certificates.
❖ Actively involved in SQL edition upgrade from Standard edition to Enterprise edition.
❖ Experience in upgrade and migration of several servers, and Databases from SQL Server 2008R2 to
SQL Server 2012/2014/2016.
❖ Monitoring the size of databases and checking the disk space.
❖ Actively involved in SQL Server In-place, and Side-by-Side upgrade from 2014 to 2016.
❖ Configuring and Implementing Jobs, Alerts and DB Mail.
❖ Manage and Maintain database changes in Development, QA and Production.
❖ Expertise in Database backup, Recovery, Restoration and Disaster Recovery Plans.
❖ Daily checking SQL server logs for errors on Production Server.
❖ Restoring the Databases from Production to stage environment and vice versa.
❖ Maintained Database Authentication modes, Creation of user, logins, configuring permissions and
assigning roles to users.
❖ Highly experienced in configuration, Implementation and Maintenance of Log shipping.
❖ Reorganize/rebuilding indexes and update stats to improve query performance.
❖ Configuring and maintaining and troubleshooting the Database mirroring and experience in
Mirroring DR activities.
❖ Configuring, monitoring and troubleshooting the REPLICATION.
❖ Good Hands-on Experience on Always-On availability feature.
❖ Expertise and Good Hands-on Experience on Windows Clustering and SQL Clustering feature.
❖ Experience in troubleshooting long running queries and resolving locking and blocking issues.
❖ Experience in SQL Azure cloud creating SQL instance, databases and security provisioning on
different service tiers.
❖ Migrating On-premises database to Azure instances using backpack files and managing space
usages by monitoring dashboard.
❖ Experience in Configuration of Reporting services, deploying rdl files and SSIS packages in jobs for
reporting purpose.
❖ Providing data for a weekly and monthly report to senior management.

EDUCATION QUALIFICATION

❖ M. Sc (Physics) from Andhra University - Visakhapatnam in 2016

TECHNICAL SKILLS

❖ Databases & Cloud : SQL Server 2012/2014/2016/2017 and 2019, Azure SQL and AWS
❖ Operating Systems : Windows Server 2008R2/2012/2012R2/2016 & Windows 10
❖ Ticketing Tools : Service Now

1
 WORK EXPERIENCE

❖ Working as Senior Database Administrator at Wavetronic Solutions Pvt Ltd from April 2024 to
present.
❖ Worked as Sr Database Administrator at Wipro- Hyderabad from Jan 2022 to March 2024.
❖ Worked as a Jr Database Associate at Sisense Info Technology from Feb 2020 to Jan 2022.

PROJECTS

# Project 1: Corteva
Client: Corteva
Role: Database Admin (L1& L2)
Env: SQL Server 2012\2014\2016\2017 & Windows Server 2012\R2 & 2016

# Project 2: Digital Realty Trust Center (DLR)

# Project 3: Shoppers Stop (SSL)

Responsibilities:

❖ Daily checking the tickets in ServiceNow and assign the tickets and resolve the tickets depends on the
priority levels and approvals.
❖ Daily checking the issues like backup failures from the report, failed logins and resolve the issues.
❖ Deploying the scripts as per the approvals and schedules. Script executions after taking the full backup
❖ Checking the data growth of the databases and sending the report to the management.
❖ Installing and configuring the new SQL servers as per the standards.
❖ Provide dedicated support to all Production, QA & Development MS SQL Server Environments
❖ Fulfill the RITM’s and process the Change Tasks, validating the servers pre and post patches.
❖ Providing the results as per the user requests. Granting permissions to the users.
❖ Running the extended events based on requirement for troubleshooting.
❖ Database refreshes from Prod to QA\Dev and vice-versa.
❖ Checking the PowerShell scripting and troubleshooting.
❖ Taking snapshots and restore the databases on demand based on request.
❖ Maintaining the servers and databases inventory. Involving annual maintenance activities. Actively
participating in Team connect calls and sharing ideas.
❖ Provide dedicated support to all Production, QA & Development MS SQL Server Environments
❖ Creating databases on Azure instance and providing access to azure databases.
❖ Migrating On-Premises database to Azure instance and monitoring space usage through dashboard.