Business Functional Analyst - AVP
Cary, 3000 CentreGreen Way
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 processingExperience 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 email HR.Direct@DB.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 Act and Pay Transparency Nondiscrimination Provision.
ApplyJob Profile
Hybrid working model Up to 60% work from home
Benefits/PerksCompetitive compensation Competitive compensation packages Diverse and inclusive environment Educational resources Employee Resource Groups Family building benefits Generous vacation Health and Wellbeing Benefits Hybrid work Hybrid working model Parental leave Personal and volunteer days Retirement savings plans Volunteer programs
Tasks- Design and implement solutions
- Develop and manage SQL procedures
- Ensure documentation is up to date
- Monitor database performance
- Provide level 3 support
- Support data architecture
Agile Attention to detail Behavior Driven Development CI/CD Cloud Communication Continuous delivery Continuous Deployment Continuous Integration Controls Cyber Database Management Data Integration Data Management DevOps Documentation Engineering ETL Excel Java Oracle Performance Tuning PL/SQL Problem-solving REST Self-Starter Spring Boot SQL Tableau Teams Test Driven Development Testing
Education TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9