Database Administrator

Northern Base
New Castle, DE, United States
9 days ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours

Tech stack

Query Performance Application Integration Architecture User Authentication Batch Processing Big Data Databases Data Deduplication Information Engineering Data Integration Data Integrity Extract Transform Load (ETL) Data Mapping
+21 more
Data Profiling Data Recovery Relational Databases Database Queries Database Security Disaster Recovery Entity Relationship Models Failover PostgreSQL Metadata Performance Tuning Release Management Runbook SQL Stored Procedures SQL Databases Data Storage Management System Availability Change Data Capture Information Technology Data Lineage Database Monitoring

Requirements

Must-Have Skills:

PostgreSQL Database Administration

Advanced SQL Development & Optimization

Complex Queries, Joins & Subqueries

Views, Stored Procedures, Functions & Triggers

Execution Plan Analysis & Query Performance Tuning

Index Optimization

Locking, Blocking & Long-Running Transaction Resolution

PostgreSQL Installation, Configuration, Patching & Upgrades

Backup & Recovery

Point-in-Time Recovery (PITR)

Replication, High Availability & Failover

Capacity Planning & Storage Management

Database Monitoring & Routine Maintenance

Database Security & Compliance

Roles, Privileges & Authentication

Encryption & Auditing

Data Protection

Relational Database Design

Conceptual, Logical & Physical Data Modeling

Entity-Relationship Diagrams, Schemas, Tables & Constraints

Normalization & Denormalization

Referential Integrity & Data Quality

Data Profiling, Analysis & Reconciliation

ETL Development & Data Integration

Data Mapping, Cleansing & Transformation

Deduplication, Validation & Error Handling

Incremental Loads & Change Data Capture (CDC)

Large-Volume Batch Processing

Production Support & Root Cause Analysis

Data Lineage, Metadata & Operational Documentation

Preferred Experience:

PostgreSQL Administration across Development, Test & Production

Enterprise Database Architecture

ETL Workflow Scheduling & Production Support

Performance Optimization for Large Data Volumes

Database Disaster Recovery & Recoverability Testing

Data Engineering & Application Integration

Collaboration with Application, Architecture, Infrastructure, QA & Business Teams

Controlled Release Management

Operational Runbook Development

Strong Analytical & Problem-Solving Skills

Bachelor’s Degree in Computer Science or related field

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…