Ronak Jani

• Designed and implemented high-availability architectures using MySQL, AWS RDS, and Aurora integrated with the organization’s proprietary automation tools and monitoring processes, ensuring consistent 99.99% uptime across mission-critical applications. • Optimized large-scale, compliance-driven databases containing millions of records by applying specialized expertise in the company’s Amazon Redshift data models and unique indexing/partitioning strategies, safeguarding both data integrity and system performance. • Developed and executed advanced disaster recovery and backup protocols tailored to the company’s internal security standards, ensuring continuity of operations and minimizing risks of data loss across global business units.

• Led proprietary database migration initiatives by spearheading the transition of legacy systems to the company’s customized AWS-based architecture, leveraging internal frameworks to enhance scalability, reduce operational costs, and align with corporate IT strategy. • Managed large-scale databases with millions of records, optimizing performance and maintaining data integrity with Amazon Redshift. • Oversaw SOX-compliant database environments, applying in-depth knowledge of the company’s proprietary access controls, auditing mechanisms, and governance frameworks to meet both regulatory and internal compliance requirements. • Automated maintenance, patching, and performance monitoring via internal scripting frameworks, cutting manual DBA workload by 50% and minimizing downtime.

• Provision MySQL instances, both in clustered and non-clustered configurations • Ensure optimal performance, security, and high availability of large, Terabyte-sized databases with Amazon Redshift. • Manage critical production environment replication systems • Identify and resolve critical production issues with active/active multi-region OLTP environment • Ensure 99.999% uptime of database technologies, including identifying areas for improvement to meet the SLA

• Implemented data replication and clustering strategies for improved data availability and redundancy. • Developed monitoring and alerting systems to proactively address potential database issues. • Conducted regular security audits and applied necessary patches and updates to maintain compliance.

• Architect, Administered and managed the entire development, QA and production environment • Developed standard operating procedures, monitored and maintained database security and database software • Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials

• Architect, Installed and maintained MySQL and ORACLE Server Reporting Services, Integration Services, Replication, DB Security compliance and Analysis Services • Gathered information, developed database design, created prototypes, and discussed outcomes with business analyst groups, stakeholders and developers • Managed projects from business requirements analysis to solutions delivery and support • Interacted with developers and analysts to ensure standards were maintained

• Served as Lead Database (MySQL) Architect / project lead in the completion of 10+ medium to large-scale implementations of ERP System developed in PHP and hosted at Amazon Cloud • Implemented complete AWS cloud setup for database and application server • Implemented database architecture for cost effective and time saving cash collection systems • Conducted SQL performance tuning for developers