Shivkumar Chavan

Education And Training 05/2022 Master of Business Administration: BHARATI VIDYAPEETH UNIVERSITY • • CGPA: 9.58 CGPA Class: Outstanding 05/2020 Master Pharmacy MIT WORLD PEACE UNIVERSITY • • CGPA: 8.38 CGPA Class: Distinction Shivkumar Uttam Chavan--,- Tal: Karad, District: Satara, Maharashtra 415124 Summary • • 05/2018 B. Pharmacy: Satara College of Pharmacy, SHIVAJI UNIVERSITY • • Percent: 63.55% Class: First Class TECHNICAL SKILLS • • • • • • • • • • • • • • Databases Managed: MS SQL Server. SQL Versions: MS SQL Server 2019, 2017, 2016, 2014 SQL Server Tools: SSMS, SQL Server Profiler, DTA, Reporting Services Configuration Manager Programming Languages: T-SQL Basic Knowledge of Azure Cloud Performance Optimization Root Cause Analysis Technical Support Security Management SSIS & SSRS MARIA DB Backup and Recovery Strategies Migration & Patching activities 24 x 7 Support Well organized and motivated employee eager to apply time management and organizational skills in various environments. Experienced MS SQL DBA with a strong understanding of organizational practices and regulations. Skilled in managing domestic and international servers & requirements while ensuring database integrity, security, and performance. Adept at troubleshooting, optimizing queries, and implementing best practices for database administration. Systematic and analytical with proven problemsolving skills to maintain high availability and efficiency in database environments. Experience FORTREA formerly known as LabCorp Drug Development. Position - Regulatory Operations Assistant II Pune, India From March/2022 – March/2025 • 1. 2. 3. 4. • • • • • • • • Handled multiple servers major are as mentioned below: LATAM, EMEA, NA, APAC Base Business server management. VOGUE FML server (Creation & Drafting Formulas submissions server) RMQ Submission server (Raw Material Qualification Submissions Server) ERMQ FnW Medical device server: (Fibers and Non-Woven materials Engineered Raw Material Submissions Server) Managed day-to-day operations of MS SQL Server databases, including installation, configuration, and maintenance tasks. Performed backup and recovery operations multiple times. Maintaining the Security of the Database, assigning responsibilities as part of Security Scheduled and maintain routine Jobs, Alerts and Maintenance Plans. Regular monitor of servers, which includes Backup Job Monitoring and troubleshooting all the issues on regular basis. Executed numerous installations of SQL Server across multiple versions including 2016, 2017, and 2019 Monitoring/Maintaining DR/HA options being used in servers Log Shipping, Replication, Mirroring and Always-ON. Performed data file movement and data refreshment activity multiple times. • Skills • • • • • • • • Excellent communication skills. Monitoring and troubleshooting using SQL Server Management Studio (SSMS) Versatility. Maintain & manage proper updated tracker/logs. Automation in Excel. Provide support & training to new joiners (freshers). Technical Documentation • • • • Accomplishments Languages • PROCESS EXCELLENCE for (2022): This award was to recognize my support on LATAM server management project. Highly appreciated the way I understood the process quickly and built bond with client to ensure issues are timely solved. Hindi: B1 • CLIENT APPRECIATION: LATAM specification server management for (2023): Intermediate (B1) Shivkumar, thank you very much for all your collaboration throughout the year and Hindi: for your tremendous patience with allB1 the back and forth! We really appreciate your sense of urgency and support in Tru server activities (which I know can be quite Intermediate (B1) stressful). • CLIENT APPRECIATION: EMEA specification server management for (2024): Shivkumar, this is to acknowledge quick support and beautiful work done on updating servers & getting them resolved by you to meet stringent timeline. Keep up the good work!! Greatly appreciated!! • CLIENT APPRECIATION: LATAM NPI/NPD specification server management for (2024): you were extremely important to our deliverables, drafting specification on time and highlighting whenever something wrong was observed, critical thinking while creating specifications is key to make sure we will not have any block in the RM receipt. In 2024 we had the biggest project in term of extension/qualifications of RM for LATAM in the last years, total of 24 servers in just one project and you were key to set the first installation and do the further updates & migrations commercialization. Great contributions to business! Thank you for the great partnership and for always be available. • CLIENT APPRECIATION: EMEA(EU) NPD EVSA specification server management for (2024): you've consistently been a great help by highlighting key actions, providing daily updates, and joining our weekly meetings. With your assistance, we successfully worked on over 30 servers in just a few months! What I value most is your Daring Spirit and your unwavering availability to support the business, especially when urgent issues arise. Your ability to quickly adapt to shifting priorities has been invaluable. I'm excited that we'll continue working together more frequently as you’ve recently started supporting EMEA server activities. I'm truly grateful for your help—thank you, Shivkumar!" Marathi: First Language English: B2 Upper Intermediate (B2) Hindi: B2 Upper Intermediate (B2) Links • • https://www.linkedin.com/in/sh ivkumar-chavan66b140173?utm_source=share& utm_campaign=share_via&utm _content=profile&utm_medium =android_app MBA Research Article http://irjhis.com/paper/IRJHISI C-.pdf Declaration I hereby, declare that all the above-mentioned information is true to the best of my knowledge. Monitored system resources, including memory usage, CPU utilization, and disk space, and took corrective action when needed to maintain optimal performance levels. Implemented performance tuning strategies to optimize database efficiency, resulting in improved query response times and system reliability. Hands-on experience in performance tuning activities, including resolving issues such as blocking, missing indexes, fragmentation, and statistics to enhance database efficiency. Performing Database Refresh activity and data file movement whenever required. Trouble shooting database and Space management issues to maintain the SQL Server to provide maximum availability and high performance. Hands-on experience in resolving blocking, handling isolation levels and performance issues like CPU, I/O, Memory bottlenecks.