PostgreSQL Developer / Database Engineer || Remote role

DMS Vision • Frisco, TX

14h • Remote

About The Position

We are seeking a highly skilled PostgreSQL Developer / Database Engineer to design, develop, optimize, and support enterprise-scale PostgreSQL database solutions. The role covers database architecture, performance tuning, data integration, and cloud-native database platforms. It includes database design and modeling; SQL and PL/pgSQL development and query optimization; indexing and performance tuning; high availability, replication, disaster recovery, and scaling; PostgreSQL tooling; data quality and governance; ETL/ELT; application development; cloud technologies; and data security. The position is remote and offered as a contract of six or more months.

Requirements

• 5+ years of PostgreSQL experience.
• Experience designing, developing, optimizing, and supporting enterprise-scale PostgreSQL database solutions.
• Background in database architecture, performance tuning, data integration, and cloud-native database platforms.

Nice To Haves

• Experience with enterprise-scale database environments.
• Healthcare experience.
• Database migration experience.
• DevOps automation experience, including GitHub Actions, Jenkins, Azure DevOps, or Ansible.

Responsibilities

• Design logical and physical data models, including normalization and denormalization, entity relationship models, partitioning strategies, and scalable schemas.
• Develop complex SQL and PL/pgSQL, including CTEs, window functions, stored procedures, views, and materialized views; analyze execution plans and optimize queries.
• Tune database performance through indexing, VACUUM optimization, statistics management, memory tuning, and troubleshooting.
• Implement and support streaming and logical replication, failover, disaster recovery, read replicas, backup and recovery, and horizontal and vertical scaling.
• Use PostgreSQL tools, including pgAdmin, psql, pg_dump, pg_restore, monitoring tools, WAL management, and migration utilities.
• Support data quality and governance through metadata management, lineage, profiling, validation, reconciliation, and lifecycle management.
• Build and support ETL/ELT integrations, including Kafka, CDC, batch and real-time pipelines, integration frameworks, and event-driven architectures.
• Develop or support applications and services using Python, Java, SQL, Bash, Spring Boot, REST APIs, microservices, Docker, and Kubernetes.
• Work with cloud database platforms and infrastructure tools, including AWS RDS, Aurora PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL, Terraform, and CI/CD.
• Implement data security measures such as RBAC, encryption at rest and in transit, auditing, and protection of PHI, PII, and PCI data.
• Engage stakeholders and contribute problem-solving, communication, leadership, accountability, and teamwork.

What This Job Offers

• Career Level: Senior
• Education Level: No Education Listed