Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9hewfulwluzm90zwnol2pwzy9iyw5uzxitzgvmyxvsdc5qcgcixv0

MS SQL DBA (Azure focus) - Frankston

Job Title: MS SQL DBA (Azure focus) - Frankston
Contract Type: Contract
Location: Frankston, Victoria
Industry:
Salary: Up to AU$700 per day + excl GST
Reference: 3633_1582844949
Contact Name: Gaurav Bagga
Contact Email: gaurav.b@ayaninfotech.com
Job Published: February 28, 2020 10:09

Job Description

Ayan Infotech has an urgent and immediate requirement for an MS SQL DBA (Azure focus) for a long term contract job opportunity in Frankston (3199).

All applicants must have full work rights in Australia.



Required Skills and Experience:

  • Implement and advocate Azure/SQL best practices and optimizations across a complex continually evolving Azure/SQL Server environment
  • Manage Azure subscriptions and resources and implement Azure IaaS/PaaS resources across Application Resource Groups
  • Analyse, predict, and resolve database, system, storage and application issues, working with all levels of technology within and across multiple Clouds
  • Manage deployments, design, debug, and optimization of Azure Cloud services across several application team environments spread across numerous subscriptions spanning multiple regions
  • Design and implement Azure Automation, ARM Templates, DevOps, CICD
  • Develop detailed solution cost/budget requirements for Azure Cloud implementations to Configure and manage virtual networks
  • Manage identities
  • Understand complex SQL Server designs to share ownership and optimize a mix of on-prem physical and Azure IaaS/Paas SQL Server environments
  • Drive forward new innovative SQL/Azure features and functionality
  • Support several highly active custom application and software development groups in controlled, audited Dev/Test/Prod/DMZ/DR environments
  • Maintain and improve DR strategy, design, and implementation
  • Support extensive DTS, SSIS, and Azure Data Factory Integrations
  • Monitor SQL job failures, debugging, root cause analysis, debug/fix, documentation and escalation of priority performance issue resolution
  • Database Performance Tuning and Optimization (PTO), troubleshooting and optimizing T-SQL code, Views, and
  • Engage in continuous process, technology learning and improvement
  • Responsible for development of stored procedures, triggers and ETL scripts
  • Expert in T-SQL coding, and assist application developers in tuning their database code.
  • Perform T-SQL code reviews during key points of the SDLC and enforce compliance with T-SQL coding standards
  • Write data conversion code for several projects in a monthly release cycle
  • Maintain the database tools and systems through best practices
  • Create highly scalable transactional database schemas utilizing data modelling discipline with an understanding of normalization, de-normalization, and the difference between the two.


Qualification

  • Bachelor's degree in information technology or solid experience preferred.
  • 5+ years in Azure Cloud Platform. Specifically in Azure SQL DB, Azure SQL Datawarehouse, Cosmos DB, Azure Data Factory and Azure DevOps
  • 10+ years experience in SQL Server database administration
  • 10+ years of experience with database Performance Tuning and Optimization (PTO), troubleshooting and optimizing T-SQL code.
  • 10+ years of experience with backups, restores and recovery models
  • 10+ years of experience with Windows server, including Active Directory
  • Highly proficient in SQL Server 2000-2017 implementation and administration, including SSRS, SSIS and SSAS
  • Proficient in installing, configuring, migration, upgrading and patching SQL Servers
  • Solid understanding of database recovery operations
  • Excellent verbal and written communication skills
  • Ability to produce quality work on tight schedules as part of a team
  • Willingness to work onsite in a professional business environment and off-site for after hours on-call activities.
  • Work effectively in a collaborative team environment, as well as independently

We will be able to contact only shortlisted candidates. We thank you in advance.

Contact: 02 9412 4178 for more details.

www.ayaninfotech.com

Get similar jobs like these by email

By submitting your details you agree to our T&C's