Database Administrator II

TECHNICAL SKILL SETS – MUST HAVE: Proficient in installation, configuration, and maintenance of PostgreSQL databases Proficient in setting up and managing streaming replication and/or logical replication, and failover mechanisms Proficient in designing and implementing backup strategies using pg_dump, pg_basebackup and/or pgBackRest and point-in-time recovery Knowledge of role-based access control Experience in partitioning and managing large datasets. Experience with extensions Proficient in scripting with Bash, Python, or Perl for automation of DBA tasks (e.g., maintenance scripts, monitoring). Proficient in analyzing PostgreSQL logs for error detection, slow queries, and deadlock resolution. Proficient in diagnosing and resolving issues like memory bottlenecks and disk I/O problems. Proficiency in Linux environments (e.g., RHEL) for systems management and troubleshooting. EXPERIENCE/KNOWLEDGE A PLUS: EnterpriseDB Oracle Database SQL Server pgwatch2 Pgpool and/or PgBouncer optimizing query performance Git for database code and configuration version control Ansible for configuration management Basic knowledge of GDPR, SOC2 Type II compliance standards AWS

#J-18808-Ljbffr