Experience with both relational and non-relational databases in terms of both an architectural point of view as well as with development.
Manage and operate medium and large-sized production database systems across multiple data centers – including MySQL Server on Linux and PostgreSQL.
Should have good hands-on experience with Postgres as well as MySQL.
Should have good knowledge in query optimization.
Should also be aware and hands-on in terms of various maintenance work for the same including managing logs, backups, restores, and cleanups of the DB during its Ops time.
Create & maintain Database access systems including Tables, indexes, Views, Stored Procedures, Triggers & Managing Data, etc.
Install, configure, and deploy MySQL Servers.
Perform capacity planning, performance tuning, monitoring, troubleshooting, and optimization of the databases.
Familiarity with Postgres – pgbadger ,pg_cron, and foreign data wrapper.
Must be familiar with Linux operating system.
Experience in creating shell scripts (Linux, Python).
Should be able to debug application code written in PL SQL and PG SQL for different applications.
Experience in AWS aurora clusters and oracle database is an added advantage.