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.