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, 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.