SQL Database Admin

Functional / Technical Competencies: The Database Operations team are responsible for providing 24x7 RDBMS and NoSQL database support in EMEA and internationally

Essential

• Excellent experience of multiple database platforms such as MSSQL and Powershell.

Knowledge of Exadata environment

• Excellent knowledge of configuring Linux and Windows operating systems for optimal database performance.
• Excellent knowledge of networking, storage, server and virtualization layers.
• Excellent knowledge of logical and physical database design.
• Excellent knowledge of database installation and configuration.
• Excellent knowledge of backup and recovery strategies.
• Excellent knowledge of database performance and tuning.
• Excellent knowledge of database migrations and upgrades.
• Excellent knowledge of clustering and high-availability.
• Excellent knowledge of replication and disaster recovery.
• Excellent knowledge of database security and auditing.
• Excellent knowledge of data security governance and regulations such as GDPR and SOX.

Key Responsibilities

• Responsible for database installation, configuration, tuning, upgrades and general maintenance activities.
• Responsible for ensuring that all project/investment related workloads are delivered according to plans and budget defined.
• Responsible for providing consultancy to application support and development teams on database and systems design.
• Responsible for ensuring daily health and compliance checks are performed for all Production systems.
• Responsible for ensuring database systems are backed up successfully and any issues are promptly resolved.
• Responsible for ensuring database jobs are running successfully and any issues are promptly resolved.
• Responsible for ensuring database monitoring alerts are detected promptly and satisfactorily resolved.
• Responsible for ensuring sufficient capacity is available to accommodate projected BAU growth.
• Responsible for ensuring all emails sent to the team distribution list are responded to in a timely manner.
• Responsible for ensuring problem tickets and service requests are handled with efficiency and the customer in mind.
• Responsible for ensuring database platforms are highly available, reliable, secure and performant.
• Responsible for providing technical support to application support and development teams.
• Responsible for executing disaster recovery procedures when necessary.
• Responsible for applying database security updates as per defined policies.
• Responsible for reviewing and subsequently remediating items detected by Qualys vulnerability and compliance scans.
• Responsible for ensuring all operational procedures are kept current and accurate.
• Responsible for participating in On-Call rotation, triaging and addressing production issues as they arise.
• Responsible for identifying cost saving and optimisation opportunities within MUS EMEA and the wider MUFG group.
• Responsible for building strong relationships across the Bank and Securities with other Bank and Securities functions and business areas, underpinned by trust and the core values of the bank.

Skills: database,sme,tuning,powershell,sql