Core SME
Job Description
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.
Requirements
Department: Engineering / Development
Experience: 5 - 20 yrs
Posted: 2025-09-22T07:40:34.617Z