Senior Database Architect

Jaya Agung Teknologi; Jakarta Pusat; On-site; IDR 700,000,000 - 1,200,000,000; Full time

Job summary

Jaya Agung Teknologi is seeking an experienced Senior Database Architect to lead the design, implementation, and optimization of our data platforms. You will own database architecture strategy, ensure high availability, drive scalability, and collaborate with engineering and product teams to support business requirements and data governance.

You will design large-scale database architectures, optimize performance, implement HA/DR, and lead data modeling, security, and cloud-based solutions

Qualifications

• Bachelor’s degree or higher in Computer Science, Information Systems, or related field.
• 8+ years of experience in database design, development, and administration.
• Proven experience architecting large-scale, high-performance database systems (OLTP & OLAP).
• Deep knowledge of relational and non-relational databases (PostgreSQL, MySQL, MongoDB, Redis).
• Hands-on with data warehousing (BigQuery, Snowflake, Redshift) and ETL/ELT pipelines.
• Strong tuning, indexing, and partitioning expertise; HA/DR familiarity.
• Experience with cloud-based DB services (GCP, AWS, Azure) and scripting (SQL/Python/Shell).
• Understanding of data governance, security, and compliance standards.

Responsibilities

• Design large-scale database architectures for operational and analytical systems.
• Lead HA/DR strategy, data replication, and disaster recovery planning.
• Define data models, schemas, and documentation standards.
• Drive data integration across microservices, DWH, and real-time pipelines.
• Collaborate with DBA, Data Engineer, and Developer teams; provide technical leadership.

Skills

Database design

Performance tuning

SQL scripting

Python scripting

Data modeling

HA/DR design

Cloud platforms

Data governance

Leadership

Cross-functional collaboration

Education

Bachelor's degree in CS/IS

Tools

PostgreSQL

MySQL

MongoDB

Redis

BigQuery

Snowflake

Redshift

Kafka

RabbitMQ

GCP

AWS

Azure

CDC pipelines

Job description

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.

Requirements

• 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 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).