Overview
Remote
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 6 Month(s)
Able to Provide Sponsorship
Skills
PostgreSQL
AWS
Azure
Aurora
ETL
SQL
migration
integration
Job Details
Job Description
Overview:
We are seeking a PostgreSQL Database Developer to 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 applications 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.