PostgreSQL Database Administrator

Job Title: PostgreSQL Database Administrator

Job Description:

We are looking for an experienced 5 to 6 year old and detail-oriented PostgreSQL Database Administrator to join our dynamic team. The ideal candidate will be responsible for managing and optimizing PostgreSQL databases, ensuring high performance, and assisting in the design and implementation of database systems. They will also play a key role in database troubleshooting, backups, migrations, and scaling solutions to meet company needs.

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
• Evaluate how applications and users interact with the data.
• 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:

• Work with developers to optimize application queries and database design.
• 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: