Postgre SQL DBA

Teamware Solutions is looking for a skilled PostgreSQL Database Administrator (DBA) to manage and optimize our critical database systems. This role involves working with relevant technologies to ensure smooth operations, high availability, and optimal performance of PostgreSQL databases, thereby significantly contributing to our business objectives within the PostgreSQL DBA domain.

Roles and Responsibilities:

• Database Administration:

  Install, configure, and maintain PostgreSQL database servers and associated tools.

• Performance Tuning:

  Monitor database performance, identify bottlenecks, and implement optimization strategies (e.g., query tuning, indexing, vacuuming) to ensure efficient operation.

• Backup and Recovery:

  Design, implement, and manage robust backup, recovery, and disaster recovery solutions for PostgreSQL databases to ensure data integrity and availability.

• Security Management:

  Implement and enforce database security policies, manage user access, roles, and permissions, and ensure compliance with security standards.

• Troubleshooting:

  Perform advanced analysis and troubleshooting of complex database issues, including connectivity problems, performance degradation, and data corruption.

• High Availability:

  Implement and maintain high availability solutions (e.g., replication, clustering) to minimize downtime and ensure continuous database operations.

• Monitoring & Alerting:

  Set up and manage database monitoring tools and alerting systems to proactively identify and respond to potential issues.

• Schema & Data Management:

  Assist developers with schema design, data modeling, and ensure data integrity and consistency.

• Automation:

  Develop and implement scripts for automating routine DBA tasks, database maintenance, and reporting.

• Collaboration & Documentation:

  Work closely with development teams, system administrators, and other stakeholders to support application deployments and provide technical guidance. Create and maintain comprehensive documentation for database configurations and procedures.

Preferred Candidate Profile:

• PostgreSQL Expertise:

  Strong hands-on experience in administering, configuring, and troubleshooting PostgreSQL databases.

• Database Concepts:

  Solid understanding of database architecture, relational database theory, SQL, and database security best practices.

• Performance Optimization:

  Proven ability to diagnose and resolve database performance issues, including query optimization and indexing strategies.

• High Availability & DR:

  Experience with PostgreSQL replication (e.g., streaming replication), clustering, and disaster recovery strategies.

• Scripting:

  Proficiency in scripting languages (e.g., Bash, Python) for database automation.

• Operating Systems:

  Familiarity with Linux/Unix operating systems as they relate to database environments.

• Problem-Solving:

  Excellent analytical and problem-solving skills with a methodical approach to complex database challenges.

• Communication:

  Strong verbal and written communication skills to effectively collaborate with technical teams and stakeholders.