Database SME

ITS A CONTRACT TO HIRE ROLE(C2H)

Role Descriptions: Database SME - MS SQL Database Admin SME with PowerShell skills + performance and tuning + always on

Experience Required: 8+ years

Location - Pune / PAN India

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.