Senior Database Administrator, SQL ServerJoin to apply for the Senior Database Administrator, SQL Server role at MUFG Pension & Market ServicesRole purposeThe 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 - MUFG Retirement Solutions businessLocation : Parramatta or Melbourne based candidatesKey Accountabilities and main responsibilitiesDrive innovation and automation using the new features in SQL Server Database softwareAnalyse, develop and implement process to secure, reduce downtime and optimise Database performanceProvide DBA Support to MUFG Retirement Solutions SQL Server Databases including:Maintaining and enhancing current proceduresUpgrading and patching SQL Server from earlier versionsBackup & Recovery of databases and process improvementsDatabase performance assessment and optimisationImplement technologies related to Replication, Mirroring, Log Shipping, Availability groups, PartitioningMigration and data movement to AzureWorking in the context of large (1TB+ databases) and associated performance challengesSupporting metadata packages (SSIS), for reporting purposesAssist in maintaining Data Quality and Data Integrity and ensure adequate capacity for database growthAdopt 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 managementImplement and Review Disaster Recovery strategyCoaches and mentors team members to strengthen specific knowledge/skill within the technology area and support Team Leader as and when requiredDevelop and Maintain Documentation related to Standard Operations Procedures and Maintain awareness and follow ITIL best practicesManage and resolve Information Security Corrective actions and raise security incidents and breaches with managementExperience & Personal AttributesTertiary qualification in Computer ScienceOver 8 Years’ experience in supporting large complex 24x7 application environments in financial services industryExperience supporting multiple large databases on SQL Server hosted on-prem and on Azure and Database DevOps experience is essentialExperience in Supporting multiple Database EnvironmentsSound Knowledge of MSSQL RDBMS and SQL problem solving and scripting is essential.Experience in T-SQL programming, data analysis and designExperience with High Availability and Disaster Recovery processExperience with Performance tuning, performance analysis and resolution.High level of problem-solving skills to handle complex software and interface support issuesAbility to work on call after hours and weekend in a rostered 24x7 environment.Willingness to accept responsibility and be accountable for service providedSound knowledge of MS Office Products and Power BIGood documentation skills and effective oral and written communications skillsExperience in Power BI Gateway management and of Powershell or similar shell scripting languagePreferredExperience in analytics or machine learning platformsAny experience in Alterix, Snowflake, Databricks or similar AI bases platformsExperience in other RDBMS platforms like ORACLE, MYSQL, Postgre SQLSome of our Employment BenefitsFlexiWorks – enabling our employees to work in the office and at homePurchased Leave, Parental Leave, Volunteer Leave, Gender transition leave, Well-being leaveEmployee Recognition Program - to recognise people who are demonstrating our values and Company purpose.Talent Referral ProgramSalary Sacrificing via SuperannuationEmployee Assistance ProgramLearning & Development - Development at your fingertips via self-paced learning, including educational assistance supportEmployee discounts – Access discounted rates and offers from a variety of providers including Bupa and Microsoft!Novated Car LeasingCulture @ MUFG Pension & Market ServicesWe 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 applyReady 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.
#J-18808-Ljbffr