DB - Support TM

Job Title: PostgreSQL Database Administrator (DBA)Location: Fill timeJob Type: Full-Time

Job Summary

We are seeking a skilled and motivated PostgreSQL Database Administrator.The ideal candidate willbe responsible for the database administration, ensuring data integrity, and supporting a robust, highavailability environment of PostgreSQL databases hosted in various platforms. This is a greatopportunity for someone who thrives in a fast-paced environment and is eager to further developtheir technical expertise.

Key Responsibilities

 Database Administration: Install, configure, and maintain PostgreSQL database systems inproduction and development environments. Backup and Recovery: Design and implement backup and recovery strategies to ensure dataintegrity and minimize downtime. Replication and High Availability: Set up and maintain database replication and highavailability configurations to ensure system reliability. Security: Ensure database security by managing user access and permissions, applyingpatches, and enforcing best practices. Performance Tuning: Monitor and optimize database performance, identify bottlenecks, andimplement 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 transferbetween environments. Troubleshooting: Diagnose and resolve database-related issues, including performanceissues, database corruption, and connectivity problems. Collaboration: Work closely with development and infrastructure teams to supportapplication 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 andknowledge 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 (orequivalent 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.