SR. DATABASE ARCHITECH

As a Senior Database Architect at PT JAYA AGUNG TEKNOLOGI, you will be responsible for designing, implementing, and optimizing complex database systems to support the company's mission-critical applications. In this full-time position, you will work out of our office in North Jakarta, Jakarta Raya, playing a crucial role in the Information Technology & Communication department's Database Development & Administration team.

• What you'll be doing ?
• 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 IS

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