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 :

J-18808-Ljbffr