Specialist, Database Developer
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 related teams' objectives
MODIFIED BASED UPON LOCAL REGULATIONS/REQUIREMENTS
Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required
5-7 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.