Database Ownership & Performance

• Own the performance and reliability of Diesta’s MySQL databases

• Monitor slow queries, execution plans, and resource usage

• Proactively optimise queries, indexes, and schemas

• Identify and resolve performance bottlenecks before they become incidents

• Support scaling strategies as data volumes and client usage grow
  
  

Schema Design & Maintenance

• Design, evolve, and maintain database schemas safely and cleanly

• Support backward-compatible changes and migrations

• Ensure schemas support both transactional workflows and analytics use cases

• Collaborate with developers on schema changes for new features
  
  

Developer & Product Support

• Support the engineering team with complex SQL queries for:

  • Application features

  • Analytics and reporting

  • Operational and Customer dashboards

• Ensure data is delivered in the format required by the portal — efficiently and consistently

• Assist with testing new features, data migrations, and regression testing
  
  

Data Integrity & Quality

• Take ownership of data correctness across the platform

• Maintain and evolve “iron-dome” queries:

  • Invariant checks

  • Contradiction detection

  • Early warning signals for data drift or corruption

• Investigate and resolve data integrity issues quickly and thoroughly

• Work closely with product and engineering to prevent repeat issues
  
  

Client & Implementation Support

• Assist with data ingestion, mapping, and transformation during client onboarding

• Analyse client data samples and identify issues earl

• Support client workshops where deeper data understanding is required