DB - Support TM

Job Title: PostgreSQL Database Administrator (DBA)Location: Fill timeJob Type: Full-TimeJob 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, high￾availability 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.

Department: Data & Analytics
Experience: 5-8
Posted: 2025-09-22T08:51:02.923Z