Oracle DBA

Oracle DBA

Up to £550 per day (Inside IR35)

4 Months

Wokingham - 2 days per week

Key skillset:

Proactive identification and resolution of performance bottlenecks

- Support for strategic data initiatives with deep PostgreSQL domain knowledge

- This dedicated focus ensures the database receives the ongoing care and engineering attention it demands as a critical foundation of the OBP ecosystem.

Enhancements

- Improved Observability: Manage metrics, alerts and dashboard changes & improvements

- Incident Response & Reliability

- Troubleshoot issues or outages: Identify and remediate causes of issues.

- Enhance high availability: Support technologies like EDB Postgres Distributed (PGD)

- Manage disaster recovery: Maintain DR playbooks and test failovers regularly in ORT.

- Performance & Tuning

- Query tuning: Analyse slow queries using EXPLAIN, pg_stat_statements, and index usage.

- Capacity planning: Monitor and forecast resource needs (storage, CPU, memory, IOPS).

- Connection pooling: Tuning to handle large numbers of client connections.

BAU Operations

- Continuously Monitor database health.

- Respond to alerts: Investigate slow queries, replication lag, disk I/O issues, or memory pressure.

- Manage backups: Ensure regular, tested backups

- Support deployments: Coordinate with development squads during schema changes or database-dependent deployments.

- Manage consistency: Review & Report on database instance consistency of data.

To find out more apply to the link.