VIVEKSAIKUMAR T
MSSQL DBA
Mumbai
Summary
Dynamic database management professional with extensive experience in optimizing and securing database systems. Expertise in data security, performance tuning, and disaster recovery ensures robust and reliable operations. A collaborative team player committed to achieving results while adapting to evolving business needs. Proficient in SQL, database design, and automation, consistently employing a reliable and flexible approach to overcoming challenges.
Overview
5
5
years of professional experience
3
3
Languages
Work History
MSSQL DBA
ALCHEMY TECHSOL INDIA PVT LTD (KYNDRYL GROUP)
09.2024 - Current
- Act as on-site DBA SPOC for Suryoday Small Finance Bank, managing communication and coordination between on-site and off-site DBA teams.
- Client: Suryoday Small Finance Bank. Environment: SQL Server 2012, 2014, 2016, 2017, 2019 & 2022. Windows OS: Windows 2008, 2012,2016.
- Configure and administer SQL Failover setups across DC and DR environments to ensure high availability.
- Implement and maintain Distributed Always on Availability Groups.
- Configuration and monitor log shipping between DC and DR servers to ensure data synchronization.
- Perform SQL server Installation, Patching and Upgrades across standalone and clustered environments.
- Execute and monitor database backup, restore and recovery operations to ensure RPO/RTO compliance.
- Perform performance tuning tasks including index Maintenance, statics updates and troubleshooting blocking/deadlocks.
- Managing security and compliance by creating logins, roles, permission and implementing auditing policies.
- Monitor and resolve database health, job failure and resource usage issues proactively using SQL server native tools and CMS.
- Carried out regular DR drills to ensure SQL server clusters always on and Log shipping configuration were functioning as expected.
- Performing SQL Server & SSRS Installation, Configuration and Hardening.
Migration & Up gradation of SQL server. - Creation of SOP documents to ensure Best Security Practices, Policies and protocols.
- Maintenances activities such as Index Rebuild, Reorganize & Update Statistics.
Automatic failover testing for Always on Environment.
File movement and database backup restoration on windows Environment.. - Managed backups, restoration, and disaster recovery plans to prevent data loss.
- Compiled and maintained detailed documentation for database configurations and procedures.
- Managed database access controls and permissions to protect sensitive information and comply with data protection regulations.
- Established and maintained replication, clustering, and other high availability solutions to ensure continuous data accessibility.
- Monitored database systems to detect and resolve performance issues promptly.
- Performed backups and procedures for quick data recovery.
- Administered and monitored databases to identify and resolve problems with diverse servers.
- Configured, installed and recovered DBMS systems, performing backups and updates to safeguard data.
- Monitored database performance, conducted regular system audits, and executed performance tuning to enhance efficiency.
- Designed, implemented, and maintained database systems for optimal performance, reliability, and security.
- Reviewed and optimized SQL queries and stored procedures, significantly reducing execution times and resource consumption.
MSSQL DBA
CMS IT SERVICES PRIVATE LIMITED
07.2022 - 07.2024
- Collaborated with onsite team to provide 24/7 support for database operations.
- Resolved tickets based on priority, adhering to service level agreements.
- Managed installation and configuration of SQL Server versions 2012 through 2022 on remote systems.
- Monitored database space management, allocating necessary resources to ensure performance.
- Applied patches across QA, UAT, DEV, and production servers to maintain system integrity.
- Designed backup strategies and conducted regular DR drills to ensure data resilience.
- Configured high availability solutions such as Log Shipping and Always On Availability Groups.
- Troubleshot critical database issues, optimizing performance through tuning and index maintenance.
DC OPERATIONS
TRAEGEN SYSTEMS
05.2021 - 07.2022
- Monitor Alerts and DC operations
Education
MBA - HR
Vikram Simhapuri University
B.COM - Computer Applications
Vikrama Simhapuri University
INTERMEDIATE - M.P.C
Board of Intermediate Education
SSC -
Board of Secondary Education
Skills
High availability
Timeline
MSSQL DBA
ALCHEMY TECHSOL INDIA PVT LTD (KYNDRYL GROUP)
09.2024 - Current
MSSQL DBA
CMS IT SERVICES PRIVATE LIMITED
07.2022 - 07.2024
DC OPERATIONS
TRAEGEN SYSTEMS
05.2021 - 07.2022
B.COM - Computer Applications
Vikrama Simhapuri University
INTERMEDIATE - M.P.C
Board of Intermediate Education
SSC -
Board of Secondary Education
MBA - HR
Vikram Simhapuri University
Languages
English
Hindi
Telugu
Personal Information
Disclaimer
I hereby declare that the information and the facts furnished here are true to best of my knowledge and Belief.
Projects
- SBI GENERAL INSURANCE at CMS IT SERVICES PVT LTD
- SURYODAY SMALL FINANCE BANK at ALCHEMY TECHSOL INDIA PVT LTD (KYNDRYL GROUP)
Personal Information
Name : Viveksaikumar Tripuram
Father Name : Kasi Babu T
Phone No : +91 9493693864
Current Designation : MSSQL Database Administrator
Languages Known : English, Hindi & Telugu
Disclaimer
I hereby declare that the information and the facts furnished here are true to best of my knowledge and Belief.