Data Engineer II

Primary Talent Partners, LLC; Charlotte (NC); On-site; USD 81,000 - 95,000; Full time

Job summary

Primary Talent Partners is seeking a Data Engineer II for a 12-month contract in Charlotte, NC. You will own operational DBA responsibilities for PostgreSQL and Redshift, ensuring availability, performance, security, backup, and recovery for nuclear data products and analytics workloads.

This W2 contract has no PTO or benefits, ACA-compliant supplemental package available for enrollment. Candidates must be legally authorized to work in the United States and able to sit on the W2 without

Qualifications

• DoE 10 CFR Part 810 compliance and US work authorization required.
• Bachelor’s degree or equivalent in a related field or 7+ years database experience.
• 7+ years progressive DBA experience for production PostgreSQL/Redshift.
• Experience with Redshift distribution, sorting, and performance tuning.
• Familiarity with regulated enterprise environments and change management.

Responsibilities

• Administer PostgreSQL and Redshift in multi-stage environments.
• Manage schemas, objects, users, and permissions with least-privilege access.
• Maintain backups, recovery, and continuity procedures.
• Develop indexing, partitioning, and workload management strategies.
• Monitor availability, performance and incidents; lead triage and RCA.
• Collaborate with engineers on data models, APIs, and integrations.

Skills

PostgreSQL

Redshift

SQL performance

Data modeling

Monitoring

CloudWatch

Automation/CI-CD

Education

Bachelor degree or equivalent experience

Tools

Flyway

Terraform

GitHub

Qlik Replicate

AWS Glue

Power BI / SSRS

Job description

Primary Talent Partners has a new contract opening for a Data Engineer II with our large power and utilities client in Charlotte, NC. This is a 12-month contract with a potential for extension.

Pay: $59.00 - $69.00/hr; W2 contract, no PTO, no Benefits. ACA-compliant supplemental package available for enrollment. Candidates must be legally authorized to work in the United States and must be able to sit on Primary Talent Partners W2 without sponsorship.

Description

NDF and NCRA are seeking an experienced, hands-on Data Engineer to provide operational ownership and technical leadership for PostgreSQL and Amazon Redshift platforms supporting nuclear data products, operational reporting, analytics, integrations, and downstream consumers. The role emphasizes traditional DBA responsibilities: availability, performance, scalability, monitoring, capacity, security, backup and recovery, controlled change, troubleshooting, and production support.

Primary Responsibilities

Database Platform Administration

• Administer PostgreSQL and 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 database standards, operating procedures, dependency maps, support documentation, and runbooks; validate backup, restore, recovery, rollback, and continuity procedures.

Performance, Scalability, and Capacity

• Diagnose slow or resource‑intensive workloads using execution plans, statistics, workload history, waits, locks, system views, and native database diagnostics.
• Implement appropriate 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.

Monitoring, Incident Response, and Support

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

Change Governance and Partnership

• Review database changes for operational risk, cross‑schema and downstream impact, backward compatibility, testing evidence, and rollback readiness.
• Promote governed deployments through approved 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.

Required Qualifications

• Candidates must be able to comply with Department of Energy 10 CFR Part 810 requirements and obtain and maintain all required authorizations, training, access privileges, and approvals necessary to perform assigned duties.
• Candidates must be legally authorized to work in the United States and satisfy all Nuclear employment, access, and regulatory requirements associated with the role.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, Information Systems, or a related field, or equivalent relevant experience.
• Seven or more years of progressive database administration experience supporting production environments.
• Production PostgreSQL administration experience, including performance diagnostics, indexing, statistics, backup and recovery, security, upgrades, and troubleshooting.
• Redshift administration or operational support experience, including query analysis, workload management, distribution and sort design, maintenance, monitoring, and scaling.
• Advanced SQL and execution‑plan analysis skills; experience with RDS or Aurora PostgreSQL, Redshift, CloudWatch, IAM, S3, and Secrets Manager.
• Flyway, Terraform, GitHub, CI/CD, and automated database deployment experience.
• 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.

Primary Talent Partners is an Equal Opportunity / Affluent Action employer committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, age, national origin, disability, protected veteran status, gender identity, or any other factor protected by applicable federal, state, or local laws.

If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at [e-mail].

#PTPJobs