The Azure Database Administrator will play a pivotal role in ensuring the optimal performance, reliability, and security of our Azure SQL databases. The successful candidate will be responsible for designing, implementing, and managing databases, with a specific focus on adhering to the principles of Semantic Layer. Additionally, this role involves collaborating with cross-functional teams.
Key Responsibilities:
Data Architecture:
- Data Integration
- Develop and implement strategies for query performance optimization, including index management, query tuning, and database partitioning.
- Apply query hints judiciously to optimize specific queries, considering factors such as locking mechanisms and concurrency requirements.
- Analyse and assess the impact of query hints, on overall system performance and data integrity.
- Data Storage, transfer & access
- Design, implement and administer of Azure SQL Server, Serverless SQL Pool, and on-premises SQL Server to ensure optimal performance, reliability, and security.
- Leverage extensive knowledge of Semantic Layer principles to structure and maintain databases efficiently, aligning data architecture standards and best practices.
- Administer both on-premises and cloud-based database environments, ensuring seamless integration and migration between platforms.
- Experience with multi-region deployment and high availability configurations.
- Contribute to the backup and disaster recovery strategies.
- Document database configurations, procedures, and troubleshooting steps to maintain a comprehensive knowledge base.
- Monitor database health, troubleshoot issues, and proactively identify and address potential problems.
- Address critical database incidents and ensure high availability.
Data Governance:
- Data catalogue and MDM:
- Apply knowledge of Azure Purview to ensure effective data governance, cataloging, and lineage tracking within the database environment.
Data Operations:
- Training:
- Foster a collaborative environment by building and maintaining a toolkit of resources, best practices, and knowledge-sharing platforms for the team to utilize effectively
- Collaborate with cross-functional teams to support and enhance data-driven applications and services.
Qualifications Required:
- Bachelor's degree in Computer Science, Information Technology, or a related field. With Azure Database Administrator Associate a plus.
Experience & Skills Required:
- 8+ years' experience
- Strong proficiency in optimizing query performance and understanding of Semantic Layer principles.
- Demonstrated expertise in managing databases in both on-premises and cloud environments.
- Extensive experience (3+ years) on Azure databases.
- Extensive experience (8+ years) on MS SQL server.
- 3+ years of experience with NoSQL databases (Bonus)
- Proficient in scripting languages (e.g., PowerShell, T-SQL) for automation and administration tasks.
- Excellent problem-solving and troubleshooting skills in database-related issues.
- Effective communication skills and the ability to work effectively in a global, cross-functional team.
Behavioural Traits Required:
- Performance and results orientated
- Team player
- Effective communication abilities
- Ability to manage change
- Ability to work under pressure
- Demonstrate leadership skills
- Knowledge and interest in computer systems and the latest technologies
Other Requirements:
- Location: Cape Town
- Travel: Regionally, minimum twice year
- Place of Work: Hybrid (2-3 Office days per week)
Visit our website and register for instant job alerts at www.first-quantum.com
Follow us for the latest news at https://www.linkedin.com/company/firstquantumminerals/
