Note: The job is a remote job and is open to candidates in USA. eJAmerica is seeking an experienced PostgreSQL Database Administrator (DBA) to manage, maintain, optimize, and secure PostgreSQL databases in production environments. The ideal candidate will have hands-on experience with database installation, configuration, performance tuning, backup and recovery, high availability, replication, and database security.
Responsibilities
- Install, configure, upgrade, and maintain PostgreSQL databases
- Monitor database performance and optimize SQL queries
- Perform database backup, recovery, and disaster recovery planning
- Configure and manage replication and high availability solutions
- Monitor database health, storage, and capacity planning
- Troubleshoot database issues and resolve production incidents
- Implement database security, user management, and access controls
- Perform routine maintenance activities such as VACUUM, ANALYZE, and indexing
- Automate database administration tasks using shell scripting or Python
- Collaborate with application developers to optimize database performance
- Document database configurations, procedures, and standards
Skills
- 5+ years of PostgreSQL Database Administration experience
- Strong knowledge of PostgreSQL architecture and internals
- Experience with PostgreSQL installation, configuration, and upgrades
- Hands-on experience with: Backup and recovery (pg_dump, pg_basebackup, pgBackRest), Replication (Streaming Replication, Logical Replication), Performance tuning and query optimization, Indexing strategies, VACUUM and ANALYZE, Partitioning
- Strong SQL and PL/pgSQL programming skills
- Experience with Linux/Unix operating systems
- Knowledge of database security and user privilege management
- Experience with monitoring tools such as pgAdmin, Prometheus, or Grafana
- Familiarity with cloud platforms (AWS RDS PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL) is a plus
- Bachelor's degree in Computer Science, Information Technology, or a related field
- PostgreSQL certification is preferred
- Experience with DevOps tools such as Docker, Kubernetes, Jenkins, or Terraform is an advantage
- Knowledge of scripting languages like Bash or Python
Company Overview