Senior Oracle ExaCC Developer and BI reporting (Tableau) - VP

Job Title: Senior Oracle Developer

Corporate Title: Vice President

Location: Pune, India

Role Description

• We are looking for a Senior Database Developer with 10–12 years of experience, specializing in Oracle database development, with strong expertise in data warehousing, BI reporting (Tableau), and AI-driven development practices.

• The ideal candidate will have deep experience in designing, developing, and optimizing scalable data solutions, along with the ability to analyze complex data landscapes, understand lineage, and troubleshoot across multiple upstream/downstream systems.

• In addition, the candidate must demonstrate hands-on experience with AI-assisted development (e.g., GitHub Copilot, agents, LLM-based tools, RAG, orchestration frameworks) to improve productivity, quality, and innovation.

• A strong focus on performance engineering, observability, and data reliability, combined with a proactive mindset, ownership, and ability to collaborate across teams, is essential.

What we’ll offer you

As part of our flexible scheme, here are just some of the benefits that you’ll enjoy,

• Best in class leave policy.

• Gender neutral parental leaves

• 100% reimbursement under childcare assistance benefit (gender neutral)

• Sponsorship for Industry relevant certifications and education

• Employee Assistance Program for you and your family members

• Comprehensive Hospitalization Insurance for you and your dependents

• Accident and Term life Insurance

• Complementary Health screening for 35 yrs. and above

Your key responsibilities

• Design, develop, and maintain high-performance Oracle database solutions, including stored procedures, functions, and packages.

• 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

Oracle Skills

• 10–12 years of experience in Oracle database development.

• Strong expertise in:

• PL Oracle SQL & PL/SQL advanced features (bulk processing, collections, pipelined functions)

• Query performance tuning and optimizer behavior

• Oracle partitioning, indexing, and storage management concepts

• Materialized views, refresh strategies, and query rewrite techniques

• Hands-on experience with:

  • AWR/ASH reports analysis for performance tuning

  • Database job scheduling (DBMS_SCHEDULER / Control-M integration)

  • Handling large datasets (TB-scale data processing)

  • Experience with automation of database deployments using CI/CD pipelines

  • Control-M scheduling

  • Unix/Linux scripting

• Strong debugging capabilities across multiple data feeds and systems.

• Ability to analyze and understand complex data lineage.

Tableau & BI Skills

• Expertise in:

  • Tableau dashboard development (complex dashboards, actions, performance tuning)

  • Cross-database joins & data blending

  • TabPy integration

  • API-based integration with external systems

• Experience with SAP BusinessObjects (BO) reporting.

AI & Modern Development (Mandatory)

• Hands-on experience with:

  • GitHub Copilot / AI code assistants

  • AI agents, tools, and orchestration frameworks

• Working knowledge of:

  • LLMs (Large Language Models)

  • RAG (Retrieval-Augmented Generation)

  • MCP / tool integration patterns

• Ability to apply AI for:

  • Code generation & optimization

  • Debugging and root cause analysis

  • Improving developer productivity

Engineering & DevOps Practices

• Strong understanding of:

  • CI/CD pipelines (Jenkins/GitHub Actions)

  • Version control and advanced branching strategies

• Focus on:

  • Observability and system supportability

  • Secure coding practices and vulnerability remediation

Soft Skills

• Strong problem-solving and analytical mindset

• Excellent communication and stakeholder management skills

• Ability to present solutions to both technical and business audiences

• High ownership, independence, and commitment to quality

• Collaborative mindset and respect for diverse perspectives

Preferred Qualifications

• Experience in Investment Banking domain

• Knowledge of Credit Risk and regulatory reporting

• Familiarity with:

• Cloud platforms (GCP/AWS/Azure)

• Monitoring tools (Grafana, ELK, Splunk)

• Exposure to modern data architectures and real-time pipelines

Proven ability to leverage AI tools to enhance productivity, optimise workflows to solve business problems, while applying critical judgment to ensure responsible and ethical use of data and AI outputs.

How we’ll support you

• Training and development to help you excel in your career.

• Coaching and support from experts in your team.

• A culture of continuous learning to aid progression.

• A range of flexible benefits that you can tailor to suit your needs.

About us and our teams

Please visit our company website for further information:

https://www.db.com/company/company.html

We strive for a culture in which we are empowered to excel together every day. This includes acting responsibly, thinking commercially, taking initiative and working collaboratively.

Together we share and celebrate the successes of our people. Together we are Deutsche Bank Group.

We welcome applications from all people and promote a positive, fair and inclusive work environment.