Description

You will act as the subject matter expert designing and building a new customer-facing CRM from the ground up.

Responsibilities

• Architect and develop a scalable PostgreSQL database to support a modern CRM platform.
• Design schemas, tables, indexes, views, and stored procedures to meet business requirements.
• Implement advanced PostgreSQL features including partitioning, replication, and high availability configurations.
• Optimize queries, troubleshoot performance bottlenecks, and ensure database reliability.
• Establish database coding standards, security strategies, and disaster recovery protocols.

Required Skills

• 8+ years of experience in database development and architecture.
• Expertise in PostgreSQL internals, indexing, query optimization, and performance tuning.
• Proficiency in SQL and PL/pgSQL.
• Proven experience designing large-scale, high-performance database systems.
• Hands-on experience with replication, partitioning, and shardings in PostgreSQL.
• Strong understanding of database security, encryption, and compliance.
• Experience building customer-facing applications with complex relational data models.

Preferred Skills

• Knowledge of cloud-hosted PostgreSQL services including AWS RDS and Aurora.
• Experience with ETL pipelines, data migration, and data integration.
• Background building CRM platforms or similar applications from scratch.

Key Skills

Education

Any Gradute