Database Architect

Database Architect

We are seeking a highly skilled Database Architect to design, implement, and optimize high-performance, scalable, secure and reliable database systems. The ideal candidate will have deep expertise in both relational and NoSQL databases, data modeling, and cloud-native database architectures, ensuring our data platforms are robust, secure, and scalable to meet evolving business demands.

Key Responsibilities

Database Architecture & Design

• Design and document enterprise-level data models, schemas, and storage strategies aligned with application requirements and business needs.
• Develop and maintain logical, physical, conceptual data models and entity relations.
• Architect both OLTP and OLAP systems, including data warehousing, ETL pipelines, and real-time data streaming.
• Review existing designs, identify issues, and provide redesigns with alignment with business needs.
• Plan and manage Database redesigns

Development & Integration

• Guide schema design, stored procedures, triggers, and functions
• Define integration points and data exchange standards (ETL, APIs, CDC)
• Work with application developers to implement optimized data access patterns
• Ensure compatibility across development, testing, staging, and production

Cloud & Distributed Systems

• Design database architectures in public/private/hybrid cloud environments (OCI)
• Automate database provisioning with IaC tools (Terraform, Ansible)
• Select appropriate cloud database services for given use cases.
• Implement strategies for data replication, sharding, partitioning, and high availability.

Data Governance & Security

• Define standards for data integrity, access control, and encryption.
• Support audit, compliance (NDMO, PDPL, NCA), and data retention policies.
• Implement role-based access, audit trails, and monitoring mechanisms.
• Maintain data integrity and disaster recovery plans

Performance & Optimization

• Analyze database performance and tune queries, indexes, resource usage and storage configurations.
• Collaborate with DevOps and Engineering teams to optimize infrastructure for database workloads.
• Monitor system performance and resolve bottlenecks
• Implement caching, materialized views, or in-memory DB features where needed.

Data Integration & Lifecycle Management

• Oversee data migrations, backup and restore, archival, and disaster recovery strategies.
• Design data integration architectures supporting ETL, CDC, and data lake models.
• Provide architectural guidance for data ingestion, cleaning, and quality monitoring.

Collaboration & Standards

• Adhere to architectural design requirements, best practices and standards.
• Work closely with architects, software developers, data engineers, and business analysts to understand needs and translate them into data solutions.
• Define data architecture best practices, naming conventions, metadata policies, and data lineage standards.

Education & Experience

• Bachelor's or Master’s degree in Computer Science, Information Systems, or a related field.
• 10+ years of experience with databases and 3+ years as a database architect.
• Oracle DB Architect-level certification.

Technical Skills

• Solid experience in RDBMS mainly Oracle.
• Experience in distributed DBs and NoSQL (MongoDB, Redis).
• Experience in ExaCC & ExaCS
• Strong SQL skills and understanding of query optimization and indexing strategies.
• Experience with data modeling tools (e.g., ER/Studio, dbt, PowerDesigner, Lucidchart).
• Deep knowledge and experience of database normalization, denormalization, dimensions, ER and schema design patterns.
• Familiarity with data lakes, data vault modeling, star/snowflake schemas, and analytics platforms (e.g., BigQuery, Redshift, Snowflake).
• Understanding of Kubernetes, Docker, Helm, and how they relate to database deployment in containerized environments.
• Backup, DR, replication, high availability design
• SQL optimization and PL/SQQL scripting
• Familiarity with data integration tools

Soft Skills

• Excellent problem-solving and analytical skills.
• Strong communication and documentation skills.
• Ability to drive design reviews mentor developers and DBAs.
• Experience working in agile and DevOps environments

Good-to-Have Qualifications

• Experience with Kafka, Airflow, or Debezium for real-time streaming.
• Knowledge of data mesh, event sourcing, or CQRS patterns.
• Familiarity with graph databases (e.g., Neo4j), time-series databases (e.g., InfluxDB), or search databases (e.g., Elasticsearch).