Database Administrator

• Join an innovative and creative team
• 
  Adaptive and flexible working environment focussed on transformation of business process
• 
  Commitment to training and professional development
• 
  Good work/life balance with hybrid working arrangements

The Database Administrator role provides an excellent opportunity for an enthusiastic individual to develop their skills and support Council’s data journey to present a single view of our customers, power our operations and to drive better decision making through the use of data.

Council’s technology systems are based on a hybrid cloud/datacentre approach, with a combination of MS SQL server database servers on premise and a planned transition to the cloud. Council has recently commenced build of a data warehouse using Azure Synapse, populated through Datafactory ETL tools and seeks a database administrator to assist the organisation to manage the transition as well as supporting current operations.

Council’s core systems include the TechnologyOne Financials product, Infor Pathway property, rating and licensing product, Microfocus Content Manager (TRIM) for unstructured data, and a number of bespoke departmental systems to manage diverse activities across the organisation including waste management, leisure centre, childcare and libraries. Council has adopted the Microsoft platform to power remote working and collaboration systems.

The successful candidate will be embedded in Council’s Enterprise Content Management section, and will help on the transformation of unstructured data to structured data by utilising online forms available in the existing products; will assist the Data Architect on the build out of the data warehouse; and will assist the business to make decisions through the use of effective reports and dashboards. As such, the ideal candidate will have a good understanding of both applications and the databases behind them, ETL and integration approaches, dashboarding and reporting tools based on a Microsoft environment.

In addition to rewarding work, we offer great employee benefits including competitive salaries, flexible working hours, participation in a 9-day fortnight, additional leave entitlements, health and wellbeing days, professional development opportunities, option to novate lease a private vehicle and much more.

What we value

We have a high-performance culture fostered through our values of Integrity, Customer Focus, Accountability, Respect and Excellence. Our culture encourages and supports equity, diversity and inclusion for our employees and our community.

Things you will do:

• 
  Service Operation – Transactional Databases – undertaking all activities necessary to optimise Council’s transactional databases and ensuring their confidentiality, integrity, availability and performance, including both on premise and cloud approaches.
• 
  Service Design/Service Transition – Design and implement the transformation of existing business processes from unstructured to structured processes through the use of existing and future transactional systems and process automation tools.
• 
  Data Management – the design and delivery of reports and dashboards that meet business requirements and assist in business decision making.

The successful applicant will require:

• Experience working with transactional databases based on the SQL language at an organisational level, including both on premise and cloud-based products (e.g. MS-SQL and Azure Data Warehouse).
• Database optimisation skills including security, backup and recovery, data migrations from production to/from non-production environments, upgrades of transactional systems, database performance, optimisation and capacity issues.
• Understanding of how business applications interact with databases and how to leverage business application functionality to transform a business process from unstructured to structured data, by being able to interpret transactional software and the underlying data entities.
• Experience in database lifecycle management activities including implementation, configuration, operation, maintenance, optimisation, upgrade and transition out of use.
• Experience in business automation utilising tools such as PowerAutomate to deliver robotic process automation for data capture.
• Experience in development of reports and business intelligence dashboards using tools such as SQL Server Reporting Services and PowerBI to inform business decisions, including gathering requirements, design of data structures such as cubes and views and the design of user interfaces to the data.

Employment in this position is subject to the successful completion of a Criminal History Check with a result of no relevant adverse findings.

Further Information

View the position description or contact Anthony Collis, Manager IMT, on 02 9093 6010.

NOTE: To be considered for the position, applicants should include two documents in their application: (1) a recent resume and (2) a statement demonstrating how they meet the essential knowledge, skills and abilities criteria listed in the position description.