- You have strong experience with PostgreSQL and it has been your primary database for
a minimum of 3-5 years as a lead DBA!
-
- Deep understanding of systems performance of PostgreSQL, and advanced knowledge
of Postgres internals
-
- Understand automation concept to speed up the work: ansible
-
- Experience implementing high availability by setting up either streaming replication or
logical replication and decoding
-
- Expertise implementing Foreign Data Wrappers to sync data across multiple
PostgreSQL servers and Advanced query tuning for large data sets
-
- Knows how to optimize queries/schemas
-
- Knows backup solutions and strategies
-
- Knows HA solutions and strategies
-
- Knows proxy usage as it relates to Postgres
-
- Ability to troubleshoot methodically, identifying and applying fixes for known errors, and
when necessary, capacity to think outside of the box to resolve complex issues
-
- Experience with system performance counters and metrics relevant to the operation of
high-concurrency PostgreSQL implementations, and resolve database performance and
scalability issues.