MYSQL DBA (Work from Office)

TechMojo Solutions Private Limited; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

TechMojo Solutions Private Limited in Hyderabad is seeking a MySQL DBA to ensure performance, availability, and security of MySQL clusters. You will design databases, architecture, upgrades, backups, and provisioning, and collaborate with cross-functional teams for documentation and specifications.

The role requires 3+ years of experience with MySQL, including InnoDB/MyISAM, replication, SQL optimization, and resource planning; work involves producing clear documentation and handling upgrades,

Qualifications

• Experience : 3+ yrs
• Design of database, architecture, upgrades, backups, and provisioning of database instances
• Prepare documentations and specifications
• Handle upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary

Responsibilities

• Database design and data architecture
• Provision MySQL instances, both in clustered and non-clustered configurations
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary

Skills

Database design

MySQL management

SQL optimization

Replication config

InnoDB

MyISAM

Event scheduler

NoSQL familiarity

Performance tuning

Documentation

Job description

MYSQL DBA/Postgressql DBA

Job Description

Experience : 3+ yrs

We are looking for a MySQL DBA who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for design of database, database architecture, orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations and specifications as required.

Responsibilities

• Database design and data architecture
• Provision MySQL instances, both in clustered and non-clustered configurations
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary

Skills and Qualifications

• Proven expertise in database design and data architecture for large scale systems
• Strong proficiency in MySQL database management
• Decent experience with recent versions of MySQL
• Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM
• Experience with replication configuration in MySQL
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler
• Ability to plan resource requirements from high level specifications
• Familiarity with other SQL/NoSQL databases such as Cassandra, MongoDB, etc.
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

The position is based in Hyderabad and requires working from the office