DMS Vision

DMS Vision

·4 days ago

Postgresql developer / database engineer || remote role

Apply now

Location

remote, Frisco, TX, United States

Commitment

Full Time

Level

Senior (5+ years)

Required skills

Container OrchestrationQueuesContainer ManagementTimeseries DatabaseDatabaseStreaming & MessagingSoftwareETLServer ConfigDBaaSOSSCloud ComputingScheduling & OrchestrationSQLDatastoresSaaSApp Definition and DevelopmentProject ManagementIDEFull Stack FrameworkCloud ProductsFrameworksIaaSProgramming LanguagesPaaSEnterprise SoftwareStat Tools & LanguagesDatabasesContinuous Delivery/Deployment (CD)Big Data ToolsCode CollaborationComputeOrchestration & ManagementContinuous Integration (CI)Data Science ToolsDevOpsProvisioningVersion ControlContinuous Integration & DeliveryAutomation & Configuration

Job Description

Hi, Hope you are doing well !! I have an urgent position. Kindly go through the Job description and let me know if this would be of interest to you.

Job Title: PostgreSQL Developer / Database Engineer

Location: Remote role

Duration: 6+ Months Contract

****While sharing resume mention consultant location and visa status***

Job 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

Preferred Qualifications:

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

Thanks & Regards, Abhishek Yadav

DMS Vision Inc. | http://dmsvisions.com/

4645 Avon Lane, Suite 210, Frisco, TX 75033

Email: abhishek@dmsvisions.com | Phone : 972-645-5314 | EXT - 103

Ready to join the team?

Apply now

Similar Jobs: