Data Architect – Lead

Job 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 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

Skills

optimized SQL queries, Monitoring Database Performance, failover testing, Indexing, Database Programming, Database Architectures, Database Administration, Data Integrity, Database Maintenance, Back Up and Disaster Recovery, Clustering, Database Interfaces, data requirements, Restoration, Data Validation, design database schemas