Description

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

Key Skills

Education

Bachelor's degree