Database Architect

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