Senior Oracle Developer, VP

Implement and optimize data warehousing solutions to support enterprise reporting and analytics.

Develop and support end-to-end data pipelines, including integration across multiple data sources and feeds.

Perform data analysis, debugging, and root cause investigation across systems, ensuring data accuracy and consistency.

Understand and document data lineage across multiple upstream and downstream systems.

Develop and optimize batch workflows using Control-M and Unix scripting.

Design and deliver BI solutions using Tableau and SAP BO, ensuring scalability and performance.

Build and maintain complex Tableau dashboards, including advanced visualizations and interactivity.

Optimize query performance and ensure efficient data retrieval.

Apply DevOps and automation practices for database development and deployment.

Leverage AI tools (GitHub Copilot, AI agents, LLM-based assistants) to accelerate development and improve code quality.

Design solutions with a focus on observability, monitoring, and supportability.

Collaborate with cross-functional teams including data engineers, UI teams, and business stakeholders.

Ensure adherence to coding standards, security practices, and data governance policies.

Your skills and experience

10+ years of experience in database development.

Expertise in Oracle databases, including ExaCC. With at least 2 years production level exposure to 19c

Strong SQL and PL/SQL programming skills including complex SQL analytics and bulk operations

Comfortable responding quickly and decisively when dealing with production database issues; used to dealing with production DBA’s and open to challenging their recommendations

Indepth knowledge of the Oracle data dictionary, ASH and AWR but not a reliance on pre-canned reports to diagnose performance issues

SME on the inner workings of the Oracle database and not just using the database as a ‘black box’

Familiar with and practical experience of both OLTP and Datawarehouse platforms and how to design and tune accordingly; the difference approaches to coding etc.

Confident talking to data modellers to talk through database design, critiquing and conveying new requirements

Ability to analyse complex legacy code and propose solutions to streamline including implementation of reusable components

Ability to code MVP’s to help demonstrate concepts and approaches to others thinking about the advantages and disadvantages of their own solution.

Terms like context switching, bind variable peeking, cardinality feedback, data skews, histograms, cursor sharing, hard parsing and database waits are all part of your repertoire

Authors like Tom Kyte, Steven Feuerstein, Christian Antognini and Jonathan Lewis are familiar to you

Familiarity with version control systems (e.g., Git).

Excellent analytical and problem-solving skills.

Awareness of container bases deployment ideally OpenShift Container Platform 4.

Experience with Jenkins/GitHub Actions and Maven/Gradle.

Scripting with any scripting system such as Bash/Python/Perl

Strong competency in building and deploying applications using standard build tools.

DevOps mindset with a focus on observability and supportability.

High emotional quotient and respect for diverse opinions.

Independence, drive, commitment to excellence, high standards of workmanship, and dedication to quality.

Proficiency with Test Driven Development and Behaviour Driven Development.

Experience with Liquibase/Flyway

Proficiency in advanced branching and merging concepts.

Strong communication and teamwork skills.

Orientation towards writing safe, secure code that avoids/remediates vulnerabilities early in the development cycle.

Preferred Qualifications