BNY is seeking a Vice President, Database Engineer II to lead the design, architecture, and implementation of scalable and secure database solutions for complex financial applications, including MBS pricing, settlement, and reporting systems, while mentoring a team and ensuring performance and reliability.
Requirements
- Deep expertise in Oracle, PL/SQL, and enterprise-grade database technologies.
- Proven experience in the financial services domain, especially mortgage-backed securities (MBS).
- Experience with Git-based workflows (e.g., GitHub, Bitbucket, GitLab).
- Experience integrating databases into CI/CD pipelines using tools like Liquibase, Flyway, Jenkins, or AWS CodePipeline.
- Experience with SQL performance analysis and tuning using Oracle AWR, TKPROF, SQL Trace, and other diagnostic tools.
- Experience with feature flags, blue-green deployments, and observability tooling.
- Experience with financial data standards, MBS reporting formats or regulatory data compliance.
Responsibilities
- Lead the design, architecture, and implementation of scalable and secure database solutions to support complex financial applications, including MBS pricing, settlement, and reporting systems.
- Develop, maintain, and optimize PL/SQL stored procedures, functions, packages, and scripts for high-volume financial data processing.
- Serve as a technical leader and subject matter expert for database design, query optimization, and performance tuning across Oracle and other RDBMS platforms.
- Oversee and mentor a team of database developers and DBAs, promoting best practices in code quality, schema management, and documentation.
- Drive and participate in code reviews using Git-based workflows (e.g., GitHub, Bitbucket, GitLab), ensuring database scripts and migrations meet quality, security, and performance standards.
- Work closely with application teams using branching strategies, pull requests, and version control practices to coordinate changes to database schemas and procedures.
- Partner with development, infrastructure, and DevOps teams to integrate databases into CI/CD pipelines, ensuring safe and repeatable deployments using tools like Liquibase, Flyway, Jenkins, or AWS CodePipeline.
Other
- Bachelor's degree in computer science engineering or a related discipline, or equivalent work experience required.
- 7-10 years of experience in software development required; experience in the securities or financial services industry is a plus; should have thorough knowledge of the software development cycle
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration skills.
- Experience working in Agile/Scrum environments with JIRA, Confluence, Slack, and collaborative development workflows.