Data Engineer II

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 / Affirmative 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 info@primarytalentpartners.com

#PTPJobs

#LI-PTP