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.