Greenlight Professional Services (GPS)
Database Administrator II
Greenlight Professional Services (GPS), Richfield, Ohio, United States, 44286
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
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