La banque d'un monde qui change

Nous recherchons un

Database Administrator & Middleware Specialist

Marque BNP Paribas Cardif
Niveau d'expérience 3 à 5 ans
Niveau d'études Niveau BAC+2/3
Postuler REF: DAMS/DP/10-19

Responsible for database/application server resources and configuration items, ensuring maximum system availability.

To manage the installation, configuration and management of all MS SQL databases.

To work alongside the Linux and Windows Infrastructure teams and assist with day to day duties.

To provide 3rd-line support for MS SQL systems including out of hours (if required) on a rota basis as defined by the company.

To manage and maintain defined middleware applications and systems.

Key responsibilities:

  • Perform MS SQL DB Migrations
  • Maintaining and recovering database backups
  • Maintaining data reports
  • Management of database configurations
  • Performance monitoring and tuning of databases
  • Reviewing and creating new database processes and procedures
  • Development of database automation solutions
  • Diagnostics and troubleshooting system problems
  • Writing SQL queries/procedures/functions
  • Disaster recovery and business continuity planning
  • Windows and MS SQL Server maintenance
  • Adhere to key policies, procedures and controls in line with company standards
  • Respond (resolve queries/issues) to regular penetration tests and vulnerability scans
  • Provide support in response to requests for technical help
  • Work closely with development teams, architects and environment owners to help design, plan and build infrastructure to meet business requirements
  • Advise on implementing infrastructure technology that improves performance and efficiency of systems and processes
  • Develop personal or technical skills and capability through on-going training as provided by, or approved by HR
  • To participate in maintaining appropriate procedures and standards for development of the Group’s IT business applications
  • Ensure databases and application servers are patched according to Group and Company Standards
  • Perform Releases
  • To participate in Project work, which may include solution and architecture design
  • To ensure Information Continuity capability is adhered to; supporting any tests as required
  •    To ensure compliance with appropriate Group and Industry audit requirements
  • Act, behave appropriately and comply with the internal rules and regulations of BNP Paribas Cardif and with the general ethical standards expected by the BNP Paribas Bank and relevant Regulatory Authorities, particularly in, but not limited to, proactively protecting and safeguarding the interests of its clients, the integrity of the markets and the Group's reputation.
  • Comply with all applicable legal, regulatory and Group's internal Compliance requirements including, but not limited to, Financial Security, Know Your Customer due diligence, International Financial Sanctions, Client Interest Protection, Market Integrity, Data Protection.
  • To carry out any other task associated with the role as reasonably requested

PERSON SPECIFICATION

Required Skills and Work Experience

Essential

  • 5 years+ of solid and proven experience of MS SQL Server database installation and administration across MS SQL Server 2005-2017
  • Experience with MS SQL Server replication; backups and DRS
  • Experience of MS SSRS and MS SSIS
  • Understanding of security and working with servers in DMZs
  • MS SQL Clustering on VMware Environment
  • Experience with designing and implementing MS SQL Server architecture
  • Windows server administration
  • Excellent troubleshooting and documentation skills
  • Excellent communication skills (written, verbal and presentation)
  • Ability to work under pressure and make appropriate decisions
 
 

Desirable

 
  • Educated to Degree level (preferably a computing degree)
  • Experience working on Data warehouse systems
  • VMware Virtualisation Technology
  • Banking or financial services background
  • SentryOne monitoring
  • ITIL v3
  • Experience with Linux operating systems

Any Other Additional Requirements

 
  • Ability to work to a shift rota
  • Ability to provide 24/7 on-call cover on a rota basis (when required)


Essential

  • Educated to Degree level (preferably a computing degree)
 

Desirable


  • MCSA SQL Server
  • Driving license
  • ITIL Foundation
  • Insurance Experience

Primary Location: GB-ENG-HertfordshireJob Type: Standard / PermanentJob: INFORMATION TECHNOLOGYEducation Level: Bachelor Degree or equivalent (>= 3 years)Experience Level: At least 5 yearsSchedule: Full-time Behavioural competency: Creativity & Innovation / Problem solvingTransversal competency: Ability to develop and adapt a process