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 :

Skills Required

Postgresql, Sql, Clustering, Scripting Languages, Operating Systems