Lead Database Analyst

  • Competitive
  • London, England, United Kingdom London England GB
  • Permanent, Full time
  • BNY Mellon
  • 13 Aug 18 2018-08-13

Lead Database Analyst


The Production Services department is responsible for supporting our offices in London, Dublin and Liverpool with users spread across all sites with a resilient DR capacity at a separate site.

Current systems run in both the Microsoft O/S environment and the Unisys Libra mainframe environment(MCP, DMSII and AB Suite)

Within Production Services, The DBA team specifically provides database and server administration, tuning and maintenance, but also other technical duties as required. On the mainframe side, responsibilities are much broader that just data administration and cover many aspects of server administration.


The priority for the role is to have strong, 'Senior SME' level hands-on technical skills related to the Unisys mainframe.


o Ensure the Remedy Incident queue is kept within SLAs and changes are closed on time

o Ensure regular DMSII maintenance jobs are run, including index defragmentation, BCV proving, backup restore tests

o Ensure backups/audit backups are secured for the Mainframe system as per business need with the appropriate retention policies

o Keeping up-to-date with new features/technology developments/industry practices and proposing those that we should consider making use of

o To undertake the daily actions defined on the relevant site checklist


• Technical Skills

o To support the road map for the mainframe

o To implement or follow best practice for system administration

o To understand interaction and importance of all systems inside immediate control

o General understanding of all business critical systems

o Liaising with 3rd party suppliers in a professional manner

o To ensure that the technology environment is secure at all times

o Inform immediate management of any risks to our systems as soon as they become apparent

o Ensure the integrity of procedures created within team

o Ensure adequate monitoring of systems and procedures under control of the team to minimise downtime

o To ensure DR capability and over all integrity of the systems that fall under your control

• Representing the Team to the business and other senior stakeholders, in the absence of the Team Lead, and or during Priority incidents

• Staff Management

o To be able to offer support and lead the team in the absence of the team lead.

• Projects And Change

o Carrying out ongoing projects on a day-to-day basis

o Following Change Control documentation procedures and also updating new procedures

o To be able to represent DBA as a stakeholder during project implementation and transition

• Working Hours

o Associates will be required to work on a rota for: - early, late and on-call shifts

o Weekend work is also expected

Technical Knowledge

• Mandatory

o Thorough Unisys Database Server knowledge of current versions (DMSII)

o Thorough knowledge of DMS tools and administration tasks (such as DBA Tools, reorganisations, etc.)

o Knowledge of replication products and services (e.g. Databridge)

o Good understanding of the MCP Operating System

o Reasonable understanding of Networking

o Basic understanding of the SAN environment (EMC VMAX), geo-clustering, SnapVX, BCV and SRDF

o An understanding of how a helpdesk call should be processed and escalated when necessary

o Good knowledge of Backup, Restore and DR processes/design (using DMS Utility and BCA)

o Good knowledge of performance monitoring, performance analysis and capacity planning using tools such as GPM and Workload Manager

o Understanding of Change Control systems and processes

o Understanding of performance/risk indicators

• Desirable

o Software Certification is desirable but not essential if substituted by over 3 years relevant IT experience.

o Experience working on large and small scale projects

o Exposure to database design (including normalisation/de-normalisation)

o Exposure to design tools (such as Team Foundation Studio)


o Experience of working with off-shore teams

o Cobol, Algol

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 & 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.

Pershing provides critical business process, financial and technology solutions for financial organizations around the globe. We operate behind the scenes to power transformational change for broker-dealers, registered investment advisors, independent financial advisers, hedge fund and '40 Act fund managers and individual investors. We strive to be innovators, developing open architecture technology and financial solutions to support our customers' growth. We advocate on behalf of our customers and help them respond to regulatory reform and drive positive outcomes for our industry and investors. From our core business as an industry-leading trade execution, clearing and custody provider, we have evolved into a global multifaceted firm that provides investment solutions, forward-thinking technology-driven efficiencies, practice management and service excellence.

BNY Mellon is an Equal Employment Opportunity Employer.

Primary Location: United Kingdom-Greater Manchester-Manchester
Job: Information Technology
Internal Jobcode: 60093
Organization: Pershing Domestic-HR06431
Requisition Number: 1806932