• 1Search for courses by Study Area, Level and Location
  • 2We deliver you all the matched results
  • 3Choose one or more course providers to contact you
Industry

Distance from location (kms)

Exact 5 10 25 50 100

Posted since

All 2 Days 1 Week 2 Weeks 1 Month

Sort results by

Relevance Date

4

February

Sql Server Dba

Link Group (LNK) - Sydney, NSW

IT
Source: uWorkin

JOB DESCRIPTION

Overview

The primary purpose of the SQL Server Database Administrator Role is to take complete ownership of all the SQL Server Database Administration within the organisation and provide with an efficient, functional and stable SQL Server database environment across multiple application on premise and in Azure. 

The secondary purpose is to provide support to the business and technology departments in the use of Link Group’s SQL Server based systems and database tools and technologies.

Key Accountabilities and Main Responsibilities

  • Provide DBA Support to Link Groups SQL Server Databases including:
    • Maintaining and enhancing current procedures
    • Upgrading and patching SQL Server from earlier versions
    • Backup & Recovery of databases and process improvements 
    • Database performance assessment and optimisation
    • Implement technologies related to Replication, Mirroring, Log Shipping, Partitioning
    • Migration and data movement to Azure
  • Working in the context of large (1TB+ databases) and associated performance challenges
  • Supporting metadata packages (SSIS), for reporting purposes
  • Assist in maintaining Data Quality and Data Integrity
  • Ensure adequate capacity for database growth
  • Provide recommendations on systems configuration and operational infrastructure as required by management.
  • Adopt and apply best practice approaches for the operating environment.
  • Ensure best value for money is obtained from third party vendors by evaluating software tools as required.
  • Effective monitoring, system status alerts and escalation where appropriate.
  • Perform project and system health checks.
  • Raise change controls for defects as required.
  • Evaluate software suitability and viability to determine its usefulness in addressing the needs of Link.
  • Performance tuning of databases, queries & reports.
  • Allocating system storage and planning future storage requirements for the database systems.
  • Modifying the database structure, as necessary, from information given by application developers and the business.
  • User access creation, monitoring and maintenance of system security.
  • Documentation of procedures and processes.
  • Implement and Review Disaster Recovery strategy 


Experience & Personal Attributes

Required
  • Minimum 3+ years’ experience working with large SQL Server Database
  • Sound knowledge of database architecture, integration issues, third party reporting and data extraction tools
  • Hands on experience with Azure SQL and Azure Data Factory
  • Availability to provide after-hours support
  • Knowledge and understanding of the Software Development Life Cycle (SDLC)
  • Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
  • Experience in Microsoft SQL Server Reporting Services, Analysis Services and SSIS 
  • Structured programming methodology, data analysis and design skills - T-SQL & SQL Knowledge
  • Experience in implementing operational automation using scripts
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Ability to work well under pressure and to balance competing priorities to deliver timely outcomes
  • Must have a strong team focus and be able to work with minimal supervision
  • Experience with technical documentation and content management. 
  • Exposure to business contingency standards and acceptable practices that comply with statutory and audit requirements
  • Strong problem-solving skills, particularly investigation and resolution of data related problems
  • Excellent analytical, programming and problem-solving skills
  • Ability to respond to user requirements and meet deadlines


Preferred

  • Tertiary qualification in Information Technology or related Discipline is preferred
  • Microsoft Certification is preferred – MCTS, MCITP 
  • Broad knowledge or exposure to financial services/ banking/ accounting applications
  • Experience working with Windows server, including Active Directory and proper disk configurations
  • Database planning and scheduling experience
  • Proven track record working directly with business users and external customers
  • Strong communication skills (verbal and written) and the ability to communicate to staff across all levels within the organisation

;