Hybrid AWS Data Engineer II: PostgreSQL & Redshift Expert

Eliassen Group; Charlotte (NC); Hybrid; USD 83,000 - 90,000; Full time

Job summary

Eliassen Group seeks a hands-on AWS Data Engineer to own PostgreSQL and Redshift operations in a hybrid Charlotte, NC role, 3 days on-site. You will ensure availability, performance, security, backups, and production support for nuclear data products and downstream integrations.

Responsibilities include tuning, monitoring, change management, and collaboration with engineers on data models and reports. DOE 10 CFR Part 810 compliance is required for this role.

Qualifications

• 7+ years of progressive database administration experience in production environments.
• Strong PostgreSQL and Redshift administration including performance tuning, backups, security, and upgrades.
• Experience with regulated enterprise environments and formal change, incident, release and access-management processes.
• Advanced SQL and execution-plan analysis; familiarity with RDS/Aurora PostgreSQL, CloudWatch, IAM and S3.

Responsibilities

• Administer PostgreSQL and Redshift across development, test, QA, and production, including provisioning, patching, upgrades, and lifecycle activities.
• Manage schemas, objects, privileges, and least-privilege access; maintain runbooks and documentation.
• Validate backups, restore, recovery, rollback, and continuity procedures; monitor performance and capacity.
• Define monitoring and alerts for availability, connections, CPU, memory, storage, and concurrency; respond to incidents.
• Lead or support root-cause analysis, on-call support, and post-incident follow-ups.
• Coordinate deployments using Flyway, IaC, and CI/CD; advise teams on design, security, and availability.

Skills

Advanced SQL

Execution plan analysis

On-call support

Security and access control

Regulatory compliance

Education

Bachelor's degree in CS/IT/Engineering

Tools

PostgreSQL

Amazon Redshift

RDS/Aurora PostgreSQL

CloudWatch

IAM

S3

Secrets Manager

Flyway

Terraform

GitHub

CI/CD

AWS Glue

Qlik Replicate

Power BI

Power BI Report Server

SSRS

Redshift Spectrum

Job description

Eliassen Group seeks a hands-on AWS Data Engineer to own PostgreSQL and Redshift operations in a hybrid Charlotte, NC role, 3 days on-site. You will ensure availability, performance, security, backups, and production support for nuclear data products and downstream integrations.

Responsibilities include tuning, monitoring, change management, and collaboration with engineers on data models and reports. DOE 10 CFR Part 810 compliance is required for this role.