SQL DBA with Azure

ClearCompany; Melbourne; On-site; AUD 90,000 - 130,000; Full time

Job summary

An established industry player is seeking a skilled MS SQL Server DBA with Azure experience to oversee the upgrade of SQL databases. This role involves designing and implementing Azure SQL databases, ensuring optimal performance and security. You will collaborate with developers and administrators, troubleshoot issues, and develop disaster recovery strategies. If you have a passion for cloud technologies and a knack for problem-solving, this position offers the chance to make a significant impact in a dynamic environment.

Qualifications

• Deep understanding of Azure SQL Database services and features.
• Proficiency in SQL Server and Azure SQL services.

Responsibilities

• Plan, implement, and maintain Azure SQL databases.
• Optimize database performance and ensure data security.

Skills

Azure SQL Database

SQL Server

Transact-SQL (T-SQL)

Problem-Solving

Communication

Job description

MS SQL Server DBA – Azure – upgrade Experience
Responsibilities:

Design and Implementation: Plan, implement, and maintain Azure SQL databases, ensuring optimal design and configuration.
Security: Ensure data integrity and security by implementing robust security measures and compliance with data regulations. Ensure that security measures are in place to protect sensitive data throughout the upgrade (encryption of data at rest).
Troubleshooting: Identify and resolve database-related issues promptly to maintain smooth operations.
Capacity Planning: Perform capacity planning and demand forecasting for database systems to anticipate future needs.
Performance Tuning: Optimize database performance during and after the upgrade, including tuning SQL queries and indexing strategies specific to Siebel applications. Monitor database performance, perform system tuning, and optimize SQL queries to ensure efficient operation.
Backup and Recovery: Implement robust backup and recovery procedures to safeguard data during the upgrade process.
Collaboration: Work closely with Siebel developers, system administrators, and other stakeholders to coordinate the upgrade process and resolve any issues that arise.
Monitoring and Maintenance: Continuously monitor the upgraded database for performance issues and apply necessary patches and updates
Disaster Recovery: Develop and implement disaster recovery and high availability strategies to minimize downtime and data loss.
Documentation: Document the upgrade process, including any changes made to the database schema, configurations, and performance optimizations.

Skills and Qualifications:

Expertise in Azure SQL: Deep understanding of Azure SQL Database services and features.
Expertise in SQL: Proficiency in SQL Server and Azure SQL services.
Knowledge of Cloud Platforms: Understanding of cloud-native and hybrid data platform solutions on Azure Cloud.
Technical Skills: Familiarity with Transact-SQL (T-SQL) and other MS-SQL administrative tools.
Problem-Solving: Strong analytical and troubleshooting skills.
Communication: Ability to collaborate effectively with developers, Client Infrastructure team(s) , and other stakeholders as necessary.