Database Engineer III

Job Description:

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day.

Being a Great Place to Work is core to how we drive Responsible Growth. This includes our commitment to being an inclusive workplace, attracting and developing exceptional talent, supporting our teammates’ physical, emotional, and financial wellness, recognizing and rewarding performance, and how we make an impact in the communities we serve.

Bank of America is committed to an in-office culture with specific requirements for office-based attendance and which allows for an appropriate level of flexibility for our teammates and businesses based on role-specific considerations.

At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!

Job Description:
This job is responsible for driving efforts to develop and deliver complex data solutions to accomplish technology and business goals. Key responsibilities include leading code design and delivery tasks with the integration, cleaning, transformation and control of data in operational and analytical data systems. Job expectations include liaising with vendors and working with stakeholders and Product and Software Engineering teams to implement data requirements, analyzing performance, and researching and troubleshooting issues within system engineering domains.

Responsibilities:

• Leads story refinement and delivery of requirements through the delivery lifecycle and assists team members in resolving technical complexities
• Codes complex solutions to integrate, clean, transform, and control data, builds processes supporting data transformation, data structures, metadata, data quality controls, dependency, and workload management, assembles complex data sets, and communicates required information for deployment
• Leads documentation of system requirements, collaborates with development teams to understand data requirements and feasibility, and leverages architectural components to develop client requirements
• Leads testing teams to develop test plans, contributes to existing test suites including integration, regression, and performance, analyzes test reports, identifies test issues and errors, and leads triage of underlying causes
• Leads work efforts with technology partners and stakeholders to close gaps in data management standards adherence, negotiates paths forward by thinking outside the box to identify and communicate solutions to complex problems, and leverages knowledge of information systems, techniques, and processes
• Leads complex information technology projects to ensure on-time delivery and adherence to release processes and risk management and defines and builds data pipelines to enable data-informed decision making
• Mentors Data Engineers to enable continuous development and monitors key performance indicators and internal controls

Position Summary: 

The Authentication Technology Team who supports the Omni channel customer identification and authentication platform is in search of a Database Engineer III, responsible for data solutions and platform stability across a large and complicated database ecosystem.   

Additional Responsibilities:

• Collaborate with architects and development teams to understand data requirements, design new tables/queries and ensure the design is feasible, implemented accurately and compliant with all the bank standards.
• Work with more senior Data Engineers on the team, DevOps and release time to support database deployment using established CI-CD practices and automation tool stack.
• Document and communicate required information for deployment, maintenance, support, and business functionality.
• Adhere to team delivery/release process and cadence pertaining to code deployment and release.
• Identify gaps in data management standards adherence, and work with appropriate partners to develop plans to close gaps.
• Monitor key performance indicators, internal controls and data quality.
• Utilize Oracle tools such as explain plans and OEM [Oracle Enterprise Manager] for performance tuning.

Required Qualifications:

• 5+ years’ experience as an engineer with Oracle database skills and SQL background
• Strong command of Oracle PL\SQL coding and Oracle functions, along with solid understanding of Oracle security features such as database roles and user access, OEM (Oracle Enterprise Manager), and query explain plan
• Understand Oracle partitioning, Oracle Goldengate replication technology, and version 19c features
• Experience in data management, relational data models and OLTP best practices and development models such as Agile and SDLC
• Must be comfortable working on a distributed, multi-time zone team and handle multiple tasks in a constantly changing environment
• Possess strong verbal and written communication skills, along with some Project Management background
• Willingness to learn both new and established database technologies as needed

Desired Qualifications

• Distributed database knowledge
• Basic understanding of networking topology
• Prior experience supporting databases inside a DMZ
• Experience with 3rd party monitoring tools and other database technologies including MSSQL, Cassandra, MongoDB and Cockroach etc.

Skills:

• Analytical Thinking
• Application Development
• Data Management
• DevOps Practices
• Solution Design
• Agile Practices
• Collaboration
• Decision Making
• Risk Management
• Test Engineering
• Architecture
• Business Acumen
• Data Quality Management
• Solution Delivery Process

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Pay Transparency details

US - WA - Seattle - 401 Union St - Rainier Square (WA1510)

Pay and benefits information

Pay range$104,000.00 - $158,200.00 annualized salary, offers to be determined based on experience, education and skill set.

Discretionary incentive eligible

This role is eligible to participate in the annual discretionary plan. Employees are eligible for an annual discretionary award based on their overall individual performance results and behaviors, the performance and contributions of their line of business and/or group; and the overall success of the Company.

Benefits

This role is currently benefits eligible. We provide industry-leading benefits, access to paid time off, resources and support to our employees so they can make a genuine impact and contribute to the sustainable growth of our business and the communities we serve.