Responsibilities:
Development Support:
- Support and guide developers on database related development and design best practices
- Monitor database health and performance metrics
- Support live situations and respond to alerts (errors, locks, deadlocks, availability etc.)
- Perform maintenance tasks including backup and restore, engine upgrades, data migrations and parameter changes
- Create database functions and triggers
- Maintain and improve Data Integrity
- 3+ years administering production PostgreSQL databases
- Proficient in reading and writing SQL queries including window functions
- Proficient in DB programming - creating triggers, functions etc.
- Proficient in Data Modelling - designing tables and relations
- Proficient in performance tuning
- Capable of giving support in a live situation
- 1+ years of High-Level Programming experience
- 1+ years of managing cloud databases (AWS, GCP)
- Experience with the following tools:
- Git (version control)
- Experience with other RDBMS systems
- Experience with NoSQL and other database types such as timeseries and graph
Generating Apply Link...