Job description
VIC South Eastern Suburbs location (Hybrid 1/2 days from office) - 6 months contract or Option of a Permanent opportunity!
Work as an SQL DBA with a Consulting firm on one of their established Melbourne based projects.
Responsibilities and Skills required include:
- 4-6 years of experience as a database specialist in Microsoft SQL Server.
- T-SQL Development: Writing, understanding and modifying the existing SQL queries(CRUD, Joins, Sub queries etc.), stored procedures, functions and trigger
- PowerShell Scripting: Writing, understanding and modifying the existing PowerShell scripts and new scripts as per the requirement
- Experience in database maintenance, like fragmentation checks including daily backups and recovery, re-index operations, update statistics, and other system commands such as DBCC and DMVs .
- Must have good exposure in setting up and troubleshooting the Always-On High availability solutions.
- Must have experience in PowerShell scripting and good to have knowledge in dbatools.
- Strong SQL knowledge and experience in creating database objects such as tables, views, stored procedures, Triggers etc.
- Generate code to extract, transform and load data from one data source to another (SSIS)
- Experience performing database migrations.
- Good to have knowledge on Reporting tools like PowerBI .
To be considered for the role click the 'apply' button or for more information about this and other opportunities please contact Yash Kumar Jain on 03 86804235 or email: [email protected] and quote the above job reference number.
