PostgreSQL Database Administrator

As a PostgreSQL Database Administrator at our company, you will play a crucial role in ensuring the integrity and high availability of PostgreSQL databases across various platforms. Your responsibilities will include: - **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. In addition to technical skills, soft skills that will benefit you in this role include strong problem-solving abilities, excellent communication and collaboration skills, the ability to work independently and handle multiple tasks simultaneously, and attention to detail with a proactive approach to identifying and addressing potential issues.,