DB - Support TM

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.