SQL Server/Azure Database Administrator

Softtestpays

Canberra, ACT
Permanent
Full-time

1 month ago
Apply easily

Australian Citizens residing in Australia with ability to obtain Baseline Clearance only respond.

Contract start 07 August 2023 to 12 months, 2 x 12 months extensions.
Australian Citizen, Ability to obtain Baseline Clearance, Canberra role.

Send your responses toOverviewThe Department of Industry, Science and Resources (DISR) strives to encourage the sustainable growth of Australian industries including the delivery of a national innovation system to drive knowledge creation, international competitiveness and greater productivity. The CIO Group provides a range of enabling services and operations delivery to the department and to Australian businesses and are seeking experienced and motivated Cloud Database Analysts with a minimum of 5 years experience to assist with the delivery of various ICT Projects across the Division.The Database Administrator will be required to:

Manage and optimize Azure-based database solutions, including Azure SQL Database and Azure SQL Managed Instance
Troubleshoot common database issues, integrity, performance, blocking and deadlocking, query plan pinning, tuning database queries, replication issues, log shipping issues, connectivity and network issues, security issues, etc. including detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
Monitor and report on database service availability, performance and proactively identify and resolve performance bottlenecks and issues
Perform database capacity planning and ensure scalability and high availability of database systems.
Conduct regular database maintenance activities, including data purging, index rebuilding, and statistics updating.
Create documentation to including reports, processes, procedures, and troubleshooting steps.
Provide technical guidance and input into the design and build of on premise and cloud-based systems
Ensure that the enterprise and system solutions maintain adherence to whole-of-government standards
Work with the delivery manager to support our agile delivery approach
Collaborate and mentor team members and support cross-skilling
Undertake additional duties as required

Every application requires to address selection criteria as part of application submission.Essential Criteria1. Experience with Microsoft SQL (all versions), Windows Servers (all versions), PowerShell scripting, managing backups, replication, log shipping, knowledge in storage Infrastructure, SQL performance monitoring and tuning, security principles and best practicesExperience with SQL Server internals, performance tuning, and query optimizationExperience with Azure SQL Database and Azure SQL Managed Instance, Azure DevOps and Visual Studio for code development, management, repositories, and deployments CI/CDFamiliarity with Azure Data Studio, Azure Portal, and other Azure database management tools.Ability to analyse and troubleshoot database-related issues.Excellent communication and teamwork skills.Experience working with agile multi-disciplinary teams to deliver secure, user friendly and reliable solutions that meet stakeholder, citizen, and business expectations.Ability to pragmatically change direction and scope as new information is discovered and challenges or opportunities present themselvesDesirable Criteria1. Demonstrated track record of technical leadership across project and operational tasksDemonstrated experience and understanding of SQL architecture at an Enterprise LevelDemonstrated experience in Migration of SQL into AzureExperience designing and documenting architectures for large, complex enterprise systems

Softtestpays