Database EngineerBring your ideas. Make history.BNY Mellon offers an exciting array of future-forward careers at the intersection of business, finance, and technology. We are one of the world's top asset management and banking firms that manages trillions of dollars in assets, custody and/or administration. Known as the "bank of banks" - 97% of the world's top banks work with us as we lead and serve our customers into the new era of digital. With over 238 years of rich history and industry firsts, BNY Mellon has been built upon our proven ability to evolve, lead, and drive new ideas at every turn. Today, we're approximately 50,000 employees across 35 countries with a culture that empowers you to grow, take risks, experiment and be yourself. This is what#LifeAtBNYMellonis all about. We're seeking a future team member in the role ofDatabase Engineerto join our Data Engineering team. This role is in Pittsburgh, PA - HYBRID/REMOTE.In this role, you'll make an impact in the following ways: Consults with internal business groups to provide appropriate application software development services or technical support. Provides application software development services or technical support in more complex situations.May also be responsible for requirements gathering and BRD/SRD preparation. Has thorough knowledge of the Software Development Life Cycle. Conducts reviews of the test Plan and test Data. May allocate/ coordinate work within a team/project. The job holder leads the technical design, development, and documentation of cross-functional, multi-platform application systems.S/he analyses, defines, and documents requirements for data, workflow, and logical processes and interfaces with other systems. S/he also ensures that expected application performance levels are achieved by coordinating, coding, testing, implementation, and documentation. Programming well-designed, testable, efficient code. Analyse, design and develop tests and test-automation suites. Develop flowcharts, layouts, and documentation to satisfy requirements and solutions. Maintain software functionality and currency (technical debt and gain). Actively participate in code reviews. Integrate software components into a fully functional software system. Apply security and privacy principles. Created functional requirements and creating reports on databases. Active learning engagement. Complete all required mandatory training / policy awareness curricula on time. Use learning tools such as Pluralsight to complete both recommended and aspirational targets set in personal development plans. Demonstrate teamwork. Leverage existing products/functionality and promote reuse. Work alongside other engineers on the team to elevate technology and consistently apply best practices.To be successful in this role, we're seeking the following: Relevant experience with Oracle 9i and PL-SQL, including index strategies, performance tuning and optimization and stored procedures. Database developers must be able to create Oracle reports and write complex SQL statements for large scale databases. Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required.7-9 years of experience in software development required; experience in the securities or financial services industry is a plus. Job holder must have understanding interdependencies and business impact of future IT plans.Extensive experience with developing and supporting mainframe applications required.S/he must have prior lead experience selecting and implementing vendor-specific methodologies and prior consulting experience with structured methodologies. At BNY Mellon, our inclusive culture speaks for itself. Here's a few of our awards: Fortune World's Most Admired Companies & Top 20 for Diversity and Inclusion Bloomberg's Gender Equality Index (GEI)Human Rights Campaign Foundation, 100% score Corporate Equality IndexBest Places to Work for Disability Inclusion, Disability: IN – 100% score 100 Best Workplaces for Innovators, Fast CompanyCDP's Climate Change 'A List'Our Benefits: BNY Mellon offers highly competitive compensation, benefits, and wellbeing programs rooted in a strong culture of excellence and our pay-for-performance philosophy. We provide access to flexible global resources and tools for your life's journey. Focus on your health, foster your personal resilience, and reach your financial goals as a valued member of our team, along with generous paid leaves that can support you and your family through moments that matter. BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer - Underrepresented racial and ethnic groups/Females/Individuals with Disabilities/Protected Veterans.Consults with internal business groups to provide appropriate application software development services or technical support. Provides application software development services or technical support in more complex situations. May also be responsible for requirements gathering and BRD/SRD preparation. Has thorough knowledge of the Software Development Life Cycle. Conducts reviews of the test Plan and test Data. May allocate/ coordinate work within a team/project. The job holder leads the technical design, development and documentation of cross-functional, multi-platform application systems. S/he analyzes, defines and documents requirements for data, workflow, and logical processes and interfaces with other systems. S/he also ensures that expected application performance levels are achieved by coordinating, coding, testing, implementation and documentation. Programming well-designed, testable, efficient code. Analyze, design and develop tests and test-automation suites. Develop flowcharts, layouts and documentation to satisfy requirements and solutions. Maintain software functionality and currency (technical debt and gain). Actively participate in code reviews. Integrate software components into a fully functional software system. Apply security and privacy principles. Created functional requirements and creating reports on databases. Active learning engagement. Complete all required mandatory training / policy awareness curricula on time. Use learning tools such as Pluralsight to complete both recommended and aspirational targets set in personal development plans. Demonstrate team work. Leverage existing products/functionality and promote reuse. Work alongside other engineers on the team to elevate technology and consistently apply best practices. Collaborate closely with all the other members of the team to take shared responsibility for the overall efforts that the team has committed to. Collaborate cross-functionally with data engineers, business users, project managers and other engineers to achieve elegant solutions. Utilize local meetups to gain and share knowledge. Compiles documentation written by more senior developers of all procedures used in database creation. Acts as a mentor to junior level developers. Relevant experience with Oracle 9i and PL-SQL, including index strategies, performance tuning and optimization and stored procedures. Database developers must be able to create Oracle reports and write complex SQL statements for large scale databases. Communications and organization skills; team work skills ; possess analytical thinking skills. Contributes to the achievement of area objectives. Modified based upon local regulations / requirements. Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required. 7-9 years of experience in software development required; experience in the securities or financial services industry is a plus. Job holder must have understanding interdependencies and business impact of future IT plans. S/he must have prior lead experience selecting and implementing vendor-specific methodologies and prior consulting experience with structured methodologies. Extensive experience with developing and supporting mainframe applications required. Job holder must have broad experience with multi-platform development tools and toolkits. BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer. Minorities/Females/Individuals with Disabilities/Protected Veterans. Our ambition is to build the best global team – one that is representative and inclusive of the diverse talent, clients and communities we work with and serve – and to empower our team to do their best work. We support wellbeing and a balanced life, and offer a range of family-friendly, inclusive employment policies and employee forums.BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer. Minorities/Females/Individuals With Disabilities/Protected Veterans.Our ambition is to build the best global team – one that is representative and inclusive of the diverse talent, clients and communities we work with and serve – and to empower our team to do their best work. We support wellbeing and a balanced life, and offer a range of family-friendly, inclusive employment policies and employee forums.
