Database Engineer

)
Geology & Exploration Databases - e.g., acQuire, Geobank
Pit/Ramp/Equipment Production Dashboards

2. OT Data Capture & Real-time Processing

Manage data pipelines that collect:

Equipment telemetry (load, haul, cycle times, KPIs)
Drill/blast data
Geotechnical and hydrological monitoring
Process plant instrumentation data
Environmental and safety monitoring data

Ensure low-latency database performance to support real-time operations.

3. Data Quality & Production Reporting

Maintain accuracy and completeness of operational data (daily, shift, monthly).
Validate data used for:

Daily pit production
Processing plant throughput and recovery
Ore tracking & reconciliation
Equipment availability & utilization
Safety KPIs and compliance reports

Work with dispatch engineers, metallurgists, geologists, and mine supervisors to ensure data reliability.

4. Database Performance Optimization

Tune mining operations databases for high performance during peak production hours.
Optimize SQL queries for reporting and real-time dashboards.
Implement indexing, partitioning, and resource optimization specific to high-volume OT systems.

5. Reliability, Backup & Recovery (Production Critical)

Implement robust backup strategies for mission-critical operational databases.
Configure disaster recovery for mine production data.
Maintain data redundancy for underground and remote site connectivity challenges.
Ensure databases can recover quickly after operational interruptions.

6. OT & Mining System Integrations

Integrate databases with mining operational systems, such as:

Fleet management ↔ Dispatch dashboards
SCADA ↔ Process historian
Geology ↔ Mine planning models
Plant laboratory systems ↔ Recovery models

Support APIs, ETL pipelines, and OPC/Telemetry gateways.

7. Production Improvement & Optimization

Enable operational analytics such as:

Equipment performance benchmarking
Ore tracking and reconciliation
Production forecasting
Real-time dashboards for supervisors & mine control

Identify data-driven improvement opportunities in mining operations.

Qualifications (Mining-focused)
Education

Degree in Mining Engineering, Computer Science, Data Engineering, or related field.

Experience

3-7 years working with mining operational systems and production databases.
Hands-on experience with:

FMS data structures
Geological databases
Plant historian databases
SCADA/OT systems

Experience in open-pit, underground, or processing plant operations preferred.

Technical Skills

Strong SQL (T-SQL, PL/SQL, PostgreSQL, etc.)
Experience with historian databases (PI, Aveva, Wonderware).
Familiarity with mining data structures (shifts → cycles → KPIs → production).
Experience with ETL for mining operational data.
Strong understanding of mining workflows: drilling, blasting, loading, hauling, processing.

Soft Skills

Ability to work closely with mine supervisors, dispatch, geology, and plant operations.
Strong analytical and troubleshooting capabilities.
Able to perform under operational pressure and tight production schedules.

Working Conditions

Mine-site-based or rotation as required.
Must adhere to HSE standards and operational safety protocols.
Work may involve extended hours during equipment or system failures, production demands, or month-end reconciliation.