Core SME

JD for Core SME

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

 Strong expertise in PostgreSQL internals, Citus, and distributed databases.

 Proficiency in C, C++ for database engine development.  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.

 Familiarity with Kubernetes, Docker, and cloud-native database deployments.

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

Skills Required

Replication, Database Security, Indexing, database performance tuning , distributed databases, Encryption, Docker, Access Control, Kubernetes