Java/oracle,avp

**Job Title
- **AVP- ORACLE DATABASE DEVELOPER**

**Location
- Pune**

**Role Description**

As part of FIC Re-engineering program, our group is building cross-asset Documentation (DICE) and Settlement (CSE) platforms.

**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**
- Develop, tune, execute, and manage Oracle PL/SQL stored procedures, functions, packages and database triggers
- Support the data architecture with some data integration
- Monitoring database performance and tuning SQL queries and identifying and resolving scalability issues
- Developing and amending stored procedures and PL/SQL code to implement business logic
- Providing L2 and L3 support on Oracle Databses Platform used within the Bank
- Design and Creatre new solution for implementation within entire Oracle infrastructure (automatizition, scripting, tools)
- Preapre new Oracle platform version rollouts (including testing and documentation)
- Integrate standard Oracle platform within solution used in wider IT Infra environement (OS, storage, virtualization, security)
- Ensure required documentation is in-place and up to date for all data management solutions
- Collaborate with other internal or external teams on projects such as sourcing data feed, working with vendors
- You will also be responsible for performance tuning including tuning complex queries to perform on a large historical data
- Develop PL/SQL Packages, Stored Procedures, Functions, Triggers, SQL statements in Oracle 12c
- Create tables, views, indexes, triggers, types, packages and other database objects as needed
- Installation and patching of Oracle Relational Database Management System (RDBMS) for Oracle EBS on Linux
- Installation and patching of MS SQL Server Databases on Windows
- Implementing SOX controls on new and existing databases and developing and documenting formal processes and procedures
- Reviewing audit reports and defining / setting up new logging when needed
- Moving changes to the Production environments and tuning / optimizing (PL)/SQL queries
- Ensuring backup and recovery of all data, for Oracle data using RMAN
- Developing scripts for reporting, data manipulation and automation of daily tasks

**Your skills and experience**
- 9-14 years experience developing PL/SQL procedures, functions, packages
- Must have experience using bulk loading methods - Oracle sqlldr, external tables
- Prior experience in performance tuning of database queries, materialized views Or similar (development environment)
- Designs, develops, and supports solutions utilizing Oracle relational database management system
- Experience creating logical entities and defining their attributes defining the relationships between the various data objects
- Excellent knowledge of Oracle Exadata is a must

**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**

Our values define the working environment we strive to create - diverse, supportive and welcoming of different views. We embrace a culture reflecting a variety of perspectives, insights and backgrounds to drive innovation. We build talented and diverse teams to drive business results and encourage our people to develop to their full potential. Talk to us about flexible work arrangements and other initiatives we offer.

Visit Inside Deutsche Bank to discover more about the culture of Deutsche Bank including Diversity, Equity & Inclusion, Leadership, Learning, Future of Work and more besides.