Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Interests
Work Availability
Timeline
Generic
Ronak Vyas

Ronak Vyas

Database Administrator and Optimizer
Ahmedabad

Summary

With a proven track record at mentioned companies, I excel in database management and optimization, enhancing system efficiency by up to 30%. My expertise in configuration management, coupled with a problem-solving mindset, has driven significant performance improvements. I lead teams to innovate and automate, ensuring robust database systems and client satisfaction.

Overview

13
13
years of professional experience
5
5
years of post-secondary education
5
5
Certificates
3
3
Languages

Work History

Sr. Software Engineer

Global Logic
02.2024 - Current
  • Technologies : AWS, T-SQL, MS SQL Server, SSIS, PGSQL, MySQL, SolarWinds DPA, Datadog, Cassandra, MongoDB, MSOffice, PowerShell, CMDLine.
  • Database Administration activities like maintenance, migration, upgrade, replication, log shipping, always on, service broker, DR drills, policy designs, indexing strategies etc.
  • Doing automation by coding, scripting and tools to reduce manual work hours.
  • Analyze database performance metrics and identify areas for improvement for enhanced performance.
  • Monitor database systems and proactively address performance bottlenecks.
  • Collaborate with Development, DBAs and system administrators to fine-tune database configurations.
  • Prepare standard SQL code check list to be used by developers while writing stored procedures.

Sr. Software Engineer

HHAeXchange (Homecare Software Solutions)
09.2022 - 02.2024
  • Optimized database performance, resulting in 7% faster query response times and 10% reduction in system resource utilization.
  • Technologies : Tableau, T-SQL, SQL Server, SSIS, PGSQL, MySQL, Solarwind DPA, DataDog, Cassandra, MongoDB, MSOffice, PowerShell, CMDLine.
  • Database Administration activities like maintenance, migration, upgrade, replication, log shipping, always on, service broker, DR drills, policy designs, indexing strategies etc.
  • Doing automation by coding, scripting and tools to reduce manual work hours and resources.
  • Analyze database performance metrics and identify areas for improvement for enhanced performance.
  • Monitor database systems and proactively address performance bottlenecks.
  • Collaborate with Development, DBAs and system administrators to fine-tune database configurations.

Database Admin Specialist

Accenture Pvt. Ltd.
01.2020 - 09.2022
  • Technologies : Oracle, PowerBI, T-SQL, AzureSQL, SQL Server, SSIS, MSOffice.
  • Database Administration activities like maintenance, migration, upgrade, replication, log shipping, always on, service broker, DR drills, policy designs, indexing strategies etc.
  • Configured a thorough backup and recovery strategy for all major production systems in order to comply with RPO/RTO and audit needs.
  • Improved customer satisfaction rates through proactive problem-solving and efficient complaint resolution.
  • Followed all company policies and procedures to deliver quality work.
  • Doing automation by coding, scripting and tools to reduce manual work hours and resources.
  • Analyze database performance metrics and identify areas for improvement for enhanced performance.
  • Collaborated with cross-functional teams to achieve project goals on time and within budget.
  • Developed strong client relationships through consistent communication and attentive service.

Database Administrator

Excellence Infocom (HHAeXchange)
08.2013 - 01.2020
  • Technologies : T-SQL, MS SQL Server, SSIS, MSOffice, PowerShell, CMDLine.
  • Managed and created SQL Server transaction replication sized 16+ TB to cater need of heavy reporting system especially to be used in the beginning of the month.
  • Optimized database performance, resulting in 30% faster query response times and 25% reduction in system resource utilization.
  • Configured a thorough backup and recovery strategy for all major production systems in order to comply with RPO/RTO and audit needs (such as HiTrust, HIPAA).
  • Handled database growth over the period from 50GB to 200+ TB.
  • Implemented many automation process which reduced 40% of database performance related tickets.
  • Contributed from best DBA team for Company to be in the Fortune 5000 list for over 8 years continuously.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
  • Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.

Database Administrator

EProcurement Technologies Pvt. Ltd.
05.2012 - 08.2013
  • Technologies : MS SQL Server, MySQL, T-SQL.
  • Built databases and table structures for web applications.
  • Worked with development and client teams to prepare database backup strategy.
  • Database administration activities like script execution, logins permission management, backup, recovery processes, long running queries check and log collections.
  • Creating documentations for each process for the department.

Database Administrator

Essar Oil Ltd.
01.2012 - 03.2012
  • Technologies : MS SQL Server, ORACLE, T-SQL.
  • Worked with development and client team to design and implement database backup recovery processes.
  • Created stored procedures as per application requirement.
  • Identified slow queries of databases and shared with optimization teams.
  • Performed DR drills to check RPO / RTO policies.

Education

Master of Science - Computer Science

Saurashtra University
Rajkot, India
04.2010 - 03.2012

Bachelor of Science - Computer Science

Saurashtra University
Rajkot, India
04.2007 - 03.2010

Skills

Team Leadership and Mentoring

Certification

Advanced PostgreSQL (LinkedIn)

Accomplishments

  • Throughout my career, my passion for technology and good causes has been intertwined with a deep commitment to the healthcare and pharmaceutical sectors. I take great pride in leveraging my technical expertise to positively impact and enhance the lives of individuals within these critical industries.
  • Optimized database performance, resulting in faster query response times and reduced resource utilization.
  • Managed 16+ TB SQL Server transaction replication for improved reporting efficiency.
  • Established a comprehensive backup strategy for compliance and data protection.
  • Successfully handled database growth from 50GB to 200+ TB.
  • Implemented automation processes, reducing performance-related tickets by 40%.
  • Contributed to company's Fortune 5000 list presence for 8+ years.
  • Proactively resolved critical production issues, minimizing downtime and revenue loss.
  • Implemented monitoring solutions for early issue detection and prevention.

Interests

Swimming, Hiking, Learning

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Advanced PostgreSQL (LinkedIn)

03-2024

Sr. Software Engineer

Global Logic
02.2024 - Current

Microsoft Azure Database Administrator Associate

03-2023

Sr. Software Engineer

HHAeXchange (Homecare Software Solutions)
09.2022 - 02.2024

Database Admin Specialist

Accenture Pvt. Ltd.
01.2020 - 09.2022

Microsoft Certified Professional

12-2015

Database Administrator

Excellence Infocom (HHAeXchange)
08.2013 - 01.2020

Database Administrator

EProcurement Technologies Pvt. Ltd.
05.2012 - 08.2013

Database Administrator

Essar Oil Ltd.
01.2012 - 03.2012

Oracle-10g Certified Professional

11-2011

Oracle PL/SQL Developer Certified Associate

11-2011

Master of Science - Computer Science

Saurashtra University
04.2010 - 03.2012

Bachelor of Science - Computer Science

Saurashtra University
04.2007 - 03.2010
Ronak VyasDatabase Administrator and Optimizer