PostgreSQL DBA

PostgreSQL DBA

100% Remote

6+ month contract

Project Scope: Going from Postgres 11 to 14 (Processing inbound and to the applications)

Development Methodology: Agile – 2 week

High-Level Individual Duties:

• Performance Analysis – about 10 instances under a single cluster (a few outside)
• Using Hibernate as an ORM, so they need someone who gets how that would impact performance
• Indexing / Caching

• DB Monitoring – Continuous eval (AWS tooling…they want to use some of the Postgres native tools – our person needs to show HOW)
• Offer solutions for alerting as well

• Scaling – want to double in size à where are we running today? If we double in size in these areas, XYZ is going to be a scalability issue and we need to do ABC
• Replication – Change Data Capture (Debezium – not necessary)
• Query optimization

Other:

• Partitioning
• DML / DDL
• Adding Query Hints
• Reading Execution Plans
• Rebuilding Indexes
• Building Data Sets

Must-Haves

• Postgres on AWS (S3)
• Aurora
• Overall DBA skills (App vs. Server)

Nice-to-Haves:

• RDS
• Hibernate

Job Type: Contract

Salary: $45.00 - $50.00 per hour

Work Location: Remote

Speak with the employer
+91 8587944417