AWS Data Engineer II

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

Description:

Hybrid 3 days on-site in Charlotte, NC

Our client seeks a hands‑on AWS Data Engineer to own and lead operations for PostgreSQL and Amazon Redshift platforms supporting nuclear data products, reporting, analytics, integrations, and downstream consumers. The role emphasizes traditional DBA responsibilities including availability, performance, scalability, monitoring, capacity, security, backup and recovery, controlled change, troubleshooting, and production support. Candidates must be convertible and meet 10 CFR Part 810 requirements.

Due to client requirements, applicants must be willing and able to work on a w2 basis. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.

Rate: $60.00 to $65.00/hr. w2

JN -102026-109193

Responsibilities:

• Administer PostgreSQL and Amazon Redshift across development, test, QA, and production, including provisioning, configuration, patching, upgrades, maintenance, and lifecycle activities.
• Manage schemas, database objects, extensions, statistics, system catalogs, users, roles, service identities, privileges, and least-privilege access.
• Maintain standards, operating procedures, dependency maps, documentation, and runbooks. Validate backup, restore, recovery, rollback, and continuity procedures.
• Diagnose slow or resource-intensive workloads using execution plans, statistics, workload history, waits, locks, system views, and native diagnostics.
• Implement indexing, statistics, partitioning, materialization, Redshift sort and distribution strategies, workload management, connection, and engine configuration changes.
• Establish performance baselines. Forecast compute, storage, connection, concurrency, workload, and data growth. Recommend scaling, resizing, workload isolation, and archiving strategies.
• Partner with engineering teams to distinguish platform constraints from inefficient SQL, upstream design issues, data-model concerns, or service-level expectations.
• Define actionable monitoring and alerts for availability, connections, CPU, memory, storage, I/O, query duration, queue depth, waits, locks, replication, backups, growth, and failed jobs.
• Use Amazon CloudWatch and native PostgreSQL and Redshift instrumentation to investigate trends, anomalies, and production incidents.
• Lead or support triage, root-cause analysis, corrective actions, and problem-management follow-up. Participate in the production support and on-call model.
• Review database changes for operational risk, impact, backward compatibility, testing evidence, and rollback readiness.
• Promote governed deployments through repositories, Flyway, infrastructure-as-code, and CI/CD processes. Coordinate implementation and post-deployment validation.
• Advise data engineers, report developers, application teams, and architects on database design, SQL performance, security, availability, and supportability.
• Support approved consumers and integrations including APIs, AWS Glue, Qlik, Power BI, Power BI Report Server, and SSRS.

Experience Requirements:

• Ability to comply with Department of Energy 10 CFR Part 810 requirements and obtain and maintain required authorizations, training, access privileges, and approvals. Must be legally authorized to work in the United States and satisfy nuclear employment and regulatory requirements.
• Seven or more years of progressive database administration experience supporting production environments.
• Production PostgreSQL administration, including performance diagnostics, indexing, statistics, backup and recovery, security, upgrades, and troubleshooting.
• Amazon Redshift administration or operational support including query analysis, workload management, distribution and sort design, maintenance, monitoring, and scaling.
• Advanced SQL and execution-plan analysis. Experience with RDS or Aurora PostgreSQL, Redshift, CloudWatch, IAM, S3, and Secrets Manager.
• Experience with Flyway, Terraform, GitHub, CI/CD, and automated database deployments.
• Experience with Qlik Replicate, AWS Glue, Power BI, Power BI Report Server, SSRS, PostgreSQL high availability, Redshift Spectrum, external tables, concurrency scaling, and observability dashboards.
• Experience supporting regulated or highly controlled enterprise environments through formal change, incident, release, security, and access-management processes. Ability to participate in on-call support.

Education Requirements:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, Information Systems, or a related field, or equivalent relevant experience.