BNY Mellon Careers
Database Developer, Senior Specialist
Clearing, Markets & Issuer Services Technology (CMIST) is responsible for application development and support for more than 350 critical business systems including Repo Edge (collateral management), Enterprise Payment Hub (multi-currency payment processing), and Broker Dealer Clearance (securities clearing).
Markets & Market Risk Technology (MMRT) within CMIST provides technology management and application development for Foreign Exchange (FX), Securities Finance, Global Collateral Management, Liquidity Management, and Fixed Income & Equities businesses. This group also supports the company’s market risk and counterparty credit risk platforms.
Senior Database Developer will have a strong background of SQL and Oracle database design and development experience. Qualified candidates will develop and support scalable enterprise databases and ETL solutions. This is a “hands-on” position requiring the candidate to be able to work with applicable technologies to develop and maintain databases across the organization, while ensuring high levels of data availability.Principal Accountabilities:
Design, develop, test, tune, and implement database objects and any supporting SQL scripts using Microsoft SQL Server or Oracle. This includes but is not limited to stored procedures, views, functions, data manipulation scripts and ETL.
Assist developers with complex query tuning and refinement.
Design databases and queries to optimize performance and scalability.
Implement and upgrade databases, automation of data quality rules, naming conventions, optimized queries and indexing.
Maintain and enhance the database schema and ETL processes related to the firm’s reporting applications.
Experience and knowledge working with large sets of data (i.e. Data lake).
Develop, implement, and maintain change control and testing processes for modifications to databases.
Maintain technical documentation and data dictionary as system modifications are made.
Sr. Specialist Database Analyst->> Designs, implements, and supports database management structures, as well as database back-up, recovery, security, archiving and conversion strategies. Collaborates with application development teams on various database issues and takes a lead role in problem resolution. Collaborates and consults with application development teams to determine database/system platform selection, efficient database design, and access. Provides technical assistance and mentoring to staff in all areas of database support. Designs, implements, and maintains physical database structures and associated network and system configurations. Manages data, maintaining data integrity, using effective utility and disk management procedures. Monitors database and replication servers for resource utilization. Uses knowledge and expertise of existing database environments to make recommendations for opportunities to share data and/or reduce data redundancies. Assists database team in providing problem identification and resolution support through analysis and research. Designs and administers database security strategies. Installs and configures database management system and related distributed system software as needed. Contributes to the achievement of area objectives.
Bachelor's degree in computer science or a related discipline, or equivalent work experience required
8-10 years of experience in design and administration of logical and relational databases or systems analysis required
5+ years of SQL and Oracle database development experience
Strong skills in SQL Server 2008/2012/2014
Knowledge of relational database, data warehouse and operational data store design that lead to support business intelligence solutions/applications.
Experience with advanced query design, stored procedures, views, functions, index design and
T-SQL performance tuning techniques
Experience with SQL Server SSIS/SSRS and Pentaho, a plus
Attention to detail and maintaining high quality standards is a must.
Ability to comprehend complex technical and logical concepts and adapt quickly to change.
Strong interpersonal skills – demonstrate a positive attitude, able to work effectively as part of a project team and foster team collaboration.
Strong communications skills; written and verbal
Superior organizational skills; prioritization, planning and time management
Experience in the securities or financial services industry is a plus.
BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer.
Minorities/Females/Individuals With Disabilities/Protected Veterans.
Primary Location: United States-New York-New York
Internal Jobcode: 45152
Job: Information Technology
Organization: Clearing Markets ISS Svcs Tech-HR16624
Requisition Number: 1912916