Data Architect

Mandatory Requirements

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

Preferred

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

Equivalent Technologies

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

Skills

Availability of Databases, Monitoring Database Performance, Indexing, Database Architectures, Database Installation, Database Security, database upgrades, Database Administration, Data Integrity, Database Performance, Back Up and Disaster Recovery, Database Integrity, Clustering, Restoration, Data Validation, design database schemas