Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy93agl6zg9tl2pwzy9iyw5uzxitzgvmyxvsdc5qcgcixv0

IT Database Administrator (SQL Server and other Midrange Database tools)

IT Database Administrator (SQL Server and other Midrange Database tools)

Job Title: IT Database Administrator (SQL Server and other Midrange Database tools)
Contract Type: Contract
Location: Canberra
Industry:
Salary: Competitive
Start Date: 2021-09-26
Reference: V-39936
Contact Name: Kelly Shockley
Contact Email: kelly@whizdom.com.au
Job Published: September 27, 2021 12:50

Job Description

The Role:

As the Senior Midrange Database administrator, you will provide the expert knowledge:

-             Expert knowledge and experience on MS SQL server (2012,2014,2016 and 2019 including SSIS and SSRS) and database cloud offerings .

                - Azure and AWS SQL server, database offerings (e.g. Postgres, DynamoDB, Mongo dB, etc.)

                -  Cloud specific SQL/database knowledge configuration on IaaS, PaaS

                -  Awareness of the working, pros and cons of different implementation, cloud platforms

                -  AOAG,  HCI cluster, network and storage on the on-prem

-             Database platform Design, process to support and deliver the business requirement and algin with the Department IT security standards 

 

Skills and Experience Required:

- Expert knowledge and experience on PowerShell scripting, especially for SQL server automation,  Performance stats collection,  monitoring  and SQL/database related tools development/deployment.

- Knowledge and experience in developing, implementing and maintaining SQL operational tasks, including maintenance tasks, database backups both native, image backup and other 3rd party solutions.

- Ability to develop, analysis and fix/improve complex SQL queries.

- Ability to manage high severity production incident, identifying cause and providing solutions for SQL related incidents.

- Ability to apply Windows patching and SQL server CU installation

- Experience in assessing the infrastructure and capacity needs of the business and design optimal infrastructure solutions to support ongoing business.

- Be able to provide day to day operational support for applications, on-call support, database design and deployment

- Exposure to No SQL databases

- Skills on estimation and right sizing of the database

- Data migration skills, understanding DMS (Database migration service capability)

- Database performance tuning and monitoring

- Backup recovery for RDS / database as service model of Cloud.

- Defining RPO (Recovery point objective) and RTO (Recovery time objective) skills

- Serverless database skills (Aurora server less) – good to have

- Aurora/scale able  database skills

 

Location and Contract Term: This is a Canberra based role. Contract till May 2022 with 1 x 12 month contract extension options pending budget and delegate approval

 

Security Requirements: Applicants must be Australian Citizens to apply for this role. A baseline security clearance or the ability to obtain and maintain is required.

 

How to Apply:

Applications close 30 September.

Please upload your resume to apply. Please note you may need to complete selection criteria to complete this application process. We will be in touch with instructions for suitably skilled candidates

Call Kelly 1300 944 936 for any further information