PostgreSQL Database Administrator (DBA)

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, highavailability 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.
Skills Required
Database Replication, Chef, Postgresql, Monitoring Tools, Grafana, Automation Tools, Docker, containerization , Python, Performance Tuning, Bash, Sql, Barman, High Availability, Ansible, User Management, Nagios, Puppet, Kubernetes