Lead Database System Engineer - PostgreSQL

Job Description :

Key Responsibilities :

- Architect & Design : Define the technical vision and architecture, ensuring scalability, reliability, and efficiency.

- Performance Optimization : Lead efforts in query optimization, indexing strategies, and efficient data partitioning for distributed workloads.

- Database Internals & Citus Integration : Enhance PostgreSQL and Citus features to improve distributed data processing.

- Replication & High Availability : Design and implement robust replication, failover, and backup strategies.

- Security & Compliance : Ensure data integrity, encryption, and adherence to industry security standards.

- Tooling & Monitoring : Enhance database monitoring tools to improve observability.

- Collaboration : Work closely with developers, DevOps, and product teams to align database technology with business needs.

- Research & Innovation : Stay updated with industry trends in distributed databases, cloud-native architectures, and storage engines.

Required Skills & Experience :

- 5- 15 years of hands-on experience and strong proficiency in C and C++ for developing database engines.

- Working knowledge of Python and Perl is a plus.

- Experience with query planning, indexing, and database performance tuning.

- Deep understanding of replication, sharding, and high-availability architectures.

- Hands-on experience with PostgreSQL performance monitoring tools.

- Experience in database security, access control, and encryption.

- Strong problem-solving skills and the ability to mentor engineering teams.

Preferred Qualifications :

- Contributions to PostgreSQL, Citus, or open-source database projects.

- Knowledge of distributed consensus algorithms (Raft, Paxos).

- Experience in parallel query execution.

- Exposure to AI/ML-driven database optimizations.