Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9hewfulwluzm90zwnol2pwzy9iyw5uzxitzgvmyxvsdc5qcgcixv0

MS SQL DBA (Azure focus)

Job Title: MS SQL DBA (Azure focus)
Contract Type: Contract
Location: Southbank, Victoria
Industry:
Salary: Negotiable
Reference: 3627_1582236764
Contact Name: Gaurav Bagga
Contact Email: gaurav.b@ayaninfotech.com
Job Published: February 21, 2020 09:12

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 Melbourne.

All applicants must have full work rights in Australia.

Title: MS SQL DBA (Azure focus)
Type: Contract (6 months + possible extensions)
Location: Melbourne

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.


Qualifications

  • 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.

www.ayaninfotech.com

Get similar jobs like these by email

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