PostgreSQL Database Developer

Job Role: PostgreSQL Database DeveloperLocation: RemoteDuration: 6+ Months/ Contract to Hire Work Authorization: USC and GC Interview Mode: Video        JD: They are going to start building a customer facing CRM in PostgreSQL so this person will be the SME in building that so probably more of a Database Developer or DB Architect.PostgreSQL SME – Deep, hands-on expertise in designing, building, and optimizing enterprise-grade PostgreSQL databases, with mastery of performance tuning, indexing, and query optimization.CRM Build Experience – Proven track record architecting databases for customer-facing applications, ideally leading the full lifecycle from design to production.Architect + Developer Hybrid – Ability to own both high-level database architecture decisions and hands-on development, ensuring scalability, security, and integration with modern app stacks. Overview: 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/architectureProven 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 stacksSolid 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.