Database Engineer - MySQL/PostgreSQL

Role : Database Engineer (MySQL and PostgreSQL) Responsibilities : - Respond to issues within the Service Level Objective during your assigned on-call rotation. - Expertise in supporting at least one of the technologies like PostgreSQL and MySQL. - Expertise in caching technologies like Redis. - Expertise in writing software in python/ Shell/ Ansible (or) any other, to improve the reliability, scalability and performance of client's infrastructure. - Troubleshoot broken systems and services issues and build new systems. - Document the services we run and how to manage them. - Monitor, measure and improve the performance and state-awareness of our systems. - Locate and deprecate unused services. - Re-deploy, reschedule services that under-utilize their planned resources every quarter. - Complete, Update or Polish 4 Runbook/SOPs/Design Documents. Requirements : - Bachelor's / master's degree in computer science or information technology. - 10+ Years experience in database/ Streaming technologies. - Expert in database technology like PostgreSQL / MySQL. - Expert in database and SQL tuning and expert troubleshooter. - Strong Shell, Python and SQL scripting to automate DB related jobs. - Familiarity with observability tools such as Grafana, Prometheus, consul, Splunk. - Proven ability to work independently or as an integral member of a team and has excellent communication and documentation skills. - Familiarity with low level debugging tools: strace, tcpdump, gdb, lsof and netstat. - Write a simple piece of software in any language that does anything. Shift timings: 8 AM to 4 PM (IST) and during on call rotation timings will change.