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
Presentations
Code reviews
Problem-solving mindset
Goal-oriented mindset
Process Automation
Performance Optimization
Disaster Recovery
Database Administration
Database Configuration
Database Monitoring
Database Troubleshooting
Query Optimization
Teamwork and Collaboration
Reporting and business analysis
Assessment and reporting
Flexible and Adaptable
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