As a Postgres Database Administrator, you'll be responsible for production support, configuring, monitoring and performance tuning PostgreSQL databases; planning backup and recovery of database information and managing data replication.
Skills : Cloud AWS PostgreSQL DBA
Location: 100% remote
Duration: 6-12 months
Functional Area : IT 5-7 years' experience as a Postgres DBA, AWS cloud production support environment, backup recovery, replication, high availability, designing and managing schema, monitoring diagnosing and optimizing database performance
-
- Knowledge of high availability, disaster recovery and replication solutions and best practices
- Demonstrated experience implementing deploying Postgres database servers
Expertise in writing SQL queries, analyzing query performance using query plans and tuning query performance
- Postgres database performance tuning and script automaton to streamline the process.
- Advanced knowledge of Database Administration on PostgreSQL platforms operating within on premise & AWS installations.
- Advanced knowledge of Database operational monitoring & alerting for PostgreSQL.
- Advance knowledge of Backups, restores and recovery models.
- Advance knowledge of indexes, index management, and statistics.
-