Job Description:RoleSQL SME/ Lead Description
of the Role Purpose We are
seeking a highly experienced and strategic SQL SME / Lead to oversee and
guide the design, implementation, and maintenance of SQL Server environments.
The ideal candidate will serve as a subject matter expert, lead a team of
database professionals and ensure optimal performance, availability and
security of database systems.
Experience Minimum 8+
years of experience in SQL Server environments, including leadership roles.capabilitesLead and
mentor a team of SQL developers and DBAs.
Act as the Subject Matter Expert (SME) for SQL Server and related
technologies.
Design and implement scalable and effective database solutions.
Develop, implement, and optimize stored procedures and functions using T-SQL.
Perform advanced performance tuning, query optimization, and index
management.
Monitor and maintain database health, security, and integrity.
Oversee backup, recovery, and archiving procedures.
Implement high availability and disaster recovery solutions (e.g. Always On,




Log Shipping, replication, mirroring, etc.
).
Create and maintain documentation, SOPs and knowledge bases for database operations.
Collaborate with cross-functional teams to understand data needs and deliver
solutions.
Participate in bridge calls for P1/P2 incidents and provide RCA
documentation.
Provide evidences for audit purposes.
Certificate renewal on cluster environment.
Knowledge of 3rd party tools (e.g., SNOW, Foglight, AppD, Splunk, DDBoost,
control-M, Windows Perfmon/ SSRS reports, FRK, UAR) and capacity planning for
both prod & non-prod environments.
Good understanding of Windows OS Administration, DNS, AD & networking
concepts.
Good understanding of T-SQL, PowerShell scripting.
Implement self-healing mechanisms for common database issues using
event-driven automation.
Standardize and automate audit logging and compliance reporting processes.

📌 Sql Serve Database Administrator (Sydney)
🏢 XPT Software Australia Pty
📍 Sydney