Team Leader, Database Administration

**Overview**

The primary purpose of the Team Leader, Database Administration - SQL Server role is to lead and drive the SQL Database Administration team to provide the organisation with an efficient, secure, functional and stable database environment across multiple platforms on-prem and in Azure cloud.

**Key Accountabilities and main responsibilities**

Strategic Focus
- Identify, take on and deliver new initiatives in the team
- Drive the transition to cloud from a Database perspective.
- Identify, collect requirements, develop workflows to automate DBA processes
- Analyse, develop and implement process to secure, reduce downtime and optimise Database performance

Operational Management
- Lead the SQL Database Administration Team
- Ensure that established procedures, service standards and SLAs are adhered to by the team
- Ensure database security controls adheres to security policies and participate in security audits.
- Provide DBA Support to all Link Group Databases including:

- Maintaining and enhancing current procedures
- Backup & Recovery of databases
- Maintain procedures to reduce downtime and performance degradation.
- Perform Database performance assessment and optimisation.
- Provide Capacity Management and growth forecasting reports to IT management
- Provide recommendations on systems configuration and operational infrastructure as required by management.
- Manage effective monitoring, system status alerts and escalation where appropriate.
- Raise change controls or defects as required.
- Evaluate software suitability and viability to determine its usefulness in addressing the needs of Link.
- Configuration and fine tuning of the databases, queries & reports.
- Review and provide impact assessment for all changes to database proposed by developers
- Contribute to improve efficiency of IT Operations process and procedure
- Provide system and environment related KPIs as required
- Represent the team during incidents by liaising with developers, back end support, database administrators and vendors
- Participate in after hours and weekend support as required.

People Leadership
- Coaches and mentors to develop team members to strengthen specific knowledge/skill within the technology area.
- Identify training needs and resources for the DBA team.
- Provide training to the IT support teams on supported tools and environments
- Prepare support and on call rosters for the team.
- Take over as the 2 IC for the Manager, Database Services as and when required.

Governance & Risk
- Manage and resolve Information Security Corrective actions
- Complete the CSA on time
- Prepare and manage the SQL Database
- 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
- Monitoring service levels for Incidents and Requests and implementing improvement programs to achieve objectives.
- Maintain awareness and champion ITIL best practices
- Adhere to all Link Groups standards, policies and procedures

**Experience & Personal Attributes**
- Tertiary qualification in Computer Science
- Experience in leading a team of SQL Server DBAs
- Experience in Supporting multiple Database on-Prem and in Azure IaaS / PaaS Environments
- Strong knowledge of SQL Server RDBMS and SQL problem solving & scripting skills is essential.
- Sound experience in Azure IaaS and PaaS solutions
- Experience in Microsoft SQL Server Reporting Services, Analysis Services and SSIS
- Experience in managing very large data warehouse and reporting instance
- Experience in Structured programming methodology, data analysis and design skills
- Experience with High Availability and Disaster Recovery technology including new and emerging.
- 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 PorwerBI
- Good documentation skills
- Effective oral and written communications skills

Preferred
- Competency across a blend of operating systems such as Windows and Linux
- Background in financial services and securities industry such as Registry, Broking, Exchange, Superannuation or Trading.
- Experience in other RDBMS streams like PostgreSQL, MySQL, Ingress, Oracle
- Analytical and Systematic approach to work
- Ability to work effectively in a team
- Pleasant and helpful personality

Link Group is a leading fund administration and share registry specialist. We are a market leading provider of technology-enabled administration solutions, continually developing our offerings to expand with our clients' needs. Since our inception, Link Group has been entrusted by clients to handle sensitive data in a secure and confidential manner. Our core businesses of fund administration and securities