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 technologies, and experience in core java (including multi-threading, performance tuning), Spring framework modules including spring boot and REST micro services Implementing SOX controls on new and existing databases and developing and documenting formal processes and procedures; Experience driving technical deliveries across teams and mentoring and/or managing junior developers Act as a leader and contact person for all Data-related topics and questions - both from the Data Engineers (by actively coaching them) and from the other team members; Should provide active support to rest of the team when needed and have strong communication and collaborative problem-solving skills Skills That Will Help You Excel Goal-focused self-starter mindset with accountability and ownership; Attention to detail, ability to look problems in depth Focuses on business outcomes, starting with the goal in mind ('works from the right') with the ability to create strong relationships between the Business and teams Is passionate about improving our products, our ways of working, each other and ourselves through continuous improvements Control-M Scheduler experience like Control-M preferable; Must have experience using bulk loading methods - Oracle sqlldr, external tables Strong knowledge of and experience implementing DevOps best practices including CI/CD and experience in core java (including multi-threading, performance tuning), Spring framework Expectations It is the Bank's expectation that employees hired into this role will work in the Cary office in accordance with the Bank's hybrid working model. Deutsche Bank provides reasonable accommodations to candidates and employees with a substantiated need based on disability and/or religion. The salary range for this position in Cary is $100,000 to $142,250.Actual salaries may be based on a number of factors including, but not limited to, a candidate's skill set, experience, education, work location and other qualifications. Posted salary ranges do not include incentive compensation or any other type of remuneration. Deutsche Bank Benefits At Deutsche Bank, we recognize that our benefit programs have a profound impact on our colleagues. That's why we are focused on providing benefits and perks that enable our colleagues to live authentically and be their whole selves, at every stage of life. We provide access to physical, emotional, and financial wellness benefits that allow our colleagues to stay financially secure and strike balance between work and home. Click here to learn more Learn more about your life at Deutsche Bank through the eyes of our current employees: https://careers.db.com/life The California Consumer Privacy Act outlines how companies can use personal information. If you are interested in receiving a copy of Deutsche Bank's California Privacy Notice please emailHR.DirectDB.com. LI-HYBRID LI-REMOTE LI-ONSITE 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. We are an Equal Opportunity Employer - Veterans/Disabled and other protected categories. Click these links to view the following notices:EEOC Know Your Rights;Employee Rights and Responsibilities under the Family and Medical Leave Act;Employee Polygraph Protection ActandPay Transparency Nondiscrimination Provision.