Role Overview
As a Database Architect, you will play a key role in designing, optimizing, and evolving database solutions that support client-facing applications, high-concurrency transactional systems, and enterprise-scale data platforms. This role is responsible for evaluating existing database structures, developing scalable data architectures, and ensuring optimal performance, reliability, and interoperability across systems.
You will collaborate closely with engineering teams, product managers, analysts, and business stakeholders to translate business requirements into effective database solutions while leveraging industry best practices and innovative design approaches to solve complex technical challenges.
Key Responsibilities
- Partner with senior architects, engineering teams, and business stakeholders to define and implement database architecture strategies.
- Analyze existing database designs and recommend improvements to enhance performance, scalability, stability, and interoperability.
- Translate business and technical requirements into efficient database, data warehouse, and data lakehouse designs.
- Provide technical leadership and guidance on database architecture initiatives across multiple projects.
- Support governance and adherence to database architecture standards through design reviews, code reviews, and technical oversight.
- Contribute to the development of database architecture roadmaps aligned with business objectives and technology strategies.
- Establish and maintain database architecture standards, best practices, and documentation.
- Evaluate emerging technologies, tools, and frameworks to support continuous improvement and innovation.
- Develop strategies for data acquisition, retention, archival, recovery, and disaster recovery planning.
- Optimize database performance and troubleshoot performance-related issues across enterprise systems.
- Design solutions that support high-performance reporting, analytics, and business intelligence requirements.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, Data Management, or a related field.
- Minimum of 3 years of experience in database architecture, database development, data engineering, or related disciplines.
- Strong experience with relational and cloud-based database technologies, including:
- Microsoft SQL Server
- Oracle Database
- Azure SQL
- Azure Databricks
- Unity Catalog
- Apache Spark / PySpark
- Azure Data Factory
- Azure Storage
- Azure Data Lake
- Azure Synapse Analytics
- Azure Purview
Technical Skills
- Strong understanding of:
- Data Modeling
- Data Integration
- Database Design
- Data Warehousing
- Data Lakehouse Architectures
- Big Data Technologies
- NoSQL Databases
- In-Memory Databases
- Data Governance and Metadata Management
- Experience with database performance tuning, optimization, and remediation.
- Hands-on Python development experience, including:
- Python
- PySpark
- Spark-based development
- Notebook environments
- Strong SQL development skills, including:
- T-SQL
- Stored Procedures
- Views
- Indexing Strategies
- Query Optimization
- Experience working with large-scale structured and unstructured datasets.
- Experience supporting web-based applications with high user concurrency and availability requirements.
