Role Overview
The Senior Database Administrator Role provides the organisation with an efficient, functional and stable database environment across multiple platforms including on-prem MS Windows and Azure IaaS and PaaS. This includes diagnosis, resolution, root cause analysis of issues and identify and document problem workarounds and provide support for scheduled release upgrades and deployments.
You will ensure that the Database Administration practice follows the Information and data security policies. Also ensure service requests are appropriately actioned according to service levels and performance targets. Provide technical support to core business application environments to ensure 24x7 availability.
* Full time permanent role in the Technology team of Retirement Solutions business
* Parramatta based candidates preferred, open to Melbourne location
Key Accountabilities and main responsibilities
* Drive innovation and automation using the new features in SQL Server Database software
* Analyse, develop and implement process to secure, reduce downtime and optimise Database performance
* Provide DBA Support to MUFG Retirement Solutions SQL Server Databases including:
o Maintaining and enhancing current procedures
o Upgrading and patching SQL Server from earlier versions
o Backup & Recovery of databases and process improvements
o Database performance assessment and optimisation
o Implement technologies related to Replication, Mirroring, Log Shipping, Availability groups, Partitioning
o Migration and data movement to Azure
* 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 and ensure adequate capacity for database growth
* Adopt and apply best practice approaches for the operating environment.
* Effective monitoring, system status alerts and escalation where appropriate.
* Raise change controls for defects as required.
* Evaluate software suitability and viability to determine its usefulness in addressing the needs of MUFG Retirement Solutions.
* User access and security controls management
* Implement and Review Disaster Recovery strategy
* Coaches and mentors team members to strengthen specific knowledge/skill within the technology area and support Team Leader as and when required
* Develop and Maintain Documentation related to Standard Operations Procedures and Maintain awareness and follow ITIL best practices
* Manage and resolve Information Security Corrective actions and raise security incidents and breaches with management
Experience & Personal Attributes
* Tertiary qualification in Computer Science
* Over 8 Years’ experience in supporting large complex 24x7 application environments in financial services industry
* Experience supporting multiple large databases on SQL Server hosted on-prem and on Azure and Database DevOps experience is essential
* Experience in Supporting multiple Database Environments
* Sound Knowledge of MSSQL RDBMS and SQL problem solving and scripting is essential.
* Experience in T-SQL programming, data analysis and design
* Experience with High Availability and Disaster Recovery process
* Experience with Performance tuning, performance analysis and resolution.
* High level of problem-solving skills to handle complex software and interface support issues
* Ability to work on call after hours and weekend in a rostered 24x7 environment.
* Willingness to accept responsibility and be accountable for service provided
* Sound knowledge of MS Office Products and Power BI
* Good documentation skills and effective oral and written communications skills
* Experience in Power BI Gateway management and of Powershell or similar shell scripting language
Preferred
* Experience in analytics or machine learning platforms
* Any experience in Alterix, Snowflake, Databricks or similar AI bases platforms
* Experience in other RDBMS platforms like ORACLE, MYSQL, Postgre SQL
Some of our Employment Benefits
* FlexiWorks – enabling our employees to work in the office and at home
* Purchased Leave, Parental Leave, Volunteer Leave, Gender transition leave, Well-being leave
* Employee Recognition Program - to recognise people who are demonstrating our values and Company purpose.
* Talent Referral Program
* Salary Sacrificing via Superannuation
* Employee Assistance Program
* Learning & Development - Development at your fingertips via self-paced learning, including educational assistance support
* Employee discounts – Access discounted rates and offers from a variety of providers including Bupa and Microsoft!
* Novated Car Leasing
Culture @ MUFG Pension & Market Services
We are an inclusive employer whose people work collaboratively. We encourage, support and value the various talents and perspectives of our people and promote a flexible and blended work environment where our people can thrive, and their wellbeing is supported. We know that diversity drives better client outcomes, continuous improvement, and growth. Be part of our company and together we will achieve our full potential.
We treat all individuals fairly and equitably and do not discriminate on the basis of diverse characteristics including, but not limited to gender, gender identity, sexual orientation, age, ethnicity, cultural background, physical abilities/disabilities, religious or political belief, marital or family status or carers responsibilities.
How to apply
Ready to take the next step in your career? Apply now with your resume and detailed cover letter highlighting your skills, experience, and why you would be a good fit for the role.
Candidates must have the relevant work rights to be considered for an opportunity at MUFG Pension & Market Services. Successful applicants will be required to complete background screening prior to commencement of employment.