Database Administrator - EMEA at First Quantum Minerals LTD

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.