Database Architect Bandung View Detail

Roketin; Kota Bandung; On-site; IDR 200,000,000 - 420,000,000; Full time

Job summary

Roketin is seeking a Database Architect to design, optimize, and govern enterprise-grade database architectures in Bandung. You will ensure high performance, security, and availability while establishing standards and best practices to support mission-critical operations and strategic data initiatives.

Responsibilities include end-to-end architecture design, performance tuning, data governance, and implementing replication, DR, and security controls.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Database certification (Oracle, PostgreSQL, or SQL Server) is highly preferred.
• 1-3 years of experience as DBA, Database Architect, or Data Engineer.

Responsibilities

• Architecture & Design: Design and manage end-to-end database architecture including conceptual, logical, and physical data modeling, normalization strategies, and schema optimization to support scalable and maintainable systems.
• Performance & Reliability: Ensure database performance, security, and high availability through advanced query optimization, execution plan analysis, indexing strategies, partitioning/sharding, and implementation of replication, clustering, and disaster recovery mechanisms.
• Governance & Standards: Develop and enforce database policies, standards, and security protocols (encryption, auditing, access control) while providing technical recommendations for enterprise data management initiatives such as MDM (Master Data Management) and SSOT (Single Source of Truth).
• Optimization & Support: Conduct proactive monitoring, bottleneck analysis, and troubleshooting of database systems; provide expert-level support for complex technical issues and continuous improvement initiatives.

Skills

Advanced SQL

Data Modeling

Query Optimization

Indexing

Performance Tuning

High Availability

Backup & Recovery

Disaster Recovery

Data Security

Database Governance

Troubleshooting

Technical Documentation

MDM/SSOT Concepts

Education

Bachelor's degree in Computer Science or Information Systems

Tools

PostgreSQL

MySQL

Oracle

SQL Server

NoSQL

Job description

Database Architect responsible for designing, optimizing, and governing enterprise-grade database architectures. Ensures high performance, security, and availability of data systems while establishing standards, policies, and best practices to support mission-critical operations and strategic data initiatives.

Key Responsibilities:

• Architecture & Design: Design and manage end-to-end database architecture including conceptual, logical, and physical data modeling, normalization strategies, and schema optimization to support scalable and maintainable systems.
• Performance & Reliability: Ensure database performance, security, and high availability through advanced query optimization, execution plan analysis, indexing strategies, partitioning/sharding, and implementation of replication, clustering, and disaster recovery mechanisms.
• Governance & Standards: Develop and enforce database policies, standards, and security protocols (encryption, auditing, access control) while providing technical recommendations for enterprise data management initiatives such as MDM (Master Data Management) and SSOT (Single Source of Truth).
• Optimization & Support: Conduct proactive monitoring, bottleneck analysis, and troubleshooting of database systems; provide expert-level support for complex technical issues and continuous improvement initiatives.
  

Qualifications:

• Bachelor's degree (S1) in Computer Science, Information Systems, or related field.
• Database certification (Oracle, PostgreSQL, or SQL Server) is highly preferred.
• 1-3 years of experience as DBA, Database Architect, or Data Engineer.'
• Proven experience handling enterprise or mission-critical database systems.
• Mandatory proficiency in Advanced SQL with expertise in query optimization and indexing.
• Strong knowledge of RDBMS (PostgreSQL, MySQL, Oracle, SQL Server); familiarity with NoSQL is a plus.
• Hands-on experience with data modeling tools, performance tuning, and high-availability architectures (replication, clustering, backup/restore, DR).
• Understanding of data security principles including encryption, auditing, and access control.
• Strong analytical, problem-solving, and communication skills with ability to work independently or collaboratively.
• Detail-oriented, systematic, and committed to producing clear technical documentation.
  

Requirements:

• Advanced SQL
• Data Modeling (Conceptual/Logical/Physical)
• Query Optimization
• Indexing
• Performance Tuning
• High Availability (Replication/Clustering)
• Backup & Recovery
• Disaster Recovery
• Data Security (Encryption/Auditing)
• Database Governance
• Troubleshooting
• Technical Documentation
• MDM/SSOT Concepts (Plus)