Database Administrator

Northern Base; New Castle (DE); On-site; USD 130,000 - 180,000; Full time

Job summary

Northern Base is seeking a Senior PostgreSQL Database Administrator & Data Engineer to manage PostgreSQL databases across development, test and production, optimize queries, ensure replication, backup, PITR and security.

The role requires 8–12 years of experience, onsite locations in New Castle DE, Jersey City NJ, or Tampa FL, and a hands-on leader who collaborates with architecture, infra, and QA teams. USC/GC preferred; in-person interview.

Qualifications

• 8–12 years of database experience required.
• Expertise in PostgreSQL database administration.
• Advanced SQL development and optimization.
• Strong knowledge of views, procedures, triggers, and analytics.
• Experience with backup, PITR, replication, and high availability.
• Proficient in performance tuning, indexing, and query plans.
• Familiarity with security, encryption, and auditing.

Skills

PostgreSQL Administration

Advanced SQL Development

Complex Queries & Subqueries

Views, Procedures & Triggers

Execution Plan & Tuning

Index Optimization

Locking & Long-Running Transactions

Install/Configure PostgreSQL

Backup & Recovery

PITR

Replication & HA

Capacity & Storage

Monitoring & Maintenance

Security & Compliance

Roles & Authentication

Encryption & Auditing

Data Protection

Data Modeling

Data Modeling (ER Diagrams)

Normalization & Denormalization

Data Quality & Profiling

ETL & Data Integration

Data Mapping & Cleansing

CDC & Incremental Loads

Batch Processing

Production Support & RCA

Data Lineage & Metadata

Education

Bachelor's Degree in Computer Science or related field

Tools

PostgreSQL

ETL Tools

Data Modeling Tools

Job description

Hiring Alert | Database Administrator PostgreSQL & Data Engineering

Location: New Castle, DE / Jersey City, NJ / Tampa, FL (Onsite)

Employment Type: Full-Time

Visa Type: USC / GC / GC-EAD Only

Interview Mode (Final Round): In-Person Interview

Experience Required: 8 12 Years

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