We are seeking an experienced PostgreSQL Database Administrator to manage and maintain development, testing, and production environments. The ideal candidate will have extensive expertise in PostgreSQL installation, configuration, backup and recovery strategies, performance tuning, replication, and database upgrades. This role requires a deep understanding of database administration best practices, security measures, and high-availability solutions.
Key Responsibilities
Database Installation & Configuration
- Install and configure PostgreSQL on various operating systems, ensuring best practices for security and performance.
- Set up PostgreSQL clusters and tune configurations based on workload requirements.
Database Administration & Maintenance
- Manage and maintain multiple PostgreSQL environments, including development, testing, and production instances.
- Perform routine health checks, monitoring, and maintenance activities to ensure database stability and reliability.
- Optimize storage, tablespaces, and indexes for improved database performance.
Backup & Recovery
- Design and implement reliable backup and recovery strategies using tools like pg_dump, pg_basebackup, and third-party solutions.
- Perform Point-In-Time Recovery (PITR) and disaster recovery procedures to minimize data loss in case of failures.
Performance Tuning & Optimization
- Monitor and analyze database performance metrics, identifying bottlenecks and optimizing query execution plans.
- Implement indexing strategies, partitioning, and caching techniques to improve query response times.
- Work closely with developers to optimize SQL queries and database schema design.
Replication & High Availability
- Configure and manage PostgreSQL streaming replication, Hot Standby, and logical replication for high availability and scalability.
- Ensure failover mechanisms are in place to minimize downtime and data loss.
Upgrades & Migrations
- Plan and execute PostgreSQL version upgrades and migrations with minimal downtime.
- Conduct thorough testing of database changes before deployment to production environments.
User & Security Management
- Manage database users, roles, and permissions to enforce access control and security policies.
- Implement best practices for encryption, auditing, and compliance with security standards.
Required Skills & Experience
- 5+ years of hands-on experience in PostgreSQL administration.
- Strong expertise in database installation, configuration, and performance tuning.
- Proven experience in managing backups, disaster recovery, and replication strategies.
- Deep understanding of SQL tuning, query optimization, and index management.
- Experience with high availability architectures and clustering solutions.
- Proficiency in scripting and automation using Shell, Python, or similar languages.
- Familiarity with cloud-based database services (AWS RDS, Azure Database for PostgreSQL, etc.).
- Excellent troubleshooting and problem-solving skills.
Preferred Qualifications
- Experience with monitoring tools such as pgAdmin, Prometheus, or Grafana.
- Knowledge of NoSQL and other database technologies.
- Experience working in Agile/Scrum environments.
If you are passionate about database administration and thrive in a fast-paced environment, we encourage you to apply and be part of our dynamic team!