Sydney / Melbourne / Perth
SQL Server / Azure SQL / 1TB + Databases
Hybrid Working
The Role:
Our client is a large Financial Services Organisation on the lookout for multiple Database Administrators to join their team on a permanent basis.
The secondary purpose is to provide support to the business and technology departments in the use of the organisations SQL Server based systems and database tools and technologies.
Responsibilities:
Provide DBA Support to the organisations 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.
Performance tuning of databases, queries & reports.
Availability to provide after-hours support
About You:
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
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
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server