Purpose:
- We are seeking a highly skilled and experienced Database Administrator with excellent hands-on PostgreSQL skills. The successful candidate will work onsite at our Winchester, UK location and should have experience supporting enterprise IT Platforms on-premises
- Key accountabilities:
- Deploy, administer, and maintain PostgreSQL database using industry-standard best practices.
- Conduct PostgreSQL backup & recovery, disaster recovery, including testing recoverability and recommending improvements to ensure 24/7 system availability.
- Implement PostgreSQL high availability & clustering solutions and manage Standby databases (hot/cold) including binary streaming replication and cross-site replication.
- Perform PostgreSQL DB performance tuning and bottleneck analysis, and advise the development community on code improvements.
- Use Postgres tools to optimize PostgreSQL query execution, explain plans, and enhance system efficiency.
- Monitor PostgreSQL database using tools such as SolarWinds, VRops, PgAdmin4, and home-grown scripts.
- Troubleshoot database related issues, corruption, and system failures.
- Manage PostgreSQL database security including permission, user access control, authentication, auditing, and vulnerability.
- Handle PostgreSQL networking and connection pooling as well as migration strategy, data migration, upgrades, release & version management.
- Plan capacity management and provide PostgreSQL object storage management and system resources reports.
- Identify tasks that can be automated with scripts and maintain relevant Postgres documentation, configuration details, procedures, checklists, and report deviations
Essential skills, experience and qualifications:
- Profound PostgreSQL skills including deployment, administration, and troubleshooting.
- Knowledge of Redhat (6-8) or other Distro is essential.
- Scripting knowledge including Bash, CLI, Terraform, etc.
- Budding capacity in VMware vSphere, Gitlab, Github, Ansible, Terraform, and other automation and config tooling.
- Familiarity with Oracle OEM tool would be advantageous.
- Knowledge of Oracle E-business suite 12.2 Database and applications would be valuable.
- Ability to attain SC Level Clearance.