PostgreSQL Database Developer

We are seeking a PostgreSQL Database Developer / Architect to serve as the subject matter expert in designing and building a new customer-facing CRM from the ground up. This is a high-impact role where you will lead database architecture, design, optimization, and implementation, ensuring the system is built for scale, security, and performance.

Key Responsibilities:

• Architect, design, and develop a scalable PostgreSQL database to support a modern customer-facing CRM platform.
• Collaborate with application developers, business analysts, and stakeholders to translate requirements into optimized database structures.
• Design schemas, tables, indexes, views, and stored procedures to meet performance and business needs.
• Implement advanced PostgreSQL features such as partitioning, indexing strategies, replication, and high availability configurations.
• Optimize queries, troubleshoot performance bottlenecks, and ensure database reliability.
• Establish database coding standards, best practices, and governance for the CRM project.
• Implement robust backup, disaster recovery, and security strategies.
• Mentor team members on PostgreSQL development best practices.

Required Skills & Experience:

• 8+ years in database development/architecture
• Proven track record designing large-scale, high-performance database systems.
• Expert in PostgreSQL internals, indexing, query optimization, and performance tuning.
• Experience building customer-facing applications with complex relational data models.
• Strong skills in SQL, PL/pgSQL, and database design principles.
• Experience with replication, partitioning, sharding, and high availability solutions in PostgreSQL.
• Familiarity with integrating PostgreSQL into modern application stacks
• Solid understanding of database security, encryption, and compliance.

Preferred:

• Experience with CRM platforms or building CRM-like applications from scratch.
• Knowledge of cloud-hosted PostgreSQL services (Azure Database for PostgreSQL, AWS RDS, Aurora).
• Familiarity with ETL pipelines, data migration, and data integration