PostgreSQL Database Administrator

**Job Title: PostgreSQL Database Administrator**

**Key Responsibilities**:
**Database Design & Management**:

- Design, implement, and manage PostgreSQL database systems.
- Perform regular maintenance of PostgreSQL databases, including updates, backups, and restores.
- Ensure database availability, reliability, and performance tuning.

**Optimization & Troubleshooting**:

- Monitor and optimize the performance of PostgreSQL databases.
- Write efficient SQL queries, create stored procedures, and optimize and diagnose slow-running queries for better performance.
- Troubleshoot and resolve database issues, performance bottlenecks, and outages.
- Ensure, high availability, high responsiveness of database, including fine tuning of queries, creating relevant indexes, defining partition strategies.

**Monitoring, Maintenance, and Capacity Planning**:

- Perform regular database maintenance tasks (index rebuilds, statistics updates, vacuuming, etc.)
- Forecast growth and plan for scaling, adjusting storage and compute resources accordingly.
- Implement and maintain data retention policies that comply with legal, regulatory, and business needs.
- Design purging and archiving processes for stale or obsolete data to optimize performance and reduce storage costs.
- Ensure policies are consistently enforced across environments (ex:/ production, UAT, dev)

**Backup & Disaster Recovery**:

- Implement and maintain regular backup and disaster recovery processes for databases.
- Perform database replication and clustering for high availability.
- Understanding Data Usage and Access Patterns
- Use this insight to guide decisions on indexing, partitioning, and caching strategies.
- Document data flows and relationships to ensure system-wide data awareness.
- Document tables, columns and entity relationships.

**Security & Compliance**:

- Enforce database security policies, including user access management and data encryption.
- Ensure compliance with relevant data protection regulations and standards.

**Collaboration & Development**:

- Assist in database migrations and upgrades to new versions of PostgreSQL.
- Participate in code reviews, system design discussions, and database architecture planning.

**Skills & Qualifications**:
**Experience**:

- Proven experience as a PostgreSQL Database Administrator.
- Strong knowledge of PostgreSQL database design, administration, and performance tuning.

**Technical Skills**:

- Proficiency with SQL and PL/pgSQL.
- Experience with PostgreSQL clustering, replication, and sharding.
- Familiarity with database backup tools (pg_dump, pg_basebackup) and high-availability techniques (replication, failover) tools like patroni, pgpool2 etc.
- Understanding of PostgreSQL performance tuning, indexing, and query optimization.

**Preferred Skills**:

- Should have experience in Azure-managed databases.
- Ability to manage databases (specifically Percona Postgres Distribution) in Kubernetes environments.
- Expertise in managing Postgres databases on cloud virtual machines (VMs).
- Proficiency in configuring distributed storage solutions like Citus.
- Experience in database partitioning to optimize large datasets.
- Should have experience in configuring tablespaces in PostgreSQL.

**Additional Skills**:

- Knowledge of containerization technologies and orchestrations such as Docker and Kubernetes for PostgreSQL deployment.
- Experience with cloud platforms (AWS, Azure, Google Cloud) and PostgreSQL in the cloud.
- Familiarity with scripting languages like Python, Bash, or Shell scripting for automating database operations.

**Summary**: