PostgreSQL Database Administrator (DBA)

Role Overview: You will be responsible for installing, configuring, and maintaining Postgre databases in production, staging, and development environments. You will monitor database performance and tune SQL queries to improve efficiency. Additionally, you will implement backup, recovery, and disaster recovery solutions to ensure data integrity. Setting up replication and high availability configurations will also be part of your role. Working closely with developers to optimize database schema, indexing, and queries will be essential. You will also manage database security, user access controls, and compliance with data protection policies. Automating routine database maintenance tasks using scripting languages and documenting database configurations, policies, and procedures will be part of your responsibilities. It is crucial to stay updated with the latest PostgreSQL features and best practices. Key Responsibilities: - Install, configure, and maintain Postgre databases in production, staging, and development environments - Monitor database performance and tune SQL queries to improve efficiency - Implement backup, recovery, and disaster recovery solutions - Set up replication and high availability configurations - Work with developers to optimize database schema, indexing, and queries - Manage database security, user access controls, and compliance with data protection policies - Automate routine database maintenance tasks using scripting languages - Document database configurations, policies, and procedures Qualifications Required: - Proven experience working with PostgreSQL databases - Strong knowledge of SQL queries and database performance tuning - Experience in implementing backup and recovery solutions - Familiarity with replication and high availability configurations - Ability to collaborate effectively with developers - Knowledge of database security best practices - Proficiency in scripting languages for automation - Excellent documentation skills - Willingness to stay updated with the latest PostgreSQL features and best practices,