Aloha - Database Engineer - PostgreSQL/SQL Server

Job Summary :

The ideal candidate will play a key role in performance tuning, query optimization, and helping scale our databases to meet growing application and business demands.

Youll work closely with developers, DevOps, and product teams to ensure our database infrastructure is secure, reliable, and efficient.

Key Responsibilities :

- Perform in-depth query tuning, index optimization, and resource analysis to ensure maximum performance.

- Support scalability of databases through partitioning, sharding, replication, and other advanced techniques.

- Troubleshoot and resolve database performance and capacity issues.

- Collaborate with developers to review and optimize application-level SQL queries.

- Participate in database design and schema reviews for new projects and features.

- Write and maintain automation scripts for database tasks and reporting.

- Stay up to date with Postgres & MS SQL server specific best practices.

Required Skills and Experience :

- Strong hands-on experience with both PostgreSQL and SQL Server.

- Proven expertise in query optimization, index tuning, and database performance troubleshooting.

- Experience with scaling strategies (e.g., replication, load balancing, partitioning).

- Solid understanding of database internals and how they impact performance.

- Experience with monitoring tools like pg_stat_statements, SQL Server Profiler, or third-party APM tools.

- Familiarity with DevOps environments, CI/CD pipelines, and database change management.

- Good understanding of security best practices related to database systems.

- Strong communication skills and ability to collaborate across teams