Database Administrator

Northern Base

Tampa, FL, United States

about 1 month ago

Apply on www.careerjet.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$41,600.0

Working hours

Regular working hours

Job source

www.careerjet.com

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