Database Administrator II
Description:
TECHNICAL SKILL SETS – MUST HAVE:
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