Overview
Sr. Specialist, Database Developer
Bring 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 #LifeAtBNYMellon is all about.
Want more jobs like this?
Get Data and Analytics jobs in Jersey City, NJ delivered to your inbox every week.
We're seeking a future team member in the role of Sr. Specialist, Database Developer to join our Enterprise Tech team. This role is in Lake Mary, FL and Jersey City, NJ- HYBRID.
Team Overview:
Pershing Technology is the global leader trusted by other global leaders to ideate, innovate, and implement next-generation solutions for trade execution, clearing, custody, and a broad array of the critical technology services upon which enterprises from all segments of the financial markets rely. Building upon world-class infrastructure, Pershing Technology's portals and systems deliver state-of-the art applications that empower our clients to build their businesses and better serve their investors.
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 and provides application software development services or technical support in more complex situations.
- 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.
- Collaborate cross-functionally with data engineers, business users, project managers and other engineers to achieve elegant solutions.
- Leverage existing products/functionality and promote reuse. Work alongside other engineers on the team to elevate technology and consistently apply best practices.
- Ensures that expected application performance levels are achieved by coordinating, coding, testing, implementation and documentation.
- 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.
- Familiar with ERWIN tool, Performing Database migration, Unix Shell Scripts, handling large amount of data, Schema migration using export/import, Database instance provision, Data Replication Techniques, Understanding of Oracle memory architecture & Understanding on AWR/ ADDM/ ASH reports.
- Familiar with Oracle Data dictionary tables, SQL Query tuning, PLSQL tuning, understanding of Liquibase for GIT pipelines, Addressing Row Contentions and long running queries, Understanding on SQL baselines vs SQL Profiles.
- Expertise on Oracle Collections, Bulk Collect techniques & native dynamic SQLs, familiar with composite triggers, materialized views, database partitions.
- Good to have Financial Domain Experience especially in the areas of Custody, Trading and Settlements, Broker Dealer Services
- Bachelor's degree in computer science 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 broad experience with multi-platform development tools and toolkits
- Fortune World's Most Admired Companies & Top 20 for Diversity and Inclusion
- Bloomberg's Gender Equality Index (GEI)
- Best Places to Work for Disability Inclusion , Disability: IN - 100% score
- 100 Best Workplaces for Innovators, Fast Company
- Human Rights Campaign Foundation, 100% score Corporate Equality Index
- CDP's Climate Change 'A List'
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
BNY Mellon assesses market data to ensure a competitive compensation package for our employees. The base salary for this position is expected to be between $91,000 and $169,000 per year at the commencement of employment. However, base salary if hired will be determined on an individualized basis, including as to experience and market location, and is only part of the BNYM total compensation package, which, depending on the position, may also include commission earnings, discretionary bonuses, short and long-term incentive packages, and Company-sponsored benefit programs.
This position is at-will and the Company reserves the right to modify base salary (as well as any other discretionary payment or compensation) at any time, including for reasons related to individual performance, change in geographic location, Company or individual department/team performance, and market factors.
Employer Description:
For over 230 years, the people of BNY Mellon have been at the forefront of finance, expanding the financial markets while supporting investors throughout the investment lifecycle. BNY Mellon can act as a single point of contact for clients looking to create, trade, hold, manage, service, distribute or restructure investments and safeguards nearly one-fifth of the world's financial assets. BNY Mellon remains one of the safest, most trusted and admired companies. Every day our employees make their mark by helping clients better manage and service their financial assets around the world. Whether providing financial services for institutions, corporations or individual investors, clients count on the people of BNY Mellon across time zones and in 35 countries and more than 100 markets. It's the collective ambition, innovative thinking and exceptionally focused client service paired with a commitment to doing what is right that continues to set us apart. Make your mark: bnymellon.com/careers.
EEO Statement:
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.