Job Description

At First Quantum, we free the talent of our people by taking a very different approach which is underpinned by a very different, very definite culture the First Quantum Way.
Working with us is not like working anywhere else, which is why we recruit people who will take a bolder, smarter approach to spot opportunities, solve problems and deliver results.
Our culture is all about encouraging you to think independently and to challenge convention to deliver the best result. Thats how we continue to achieve extraordinary things in extraordinary locations.
Job description:
Purpose of the role:
Although our production and financial results are the engine that drives our business, it is the depth of capability in our people that will continue to determine First Quantums ongoing success. Reporting to the Regional IT Manager - EMEA of our IT division, this role will form an integral part of our Regional IT team, responsible for maintaining the performance, reliability, and security of FQM's SQL database environment, which spans both on-premises and cloud-based solutions. The incumbent will design, implement, and manage databases, with a focus on following Information Integration Standards, while also collaborating closely with cross-functional teams.
Key Responsibilities:
The Senior SQL Server Database Administrators general accountabilities include, but are not limited to, the below:
Database Core Management:
Administer and maintain SQL Server databases with Enterprise-level complexity, ensuring data integrity, security, and availability
Perform database health checks, monitor resource utilization, and fine-tune configurations for optimal performance.
Regularly upgrade and patch database systems to maintain compliance and security
Design and optimise database structures for:
Partitioning strategies
File group management
Table and index design
Memory and storage configurations
Collaborate with:
Data Architects on implementing data models
Application teams on database design requirements
Infrastructure teams on capacity planning
Performance Optimization:
Query performance tuning and plan analysis
Index strategy development and maintenance
Implement proactive performance monitoring and alerting systems
Workload analysis and optimization
Capacity planning and growth management
Hybrid Environment Administration:
Manage hybrid database environments, balancing workloads across on-premises and cloud platforms
Implement cloud technologies for enhanced availability and disaster recovery, in line with the enterprise cloud roadmap (80% enterprise, 20% cloud)
High Availability & Disaster Recovery:
Implement and maintain high availability solutions: * Always On Availability Groups configuration

• Failover Cluster Instance management
• Database mirroring where applicable
• Log shipping and replication setup

Manage comprehensive backup and recovery: * Design and implement backup strategies

• Regular recovery testing and validation
• Disaster recovery documentation and procedures

Incident and Operational Support:
Provide database-related expertise as part of an incident response team which supports 24/7 operations: * P1 (Critical): X minute response

• P2 (High): X minute response
• P3 (Medium): Next business day
• Document and resolve recurring problems through root cause analysis
• Contribute to and maintain incident response playbooks

Qualifications:
Bachelor's degree in Computer Science, Information Technology, or related field
Or
Microsoft Certified: Azure Database Administrator Associate
Microsoft SQL Server certifications
MCSA
Experience & Technical Skills Required:
8+ years of enterprise-level SQL Server database administration experience, including: * Experience managing databases
1TB in size * Experience with high-availability configurations

• Production environment experience in regulated industries

Advanced expertise in SQL Server Enterprise database management and administration
Proficiency in T-SQL and PowerShell scripting for automation and operational efficiency
Strong experience in query optimization, indexing strategies, and performance tuning
Hands-on experience with multi-region database deployments and high-availability configurations
Familiarity with hybrid on-premises and cloud database solutions (Azure SQL, Managed Instances.)
Extensive experience (3+ years) on Azure databases
Extensive experience (8+ years) on MS SQL server
3+ years of experience with NoSQL databases (Bonus)
Experience in cloud migration projects, especially migrating databases to Enterprise environments (Advantages)
Expertise in advanced Azure integration, including Azure Synapse Analytics, and Managed Instances (Advantages)
Advantageous: * Additional Azure certifications

• Experience with migration projects
• NoSQL database experience

Behavioural Traits Required:
Strong analytical and problem-solving abilities, with a proactive approach to troubleshooting
Excellent communication skills, with the ability to collaborate effectively with cross-functional teams and stakeholders
Adaptability to evolving technologies and a commitment to continuous learning
Performance and results orientated
Team player
Effective communication abilities
Ability to manage change
Ability to work under pressure
Knowledge and interest in computer systems and the latest technologies
Other Requirements:
Candidates must have the right to work in the applicable region without visa sponsorship
Willingness to work and travel across FQMs operations and locations worldwide
Fluency in English is required. Proficiency in other languages highly regarded
Roadmap and Vision:
Short-Term Goals: Enhance existing on-premises enterprise database systems, addressing immediate performance, scalability, and security requirements. Establish a robust backup and disaster recovery framework.
Mid-Term Goals: Initiate and lead the migration of select workloads to the cloud, ensuring 20% of database operations are seamlessly transitioned to Azure. Introduce hybrid management tools and practices for smoother integration.
Long-Term Goals: Transition towards an enterprise-level cloud-first architecture, leveraging Microsofts Azure ecosystem. Develop fully scalable, high-availability solutions to support the organizations data-driven initiatives.
Visit our website and register for instant job alerts at
Follow us for the latest news at
If you are already a First Quantum employee and have access to the First Quantum network, log into First Quantum MINE
Careers to apply internally for this opportunity.
If you are an employee without network access, contact your Site Recruiter.