Database Architect is responsible for designing and architecting robust, scalable, and high‑performance database systems. This role focuses on data modelling, database design, performance optimisation, system integrations, and guiding development teams on best database practices.
Key Responsibilities
- Design scalable database architectures for enterprise and web-based applications.
- Develop logical and physical data models, ER diagrams, and schema structures.
- Define database standards, naming conventions, indexing strategies, and best practices.
- Evaluate and select database technologies (SQL, NoSQL, cloud-native).
- Optimise system performance, storage, and data flows.
- Review and approve database structures developed by engineering teams.
- Oversee database migrations, replication strategies, and multi-region setups.
- Collaborate with developers to build efficient backend data workflows.
- Ensure high availability, disaster recovery, and data redundancy.
- Conduct regular database audits, security reviews, and performance tuning.
- Provide architectural guidance on ETL pipelines, analytics, and data warehousing.
- Produce documentation for architecture, design decisions, and technical standards.
Required Skills & Experience
- 5+ years of experience as a Database Architect, Senior Database Developer, or Senior DBA.
- Strong proficiency in:
- MySQL / MariaDB
- PostgreSQL
- SQL Server (optional but beneficial)
- NoSQL databases (MongoDB, Redis, DynamoDB)
- Expertise in data modelling, schema design, indexing strategies, and query optimization.
- Strong understanding of distributed systems, replication, sharding, and clustering.
- Experience working with cloud databases (AWS RDS/Aurora, Azure SQL, Google Cloud SQL).
- Knowledge of ETL, data pipelines, and data warehousing concepts.
- Understanding of database security, encryption, IAM/roles, and compliance standards.
- Familiarity with DevOps tools (Git, CI/CD) and infrastructure (Docker, Kubernetes).
Preferred Qualifications
- Experience designing databases for large-scale web portals or SaaS platforms.
- Exposure to microservices architecture.
- Knowledge of scripting languages: Python, Bash, PowerShell.
- Cloud certifications (AWS, Azure, GCP) related to data or architecture.
