SQL Server Database Administrator (SME / Lead)

About the role

XPT Software Australia is seeking a highly experienced and strategic SQL Server SME / Lead to oversee and guide the design, implementation and maintenance of SQL Server environments. The role serves as a subject matter expert, leads a team of database professionals and ensures optimal performance, availability and security of the database systems.

Key responsibilities

• Lead and mentor a team of SQL developers and DBAs.
• Act as the subject matter expert for SQL Server and related technologies.
• Design and implement scalable and efficient database solutions.
• Develop, implement and optimise stored procedures and functions using T-SQL.
• Perform advanced performance tuning, query optimisation and index management.
• Monitor and maintain database health, security and integrity.
• Oversee backup, recovery and archiving procedures.
• Implement high availability and disaster recovery solutions such as Always On, log shipping, replication and mirroring.
• Create and maintain documentation, SOPs and knowledge bases.
• Take part in bridge calls for P1/P2 incidents and provide RCA documentation and evidence for audits.
• Renew certificates for cluster environments.
• Use third-party tools (SNOW, Foglight, AppD, Splunk, DDBoost, control-M, Windows PerfMon, SSRS, FRK, UAR) and plan capacity for production and non-production environments.
• Automate self-healing for common issues, audit logging and compliance reporting.

Required profile

• Minimum 8 years of experience in SQL Server environments, including leadership roles.
• Good understanding of Windows OS administration, DNS, Active Directory and networking concepts.
• Good understanding of T-SQL and PowerShell scripting.