Job description for Database Architech at Pt. Jaya Agung Teknologi
JobDesc :
1. 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.
2. 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.
3. 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.
4. 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.
5. 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.
6. 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 :
1. Education & Experience
Bachelor’s degree or higher in Computer Science, Information Systems, or related field.
Minimum 5+ years of experience in database design, development, and administration.
Proven experience in architecting large-scale and high-performance database systems (OLTP & OLAP).
2. Technical Expertise
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.
3. Governance & Security
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.
4. Architecture & Integration
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.
5. Leadership & Collaboration
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).
