JD for Postgres Database Administrator.
| Role name: |
Database Administrator |
| Role Description: |
Responsible for building, maintaining, configuring, and repairing PostgreSQL databases. |
| Competencies: |
PostgreSQL, IT IS_AMS_Database_MS SQL Server |
| Experience (Years): |
6-8 |
| Essential Skills: |
Postgres Database Administrator |
| Roles and Responsibilities |
-
Database Installation & Configuration:
Install, configure, and maintain PostgreSQL database instances on Linux/Unix and cloud-based environments. Manage database environments, including clustering, replication, and partitioning.
-
Database Maintenance & Monitoring:
Perform regular database health checks and optimization tasks to ensure high availability and performance. Monitor and troubleshoot database issues (e.g., performance bottlenecks, locks, connection issues, slow queries). Implement and manage database monitoring tools such as pg_stat_statements, Prometheus, or other PostgreSQL-native solutions.
-
Backup & Recovery:
Design, implement, and maintain backup and disaster recovery strategies for PostgreSQL databases. Regularly test recovery processes and ensure data protection. Perform PITR (Point-In-Time Recovery) and manage WAL (Write-Ahead Log) archiving and restoration.
-
Performance Tuning & Optimization:
Optimize query performance using EXPLAIN ANALYZE, indexing, and query rewriting techniques. Tune PostgreSQL configurations (shared_buffers, work_mem, etc.) for optimal performance. Perform regular vacuuming and indexing to prevent database bloat and ensure efficient data storage.
|
