Position: Database administrator (DBA)
Company: De.Fi
Category: SQL
Experience required: 2y
English level: upper

We are looking for a talented and experienced DBA Engineer to help us review our existing Amazon RDS PostgreSQL schema and queries. The ideal candidate will have a strong background in database administration, schema design, query optimization, and performance tuning, with experience working with PostgreSQL and Amazon RDS.
In this role, you will work closely with our development team to review our existing schema and queries, identify areas for improvement, and provide recommendations for scaling our database to meet our growing needs. You will also be responsible for monitoring database performance, ensuring data integrity, and troubleshooting any issues that arise.

Responsibilities:

Review and optimize existing Amazon RDS PostgreSQL schema and queries
Identify areas for improvement and provide recommendations for scaling and optimizing database performance
Monitor database performance and ensure data integrity
Troubleshoot and resolve any database-related issues
Collaborate with development team to ensure database design meets business requirements
Design and implement schema changes as necessary
Maintain database backups and disaster recovery procedures

Requirements:

5+ years of experience in database administration, schema design, query optimization, and performance tuning
Strong knowledge of PostgreSQL and Amazon RDS
Experience with schema design and implementation
Experience with query optimization and performance tuning
Strong understanding of database security and data integrity best practices
Experience with database backup and disaster recovery procedures
Strong problem-solving and analytical skills
Excellent communication and collaboration skills


As a plus:

Experience with other SQL databases such as MS SQL, MySQL or Oracle
Familiarity with blockchain technology
Familiarity with DevOps methodologies