Overview
Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
Design Optimization
Data Migration
Database Architecture
Database Design
Database Security
Customer Facing
Customer Relationship Management (CRM)
Data Integration
Amazon RDS
Performance Tuning
PostgreSQL
Profit And Loss
Query Optimization
Disaster Recovery
Encryption
Extract
Transform
Load
High Availability
Amazon Web Services
Regulatory Compliance
Remote Desktop Services
SQL
Backup
Cloud Computing
Stored Procedures
Structural Engineering
Collaboration
Database
Mentorship
Replication
SQL Azure
Scratch
Job Details
Job Title:- PostgreSQL Database Developer / Architect (SME CRM Build)
Location:- Remote
Duration:- 6-Month Contract-to-Hire
Job Description
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/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.