Job Title: PostgreSQL Database Administrator (DBA)
Location: Fill time
Job Type: Full-Time
Job Summary:
We are seeking a skilled and motivated PostgreSQL Database Administrator.The ideal candidate will
be responsible for the database administration, ensuring data integrity, and supporting a robust, highavailability environment of PostgreSQL databases hosted in various platforms. This is a great
opportunity for someone who thrives in a fast-paced environment and is eager to further develop
their technical expertise.
Key Responsibilities:
Database Administration: Install, configure, and maintain PostgreSQL database systems in
production and development environments.
Backup and Recovery: Design and implement backup and recovery strategies to ensure data
integrity and minimize downtime.
Replication and High Availability: Set up and maintain database replication and high
availability configurations to ensure system reliability.
Security: Ensure database security by managing user access and permissions, applying
patches, and enforcing best practices.
Performance Tuning: Monitor and optimize database performance, identify bottlenecks, and
implement improvements.
Database Optimization: Perform routine database optimization tasks, including query tuning,
index management, and configuration adjustments.
Data Migration: Assist with database migrations, including schema changes and data transfer
between environments.
Troubleshooting: Diagnose and resolve database-related issues, including performance
issues, database corruption, and connectivity problems.
Collaboration: Work closely with development and infrastructure teams to support
application deployments and system upgrades.
Documentation: Maintain clear and detailed documentation of database configurations,
processes, and troubleshooting procedures.
Required Skills:
Ability to troubleshoot and resolve database issues quickly and efficiently.
Proficient in SQL and PL/pgSQL.
Experience with database replication, high availability on repmgr or patroni
Experience with backup tools like pg_dump, pg_basebackup, barman or pgbackrest
Experience in performance tuning techniques for PostgreSQL.
Familiarity with PostgreSQL backup and recovery strategies.
Proficiency in using monitoring tools such as Nagios, Grafana, or similar tools.
Experience in database security practices, including user management and access controls.
Strong scripting skills (e.g., Bash, Python, or similar).
Experience with automation tools (e.g., Ansible, Chef, Puppet), data migration tools and
knowledge on other database administration is a plus.
Familiarity with containerization (Docker, Kubernetes) and orchestration tools is a bonus.
Desired Qualifications:
Bachelor’s degree in Computer Science, Information Technology, or related field (or
equivalent experience).
Soft Skills:
Strong problem-solving and troubleshooting skills.
Excellent communication and collaboration skills.
Ability to work independently and handle multiple tasks simultaneously.
Attention to detail and proactive in identifying and addressing potential issues.