AWS Data Engineer II

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 -93

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 reflects a W2 hourly rate; other employment options may be available that may result in pay outside of the provided range.

W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality.
If anyone reaches out to you about an open position connected with Eliassen Group, please ensure that you are working directly with us by confirming the following:

When you work with Eliassen Group, all email communication will come from an Eliassen.com address, never Gmail, Yahoo, etc.

Eliassen Group will never ask you for personal information (home address, bank account, or check routing number) until you have worked with someone clearly associated with Eliassen Group.

If you have any indication of fraudulent activity, please contact .

About Eliassen Group:

Eliassen Group is a strategic consulting firm that helps organizations reach further and achieve more through our technology, business advisory, and life sciences solutions. For nearly 40 years, we have combined exceptional people, deep domain expertise, and intelligent capabilities to expand our clients' capacity and accelerate meaningful outcomes. We are driven by a purpose to positively impact the lives of our employees, clients, consultants, and the communities we serve.

Eliassen is committed to building a diverse and inclusive team from a variety of backgrounds, perspectives, and skills. We are an Equal Opportunity and Affirmative Action Employer and all employment decisions are based on merit, performance, and business needs. Eliassen does not discriminate on the basis of race, color, gender identity or expression, sexual preference or orientation, sex (including pregnancy, childbirth, and related medical conditions), marital status, creed, religion, physical or mental disability, genetic information, military or veteran status, age, ancestry, national origin, citizenship status, prohibited criminal record inquiries of applicants and employees, or any other category protected by federal, state, or local laws.

Don't miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!