Role: SQL SME/ Lead

Location: Sydney, NSW

Duration: 12 months

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.

capabilites

Lead 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 efficient 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.

Grade 3

Enterprise competencies consulting skills

Expertise effectively exploring alternatives and positions to reach outcomes that gain the acceptance of all parties

Problem Solving

Expertise

Finding relevant information and identifying the key issues and relationships from a base of information relating and comparing data from different sources and identifying cause and effect relationships.

Quality contiuos improvement : Expertise

Manage operations to continuosly improve business operations.

Technical competencies

Bachelor’s degree in Computer Science, Information Technology or related field.

7–12 years of experience in SQL Server environments, including leadership roles.

Strong proficiency in T-SQL, performance tuning, and query optimization.

Experience with monitoring tools (e.g. Foglight, Splunk & native SQL tools).

Familiarity with ITIL processes and incident/change/problem management.

Good understanding of Sybase & Azure MI.

Positive understanding of Windows Server OS and networking fundamentals.

Excellent analytical, communication, and documentation skills.

Preferred Certifications-

Microsoft Certified: Azure Database Administrator Associate or MCSE: Data Management and Analytics.

ITIL Foundation Certification.

Any relevant SQL Server or DBA certifications.

📌 SQLAdministrator (DBA) (Sydney)
🏢 Burgeon IT Services
📍 Sydney