Database Developer, Senior Specialist Database Developer, Senior Specialist …

BNY Mellon
in New York, NY, United States
Permanent, Full time
Be the first to apply
Competitive
BNY Mellon
in New York, NY, United States
Permanent, Full time
Be the first to apply
Competitive
Database Developer, Senior Specialist


Clearing,Markets & Issuer Services Technology (CMIST) is responsible for application development and support for more than 350critical business systems including Repo Edge (collateral management),Enterprise Payment Hub (multi-currency payment processing), and Broker DealerClearance (securities clearing).

Markets& Market Risk Technology (MMRT) within CMIST provides technology management andapplication development for Foreign Exchange (FX), Securities Finance, GlobalCollateral Management, Liquidity Management, and Fixed Income & Equitiesbusinesses. This group also supports the company's market risk and counterpartycredit risk platforms.

SeniorDatabase Developer will have a strong background of SQL and Oracle databasedesign and development experience. Qualified candidates will develop andsupport scalable enterprise databases and ETL solutions. This is a "hands-on"position requiring the candidate to be able to work with applicabletechnologies to develop and maintain databases across the organization, whileensuring high levels of data availability.
Principal Accountabilities:

  • Design,develop, test, tune, and implement database objects and any supporting SQL scriptsusing Microsoft SQL Server or Oracle. This includes but is not limited tostored procedures, views, functions, data manipulation scripts and ETL.

  • Assistdevelopers with complex query tuning and refinement.

  • Designdatabases and queries to optimize performance and scalability.

  • Implementand upgrade databases, automation of data quality rules, naming conventions,optimized queries and indexing.

  • Maintainand enhance the database schema and ETL processes related to the firm'sreporting applications.

  • Experienceand knowledge working with large sets of data (i.e. Data lake).

  • Develop,implement, and maintain change control and testing processes for modificationsto databases.

  • Maintaintechnical documentation and data dictionary as system modifications are made.

Sr.Specialist Database Analyst->> Designs, implements, and supports databasemanagement structures, as well as database back-up, recovery, security,archiving and conversion strategies. Collaborates with application developmentteams on various database issues and takes a lead role in problem resolution.Collaborates and consults with application development teams to determinedatabase/system platform selection, efficient database design, and access.Provides technical assistance and mentoring to staff in all areas of databasesupport. Designs, implements, and maintains physical database structures andassociated network and system configurations. Manages data, maintaining dataintegrity, using effective utility and disk management procedures. Monitorsdatabase and replication servers for resource utilization. Uses knowledge andexpertise of existing database environments to make recommendations foropportunities to share data and/or reduce data redundancies. Assists databaseteam in providing problem identification and resolution support throughanalysis and research. Designs and administers database security strategies.Installs and configures database management system and related distributedsystem software as needed. Contributes to the achievement of area objectives.

Qualifications

  • Bachelor's degree in computerscience or a related discipline, or equivalent work experience required

  • 8-10 years of experience in designand administration of logical and relational databases or systems analysisrequired

  • 5+years of SQL and Oracle database development experience

  • Strongskills in SQL Server 2008/2012/2014

  • Knowledgeof relational database, data warehouse and operational data store design thatlead to support business intelligence solutions/applications.

  • Experiencewith advanced query design, stored procedures, views, functions, index designand

  • T-SQLperformance tuning techniques

  • Experiencewith SQL Server SSIS/SSRS and Pentaho, a plus

  • Attentionto detail and maintaining high quality standards is a must.

  • Abilityto comprehend complex technical and logical concepts and adapt quickly tochange.

  • Stronginterpersonal skills - demonstrate a positive attitude, able to workeffectively as part of a project team and foster team collaboration.

  • Strongcommunications skills; written and verbal

  • Superiororganizational skills; prioritization, planning and time management

  • Experience in the securities orfinancial 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
Close
Loading...