DB - Support TM

As a PostgreSQL Database Administrator at our company, you will have the opportunity to showcase your skills and expertise. Your main responsibilities will revolve around database administration, ensuring data integrity, and maintaining a high availability environment for PostgreSQL databases across different platforms. If you thrive in a fast-paced environment and are eager to enhance your technical proficiency, this role is perfect for you. **Key Responsibilities:** - **Database Administration:** You will be in charge of installing, configuring, and managing PostgreSQL database systems in both production and development settings. - **Backup and Recovery:** Design and implement effective backup and recovery strategies to uphold data integrity and minimize downtime. - **Replication and High Availability:** Set up and maintain database replication and high availability configurations to ensure system reliability. - **Security:** Manage user access and permissions, apply patches, and enforce best practices to maintain robust database security. - **Performance Tuning:** Monitor and optimize database performance, identify bottlenecks, and implement necessary improvements. - **Database Optimization:** Conduct routine optimization tasks like query tuning, index management, and configuration adjustments. - **Data Migration:** Support database migrations, including schema changes and data transfers between environments. - **Troubleshooting:** Diagnose and resolve various database-related issues, such as performance problems, database corruption, and connectivity issues. - **Collaboration:** Collaborate closely with development and infrastructure teams to facilitate application deployments and system upgrades. - **Documentation:** Maintain detailed documentation of database configurations, processes, and troubleshooting procedures. **Required Skills:** - Ability to quickly and efficiently troubleshoot and resolve database issues. - Proficiency in SQL and PL/pgSQL. - Experience with database replication, high availability using tools like repmgr or patroni. - Knowledge of backup tools such as pg_dump, pg_basebackup, barman, or pgbackrest. - Proficiency in performance tuning techniques specific to PostgreSQL. - Familiarity with PostgreSQL backup and recovery strategies. - Experience with monitoring tools like Nagios, Grafana, or similar. - Understanding of database security practices, including user management and access controls. - Strong scripting skills in Bash, Python, or similar languages. - Experience with automation tools like Ansible, Chef, or Puppet, and familiarity with data migration tools. Knowledge of other database administration is a plus. - Familiarity with containerization tools like Docker, Kubernetes, and orchestration tools is a bonus. In addition to technical qualifications, the following soft skills are desirable: - Strong problem-solving and troubleshooting skills. - Excellent communication and collaboration abilities. - Capacity to work independently while managing multiple tasks simultaneously. - Attention to detail and proactive approach in identifying and addressing potential issues. If you possess a Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience), and align with the mentioned skills and soft skills, we encourage you to apply for this challenging and rewarding position.,