Ayan Infotech has an urgent and immediate requirement for an MS SQL DBA for a contract job opportunity in Bella Vista, Sydney.
All applicants must have full work rights in Australia.
Title: MS SQL DBA
Location: Bella Vista, Sydney
Type: Contract (3 months + extensions)
About The Role:
As a Microsoft SQL Database Administrator with the Database Services Development team, your key focus will be Design, Implementation, Configuration and Development of the MS SQL database platform. Strong attention to detail is a must, as is the ability to think outside the box. Working with internal and external partners, you will manage and improve existing systems, build new systems and work closely with the support team to ensure system stability.
What You'll Do:
- Database solution design, development and implementation.
- Document and follow database standards, policies and procedures.
- Database backup and recovery with third party backup tools
- Database performance optimisation and troubleshooting
- Provide security hardening to both servers and databases
- Database patching and upgrade
- Database migration and consolidation
- Maintain database metrics up to date
- Implement database alerting and monitoring
- Database capacity planning
What You'll Need to Succeed:
- Experience in Microsoft SQL Server 2008R2 / 2012 / 2014 / 2016/2017
- Solid database design and development skills
- Sound knowledge of Windows operating system.
- T-SQL, PowerShell.
- Excellent understanding of the High Availability technologies.
- Previous experience with complex database migrations / upgrades.
- Integration Services / Integration Services Catalog / SSIS configuration, development and migration.
- Advanced skills in database performance tuning and sql query optimisation.
Experience in the following areas would be highly regarded -
- Microsoft Certification on SQL server 2008/12/14/16/17
- MS SQL HA design and Implementation (compulsory).
- Other RDBMS technology
- SQL Server Analysis / SQL Server Reporting Services.
- Administering / Troubleshooting Active Directory / DNS
- Experience on SQL server Azure.
- DR technology solution and its implementation
- Multisite Always on cluster
- SQL server clustering
We will be able to contact only shortlisted candidates. We thank you in advance.