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