Senior Sql Server Dba

A great opportunity to join our Technology Division, with the platform delivery team who enable Macquarie's global activities by undertaking the design and implementation of IT infrastructure related projects.

As the successful applicant, you will be responsible for delivering solutions and support for our evolving database environment as part of a global team. The database environment is complex, with Oracle, Sybase, SQL Server running on Linux and Windows platforms.

Your responsibilities will include deploying, upgrading and maintaining the database fleet, providing feedback on the health of the environment and creating automation for repeatable requirements. You will need to have recent experience in developing and deploying database server design patterns.

This position will suit you if you are a skilled Senior SQL Server DBA, with a DevOps mindset who has a strong interest in career advancement in a technical stream.

You will be required to be available for after-hours support through a roster based system.

Your day to day responsibilities will include:

• production operational support of Microsoft SQL Server 2008 through to 2016
• automating of SQL Server processes using PowerShell
• creation and management of Splunk and Grafana reports and dashboards
• work with Windows resources on configuring SCOM monitors and rules of the SQL management packs
• work with SCCM security vulnerability management including ongoing upgrade and maintenance of database versioning
• ensuring that SQL Server database systems are built to Macquarie standards and with existing fleet meeting our compliance standards
• proven understanding of the SQL Server Database architecture, internals, clustering and performance tuning
• thorough knowledge of performing SQL Server database restoration under a variety of different scenarios and the information required to support restoration
• troubleshooting production incidents through SSMS, Windows, Cluster and Database logs with clear communication to customers on the issue, root cause and its impact.

It would be highly beneficial to have skills or experience in:

• experience of working within a DevOps team providing 24x7 support for over 100 SQL Servers per support DBA
• programming experience with Python, Java, GO, and/or demonstrable open-source contributions
• experience with supporting partitioned databases over 10TB in size in AlwaysOn Availability Groups.

About the Corporate Operations Group

The Corporate Operations Group brings together specialist support services in Digital Transformation & Data, Technology, Operations, Human Resources, Business Services, Business Improvement & Strategy, and the Macquarie Group Foundation. We deliver service excellence to ensure Macquarie is open for business, deliver on transformational change, invest in our people and have deep relationships with our customers.

Our commitment to Diversity, Equity and Inclusion

The diversity of our people is one of our greatest strengths. An inclusive and equitable environment enables us to deliver innovative and sustainable outcomes for our people, clients, shareholders and communities. From day one, you'll be encouraged to be yourself and supported to perform at your best. If our purpose of ‘empowering people to innovate and invest for a better future’ is as inspiring to you as it is to us, please apply. With the right technology, support and resources, our people can work in a range of flexible ways.

We are committed to providing a working environment that embraces and values diversity, equity and inclusion. We encourage candidates to speak with a member of our recruitment team if you require adjustments to our recruitment process to support you, and the type of working arrangements that would help you thrive.