Senior Data Engineer: Cloud Migrations & Real-Time Data

Gravity IT Resources; Charlotte (NC); On-site; USD 120,000 - 180,000; Full time

Job summary

Gravity IT Resources seeks a Senior Data Engineer to lead critical data infrastructure and migration efforts as we move from legacy systems to a modern cloud-based platform.

You will architect PostgreSQL schemas, migrate large Oracle databases to AWS RDS, and build real-time data products with Kafka, Flink, and lakehouse technologies. Strong modeling, CDC, and governance skills are required.

Qualifications

• Experience designing PostgreSQL schemas and optimizing performance.
• Proven data migration experience from Oracle to PostgreSQL or similar.
• Hands-on AWS experience with RDS, EC2, and networking.
• Experience with Kafka, Flink, and lakehouse technologies (Hudi/Delta).
• Ability to design normalized and denormalized schemas for OLTP and analytics.
• Experience implementing CDC and audit logging.
• Strong communication and documentation skills.

Responsibilities

• Database Architecture & Design: design PostgreSQL databases and schemas from the ground up.
• Legacy System Migration: lead migration of Oracle databases to AWS RDS PostgreSQL clusters with minimal downtime.
• Real-Time Data Products: build data products using Kafka and Flink for reliable streams.
• Schema Analysis & Optimization: evaluate and optimize existing schemas for performance and integrity.
• Change Data Capture & Auditing: implement auditing and lineage tracking across systems.
• Data Governance & Documentation: maintain data catalog and schema docs to aid development teams.

Skills

PostgreSQL

Data Migration

AWS

Kafka

Flink

CDC

Data Modeling

SQL

OLTP & Analytics

Tools

AWS RDS

Terraform

CloudFormation

Delta Lake

Hudi

Job description

Gravity IT Resources seeks a Senior Data Engineer to lead critical data infrastructure and migration efforts as we move from legacy systems to a modern cloud-based platform.

You will architect PostgreSQL schemas, migrate large Oracle databases to AWS RDS, and build real-time data products with Kafka, Flink, and lakehouse technologies. Strong modeling, CDC, and governance skills are required.