Senior Databse Engineer - DBA

• Responsibilities
• -Provision MySQL instances, both in clustered and non-clustered configurations
• -Ensure performance, security, and availability of databases
• -Perform database administration tasks, including automation, performance monitoring and tuning, and query optimization.
• -Prepare documentations and specifications
• -Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• -Profile server resource usage, optimize and tweak as necessary -Collaborate with other team members and stakeholders
• Acts as a Team Lead.

- 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(Master-slave, Master-Master)
- Create and Manage MySQL users with proper permissions.
- Proficient in writing and optimizing SQL statements.
- Automate day to day regular tasks.
- Strong knowledge in MySQL Binlog and point in time recovery.
- Decent experience in Linux Administration.
- Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

Good to have:

- Knowledge on NoSQL
- Knowledge on Cassandra, MongoDB and ElasticSearch
- Knowledge on public cloud platform like AWS/Azure/GCP).
- Python/Shell scripting.
- Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc.
- Proficient understanding of code versioning tools such as Git / Mercurial / SVN