Postgresql Database Administrator
Posted Updated 1
view
Summary
A PostgreSQL database administrator at Deloitte's US-India offices, responsible for managing PostgreSQL databases day to day — backups, recovery, performance tuning, high availability via clustering and replication, and monitoring/troubleshooting with tools like pg_stat. Core stack: PostgreSQL, Linux, and basic Bash scripting.
Roles and Responsibilities
- Manage PostgreSQL databases, including backup, recovery, and performance tuning.
- Ensure high availability of databases through clustering and replication setup.
- Monitor database activity using tools like pg_stat and troubleshoot issues promptly.
Desired Candidate Profile
- Strong understanding of PostgreSQL fundamentals, including data types, functions, procedures, triggers, and SQL syntax.
- 2-7 years of experience in PostgreSQL administration or related field (B.Tech / B.E. degree).
- Experience with Linux operating system administration (Ubuntu/Centos) and basic knowledge of scripting languages (e.g., Bash).