Vacancy description

SQL Serve Database Administrator in Syd, Australia

XPT Software Australia Pty

  • Full-timeStandard weekly hours

Syd, Australia

Job Description:

Role

SQL 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.

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.


Similar vacancies

More like this role

  • On-site
  • Full-time
  • Contract
Lead SQL Database Administrator | Azure SQL Lead Microsoft SQL database platforms across a complex Australian Government environment, supporting SQL Server, Azure SQL, high availability, performance optimisation and cloud migration initiatives. Location: ACT Contract Duration: 12 months + 2 x 12-month extensions Security ...

Canberra, Australia

  • Full-time

A$16.7 AUD

... What You'll Bring - Strong experience with Microsoft SQL Server environments, including administration, query development, and performance tuning. - Advanced SQL expertise, with the ability to optimise queries, stored procedures, and data processing solutions. - Solid understanding of database fundamentals such as data ...

Canberra, Australia

University Of Western Australia

Database Administrator

  • Full-time
  • Contract

$120,912 - $132,161

... Relevant tertiary qualification or equivalent competency. - Thorough knowledge of database and web technical architectures and integration techniques (particularly SQL Server, MySQL, Oracle, WebLogic, IIS etc.). - Substantial experience in recommending, planning and executing database/web architecture changes to support implementations ...

Crawley, Australia

  • Hybrid
  • On-site
  • Full-time
  • Contract
... stakeholders to ensure database services are secure, resilient, and operating at peak performance. Key Responsibilities - Administer, monitor, and support enterprise database environments including SQL Server, PostgreSQL, and Azure SQL Database. - Design, implement, and maintain database solutions to meet business and operational ...

Australia

  • Hybrid
  • On-site
  • Full-time
  • Part-time
  • Contract
About The Role Kinetic IT has an opportunity for a SQL Database Administrator to join one of our onsite teams delivering managed ICT services to a Federal Government customer. In this position, you will manage and optimise SQL Server database environments, ensuring their performance, availability and security. This is a ...

Canberra, Australia

  • Full-time
... Python). - Proficient in Geobank and preferably also Datashed. - Competent in writing advanced SQL queries. - Able to manage database objects using Microsoft SQL Server Management Studio. - Experience in software configuration and testing (e.g. Geobank, Datashed, OCRIS, Geobank for Field Teams) - SQL Reporting Services ...

Perth, Australia

  • Hybrid
  • Full-time
... systems supporting database workloads, including performance tuning, storage management and security hardening. - Provide Level 2 and Level 3 support for PostgreSQL and Microsoft SQL Server incidents. - Manage database security, including user access, roles and auditing. - Support Microsoft SQL Server environments across ...

Ballarat, Australia

  • Hybrid
  • On-site
  • Full-time
  • Part-time
... Experience with Oracle RAC, Oracle Data Guard, RMAN backup and recovery, and the design of highly available and resilient database platforms. - Advanced capability in SQL and PL/SQL development, database performance tuning, workload optimisation, indexing, partitioning, and capacity management. - Knowledge of Oracle database security, ...

Canberra, Australia

  • Contract
... across existing applications and data structures. - Analyse business and technical requirements and translate them into Natural modules, subprograms, and ADABAS database updates. - Support, optimise, and troubleshoot ADABAS databases, including file structures, performance tuning, and data integrity management. - Work with technical ...

Canberra, Australia

... across existing applications and data structures. - Analyse business and technical requirements and translate them into Natural modules, subprograms, and ADABAS database updates. - Support, optimise, and troubleshoot ADABAS databases, including file structures, performance tuning, and data integrity management. - Work with technical ...

Canberra, Australia