Source description
About the role
Role: Postgres DBA Location: 100%remote Duration: 6+Months 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 Must-Haves (Concepts & Tools): • Postgres on AWS (S3) • Aurora • Overall DBA skills (App vs. Server) Nice-to-Haves: • RDS • Hibernate Thanks & Regards, Naveen Sai - Sr Technical Recruiter Thought wave Software and Solutions 314 N. Lake St, Suite 6, Aurora IL 60506 Desk: 6302168656 EXTN: 156 Mobile: 4307552553 Email : naveen@thoughtwavesoft.com Website:www.thoughtwavesoft.com https://www.linkedin.com/in/naveen-chakra-sai-kodi-0b79aa131
More at Thoughtwave Software and Solutions