JOB DECRIPTION :
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.
JOB REQUIREMENT :
- Bachelor's degree or higher in Computer Science, Information Systems, or related field.
- Minimum 5+ 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).