Job description

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.

Someone shared one job with you. ASAI keeps finding the rest.

Scored, not searched. Every role ranked against your actual profile.

Alerts as often as hourly. Reach new roles while the pile is still small.

Skill gaps, spelled out. See exactly which requirements you don't meet yet.

Verified jobs, only. Say no to ghost jobs. Your time deserves respect.

Someone shared one job with you. ASAI keeps finding the rest.