Business Functional Analyst - AVP

Job Description:

Job Title Senior Engineer

Corporate Title Assistant Vice President

Location Cary, NC

Who we are:

In short – an essential part of Deutsche Bank’s technology solution, developing applications for key business areas.

Our Technologists drive Cloud, Cyber and business technology strategy while transforming it within a robust, hands-on engineering culture. Learning is a key element of our people strategy, and we have a variety of options for you to develop professionally. Our approach to the future of work champions flexibility and is rooted in the understanding that there have been dramatic shifts in the ways we work.

Having first established a presence in the Americas in the 19th century, Deutsche Bank opened its US technology center in Cary, North Carolina in 2009. Learn more about us here.

Overview

As a Senior Full Stack Developer on our Technology team, you will partner with our global engineering team and business stakeholders to deliver value by building high-quality software products via agile development lifecycle. You contribute to the wider objectives of Account TD to ensure flow, consistent standards and approach to software development and design to a common shared framework. Deutsche Bank is investing heavily in technology, which means we are investing in you. Join us here, and you’ll constantly be looking ahead.

What We Offer You

• A diverse and inclusive environment that embraces change, innovation, and collaboration

• A hybrid working model with up to 60% work from home, allowing for in-office / work from home flexibility, generous vacation, personal and volunteer days

• A commitment to Corporate Social Responsibility

• Employee Resource Groups support an inclusive workplace for everyone and promote community engagement

• Access to a strong network of Communities of Practice connecting you to colleagues with shared interests and values

• Competitive compensation packages including health and wellbeing benefits, retirement savings plans, parental leave, and family building benefits

• Educational resources, matching gift, and volunteer programs

What You’ll Do

• Develop, tune, execute, and manage Oracle PL/Structured Query Language (SQL) stored procedures, functions, packages, and database triggers; Prepare new Oracle platform version rollouts (including testing and documentation)

• Support the data architecture with some data integration, providing support on Oracle Databases Platform used within the Bank; Design, implement, and test solutions, providing support through the production process; Build reliable pipe-lines that is easy to support in production and design and develop high-quality and easily maintainable code

• Monitoring database performance and tuning SQL queries and identifying and resolving scalability issues; You will also be responsible for performance tuning including tuning complex queries to perform on a large historical data

• He/she will also provide subject matter expertise and level 3 support to ensure the smooth running of systems and quick recovery from outages/downtime

• 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; Informatica Extract Transform Load (ETL) and ELT tools from a variety of data sources using batch processing

• Experience creating logical entities and defining their attributes defining the relationships between the various data objects; Developing and amending stored procedures and PL/SQL code to implement business logic

Skills You’ll Need

• Strong knowledge of and experience implementing DevOps best practices including behavior driven development, test driven development and continuous integration/continuous deployment (CI/CD) practices; develop PL/SQL Packages, Stored Procedures, Functions, Triggers, SQL statements in Oracle, and ensuring backup and recovery of all data, for Oracle data using RMAN

• Create tables, views, indexes, triggers, types, packages, and other database objects as needed; Tableau Reporting Tool to modify and build Regulatory report in Tableau; Informatica ETL Tool experience to load data and execute scheduler jobs

• Installation and patching of MS SQL Server Databases on Windows and Installation and patching of Oracle Relational Database Management System (RDBMS) for Oracle EBS on Linux; Also experience designing scalable solutions across techn