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.