Database Consultant

• Job Description
• Job Title: Senior Consultant / Lead Engineer / Solution Architect
• /n
• Location: London, UK (Hybrid-3days/week)
• /n
• Duration: 12 Months
• /n
• /n
• Job Description:
• /n
• 1. Role Overview:
• /n

We are seeking an experienced Lead Oracle Analytics & Python Reporting Modernisation Architect to modernise a legacy Microsoft Access reporting solution that connects to Oracle databases, feeds local Access data stores, executes Access queries/macros/VBA, and produces business reports. The resource must be able to assess the current Access application and build a replacement using Oracle Analytics Server (OAS), BI Publisher, Oracle SQL/PLSQL, and Python-based automation where appropriate.

• /n
• 2. Current State and Target Options
• /n
• Option Architecture Best Fit Key Deliverables
• /n
• Option 1 Oracle DB OAS BI Publisher Users Enterprise reporting, dashboards, scheduling, governed access OAS dashboards, BI Publisher reports, data models, schedules
• /n
• Option 2 Oracle DB Python Excel/PDF/CSV Email/SharePoint Replacing Access macros and producing the same report outputs Python reporting framework, Excel templates, batch automation
• /n
• Option 3 Oracle DB Python ETL Oracle tables/views OAS Complex transformations before analytics/reporting Python ETL jobs, staging tables/views, OAS reports
• /n
• Option 4 Oracle DB Python Flask/FastAPI portal Self-service reports User-driven parameterised execution without Access desktop Web UI, API layer, report downloads, authentication pattern
• /n
• /n
• 3. Primary Responsibilities
• /n
• Discovery & Assessment
• /n

Inventory Access databases (.mdb/.accdb), linked tables, pass-through queries, local tables, forms, reports, macros and VBA modules.

/n

Document current report execution process, data refresh steps, schedules, outputs, distribution lists and manual dependencies.

/n

Identify Oracle database objects used by the Access solution and map them to target OAS/Python components.

/n

Assess migration complexity and recommend the right target option: OAS-only, Python-only, Python + OAS, or Python web portal.

• /n
• Oracle Database Engineering
• /n

Develop and tune Oracle SQL, views, materialised views, PL/SQL packages and stored procedures for reporting workloads.

/n

Convert Access SQL/VBA business logic into Oracle SQL, PL/SQL or Python transformations.

/n

Analyse execution plans, AWR/ASH evidence, TEMP/PGA usage and parallel execution behaviour for high-volume reports.

/n

Implement secure database connectivity, service accounts, least-privilege access and production deployment controls.

• /n
• OAS & BI Publisher Development
• /n

Build OAS analyses, dashboards, prompts, filters and drill-down reporting where interactive analytics are required.

/n

Create BI Publisher data models, layouts, Excel/PDF/CSV outputs, bursting, scheduling and job management.

/n

Migrate Access reports into governed OAS/BI Publisher assets with parameterised execution and standardised output formats.

/n

Configure security models aligned with enterprise roles, groups, folders and report access requirements.

• /n
• Python Reporting & Automation
• /n

Design Python jobs to extract Oracle data, apply transformations, validate results and generate Excel/PDF/CSV outputs.

/n

Use Python libraries such as oracledb/cx_Oracle, pandas, SQLAlchemy, openpyxl, XlsxWriter and NumPy.

/n

Implement robust logging, exception handling, audit trails, restartability and data reconciliation checks.

/n

Automate execution using enterprise schedulers such as Control-M, Autosys, Windows Task Scheduler or equivalent.

• /n
• Testing, Deployment & Support
• /n

Create unit, system, regression and parallel-run test evidence comparing Access output with the new platform output.

/n

Prepare implementation plans, rollback plans, production validation steps and operational support runbooks.

/n

Provide knowledge transfer to application support, database, reporting and business operations teams.

/n

Support post-implementation stabilisation, defect remediation and performance tuning.

• /n
• 4. Required Skills
• /n

Microsoft Access databases linked Oracle tables, pass-through queries, macros, VBA, forms and reports to reverse engineer the existing application accurately.

/n

Oracle Database Oracle SQL, PL/SQL, views, materialised views, performance tuning, execution plans to rebuild report logic close to the data and optimise large workloads.

/n

OAS / OBIEE OAS dashboards, analyses, repository/subject area concepts, prompts, filters, security to deliver governed enterprise analytics and self-service reporting.

/n

BI Publisher Data models, RTF/Excel templates, bursting, scheduling, PDF/Excel/CSV outputs to replace scheduled Access reports and standardise enterprise output.

/n

Python Python 3.x, pandas, oracledb/cx_Oracle, SQLAlchemy, openpyxl, XlsxWriter, logging frameworks to replace macros, automate extraction/transformation and generate report packs.

/n

DevOps & Release Git, Azure DevOps/GitHub, CI/CD concepts, deployment documentation, environment management to make the solution maintainable rather than desktop dependent.

• /n
• 5. Experience Profile
• /n

8+ years of Oracle database development and SQL performance tuning experience.

/n

5+ years of OAS/OBIEE and BI Publisher development experience.

/n

5+ years of Python development for data/reporting automation.

/n

3+ years of Microsoft Access/VBA migration or legacy reporting modernisation experience.

/n

Experience working in financial services or another controlled enterprise environment is strongly preferred.

/n

Ability to work independently with business, DBA, infrastructure, security and reporting teams.

• /n
• 6. Expected Deliverables
• /n
• Current-state Access assessment and object inventory
• /n
• Report and data lineage mapping from Access to Oracle/OAS/Python
• /n
• Target-state architecture and migration strategy
• /n
• Converted Oracle SQL/PLSQL objects and performance tuning notes
• /n
• OAS dashboards, BI Publisher reports and schedules where applicable
• /n
• Python automation framework with configuration, logging and error handling
• /n
• Reconciliation evidence between legacy Access output and new output
• /n
• Implementation, rollback and production validation plan
• /n
• Operational runbook and support handover document
• /n
• Knowledge transfer material for support teams and business users
• /n

Report this job