Senior Data Engineer: Cloud Modernization & Real-Time Data

Strategic Staffing Solutions; Charlotte (NC); On-site; USD 120,000 - 180,000; Full time

Job summary

Strategic Staffing Solutions seeks a Senior Data Engineer to lead data infrastructure modernization and migration efforts, including Oracle-to-PostgreSQL migrations and AWS-based cloud transition. The role emphasizes building scalable data foundations, governance, and real-time processing capabilities across enterprise systems.

The candidate will design robust PostgreSQL data models, implement CDC and auditing, and collaborate with developers and stakeholders to ensure secure, compliant data

Qualifications

• Strong PostgreSQL expertise including architecture, schema design, SQL, admin, performance tuning.
• Experience with large enterprise migrations; Oracle-to-PostgreSQL preferred.
• Hands-on AWS experience focusing on RDS, EC2, networking and security.
• Experience with streaming/real-time data processing using Kafka and Flink.
• Familiarity with lakehouse tech like Apache Hudi or Delta Lake.

Responsibilities

• Design and build PostgreSQL databases, schemas, and data models with focus on performance and scalability.
• Lead Oracle-to-PostgreSQL migrations to AWS RDS PostgreSQL while minimizing downtime.
• Analyze existing schemas and recommend improvements for modernization.
• Build and optimize real-time data pipelines using Kafka, Flink, and similar lakehouse tech.
• Design and implement CDC, auditing, data lineage, and change-tracking solutions.
• Develop normalized and denormalized models supporting OLTP and analytics.
• Establish data validation and quality controls during migration and modernization.
• Create data catalogs and schema/architectural documentation for teams.
• Collaborate with developers, architects, and stakeholders on modernization initiatives.
• Ensure data security, access controls, encryption, and compliance.

Skills

PostgreSQL

Oracle-to-PostgreSQL migrations

AWS

Data modeling

Real-time data processing

CDC / data lineage

OLTP & analytical workloads

Data security / auditing

Tools

Apache Kafka

Apache Flink

Apache Hudi / Delta Lake

RDS / AWS networking / security

Terraform / CloudFormation

Job description

Strategic Staffing Solutions seeks a Senior Data Engineer to lead data infrastructure modernization and migration efforts, including Oracle-to-PostgreSQL migrations and AWS-based cloud transition. The role emphasizes building scalable data foundations, governance, and real-time processing capabilities across enterprise systems.

The candidate will design robust PostgreSQL data models, implement CDC and auditing, and collaborate with developers and stakeholders to ensure secure, compliant data