Database Architect

Roketin - PT Roketin Kreatif Teknologi; Sumur Bandung; On-site; IDR 250,000,000 - 450,000,000; Full time

Job summary

Roketin - PT Roketin Kreatif Teknologi is seeking a Database Architect to design enterprise-grade database architectures and govern data systems. You will ensure performance, security, and availability while establishing standards and best practices for strategic data initiatives.

The role emphasizes end-to-end modeling, replication, DR, and governance, with a focus on certification and hands-on optimization across PostgreSQL, MySQL, Oracle, and SQL Server environments.

Qualifications

• Bachelor's degree in CS/IS or related field.
• Database certification (Oracle, PostgreSQL, or SQL Server) is highly preferred.
• Minimum 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.

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

DB Architecture

Data Modeling

RDBMS knowledge

Performance tuning

Security & encryption

Documentation

Problem solving

Education

Bachelor's degree in CS/IS

Tools

Data modeling tools

Backup/DR tools

Job description

Job Requirements

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.
• Minimum 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
• Database Architecture
• Data Modeling (Conceptual/Logical/Physical)
• RDBMS (PostgreSQL/MySQL/Oracle/SQL Server)
• Query Optimization
• Indexing
• Performance Tuning
• Execution Plan Analysis
• High Availability (Replication/Clustering)
• Backup & Recovery
• Disaster Recovery
• Data Security (Encryption/Auditing)
• Database Governance
• Troubleshooting
• Technical Documentation
• MDM/SSOT Concepts (Plus)