Brijesh Savaliya, Software Developer in Los Angeles, CA, United States
Brijesh Savaliya

Software Developer in Los Angeles, CA, United States

Member since August 21, 2020
Brijesh is a MySQL DBA with over 14+ years of experience. He specializes in all aspects of MySQL database from installation, configuration, optimization, query fine-tuning, index optimization, resource allocation, backups, and disaster recovery scenarios. Brijesh has worked with multiple teams on helping scale up databases (horizontally or vertically). He has worked with standard replication and cluster replication technologies and has extensive experience with the Percona toolkit.
Brijesh is now available for hire

Portfolio

  • Mode Media
    PHP, Elasticsearch, Java, MySQL
  • Instantly
    Amazon Web Services (AWS), SQL Server Analysis Services (SSAS)...
  • Sony
    Oracle, Java, Bash Script, MySQL

Experience

Location

Los Angeles, CA, United States

Availability

Part-time

Preferred Environment

MySQL, Bash Script, SQL Server DBA, AWS ELB, AWS EC2, Percona, Linux CentOS 7

The most amazing...

...thing I've completed was the successful migration of 1,500+ MySQL database servers from the data center to AWS RDS.

Employment

  • Lead Database Administrator

    2015 - 2016
    Mode Media
    • Led a team of engineers in building development and deployment tools with CI/CD.
    • Architected and designed back-end services for Mode Media's consumer product group.
    • Implemented and architected the Elasticsearch cluster to handle millions of search queries.
    Technologies: PHP, Elasticsearch, Java, MySQL
  • Lead Database Administrator

    2013 - 2015
    Instantly
    • Led the migration of the MySQL/Mongo database environment from AWS to a data center.
    • Provided ongoing maintenance and support for MySQL/Mongo database infrastructure for more than 50 servers.
    • Set up high-availability, backups, and disaster recovery solutions for all databases.
    • Collaborated with developers in identifying slow performing queries and doing index optimizations and query fine-tuning.
    Technologies: Amazon Web Services (AWS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL, MongoDB, Percona, Bash Script, AWS, MySQL
  • MySQL DBA

    2012 - 2013
    Sony
    • Performed database installation, configuration, upgrades, and optimizations.
    • Wrote custom scripts to perform optimization for various jobs and scheduled tasks.
    • Created database governance package for the release of database changes.
    • Contributed to the redesign of the database design and architecture.
    Technologies: Oracle, Java, Bash Script, MySQL

Experience

  • Migration from Datacenter to AWS

    The project was to migrate the entire database server stack from the existing data center to AWS. We migrated around 200 database servers from standard replication to cluster replication running on Amazon EC2 instances. We implemented a high availability solution so that when we lost ec2 instances there was no downtime.

  • Custom database monitoring

    Led the migration of database monitoring solution from Nagios to custom monitoring writing in Go. The solution was based on Prometheus metrics. We implemented it using the tech stack provided by the company.

  • Query Optimization and Index Fine Tuning

    For an application that was having database performance issues, I optimized queries and did index tuning reducing the database load by 90%. The query response time went from 10 seconds to 10 ms. I also implemented read-write query splitting to utilize the replica server.

Skills

  • Storage

    MySQL, Databases, SQL Server DBA, Elasticsearch, MongoDB, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MySQL Clustering
  • Platforms

    Percona, AWS EC2, Linux CentOS 7, PagerDuty, Amazon Web Services (AWS)
  • Languages

    Bash Script, Java, PHP, SQL, Go
  • Tools

    AWS ELB, Terraform, Chef, Nagios
  • Other

    Software Development, AWS, Prometheus

Education

  • Master's degree in Computer Science
    2004 - 2006
    University of Southern California - Los Angeles, California

To view more profiles

Join Toptal
Share it with others