Database Administrator II

Greenlight Professional Services
Richfield, United States of America
1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Richfield, United States of America

Tech stack

Query Performance
Amazon Web Services (AWS)
Bash
Big Data
Configuration Management
Databases
Perl
Python
PostgreSQL
Linux System Administration
Microsoft SQL Server
Oracle
Role-Based Access Control
Red Hat Enterprise Linux - RHEL
Ansible
Data Streaming
Scripting (Bash/Python/Go/Ruby)
GIT
Software Version Control

Requirements

o Proficient in installation, configuration, and maintenance of PostgreSQL databases o Proficient in setting up and managing streaming replication and/or logical replication, and failover mechanisms o Proficient in designing and implementing backup strategies using pg_dump, pg_basebackup and/or pgBackRest and point-in-time recovery o Knowledge of role-based access control o Experience in partitioning and managing large datasets. o Experience with extensions o Proficient in scripting with Bash, Python, or Perl for automation of DBA tasks (e.g., maintenance scripts, monitoring). o Proficient in analyzing PostgreSQL logs for error detection, slow queries, and deadlock resolution. o Proficient in diagnosing and resolving issues like memory bottlenecks and disk I/O problems. o Proficiency in Linux environments (e.g., RHEL) for systems management and troubleshooting.

EXPERIENCE/KNOWLEDGE A PLUS: o EnterpriseDB o Oracle Database o SQL Server o pgwatch2 o Pgpool and/or PgBouncer o optimizing query performance o Git for database code and configuration version control o Ansible for configuration management o Basic knowledge of GDPR, SOC2 Type II compliance standards o AWS

Apply for this position