Software Engineer III - Senior Database Developer
New York, New York
**Job Description:**
**Senior Database Developer**
Are you excited by the idea of designing and delivering next generation data warehouse solutions in a rapidly expanding team in a globally recognized financial institution? The senior database developer / architect would be responsible for leading the design and implementation of the data warehouse systems for the Global Markets Equities Data and Analytics group. Join us during this fast paced and exciting period as a leader and mentor within the organization.
**Responsibilities:**
Responsible for designing and developing complex requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. Ensures solutions are well designed with maintainability/ease of integration and testing built-in from the outset. Possess strong proficiency in development and testing practices common to the industry, and have extensive experience of using design and architectural patterns. At this level, specializations start to form in either Architecture, Test Engineering or DevOp. Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements. Utilizes multiple architectural components (across data, application, business) in design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Designs/develops/modifies architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained. Designs/develops/maintains automated test suites (integration, regression, performance). Sets up and develops a continuous integration/continuous delivery pipeline. Automates manual release activities. Mentors other Software Engineers and coaches team on CI-CD practices and automating tool stack. Individual contributor.
+ Translate business and technology requirements into database design models using modeling techniques for mixed workloads, such as OLTP, OLAP, streaming using any formats (structured, semi-structured, unstructured)
+ Lead end-to-end (conception, development, maintenance and evolution) implementation of technology solutions to manage data.
+ Work closely with development, support, DBA and business teams.
+ Perform end to end impact assessment for any technical change and how it may impact upstream and downstream systems and processes.
+ Implementing leading practices in supporting high availability, scalable, process and storage intensive solutions architectures to data integration/migration
**Basic Requirements:**
+ 10+ years of professional database development experience
+ Experience as a delivery lead, mentor and or leading an engineering team
+ Experience with data warehousing, analytics and reporting on a Petabyte scale
+ Proficient in SQL, data modeling, query tuning and optimization
+ Extensive knowledge and hands on experience with SQL writing queries, functions and stored procedures
+ Experience working on Oracle Exadata or HP Vertica (or other MPP databases)
+ Experience developing distributed multi-threaded systems
+ Hands on with scripting Shell, Perl or Python
+ Strong understanding of SDLC and Release Management
+ Ability to work under pressure, facilitate discussions and conduct group meetings
+ Team player with excellent interpersonal skills and integrity
+ Bachelors degree or equivalent in Computer Science or similar required
**Preferred Requirements:**
+ Experience in the financial industry is a plus
+ Knowledge of NoSQL databases / SQL-on-Hadoop technology (Hive, Impala)
+ Interest and experience with emerging DB trends such as data lakes, lake houses, etc.
+ Understanding of big data stack including Apache Storm, Kafka and Cassandra is a plus
+ Experience with BI tools like Cognos and Tableau is a plus
**Bank of America's Global Banking and Markets Technology Organization..**
+ **_Believes diversity makes us stronger so we can reflect, connect and meet the diverse needs of our clients and employees around the world._**
+ **_Is committed to building a workplace where every employee is welcomed and given the support and resources to perform their jobs successfully._**
+ **_Wants to be a great place for people to work and strives to create an environment where all employees have the opportunity to achieve their goals._**
+ **_Provides continuous training and development opportunities to help employees achieve their career goals, whatever their background or experience._**
+ **_Is committed to advancing our tools, technology, and ways of working to better serve our clients and their evolving business needs._**
+ **_Believes in responsible growth and is dedicated to supporting our communities by connecting them to the lending, investing and giving them what they need to remain vibrant and vital._**
**Job Band:**
H5
**Shift:**
1st shift (United States of America)
**Hours Per Week:**
40
**Weekly Schedule:**
**Referral Bonus Amount:**
5000
**Job Description:**
**Senior Database Developer**
Are you excited by the idea of designing and delivering next generation data warehouse solutions in a rapidly expanding team in a globally recognized financial institution? The senior database developer / architect would be responsible for leading the design and implementation of the data warehouse systems for the Global Markets Equities Data and Analytics group. Join us during this fast paced and exciting period as a leader and mentor within the organization.
**Responsibilities:**
Responsible for designing and developing complex requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements. Ensures solutions are well designed with maintainability/ease of integration and testing built-in from the outset. Possess strong proficiency in development and testing practices common to the industry, and have extensive experience of using design and architectural patterns. At this level, specializations start to form in either Architecture, Test Engineering or DevOp. Contributes to story refinement/defining requirements. Participates and guides team in estimating work necessary to realize a story/requirement through the delivery lifecycle. Performs spike/proof of concept as necessary to mitigate risk or implement new ideas. Codes solutions and unit tests to deliver a requirement/story per the defined acceptance criteria and compliance requirements. Utilizes multiple architectural components (across data, application, business) in design and development of client requirements. Assists team with resolving technical complexities involved in realizing story work. Designs/develops/modifies architecture components, application interfaces, and solution enablers while ensuring principal architecture integrity is maintained. Designs/develops/maintains automated test suites (integration, regression, performance). Sets up and develops a continuous integration/continuous delivery pipeline. Automates manual release activities. Mentors other Software Engineers and coaches team on CI-CD practices and automating tool stack. Individual contributor.
+ Translate business and technology requirements into database design models using modeling techniques for mixed workloads, such as OLTP, OLAP, streaming using any formats (structured, semi-structured, unstructured)
+ Lead end-to-end (conception, development, maintenance and evolution) implementation of technology solutions to manage data.
+ Work closely with development, support, DBA and business teams.
+ Perform end to end impact assessment for any technical change and how it may impact upstream and downstream systems and processes.
+ Implementing leading practices in supporting high availability, scalable, process and storage intensive solutions architectures to data integration/migration
**Basic Requirements:**
+ 10+ years of professional database development experience
+ Experience as a delivery lead, mentor and or leading an engineering team
+ Experience with data warehousing, analytics and reporting on a Petabyte scale
+ Proficient in SQL, data modeling, query tuning and optimization
+ Extensive knowledge and hands on experience with SQL writing queries, functions and stored procedures
+ Experience working on Oracle Exadata or HP Vertica (or other MPP databases)
+ Experience developing distributed multi-threaded systems
+ Hands on with scripting Shell, Perl or Python
+ Strong understanding of SDLC and Release Management
+ Ability to work under pressure, facilitate discussions and conduct group meetings
+ Team player with excellent interpersonal skills and integrity
+ Bachelors degree or equivalent in Computer Science or similar required
**Preferred Requirements:**
+ Experience in the financial industry is a plus
+ Knowledge of NoSQL databases / SQL-on-Hadoop technology (Hive, Impala)
+ Interest and experience with emerging DB trends such as data lakes, lake houses, etc.
+ Understanding of big data stack including Apache Storm, Kafka and Cassandra is a plus
+ Experience with BI tools like Cognos and Tableau is a plus
**Bank of America's Global Banking and Markets Technology Organization..**
+ **_Believes diversity makes us stronger so we can reflect, connect and meet the diverse needs of our clients and employees around the world._**
+ **_Is committed to building a workplace where every employee is welcomed and given the support and resources to perform their jobs successfully._**
+ **_Wants to be a great place for people to work and strives to create an environment where all employees have the opportunity to achieve their goals._**
+ **_Provides continuous training and development opportunities to help employees achieve their career goals, whatever their background or experience._**
+ **_Is committed to advancing our tools, technology, and ways of working to better serve our clients and their evolving business needs._**
+ **_Believes in responsible growth and is dedicated to supporting our communities by connecting them to the lending, investing and giving them what they need to remain vibrant and vital._**
**Shift:**
1st shift (United States of America)
**Hours Per Week:**
40
Learn more about this role
Full time
JR-22088727
Band: H5
Manages People: No
Travel: No
Manager:
Talent Acquisition Contact:
Brittany Sherman [C]
Referral Bonus:
5000
Bank of America and its affiliates consider for employment and hire qualified candidates without regard to race, religious creed, religion, color, sex, sexual orientation, genetic information, gender, gender identity, gender expression, age, national origin, ancestry, citizenship, protected veteran or disability status or any factor prohibited by law, and as such affirms in policy and practice to support and promote the concept of equal employment opportunity and affirmative action, in accordance with all applicable federal, state, provincial and municipal laws. The company also prohibits discrimination on other bases such as medical condition, marital status or any other factor that is irrelevant to the performance of our teammates.
To view the "EEO is the Law" poster, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf) .
To view the "EEO is the Law" Supplement, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP\_EEO\_Supplement\_Final\_JRF\_QA\_508c.pdf) .
Bank of America aims to create a workplace free from the dangers and resulting consequences of illegal and illicit drug use and alcohol abuse. Our Drug-Free Workplace and Alcohol Policy (Policy) establishes requirements to prevent the presence or use of illegal or illicit drugs or unauthorized alcohol on Bank of America premises and to provide a safe work environment.
To view Bank of Americas Drug-free workplace and alcohol policy, CLICK HERE .
