Senior Databased Administrator

Looking for a Senior Database Administrator

Skills:

- Proven experience as a Database Administrator for PostgreSQL 12+

- Excellent knowledge of data backup, recovery, security, integrity and SQL

Description:

Our backend is a Python flask application using SQL Alchemy as ORM to make requests to our PostGreSQL database. We instrumented the python code with New Relic and can see that the PostgreSQL requests are the bottlenecks. We are experiencing major slowdowns (> 10s for some select/update SQL requests). None of the tables are indexed yet and we would like to discuss with an expert to challenge :

- our database structure

- which tables to index and which key we should use for the indexation

- whether table views are needed to go further to speed things us

Rate based on experience

Start ASAP