Database Consultant
hace 1 día
London
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 1. 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 1. 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 1. 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 1. 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 1. 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