Data Engineer

Company introduction 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. Role summary / purpose The role emphasizes traditional DBA responsibilities: availability, performance, scalability, monitoring, capacity, security, backup and recovery, controlled change, troubleshooting, and production support. Key responsibilities • 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. • 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. • 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, 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. Requirements – education & experience • 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, monito…