JD for Core and tools lead

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:

 8 plus 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.