Wednesday , April 17 2024

Caseys Jobs – Application and Database Analyst

Website City of Casey

Job Description:

As part of the Technology team Application and Database Analyst will provide database management, planning, implementation, training and testing of new corporate software and maintain enhancements and upgrades to existing ones. This role will also investigate problems with software applications, diagnose root causes and work on resolving associated issues and undertake PowerShell programming for the Council to minimize service disruption and facilitate operations
This role sits in the Customer & Business Transformation division, focused on delivering value to our customers through partnering with the business to achieve great performance outcomes

Job Responsibilities:

  • Manage the organization’s database technology and associated schemes to allow secure, efficient and effective access to the council’s structured data.
  • Design, develop and implement SSIS, SSRS and PowerBi solutions to support business unit objectives and develop and maintain Powershell scripts.
  • Review and revise practices and processes to enhance efficiency of access for users.
  • Oversee the development, integration, and configuration of database infrastructure and business applications used across the Council; ensuring that all applications comply with relevant standards and regulations.
  • Monitor performance and manage parameters for Database and application servers to provide efficient and effective responses to front-end users.
  • Utilize effective design principles to develop both back-end organization of data and front-end accessibility for end-users.
  • Perform data cleansing of the logical design so that it can be translated into a specific data model.
  • Produce database documentation, including data standards, procedures and definitions for the data dictionary (metadata).
  • Monitor the storage and archiving procedures for accurate functionality and procedural compliance

Qualification & Experience:

  • Configuration and administration of business applications and systems integration software
  • Experience with Azure in data warehousing methodologies Windows
  • SQL Server Cluster and Always On experience
  • Proven applications experience and strong Powershell scripting knowledge
  • Excellent communication and problem solving skills
  • SQL Server System performance tuning & recovery experience
  • Working knowledge of SQL Databases, Querying, Stored, Backup and Restore procedures

Job Details:

Company: City of Casey

Vacancy Type:  Full Time

Job Location: Narre Warren, Victoria, Australia

Application Deadline: N/A

Apply Here