AWS Data Engineer II

aws Data Engineer II

• 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.

• Recruitment Transparency Notice

• Eliassen Group values transparency in our recruitment practices. Please be advised that Eliassen Group utilizes artificial intelligence (AI) tools as part of its initial application screening and hiring process. You may receive email and SMS notifications from the Eliassen Virtual Recruiting Team inviting you to complete a brief voice screening as part of your application process. These tools assist our hiring teams in different ways, including but not limited to, assistance in reviewing application materials to help identify candidates whose qualifications most closely match the requirements of the position. All AI-assisted evaluations and responses are reviewed by human recruiters before any hiring decisions are made. The use of AI in our process is intended to support fairness, efficiency, and consistency, and Eliassen Group takes measures to prevent bias or discrimination in connection with its hiring practices. By proceeding, you acknowledge, agree, and consent to Eliassen Group’s use of these tools, including AI tools, as part of the application and hiring process.

• Skills, experience, and other compensable factors will be considered when determining pay rate. The pay range provided in this posting ref