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 availabilityPerform database health checks, monitor resource utilization, and fine-tune configurations for optimal performance.Regularly upgrade and patch database systems to maintain compliance and securityDesign and optimise database structures for:Partitioning strategiesFile group managementTable and index designMemory and storage configurationsCollaborate with:Data Architects on implementing data modelsApplication teams on database design requirementsInfrastructure teams on capacity planningPerformance Optimization:Query performance tuning and plan analysisIndex strategy development and maintenanceImplement proactive performance monitoring and alerting systemsWorkload analysis and optimizationCapacity planning and growth managementHybrid Environment Administration:Manage hybrid database environments, balancing workloads across on-premises and cloud platformsImplement 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 fieldOrMicrosoft Certified: Azure Database Administrator AssociateMicrosoft SQL Server certificationsMCSAExperience & Technical Skills Required:8+ years of enterprise-level SQL Server database administration experience, including: * Experience managing databases1TB in size * Experience with high-availability configurations

• Production environment experience in regulated industries

Advanced expertise in SQL Server Enterprise database management and administrationProficiency in T-SQL and PowerShell scripting for automation and operational efficiencyStrong experience in query optimization, indexing strategies, and performance tuningHands-on experience with multi-region database deployments and high-availability configurationsFamiliarity with hybrid on-premises and cloud database solutions (Azure SQL, Managed Instances.)Extensive experience (3+ years) on Azure databasesExtensive experience (8+ years) on MS SQL server3+ 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 troubleshootingExcellent communication skills, with the ability to collaborate effectively with cross-functional teams and stakeholdersAdaptability to evolving technologies and a commitment to continuous learningPerformance and results orientatedTeam playerEffective communication abilitiesAbility to manage changeAbility to work under pressureKnowledge and interest in computer systems and the latest technologiesOther Requirements:Candidates must have the right to work in the applicable region without visa sponsorshipWillingness to work and travel across FQMs operations and locations worldwideFluency in English is required. Proficiency in other languages highly regardedRoadmap 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 atFollow us for the latest news atIf 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.

First Quantum Minerals