Live opening · Posted 1 day ago
The key details from the original listing.
Description supplied by the original job listing.
Lead Architect – Oracle Analytics, Python & Access Reporting Modernisation
Job Title: Lead Architect / Senior Solution Architect
Workstream: Legacy Reporting Modernisation
Primary Tech Stack: Oracle DB (SQL/PLSQL), OAS, BI Publisher, Python
Legacy Stack: Microsoft Access / VBA / Macros
Environment: Enterprise / Production-Grade
Engagement Type: Full-Time
1. Executive Summary
We are looking for an experienced Lead Oracle Analytics, Python & Access Reporting Modernisation Architect to lead the end-to-end migration of a mission-critical Microsoft Access reporting platform to a modernized, enterprise-grade architecture.
In this role, you will analyze legacy MS Access applications connected to Oracle databases, re-architect complex business logic, and construct a scalable replacement using Oracle Analytics Server (OAS), BI Publisher, Oracle SQL/PLSQL, and Python automation. You will serve as the single lead owner delivering this solution end-to-end.
2. Core ResponsibilitiesA. Discovery & Architecture Assessment
Audit and inventory legacy MS Access databases (.mdb/.accdb), linked Oracle tables, pass-through queries, forms, macros, and VBA modules.
Document current-state reporting workflows, schedules, distribution rules, data refresh intervals, and manual interventions.
Evaluate migration complexity to select the optimal target pattern: OAS-Only, Python-Only, Python + OAS, or a Python Web Portal.
B. Oracle Database Engineering & Tuning
Convert complex Access SQL queries and embedded VBA logic into robust Oracle SQL, views, materialized views, and PL/SQL packages.
Perform high-volume database performance tuning using AWR/ASH reports, execution plans, parallel processing, and TEMP/PGA management.
Implement secure DB connection methods, service account configurations, least-privilege policies, and release controls.
C. OAS & BI Publisher Development
Build interactive OAS dashboards, analyses, prompts, custom filters, and drill-down capabilities.
Create BI Publisher data models, layouts (RTF/Excel/PDF/CSV), bursting definitions, and automated execution schedules.
Migrate Access reports into governed OAS assets aligned with enterprise security models, roles, and folder structures.
D. Python Reporting & Workflow Automation
Design Python jobs using pandas, oracledb/cx_Oracle, SQLAlchemy, openpyxl, XlsxWriter, and NumPy to automate data extraction, transformation, and output generation.
Build audit logging, exception handling, automated retry mechanisms, and data reconciliation checks into all Python jobs.
Integrate execution workflows with enterprise schedulers such as Control-M, AutoSys, or Windows Task Scheduler.
E. Testing, Deployment & Stakeholder Management
Execute unit, regression, system, and parallel-run testing comparing legacy Access outputs with the modern platform.
Prepare comprehensive cutover plans, rollback strategies, production runbooks, and operational documentation.
Provide knowledge transfer to DBA, support, and business operations teams during post-implementation stabilization.
3. Skill Matrix & Requirements
Skill AreaMinimum Required ExperienceKey Focus AreasOracle Database8+ YearsOracle SQL, PL/SQL, Materialized Views, Performance Tuning, Execution PlansOAS / OBIEE5+ YearsOAS Dashboards, RPD/Subject Areas, Prompts, Security & Folder GovernanceBI Publisher5+ YearsData Models, Layout Templates (RTF/Excel), Bursting, SchedulingPython Automation5+ YearsPython 3.x, pandas, oracledb, SQLAlchemy, openpyxl, LoggingMS Access / VBA3+ YearsModernization of legacy .mdb/.accdb, VBA macros, pass-through queriesDevOps & EnterpriseIndustry StandardGit, CI/CD pipelines, Enterprise Schedulers (Control-M/AutoSys)
4. Key Deliverables
Current-State Inventory & Mapping: Complete object catalog of Access databases and source-to-target data lineage mapping.
Target Architecture & Strategy: End-to-end migration blueprint and component design document.
Optimized Core Data Objects: Converted and tuned Oracle SQL/PLSQL code and database objects.
Reporting Assets: Configured OAS dashboards, BI Publisher data models, and scheduled report jobs.
Python Automation Engine: Modular Python scripts for data processing, error handling, and scheduled report generation.
Reconciliation & Handover Package: Parallel-run audit evidence, production runbooks, cutover/rollback plans, and support training materials.
5. How to Apply / Mandatory Details
Interested candidates are invited to submit their application along with the following details:
Current CTC:
Expected CTC:
Notice Period / Availability:
Preferred Work Mode (On-site / Hybrid / Remote):
Please, share your resume to viswa@sharobitech.com
Work arrangement
No
Live timing from JobBeeper.
Recently tracked roles with full details and direct application links.