Lead Data Engineer: PostgreSQL, Cloud Migrations & Streaming

US Tech Solutions; Charlotte (NC); On-site; USD 120,000 - 160,000; Full time

Job summary

US Tech Solutions seeks a Senior Data Engineer to lead data infrastructure and migration initiatives for a next-generation platform. You will design PostgreSQL databases, migrate Oracle on-prem to AWS RDS PostgreSQL, and build real-time data products with Kafka, Flink, and lakehouse tech.

You will craft schemas, ensure data integrity, and implement CDC with thorough documentation. The role emphasizes governance, data cataloging, and collaboration with development teams to support scalable

Qualifications

• Deep proficiency in PostgreSQL database design, administration, and optimization.
• Proven experience migrating large enterprise databases (Oracle to PostgreSQL preferred).
• Hands-on experience with AWS services, especially RDS/EC2.
• Experience with Apache Kafka, Apache Flink, and data lakehouse tech (Hudi/Delta Lake).
• Ability to design normalized/denormalized schemas for OLTP and analytical workloads.
• Experience implementing CDC patterns and audit logging for lineage.

Responsibilities

• Database architecture and design from the ground up for scalable systems.
• Lead migration of Oracle databases to PostgreSQL on AWS.
• Build real-time data products using Kafka, Flink, and lakehouse tech.
• Evaluate and optimize existing schemas for performance and integrity.
• Implement comprehensive CDC and audit solutions for governance.
• Document data catalog and schemas for application teams.

Skills

PostgreSQL design

Data migration

Cloud infrastructure

Streaming & real-time processing

Data modeling

Change data capture

Technical communication

Tools

PostgreSQL

Oracle

AWS

Kafka

Flink

Hudi

Delta Lake

Job description

US Tech Solutions seeks a Senior Data Engineer to lead data infrastructure and migration initiatives for a next-generation platform. You will design PostgreSQL databases, migrate Oracle on-prem to AWS RDS PostgreSQL, and build real-time data products with Kafka, Flink, and lakehouse tech.

You will craft schemas, ensure data integrity, and implement CDC with thorough documentation. The role emphasizes governance, data cataloging, and collaboration with development teams to support scalable