{"schemaVersion":"jobsearcher.job.v1","id":"a1ab0e79609e57d3476c7a17","url":"https://jobsearcher.com/jobs/a1ab0e79609e57d3476c7a17","canonicalUrl":"https://jobsearcher.com/jobs/a1ab0e79609e57d3476c7a17","title":"PostgreSQL Developer/Database Engineer","description":"Job Description\n\nPosition Details:\r\nClient:Healthcare Client\r\nJob Title:PostgreSQL Developer/Database Engineer\r\nLocation:Remote\r\nRate: $60/hr on W2 (to Ascendion)\r\nNote:We would need a profile who can contribute both as a PostgreSQL Developer & Database Engineer.\r\nJob Description\r\nWe are seeking an experienced PostgreSQL Developer / Database Engineer to design, develop, optimize, and support enterprise-scale PostgreSQL solutions. The ideal candidate has strong expertise in database architecture, performance tuning, data integration, and cloud-native database platforms.\r\nDatabase Design and Data Modeling\r\nLogical and physical data modeling, normalization and denormalization, entity-relationship modeling, partitioning strategies, and scalable schema design.\r\nSQL Development and Query Optimization\r\nAdvanced SQL and PL/pgSQL, CTEs, window functions, stored procedures, views, materialized views, and execution-plan analysis.\r\nPerformance Tuning and Indexing\r\nB-Tree, Hash, GIN, GiST, and BRIN indexes; VACUUM optimization; statistics management; memory tuning; and performance troubleshooting.\r\nHigh Availability, Replication, and Scalability\r\nStreaming and logical replication, failover, disaster recovery, read replicas, backup and recovery, and horizontal and vertical scaling.\r\nPostgreSQL Tooling\r\npgAdmin, psql, pg_dump, pg_restore, monitoring tools, WAL management, and migration utilities.\r\nData Quality and Governance\r\nMetadata management, lineage, profiling, validation, reconciliation, and lifecycle management.\r\nETL / ELT\r\nKafka, CDC, batch and real-time pipelines, integration frameworks, and event-driven architectures.\r\nProgramming and Application Development\r\nPython, Java, SQL, Bash, Spring Boot, REST APIs, microservices, Docker, and Kubernetes.\r\nCloud Technologies\r\nAWS RDS, Aurora PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL, Terraform, and CI/CD.\r\nData Security\r\nRBAC, encryption at rest and in transit, auditing, compliance, and PHI, PII, and PCI protection.\r\nHighly Desired\r\nHealthcare experience, database migrations, DevOps automation, GitHub Actions, Jenkins, Azure DevOps, and Ansible.\r\nSoft Skills\r\nProblem-solving, communication, stakeholder engagement, leadership, accountability, and teamwork.\r\nPreferred Qualifications\r\n5 years of PostgreSQL experience, preferably in enterprise-scale database environments.","company":"Dpr Solutions","rawCompany":"dpr solutions","city":"Austin","state":"TX","isRemote":false,"isActive":false,"createdAt":"2026-11-03T02:08:44.359Z","occupations":[{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"PostgreSQL Developer/Database Engineer","description":"Job Description\n\nPosition Details:\r\nClient:Healthcare Client\r\nJob Title:PostgreSQL Developer/Database Engineer\r\nLocation:Remote\r\nRate: $60/hr on W2 (to Ascendion)\r\nNote:We would need a profile who can contribute both as a PostgreSQL Developer & Database Engineer.\r\nJob Description\r\nWe are seeking an experienced PostgreSQL Developer / Database Engineer to design, develop, optimize, and support enterprise-scale PostgreSQL solutions. The ideal candidate has strong expertise in database architecture, performance tuning, data integration, and cloud-native database platforms.\r\nDatabase Design and Data Modeling\r\nLogical and physical data modeling, normalization and denormalization, entity-relationship modeling, partitioning strategies, and scalable schema design.\r\nSQL Development and Query Optimization\r\nAdvanced SQL and PL/pgSQL, CTEs, window functions, stored procedures, views, materialized views, and execution-plan analysis.\r\nPerformance Tuning and Indexing\r\nB-Tree, Hash, GIN, GiST, and BRIN indexes; VACUUM optimization; statistics management; memory tuning; and performance troubleshooting.\r\nHigh Availability, Replication, and Scalability\r\nStreaming and logical replication, failover, disaster recovery, read replicas, backup and recovery, and horizontal and vertical scaling.\r\nPostgreSQL Tooling\r\npgAdmin, psql, pg_dump, pg_restore, monitoring tools, WAL management, and migration utilities.\r\nData Quality and Governance\r\nMetadata management, lineage, profiling, validation, reconciliation, and lifecycle management.\r\nETL / ELT\r\nKafka, CDC, batch and real-time pipelines, integration frameworks, and event-driven architectures.\r\nProgramming and Application Development\r\nPython, Java, SQL, Bash, Spring Boot, REST APIs, microservices, Docker, and Kubernetes.\r\nCloud Technologies\r\nAWS RDS, Aurora PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL, Terraform, and CI/CD.\r\nData Security\r\nRBAC, encryption at rest and in transit, auditing, compliance, and PHI, PII, and PCI protection.\r\nHighly Desired\r\nHealthcare experience, database migrations, DevOps automation, GitHub Actions, Jenkins, Azure DevOps, and Ansible.\r\nSoft Skills\r\nProblem-solving, communication, stakeholder engagement, leadership, accountability, and teamwork.\r\nPreferred Qualifications\r\n5 years of PostgreSQL experience, preferably in enterprise-scale database environments.","datePosted":"2026-11-03T02:08:44.359Z","dateModified":"2026-11-03T02:08:44.359Z","hiringOrganization":{"@type":"Organization","name":"Dpr Solutions","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Austin","addressRegion":"TX","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"a1ab0e79609e57d3476c7a17"},"url":"https://jobsearcher.com/jobs/a1ab0e79609e57d3476c7a17"}}