Senior Database Architect

We are seeking an experienced Senior Database Architect to lead the design, implementation, and optimization of our data platforms. The ideal candidate will own database architecture strategy, ensure high availability and performance, drive scalability, and collaborate with engineering and product teams to support business requirements and data governance.

Key Responsibilities

Database Architecture & Design : Design large-scale database architectures for both operational and analytical systems (OLTP & OLAP); Develop database schema blueprints, entity relationship models, indexing strategies, and partitioning approaches; Design data flows and replication topologies across systems (microservices, DWH, real-time pipelines); Define naming conventions, data modeling standards, and comprehensive documentation. Performance & Scalability : Analyze and optimize query performance, indexing, and storage layers; Implement sharding, caching (Redis), and read replica strategies to achieve high scalability; Develop and monitor capacity planning and long-term data growth projections. High Availability & Disaster Recovery : Design HA/DR systems using techniques such as streaming replication, failover clustering, and backup rotation; Define RTO/RPO targets in alignment with business SLAs; Conduct periodic disaster recovery tests to ensure system resilience. Data Governance & Security : Implement data encryption, access control, and auditing policies; Ensure compliance with security standards such as GDPR, ISO 27001, and PCI DSS; Collaborate with the DevSecOps team to maintain data security and privacy. Integration & Cloud Infrastructure : Design data integration across platforms (PostgreSQL, BigQuery, Redis, Kafka, RabbitMQ, etc.); Experienced in working with Cloud Platforms such as GCP, AWS, and Azure; Implement CDC pipelines and real-time synchronization across data systems. Leadership & Collaboration : Provide technical direction to DBA, Data Engineer, and Developer teams; Collaborate with application and infrastructure architecture teams to design end-to-end systems; Develop database architecture documentation and best practice guidelines.

Requirement

Bachelor’s degree or higher in Computer Science, Information Systems, or related field. Minimum 8+ years of experience in database design, development, and administration. Proven experience in architecting large-scale and high-performance database systems (OLTP & OLAP). Deep understanding of relational and non-relational databases, such as PostgreSQL, MySQL, MongoDB, and Redis. Hands-on experience with data warehousing (e.g., BigQuery, Snowflake, Redshift) and ETL/ELT pipeline design. Strong knowledge of database performance tuning, indexing, query optimization, and partitioning. Experience implementing high availability (HA) and disaster recovery (DR) strategies (e.g., replication, failover, backup/restore). Skilled in data modeling (conceptual, logical, and physical) and schema versioning. Familiar with real-time data streaming technologies such as Kafka or RabbitMQ. Understanding of cloud-based database services (GCP Cloud SQL/BigQuery, AWS RDS/Redshift, Azure SQL). Proficiency in scripting and automation using SQL, Python, or Shell scripting. Knowledge of data governance frameworks, data retention, and archival strategies. Experience in implementing data encryption, access control, auditing, and compliance with standards such as GDPR, ISO 27001, or PCI DSS. Ability to design scalable, fault-tolerant, and secure data architectures supporting microservices and analytics workloads. Experience designing data replication and synchronization topologies across multiple systems. Strong understanding of API-based data integration and event-driven architecture. Excellent communication and documentation skills to define and maintain database architecture blueprints and best practices. Ability to lead and mentor DBA, Data Engineer, and Developer teams. Proven experience collaborating with cross-functional teams (application, infrastructure, and DevSecOps).