Source description
About the role
Role: Postgres DBA
Location: 100%remote Vendor/Client: Apex/Optum Duration: 6+Months
Required Skills: Must-Haves (Concepts & Tools): · Postgres on AWS (S3) · Aurora · Overall DBA skills (App vs. Server)
Job Description: This is not a server DBA this is an application DBA! Need to have the application side knowledge of DBA. Hibernate is not required but they must understand scaling and know how to fix scaling issues and be able to explain how they would fix it.. They need someone super strong!
Project Scope: Going from Postgres 11 à 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 evaluation (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 have a scalability issue and we need to do ABC
· Replication – Change Data Capture (Debezium – not necessary)
· Query optimization
Others…
· Partitioning
· DML / DDL
· Adding Query Hints
· Reading Execution Plans
· Rebuilding Indexes
· Building Data Sets
Nice-to-Haves:
· RDS
· Hibernate
-- Thanks & Regards, Manoj - Technical Recruiter Thought wave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6304919831 EXTN: 158 Email : Manoj@thoughtwavesoft.com Website:www.thoughtwavesoft.com https://www.linkedin.com/in/chettipalli-manoj-398b02246
More at Thoughtwave Software and Solutions