Bharuwa Solutions - PostgreSQL DBA Expert - Database Performance Tuning

Key Responsibilities :

- Install, configure, and upgrade PostgreSQL database servers and tools.

- Monitor database performance and tune systems for optimal efficiency.

- Perform regular backups, restores, and disaster recovery testing.

- Ensure database availability, integrity, security, and performance.

- Manage and maintain replication, clustering, and failover mechanisms (e.g., streaming replication, Patroni, pgBouncer, etc.).

- Automate routine tasks using scripting (Bash, Python, etc.).

- Implement and manage database security (roles, privileges, SSL, etc.).

- Troubleshoot database issues, including performance bottlenecks and query optimization.

- Collaborate with development teams for schema design, indexing strategies, and SQL reviews.

- Support and optimize ETL jobs and data pipelines.

- Conduct root cause analysis on database outages and ensure long-term resolution.

- Maintain and optimize PostgreSQL databases for performance, stability, and security.

- Perform database tuning, query optimization, and schema design.

- Implement and maintain database monitoring and alerting solutions.

- Coordinate and perform database backups, recovery, and archival.

- Conduct regular database maintenance tasks to ensure top performance.

- Collaborate with development teams to design and review database schemas and queries.

- Create and maintain documentation related to database environments and processes.

- Stay current with industry trends and best practices in database management

- Bachelor's degree in computer science, information technology, or a related field.

Requirements :

- Proven experience in database administration, including performance tuning, query optimization, and schema design.

- Strong understanding of database security practices and disaster recovery strategies.

- Excellent problem-solving abilities and attention to detail.

- Strong communication and collaboration skills

Skills :

- PostgreSQL

- SQL

- Database Performance Tuning

- Query Optimization

- Database Monitoring

- Backup and Recovery

- Schema Design

- Database Security

- Linux/Unix

- Shell Scripting