SQL Server/Azure Database Administrator

Overview Australian Citizens residing in Australia with ability to obtain Baseline Clearance only respond. Contract Contract start 07 August 2023 to 12 months, 2 x 12 months extensions. Australian Citizen, Ability to obtain Baseline Clearance, Canberra role. About the Role The 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. Responsibilities 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 Selection Every application requires to address selection criteria as part of application submission. Qualifications 1. 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 practices Experience with SQL Server internals, performance tuning, and query optimization Experience with Azure SQL Database and Azure SQL Managed Instance, Azure DevOps and Visual Studio for code development, management, repositories, and deployments CI/CD Familiarity 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 themselves 1. Demonstrated track record of technical leadership across project and operational tasks Demonstrated experience and understanding of SQL architecture at an Enterprise Level Demonstrated experience in Migration of SQL into Azure Experience designing and documenting architectures for large, complex enterprise systems #J-18808-Ljbffr