We have partnered with our client in their search for a PostgresSQL DBA Engineer.
Responsibilities
Support PostgreSQL Server platforms (PostgreSQL 15)
Provide system design, administration, troubleshooting, monitoring, DB installation, DB backup and restore, database replication setup and maintenance, database development and tuning, user supports, security hardening such as CIS deployment and maintenance.
Research and recommend innovative solutions and where possible automated approaches for system administration tasks
Implement monitoring tools and proactively implement improvement steps to prevent potential issues. Troubleshoot and solve incidents quickly to maintain the high availability environment.
Carry out annual Disaster Recovery test.
Work with Cyber Security and Audit teams to maintain stable and efficient Postgres platform
Late night and weekend work may be necessary at times for installations, patching, upgrades, and maintenance
Follow the change control processes and procedures
The candidate is required to update/maintain all documentation and will be tasked with improving such documentation as required.
Maintain effective communication with the Systems Infrastructure team and management
Skills Required
Experience with PostgreSQL 15 administration.
Experience with installation, configuration, and maintenance of PostgreSQL on Redhat OS
Experience with Linux (Redhat)
Experience with high availability and disaster recovery, backups/restores
Understanding on change control, upgrade, and release deployment activities
Knowledge of database security, access control, monitoring, and auditing
Experience with DB authentication via AD or Azure AD
Experience with monitoring, tuning, and analyzing database performance
Experience with both on-prem and Cloud PostgreSQL
Experience that is a major plus:
Experience with Microsoft SQL Server administration
