ea Change
Oracle Database Administrator
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Oracle Database Design Assurance Lead — Contract — Inside IR35
Duration: 6 months initial, with extension likely
Location: Remote first with occasional travel
Start: Within 2 weeks post offer
Sector: Banking / financial services
The role
A UK bank is running a large-scale data migration against a live Oracle estate. They need an experienced Oracle specialist to sit inside the design authority and make sure nothing reaches production that shouldn't.
This is an assurance and governance role, not a build role. You won't be writing the migration scripts — you'll be reviewing them, challenging them, and setting the conditions under which they're allowed to run against a system that's still serving customers.
What you'll actually be doing
- Reviewing high-level and low-level designs for technical accuracy, supportability, dependencies, capacity constraints, and failure scenarios
- Reviewing SQL, PL/SQL, stored procedures, packages, and extraction scripts — identifying inefficient joins, full table scans, poor cursor handling, inappropriate hints, transaction risk, and restartability gaps
- Assessing performance and capacity impact: execution plans, optimizer behaviour, statistics, indexing, partitioning, wait events, locking, I/O, TEMP, UNDO, archive log, and redo generation
- Protecting live service — recommending safe batch sizes, scheduling windows, query time-outs, throttling, workload isolation, read-only replicas, standby databases, and snapshots
- Supporting full, incremental, and delta extraction, reconciliation, referential integrity, sequencing, cutover, rollback, and validation
- Defining health checks, alerting thresholds, abort criteria, implementation plans, runbooks, backout plans, and post-migration monitoring, within formal change-management governance
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
What we need
Get help with your application
Your very own career expert that helps elevate your application to the next level.
- Extensive hands-on Oracle production DBA background — architecture, configuration, storage, security, availability, performance, and multitenant (CDB/PDB)
- Advanced SQL and PL/SQL review capability, with the confidence to reject a design and explain why
- Strong Data Guard, backup, restore, disaster recovery, RPO/RTO, standby lag, and redo experience
- Proven involvement in large-scale data migrations or bulk extracts against production systems
- Experience operating inside formal change governance — CAB, change freezes, documented backout
Useful, not essential
- Financial services or other regulated, live-service environment
- Exadata or engineered systems exposure
- Oracle GoldenGate, Data Pump
- Prior design authority or technical assurance membership
- OCP or OCM certification
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location