Swimming, Hiking, Learning
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
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