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
Please Note :
chrismaxcer.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, chrismaxcer.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.