Ronak V. Email & Phone Number

Ahmedabad, Gujarat, India

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.

Ahmedabad, Gujarat, India

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.

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.

Ahmedabad, Gujarat, India

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.

Ahmedabad, Gujarat, India

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.

Jamnagar, Gujarat, India

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.

Master Of Science (M.Sc.), Computer Science

Bachelor Of Computer Application, Computer Science