iServeU Technology - PostgreSQL Administrator - Database Architecture

Description :

Job Summary :

We are seeking a skilled PostgreSQL Database Administrator to manage, optimize, and maintain our PostgreSQL databases.

The ideal candidate will ensure high availability, performance, and security of database systems while supporting development teams with database architecture, queries, and troubleshooting.

This role involves both operational responsibilities and strategic database planning.

Key Responsibilities :

- Install, configure, and maintain PostgreSQL database servers across multiple environments (development, staging, production)

- Monitor and optimize database performance, including indexing, query optimization, and resource utilization

- Ensure high availability, backup, and disaster recovery strategies

- Implement security best practices, including access control, encryption, and auditing

- Support database schema design, data modeling, and migrations in collaboration with development teams

- Perform database upgrades, patching, and version management

- Troubleshoot and resolve database-related issues, including performance bottlenecks and replication errors

- Maintain database documentation, standard operating procedures, and monitoring dashboards

- Work with DevOps teams to automate database provisioning, CI/CD deployments, and monitoring

- Conduct capacity planning and scalability analysis to meet growing business demands

- Assist in setting up replication, clustering, and high-availability configurations (e.g., streaming replication, Pgpool-II, Patroni)

- Participate in on-call rotation for critical production incidents

Technical Skills :

- Strong expertise in PostgreSQL administration (installation, configuration, backup/restore, replication)

- Proficiency in SQL and PL/pgSQL programming

- Experience with performance tuning : query optimization, indexing, partitioning, and caching

- Familiarity with high availability and disaster recovery solutions for PostgreSQL

- Experience with monitoring and alerting tools (Prometheus, Grafana, Nagios, pg_stat_activity, etc.)

- Knowledge of cloud PostgreSQL services (AWS RDS, Azure Database for PostgreSQL, GCP Cloud SQL)

- Understanding of database security practices, including roles, permissions, and encryption

- Familiarity with backup and recovery strategies, including PITR (Point-in-Time Recovery)

- Experience with scripting and automation (Bash, Python, Ansible, Terraform)

- Understanding of CI/CD pipelines and DevOps integration