Database Administrator
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+21 more
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.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦