Data Architect

Mandatory Requirements • 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 highavailability 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