MySQL Database Architect

Home > MySQL Database Architect
Department:
Engineering
Project Location(s):
Ahmedabad, India
Job Type:
Full time, Employee

JOB DESCRIPTION:

We are urgently seeking a talented Senior MySQL Database Architect to help in designing and developing database schemas, performing database performance profiling, and provide implementation guidance to developers in a multi-platform environment leveraging both RDMS & NoSQL solutions such as MySQL and MongoDB.  As part of our engineering team, you will be given the autonomy to lead critical features for our SaaS offering.

RESPONSIBILITIES INCLUDE:

  • Be responsible for providing operational and development support services for the MySQL and MongoDB SaaS environments
  • Design and implement effective database solutions and models to store and retrieve company & customer data
  • Examine and identify database structural necessities by evaluating client operations, applications, and programming
  • Assess database implementation procedures to ensure they comply with internal and external regulations
  • Install and organize information systems to guarantee company functionality
  • Prepare accurate database design and architecture reports for management and executive teams
  • Oversee the migration of data from legacy systems to new solutions
  • Monitor the system performance by performing regular tests, troubleshooting and integrating new features
  • Recommend solutions to improve new and existing database systems
  • Educate staff members through training and individual support
  • Offer support by responding to system problems in a timely manner

REQUIREMENTS:

  • 5+ years of experience as a production environment Database Developer or Database Architect
  • Experience with MySQL NoSQL, Amazon RDS or similar cloud offerings, MongoDB & MongoDB Atlasor in a SaaS environment
  • In depth knowledge of MySQL Server databases, including experience working with transactional replication, performance tuning and optimization
  • Experience with database backup and restore, disaster recovery and security
  • Advanced knowledge of the MySQL and MongoDB engines for performance tuning and optimization
  • The Ability to optimize complex queries to achieve sub-millisecond performance gains through query benchmarking
  • Expert knowledge of database design concepts, stored procedures, triggers, and views
  • Experience with monitoring tools and troubleshooting database performance issues
  • Installed and configured new server instances and upgrade existing ones in a cloud environment
  • Tested backups to ensure the business’ Recovery Time Objectives are met
  • Managed DDL scripts for multiple environments DEV/UAT/PROD
  • Managed schema update, rollback and other operational activities with minimal to no downtime.
  • General ability to support and optimize advanced and complex queries
  • Experience with Flyway or similar database migration tooling

By using this site, you agree with our use of cookies. Privacy Policy