Oracle DBA

Oracle DBA Up to £550 per day (Inside IR35) 4 MonthsWokingham – 2 days per weekKey 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.