PostgreSQL DBA Professionals

Job Title: PostgreSQL DBA SME with Ansible Automation Expertise*

Experience:*8-10 years **

About Us:** We are a leading technology company dedicated to creating innovative solutions in the Database as Service platform . We are looking for a skilled PostgreSQL DBA with strong Ansible automation expertise to join our dynamic team as a Subject Matter Expert (SME) with experience of opens source and EDB PostgreSQL.

**Job Responsibilities:*-

• Serve as the Subject Matter Expert (SME) for PostgreSQL database management and optimization.


• Manage and maintain the companys PostgreSQL database systems, ensuring high performance, availability, and security.


• Implement and manage automation processes using Ansible to streamline PostgreSQL database operations.


• Hands on experience with Ansible


• Utilize PostgreSQL tools such as pgAdmin, pg_dump, pg_backup, Barman, and pg_stat_statements for database management, backup, and performance tuning.


• Configure and manage database replication using pg_logical and other relevant PostgreSQL replication tools to ensure data consistency and high availability.


• Deploy and manage multi-node PostgreSQL clusters using Patroni and other relevant high-availability solutions for scalability and fault tolerance.


• Monitor PostgreSQL database systems using monitoring tools such as pg_stat_activity, pgBadger, and Prometheus for performance and availability monitoring.


• Perform regular PostgreSQL backups and implement recovery strategies to safeguard data integrity.


• Optimize PostgreSQL performance through query and index tuning, as well as system parameter adjustments.


• Collaborate with cross-functional teams to support application development and deployment processes.


• Develop and maintain documentation related to PostgreSQL configurations, Ansible automation processes, PostgreSQL tools, and procedures.


• Develop and maintain shell scripts, Ansible playbooks, and Python scripts to automate and optimize database operations and infrastructure management

**Required Skills and Qualifications:*

• 
  
  
  
  • Bachelor s degree in Computer Science, Information Technology, or related field.
  
  
  • 8-10 years of experience as a Database Administrator (DBA) with a focus on PostgreSQL.
  
  
  • Strong expertise in PostgreSQL database management, optimization, and troubleshooting.
  
  
  • Proficiency in Ansible automation for database operations and infrastructure management.
  
  
  • Experience with PostgreSQL tools such as pgAdmin, pg_dump, pg_backup, Barman, and pg_stat_statements for backup, recovery, and performance tuning. - Knowledge of PostgreSQL replication tools like pg_logical and high-availability solutions like Patroni.
  
  
  • Experience with PostgreSQL monitoring tools such as pg_stat_activity, pgBadger, and Prometheus for performance and availability monitoring.
  
  
  • Experience with PostgreSQL backup, recovery, and performance tuning. - Solid understanding of PostgreSQL security best practices. - Excellent problem-solving and troubleshooting skills. - Strong communication and collaboration skills. - Expertise in shell scripting, Ansible scripting, and Python programming.
  
  
  
  

Tools Knowledge of Posgresql

1. **pgAdmin**: A comprehensive PostgreSQL management tool that provides a graphical interface for database management, query execution, and performance tuning.

2. **pg_dump and pg_restore**: These are command-line utilities for backing up and restoring PostgreSQL databases.

3. **pg_backup**: A flexible backup script for PostgreSQL databases, often used for automated backups.

4. **Barman (Backup and Recovery Manager)**: A tool for disaster recovery of PostgreSQL servers, providing backup and recovery procedures.

5. **pg_stat_statements**: A built-in PostgreSQL module that provides detailed statistics about SQL query execution, helping in performance tuning.

6. **pgBadger**: A fast PostgreSQL log analyzer that generates detailed reports, helping to identify performance bottlenecks.

7. **pg_stat_activity**: A system view in PostgreSQL that shows the current activity of the database, including active connections, query execution status, and more.

8. **pg_repack**: A PostgreSQL extension for performing online table reorganization without locking tables, useful for managing table bloat.

9. **pgAudit**: A PostgreSQL extension for auditing database activity, providing detailed logging and monitoring capabilities for security and compliance.

10. **pg_logical**: A PostgreSQL extension for logical replication, allowing for replication of specific tables or databases rather than the entire cluster.

11. **Patroni**: A high-availability solution for PostgreSQL, providing automated failover and management of PostgreSQL clusters.

12. **pg_partman**: A PostgreSQL extension for partition management, helping to manage large tables by partitioning data based on specific criteria. In addition to these tools, a PostgreSQL DBA with Ansible automation expertise might also use Ansible playbooks to automate database provisioning, configuration management, and deployment tasks, enhancing efficiency and consistency across PostgreSQL environments. These tools, combined with expertise in shell scripting, Ansible scripting, and Python programming, can enable a PostgreSQL DBA to effectively manage, monitor, and optimize PostgreSQL databases in a production environment.

**Preferred Qualifications:**

• 
  
  
  
  • Certification in PostgreSQL database administration or related field.
  
  
  • Experience with cloud database services, such as AWS RDS or Azure Database for PostgreSQL.
  
  
  • Familiarity with containerization technologies, such as Docker and Kubernetes.