[Hiring] PostgreSQL Developer / Database Engineer @DMS Vision

Role Description

We are seeking a highly skilled PostgreSQL Developer / Database Engineer with extensive experience designing, developing, optimizing, and supporting enterprise-scale PostgreSQL database solutions. The ideal candidate will have a strong background in database architecture, performance tuning, data integration, and cloud-native database platforms.

• Database Design and Data Modeling:
  • Logical and physical data modeling
  • Normalization and denormalization
  • Entity relationship modeling
  • Partitioning strategies
  • Scalable schema design
• SQL Development and Query Optimization:
  • Complex SQL
  • PL/pgSQL
  • CTEs
  • Window functions
  • Stored procedures
  • Views
  • Materialized views
  • Execution plan analysis
• Performance Tuning and Indexing:
  • B-Tree, Hash, GIN, GiST, BRIN indexes
  • VACUUM optimization
  • Statistics management
  • Memory tuning
  • Performance troubleshooting
• High Availability, Replication, and Scalability:
  • Streaming replication
  • Logical replication
  • Failover
  • Disaster recovery
  • Read replicas
  • Backup and recovery
  • Horizontal and vertical scaling
• PostgreSQL Tooling:
  • pgAdmin
  • psql
  • pg_dump
  • pg_restore
  • Monitoring tools
  • WAL management
  • Migration utilities
• Data Quality and Governance:
  • Metadata management
  • Lineage
  • Profiling
  • Validation
  • Reconciliation
  • Lifecycle management
• ETL / ELT:
  • Kafka
  • CDC
  • Batch and real-time pipelines
  • Integration frameworks
  • Event-driven architectures
• Programming and Application Development:
  • Python
  • Java
  • SQL
  • Bash
  • Spring Boot
  • REST APIs
  • Microservices
  • Docker
  • Kubernetes
• Cloud Technologies:
  • AWS RDS
  • Aurora PostgreSQL
  • Azure Database for PostgreSQL
  • Google Cloud SQL
  • Terraform
  • CI/CD
• Data Security:
  • RBAC
  • Encryption at rest and in transit
  • Auditing
  • Compliance
  • PHI, PII, PCI protection
• Highly Desired:
  • Healthcare experience
  • Database migrations
  • DevOps automation
  • GitHub Actions
  • Jenkins
  • Azure DevOps
  • Ansible
• Soft Skills:
  • Problem solving
  • Communication
  • Stakeholder engagement
  • Leadership
  • Accountability
  • Teamwork

Qualifications

• 5+ years PostgreSQL experience; enterprise-scale database environments preferred.