DB - Support TM

As a PostgreSQL Database Administrator at our company, you will play a crucial role in maintaining the integrity and high availability of our PostgreSQL databases across various platforms. Your responsibilities will include: - **Database Administration:** Installing, configuring, and maintaining PostgreSQL database systems in both production and development environments. - **Backup and Recovery:** Designing and implementing backup and recovery strategies to ensure data integrity and minimize downtime. - **Replication and High Availability:** Setting up and maintaining database replication and high availability configurations to guarantee system reliability. - **Security:** Ensuring the security of the database by managing user access and permissions, applying patches, and enforcing best practices. - **Performance Tuning:** Monitoring and optimizing database performance, identifying bottlenecks, and implementing improvements. - **Database Optimization:** Performing routine database optimization tasks such as query tuning, index management, and configuration adjustments. - **Data Migration:** Assisting with database migrations, including schema changes and data transfer between environments. - **Troubleshooting:** Diagnosing and resolving database-related issues, including performance problems, database corruption, and connectivity issues. - **Collaboration:** Working closely with development and infrastructure teams to support application deployments and system upgrades. - **Documentation:** Maintaining clear and detailed documentation of database configurations, processes, and troubleshooting procedures. The required skills for this role include: - Ability to troubleshoot and resolve database issues efficiently. - Proficiency in SQL and PL/pgSQL. - Experience with database replication, high availability on repmgr or patroni. - Familiarity with backup tools like pg_dump, pg_basebackup, barman or pgbackrest. - Experience in performance tuning techniques for PostgreSQL. - 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 of other database administration practices. - Familiarity with containerization (Docker, Kubernetes) and orchestration tools is a bonus. Desired qualifications for this role include a Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience). Additionally, soft skills such as strong problem-solving abilities, excellent communication, collaboration skills, independence in task handling, and attention to detail are highly valued.,