Database Administrator, SQL Server

Overview

The primary purpose of the individual is to take complete ownership of all the SQL Server Database Administration within the organisation and provide with an efficient, functional and stable SQL Server database environment across multiple application on premise and in Azure.

The secondary purpose is to provide support to the business and technology departments in the use of MUFG Pension & Market Services SQL Server based systems and database tools and technologies.

Key Accountabilities and main responsibilities

Strategic Focus

• Identify, own and deliver new initiatives in the team.

• Drive innovation using the new features in Database software.

• Assist with the transition to cloud from a Database perspective.

• Identify, collect requirements, develop workflows to automate support processes.

• Analyse, develop and implement process to secure, reduce downtime and optimise Database performance.

Operational Management

Provide administration Support to MUFG’s SQL Server Databases including:

• Maintaining and enhancing current procedures.

• Upgrading and patching SQL Server from earlier versions.

• Backup & Recovery of databases and process improvements.

• Database performance assessment and optimisation.

• Implement technologies related to Replication, Mirroring, Log Shipping, Partitioning.

• Migration and data movement to Azure.

• Respond to and resolve database access and performance issues.

• Working in the context of large (1TB+ databases) and associated performance challenges.

• Supporting metadata packages (SSIS), for reporting purposes.

• Assist in maintaining Data Quality and Data Integrity.

• Ensure adequate capacity for database growth.

• Plan and coordinate data migrations between systems.

• Provide recommendations on systems configuration and operational infrastructure as required by management.

• Adopt and apply best practice approaches for the operating environment.

• Ensure best value for money is obtained from third party vendors by evaluating software tools as required.

• Effective monitoring, system status alerts and escalation where appropriate.

• Perform project and system health checks.

• Raise change controls for defects as required.

• Evaluate software suitability and viability to determine its usefulness in addressing the needs of MUFG.

• Performance tuning of databases, queries & reports.

• Allocating system storage and planning future storage requirements for the database systems.

• Modifying the database structure, as necessary, from information given by application developers and the business.

• User access creation, monitoring and maintenance of system security.

• Build maintain SQL database pipelines in cloud.

• Documentation of procedures and processes.

• Implement and Review Disaster Recovery strategy.

Governance & Risk

• Help resolving Information Security Corrective actions.

• Develop and Maintain Documentation related to Standard Operations Procedures.

• Raising security issues and breaches to Manager.

• Report to Management of any issues that may impact the Business.

• Maintain awareness and champion ITIL best practices.

• Adhere to all MUFG’s standards, policies and procedures.

The above list of key accountabilities is not an exhaustive list and may change from time-to-time based on business needs.

Experience & Personal Attributes

Experience

• Overall 5+ Years with Minimum of 3+ years’ relevant experience working with large SQL Server Database

• Sound knowledge of database architecture, integration issues, third party reporting and data extraction tools.

• Hands on experience with Azure SQL and Azure Data Factory.

• Knowledge and understanding of the Software Development Life Cycle (SDLC)

• Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.

• Experience in Microsoft SQL Server Reporting Services, Analysis Services and SSIS.

• Structured programming methodology, data analysis and design skills - T-SQL & SQL Knowledge.

• Experience in implementing operational automation using scripts.

• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.

• Experience with technical documentation and content management.

• Exposure to business contingency standards and acceptable practices that comply with statutory and audit requirements.

• Microsoft Certification is preferred – MCTS, MCITP.

• Broad knowledge or exposure to financial services/ banking/ accounting applications.

• Experience working with Windows server, including Active Directory and proper disk configurations.

• Database planning and scheduling experience.

• Knowledge of shell scripting (e.g. PowerShell) or any automation tools to make automation processes/dashboards.

• Basic knowledge of PowerBI reporting to support PowerBI gateway and dashboards.

• Ability to investigate, analyse, and resolve data-related issues in a timely and effective manner.

Personal Attributes

• Strong verbal and written communication skills, with the ability to effectively engage and collaborate with global teams and stakeholders.

• Excellent analytical, problem-solving, and troubleshooting skills, with strong technical and programming capabilities.

• Ability to manage and prioritise workloads effectively, working independently with minimal supervision.

• Strong team player with the ability to collaborate effectively within cross-functional teams.

• Demonstrated commitment to continuous improvement and professional development.

• Ability to perform effectively under pressure, balancing competing priorities and delivering timely outcomes.

• Demonstrates flexibility and adaptability to meet changing business and operational requirements.

MUFG Pension & Market Services is a global, digitally enabled business that empowers a brighter future by connecting millions of people with their assets – safely, securely and responsibly.

Through our two businesses MUFG Retirement Solutions and MUFG Corporate Markets, we partner with a diversified portfolio of global clients to provide robust, efficient and scalable services, purpose-built solutions and modern technology platforms that deliver world class outcomes and experiences.

A member of MUFG, a global financial group, we help manage regulatory complexity, improve data management and connect people with their assets, through exceptional user experience that leverages the expertise of our people combined with scalable technology, digital connectivity and data insights.

India Hub is a central part of MUFG's transformation program, which has rapidly expanded over the past 5 years to nearly 1100+ employees, to provide services to our clients across two of our businesses. We have offices in Mumbai and Pune.

India Hub has allowed us to streamline our operations and forms one of our global centres of excellence. This has allowed us to focus our skillsets, innovate our current operations and create new capabilities for the future. The Hub has been designed to support flexible operations processing our three businesses - Retirement Solutions, Corporate Markets and Investor Services. In addition, our Global Functions team provide centralized expertise and support—like HR, Finance, and IT—to ensure consistency, efficiency, and strategic alignment across all business units.

At India Hub, we are building a dynamic, client-focused, caring, and inclusive culture based on entrepreneurial spirit, effective risk management, empathy, and trust, underpinned by core values. We work collaboratively, supporting and valuing the talents and perspectives of our people, and promoting a flexible work environment where their wellbeing is prioritized. We believe diversity drives better client outcomes, improvement, and growth.

Be part of the MUFG Pension & Market Services journey and together we will achieve our full potential. Candidates must have the relevant work rights. Successful applicants must complete background screening before employment.