Data Architect – Lead

Mandatory

• 8–10+ years of experience in database administration, database engineering or database architecture for large-scale or critical systems
  Strong experience in database architecture, logical and physical data modelling, schema design and database standards
• Strong experience in database performance monitoring, SQL/query optimisation, indexing, partitioning, capacity planning and performance tuning
• Experience implementing data integrity, data validation, access controls and database security
• Experience designing and implementing backup, restoration, disaster recovery and high-availability mechanisms
• Experience with database replication, clustering, failover and recovery testing for critical systems
• Experience performing database installation, configuration, upgrades, patching and migration
• Experience troubleshooting database performance, availability and data-integrity issues
• Experience supporting application and system teams on database interfaces, data requirements and integration
• Experience producing and maintaining database architecture, data models, configuration, backup/recovery and operational documentation

Preferred

• Experience supporting high-availability, mission-critical or safety-critical systems
• Experience working within Agile and/or SAFe delivery environments
• Experience with containerised or cloud/hybrid database environments
• Experience with database monitoring, automation and CI/CD practices
• Knowledge of database security hardening, audit logging, encryption and privileged-access controls
• Experience conducting database capacity planning, performance baselining and resilience/failover testing

Equivalent Technologies

• Oracle Database, PostgreSQL, Microsoft SQL Server, MySQL/MariaDB or equivalent enterprise relational database technologies
• Oracle Data Guard, SQL Server Always On, PostgreSQL streaming replication or equivalent high availability and disaster-recovery technologies
• SQL/PL/SQL or equivalent database query and procedural languages
• Database performance-monitoring and administration tools appropriate to the deployed technology stack