Database Engineer III- #26-23189

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

We are seeking a Senior Data Engineer to lead critical data infrastructure and migration initiatives for our next-generation application platform. This role is essential for establishing a robust, scalable data foundation as we transition from legacy systems to modern cloud-based architecture.

Key Responsibilities

Database Architecture & Design: Design and implement PostgreSQL databases and schemas from the ground up, ensuring optimal performance, scalability, and maintainability.

Legacy System Migration: Lead the migration of large-scale Oracle databases from on-premises infrastructure to AWS RDS PostgreSQL clusters, managing data integrity and minimizing downtime.

Real-Time Data Products: Build and optimize data products leveraging Apache Kafka, Apache Flink, and Apache Hudi to deliver reliable data streams to downstream consumers.

Schema Analysis & Optimization: Evaluate existing database schemas, identify optimization opportunities, recommend structural improvements, and ensure database integrity throughout changes.

Change Data Capture & Auditing: Design and implement comprehensive change auditing solutions that track data modifications, provide audit trails, and support compliance requirements.

Data Governance & Documentation: Develop and maintain a data catalog and comprehensive schema documentation to facilitate seamless integration with application development teams.

Required Skills & Experience

Database Expertise: Deep proficiency in PostgreSQL database design, administration, and optimization; strong understanding of relational database principles and SQL.

Data Migration: Proven experience migrating large enterprise databases (Oracle to PostgreSQL preferred) with strong change management practices.

Cloud Infrastructure: Hands‑on experience with AWS services, particularly RDS, EC2, and associated networking and security configurations.

Streaming & Real‑Time Processing: Solid experience with Apache Kafka, Apache Flink, and data lakehouse technologies (Hudi, Delta Lake, or similar).

Data Modeling: Ability to design normalized and denormalized schemas, understand trade‑offs, and optimize for both OLTP and analytical workloads.

Change Data Capture (CDC): Experience implementing CDC patterns and audit logging systems for tracking data lineage and changes.

Communication: Strong ability to translate complex data concepts for technical and non‑technical stakeholders; skilled at documenting architectures and schemas.

Preferred Qualifications

Experience with AWS Data Pipeline tools (Glue, Lambda, or Step Functions).

Knowledge of data quality and validation frameworks.

Familiarity with infrastructure-as-code tools (Terraform, CloudFormation).

Prior experience in application modernization or legacy system replacements.

Understanding of data security, encryption, and compliance requirements (GDPR, HIPAA, etc.).

About US Tech Solutions:

US Tech Solutions is a global staff augmentation firm providing a wide range of talent on‑demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.

US Tech Solutions is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

AI Statement:

By applying, you acknowledge that AI-assisted tools may be used during hiring.