Data Analyze
Ida Bagus Enderajana
Senior Database Consultant
Jakarta
Summary
I am an accomplished IT professional with over 22 years of extensive experience in the ICT industry, spanning a wide range of sectors including Telecommunications, Government, State-Owned Enterprises (BUMN), Banking, Transportation, Retail, Manufacturing, Insurance, and Oil & Gas. My expertise encompasses a variety of critical roles such as Database Administrator (DBA), DBA Team Lead, Database Expert, Database Engineer, Database Solutions Architect, EAI Developer (WebMethods), IT Database Manager, IT Infrastructure Manager, and Project Team Leader. My career began even before graduation, where I contributed to projects involving inventory systems, database troubleshooting, and teaching programming languages. After graduating, I played a key role in developing Indonesia’s first train reservation system with integrated payment via BCA ATM. This groundbreaking project marked the beginning of my career in delivering innovative and impactful IT solutions across multiple industries. Over the years, I have accumulated significant experience in leading and executing complex projects across diverse sectors: Telecommunications: Delivered high-impact projects for major telco players such as Telkom, Telkomsel, Axis, XL Axiata, and Indosat Ooredoo, including Customer Care Flexi & Finance Audit (SOX Compliance), Electronic Voucher System, Dompetku (Mobile Wallet Solution), Service Platform Network (SPN), and Business Support System (BSS). Government & BUMN: Supported IT transformation and database management for large-scale government and BUMN projects, focusing on critical public service systems and operational efficiency. Banking: Contributed to secure and efficient database architecture for banking operations, ensuring compliance with financial industry standards. Transportation: Played a pivotal role in transforming the transportation sector through innovative IT systems, such as Indonesia's first integrated train reservation and payment system. Retail & Manufacturing: Streamlined operational processes through robust database solutions and system integrations that enhanced supply chain and customer management. Insurance: Delivered efficient IT solutions to support claims processing, policy management, and regulatory compliance. Oil & Gas: Enabled critical operational support through reliable IT infrastructure and data management tailored to the industry’s unique demands. With over 15 years of specialization in the telecommunications sector, I have developed deep expertise in delivering scalable, innovative, and efficient solutions that address complex business challenges. My experience spans end-to-end project delivery, from design and development to deployment and support, ensuring optimal results and client satisfaction.
Overview
24
24
years of professional experience
4
4
Certifications
Work History
Team Lead DBA & Database Solution Architect
Tata Consultancy Services
Jakarta, Jakarta
05.2016 - Current
- Company Overview: Global Leader in IT Services, Consulting, Technology and Digital Solutions with a Large Network of Innovation & Delivery Centers. Tata Consultancy Services Limited is an Indian multinational information technology service, consulting and business solutions company Headquartered in Mumbai, Maharashtra. It is a subsidiary of the Tata Group Company and operates in 149 locations across 46 countries.
- Lead and Coordinate DBA Team (Team Infra) to Maintain all Database Core System (Oracle Database) and All Database Satellite System (PostgreSQL Databases) and provide Database Solution Architecture for Enterprise Data warehouse Project at Allianz Insurance.
- Determine and Design Physical Architecture for Database Core System.
- Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, Backup, and Recovery Strategy.
- Provide Solutions for Slow Performance Complex Query.
- Capacity Planning for Enterprise Data warehouse.
- Maintains database performance by identifying and resolving production and application development problems.
- Minimize Down Time Database Upgrade and Migration Using Oracle ADG.
- Configure HA Database Using Oracle ADG and Attunity.
- Tuning Database Performance (Instance Tuning).
- Tuning And Optimize Query Statement.
- Implement Clean garbage Connection Solution on Core Database Systems.
- Collaborate with Team Apps to Implement Fix Slow Transaction between Talend Server and Core Database Servers.
- Provides database support by coding utilities, responding to user questions, and resolving problems.
- Global Leader in IT Services, Consulting, Technology and Digital Solutions with a Large Network of Innovation & Delivery Centers. Tata Consultancy Services Limited is an Indian multinational information technology service, consulting and business solutions company Headquartered in Mumbai, Maharashtra. It is a subsidiary of the Tata Group Company and operates in 149 locations across 46 countries.
Team Lead DBA & Database Solution Architect
Tata Consultancy Services
05.2016 - Current
- Company Overview: Global Leader in IT Services, Consulting, Technology and Digital Solutions with a Large Network of Innovation & Delivery Centers. Tata Consultancy Services Limited is an Indian multinational information technology service, consulting and business solutions company Headquartered in Mumbai, Maharashtra. It is a subsidiary of the Tata Group Company and operates in 149 locations across 46 countries.
- Lead and Coordinate DBA Team (Team Infra) to Maintain all Database Core System (Oracle Database) and All Database Satellite System (PostgreSQL Databases) and provide Database Solution Architecture for Enterprise Datawarehouse Project at Allianz Insurance.
- Determine and Design Physical Architecture for Database Core System.
- Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, Backup, and Recovery Strategy.
- Provide Solutions for Slow Performance Complex Query.
- Capacity Planning for Enterprise Datawarehouse.
- Maintains database performance by identifying and resolving production and application development problems.
- Minimize Down Time Database Upgrade and Migration Using Oracle ADG.
- Configure HA Database Using Oracle ADG and Attunity.
- Tuning Database Performance (Instance Tuning).
- Tuning And Optimize Query Statement.
- Implement Clean garbage Connection Solution on Core Database Systems.
- Collaborate with Team Apps to Implement Fix Slow Transaction between Talend Server and Core Database Servers.
- Provides database support by coding utilities, responding to user questions, and resolving problems.
- Global Leader in IT Services, Consulting, Technology and Digital Solutions with a Large Network of Innovation & Delivery Centers. Tata Consultancy Services Limited is an Indian multinational information technology service, consulting and business solutions company Headquartered in Mumbai, Maharashtra. It is a subsidiary of the Tata Group Company and operates in 149 locations across 46 countries.
Team Lead DBA
Sisindokom Lintasbuana
05.2015 - 05.2016
- Company Overview: Previously known as PT. Sisindosat Lintasbuana, acquired by Astel Group in 2005 and transformed into PT. Sisindokom Lintasabuana (Sisindokom). Since 1990, the company has set the foundation to become professional system integrator in the field of Information and Communication Technology (ICT).
- Leadership and Coordination of DBA Team for Comprehensive Database Support, Maintenance, and High-Availability Solutions Across Multiple Key Clients.
- Lead 24/7 Database Support and Maintenance for approximately 190 database instances, including 45 clustered databases at PT. Indosat (Ooredo Group), ensuring high performance, availability, and proactive issue resolution through Preventive Maintenance (PM) and Corrective Maintenance (CM) activities.
- Spearheaded the successful implementation of Oracle EXADATA at PT. KAI, optimizing database performance and scalability for critical operations.
- Orchestrated the configuration and management of Oracle High Availability (HA) using Oracle Data Guard at PT. KAI, ensuring robust disaster recovery and system resilience.
- Managed the addition and removal of RAC nodes in the core system environment at PT. Indosat Ooredo (Ooredo Group), enhancing system scalability and availability.
- Provided 24/7 database support for mission-critical Pension Fund Application at PT. Pertamina, ensuring operational continuity and system reliability.
- Delivered round-the-clock database support for Core Systems of Dirjen Pajak (Indonesian Directorate General of Taxes), playing a pivotal role in maintaining system stability and data integrity.
- Led 24/7 database support for high-profile clients such as Lintasarta and Artajasa, ensuring their systems operate smoothly and efficiently.
- Supported the SMS Application with 2 database instances at Indosat Ooredo, optimizing system uptime and performance.
- Managed 5x8 support and maintenance for 9 database instances at the Central Bank of Indonesia, ensuring regulatory compliance and system reliability.
- Configured High Availability (HA) solutions for the RTGS System at Bank Mandiri, significantly improving system uptime and operational efficiency.
- Implemented and managed Oracle Data Guard across all clients, safeguarding data integrity and business continuity through enhanced disaster recovery capabilities.
- Led Disaster Recovery (DR) Simulations, including Switchover and Switchback procedures, using Oracle Data Guard to ensure readiness for critical system failover scenarios.
- Expertly troubleshot and resolved Oracle Data Guard issues, minimizing downtime and ensuring seamless operations across all clients.
- Championed the implementation of core database replication using Oracle GoldenGate at PPATK, enhancing real-time data integration and system performance.
- Previously known as PT. Sisindosat Lintasbuana, acquired by Astel Group in 2005 and transformed into PT. Sisindokom Lintasabuana (Sisindokom). Since 1990, the company has set the foundation to become professional system integrator in the field of Information and Communication Technology (ICT).
Team Lead DBA
Sisindokom Lintasbuana
05.2015 - 05.2016
- Company Overview: Previously known as PT. Sisindosat Lintasbuana, acquired by Astel Group in 2005 and transformed into PT. Sisindokom Lintasabuana (Sisindokom). Since 1990, the company has set the foundation to become professional system integrator in the field of Information and Communication Technology (ICT).
- Leadership and Coordination of DBA Team for Comprehensive Database Support, Maintenance, and High-Availability Solutions Across Multiple Key Clients.
- Lead 24/7 Database Support and Maintenance for approximately 190 database instances, including 45 clustered databases at PT. Indosat (Ooredo Group), ensuring high performance, availability, and proactive issue resolution through Preventive Maintenance (PM) and Corrective Maintenance (CM) activities.
- Spearheaded the successful implementation of Oracle EXADATA at PT. KAI, optimizing database performance and scalability for critical operations.
- Orchestrated the configuration and management of Oracle High Availability (HA) using Oracle Data Guard at PT. KAI, ensuring robust disaster recovery and system resilience.
- Managed the addition and removal of RAC nodes in the core system environment at PT. Indosat Ooredo (Ooredo Group), enhancing system scalability and availability.
- Provided 24/7 database support for mission-critical Pension Fund Application at PT. Pertamina, ensuring operational continuity and system reliability.
- Delivered round-the-clock database support for Core Systems of Dirjen Pajak (Indonesian Directorate General of Taxes), playing a pivotal role in maintaining system stability and data integrity.
- Led 24/7 database support for high-profile clients such as Lintasarta and Artajasa, ensuring their systems operate smoothly and efficiently.
- Supported the SMS Application with 2 database instances at Indosat Ooredo, optimizing system uptime and performance.
- Managed 5x8 support and maintenance for 9 database instances at the Central Bank of Indonesia, ensuring regulatory compliance and system reliability.
- Configured High Availability (HA) solutions for the RTGS System at Bank Mandiri, significantly improving system uptime and operational efficiency.
- Implemented and managed Oracle Data Guard across all clients, safeguarding data integrity and business continuity through enhanced disaster recovery capabilities.
- Led Disaster Recovery (DR) Simulations, including Switchover and Switchback procedures, using Oracle Data Guard to ensure readiness for critical system failover scenarios.
- Expertly troubleshot and resolved Oracle Data Guard issues, minimizing downtime and ensuring seamless operations across all clients.
- Championed the implementation of core database replication using Oracle GoldenGate at PPATK, enhancing real-time data integration and system performance.
- Previously known as PT. Sisindosat Lintasbuana, acquired by Astel Group in 2005 and transformed into PT. Sisindokom Lintasabuana (Sisindokom). Since 1990, the company has set the foundation to become professional system integrator in the field of Information and Communication Technology (ICT).
IT Infrastructure Manager (Database & System)
XL Axiata
03.2014 - 04.2015
- Company Overview: PT XL Axiata Tbk (formerly PT Excelcomindo Pratama Tbk), is an Indonesia-based mobile telecommunications services operator. The operator's coverage includes Java, Bali, and Lombok as well as the principal cities in and around Sumatra, Kalimantan and Sulawesi.
- Supervise and Coordinate Data Migration Activities.
- Collaborate with users to gather business requirements for data migration needs.
- Assist in the design, planning, and management of the entire data migration process.
- Partner with subject matter experts and the project team to identify, define, collect, document, and communicate data migration requirements.
- Manage assigned risks and closely monitor potential impacts as part of the data migration plan.
- Oversee the migration and testing of static data, ensuring accuracy and completeness.
- PT XL Axiata Tbk (formerly PT Excelcomindo Pratama Tbk), is an Indonesia-based mobile telecommunications services operator. The operator's coverage includes Java, Bali, and Lombok as well as the principal cities in and around Sumatra, Kalimantan and Sulawesi.
IT Infrastructure Manager (Database & System)
XL Axiata
03.2014 - 04.2015
- Company Overview: PT XL Axiata Tbk (formerly PT Excelcomindo Pratama Tbk), is an Indonesia-based mobile telecommunications services operator. The operator's coverage includes Java, Bali, and Lombok as well as the principal cities in and around Sumatra, Kalimantan and Sulawesi.
- Supervise and Coordinate Data Migration Activities.
- Collaborate with users to gather business requirements for data migration needs.
- Assist in the design, planning, and management of the entire data migration process.
- Partner with subject matter experts and the project team to identify, define, collect, document, and communicate data migration requirements.
- Manage assigned risks and closely monitor potential impacts as part of the data migration plan.
- Oversee the migration and testing of static data, ensuring accuracy and completeness.
- PT XL Axiata Tbk (formerly PT Excelcomindo Pratama Tbk), is an Indonesia-based mobile telecommunications services operator. The operator's coverage includes Java, Bali, and Lombok as well as the principal cities in and around Sumatra, Kalimantan and Sulawesi.
IT Infrastructure Manager (Database & System)
Axis Telekom Indonesia
02.2011 - 03.2014
- Company Overview: AXIS Telekom Indonesia (AXIS) is the fastest growing national GSM mobile operator in Indonesia. The company provides 2G, 3G and BlackBerry Services nationwide and covers the world through 382 international roaming partners in 159 countries.
- Supervise and Coordinate MS Team DBA and Backup Team to Ensure Optimal Database Maintenance.
- Design and Implement Database Architecture Solutions for Enterprise Data Warehouses, ensuring scalability and high performance.
- Monitor and Optimize Database Performance, ensuring stable operations and conducting tuning as necessary.
- Oversee Database Resource Allocation, ensuring all database objects have designated owners.
- Prevent objects from being created in default permanent tablespaces and enforce best practices by restricting the use of SYS, AUX, and SYSTEM tablespaces for storage.
- Regularly clean up obsolete or unused objects.
- Ensure Database Security by preventing unauthorized access to application schemas and enforcing security policies.
- Develop and Implement Backup Strategies for VLDB Databases (size > 90 TB), ensuring consistent and reliable data protection.
- Troubleshoot Database Issues swiftly to minimize downtime and service disruption.
- Perform Database Upgrades to address bugs, improve performance, and implement security patches.
- Manage Logical Backups to ensure data integrity and availability.
- Monitor and Maintain Database Storage, ensuring adequate space allocation and preventing storage shortages that could impact database availability.
- Supervise Database Installation, Migration, and Upgrades, ensuring smooth transitions and minimal disruption to services.
- Align Database Development with Business Requirements, ensuring all systems meet organizational needs.
- Prepare Scalability and Capacity Planning Reports, providing insights into future database requirements.
- Enforce Best Practices for database management and maintenance to optimize operational efficiency.
- Create and Implement Standard Operating Procedures to enhance scalability, performance, and consistency in the database architecture.
- AXIS Telekom Indonesia (AXIS) is the fastest growing national GSM mobile operator in Indonesia. The company provides 2G, 3G and BlackBerry Services nationwide and covers the world through 382 international roaming partners in 159 countries.
IT Infrastructure Manager (Database & System)
Axis Telekom Indonesia
02.2011 - 03.2014
- Company Overview: AXIS Telekom Indonesia (AXIS) is the fastest growing national GSM mobile operator in Indonesia. The company provides 2G, 3G and BlackBerry Services nationwide and covers the world through 382 international roaming partners in 159 countries.
- Supervise and Coordinate MS Team DBA and Backup Team to Ensure Optimal Database Maintenance.
- Design and Implement Database Architecture Solutions for Enterprise Data Warehouses, ensuring scalability and high performance.
- Monitor and Optimize Database Performance, ensuring stable operations and conducting tuning as necessary.
- Oversee Database Resource Allocation, ensuring all database objects have designated owners.
- Prevent objects from being created in default permanent tablespaces and enforce best practices by restricting the use of SYS, AUX, and SYSTEM tablespaces for storage.
- Regularly clean up obsolete or unused objects.
- Ensure Database Security by preventing unauthorized access to application schemas and enforcing security policies.
- Develop and Implement Backup Strategies for VLDB Databases (size > 90 TB), ensuring consistent and reliable data protection.
- Troubleshoot Database Issues swiftly to minimize downtime and service disruption.
- Perform Database Upgrades to address bugs, improve performance, and implement security patches.
- Manage Logical Backups to ensure data integrity and availability.
- Monitor and Maintain Database Storage, ensuring adequate space allocation and preventing storage shortages that could impact database availability.
- Supervise Database Installation, Migration, and Upgrades, ensuring smooth transitions and minimal disruption to services.
- Align Database Development with Business Requirements, ensuring all systems meet organizational needs.
- Prepare Scalability and Capacity Planning Reports, providing insights into future database requirements.
- Enforce Best Practices for database management and maintenance to optimize operational efficiency.
- Create and Implement Standard Operating Procedures to enhance scalability, performance, and consistency in the database architecture.
- AXIS Telekom Indonesia (AXIS) is the fastest growing national GSM mobile operator in Indonesia. The company provides 2G, 3G and BlackBerry Services nationwide and covers the world through 382 international roaming partners in 159 countries.
Team Lead DBA
Oracle
04.2010 - 01.2011
- Company Overview: Excelcom (XL Axiata), one of the biggest telecom operator in Indonesia has selected Oracle Corporation as their prime partner in the Managed Utility project.
- Lead and Mentor a Team of DBAs, Driving Excellence in Database Management and Performance.
- Provide Daily Support, including maintenance, monitoring, and troubleshooting, to ensure seamless operation of all Billing Databases and address issues such as space constraints and performance degradation.
- Lead Installation and Setup of Oracle 11gR2 RAC, ensuring high availability and scalability for critical applications.
- Optimize Database Performance by conducting regular tuning, including gathering statistics for large tables to enhance query performance and overall efficiency.
- Develop and Implement Database Monitoring Tools to proactively track database health and performance metrics.
- Perform Data Housekeeping, ensuring data cleanliness and effective database management by regularly purging obsolete or unnecessary data.
- Apply Patches and Bug Fixes as needed to address identified issues or user requests, ensuring stability and security across all systems.
- Lead Database Migration Projects, including the upgrade from Oracle 10.2 to 11gR1 as part of the Billing Application upgrade (Amdocs 7.3 to 7.5), ensuring smooth transitions with minimal disruption.
- Support Disaster Recovery (DRC) Activities, leveraging Oracle GoldenGate (OGG) for real-time database replication to maintain business continuity and minimize downtime.
- Provide Capacity Planning and Forecasting for database storage, anticipating growth and ensuring adequate resources to handle future demands.
- Generate Daily and Weekly Health Check Reports for all Billing Databases, ensuring continuous oversight and quick identification of potential issues.
- Implement Security Policies for database users, ensuring compliance with internal and external regulations and protecting sensitive data.
- Establish and Maintain Comprehensive Documentation for database configurations, procedures, and best practices to ensure consistency and facilitate knowledge transfer.
- Excelcom (XL Axiata), one of the biggest telecom operator in Indonesia has selected Oracle Corporation as their prime partner in the Managed Utility project.
Team Lead DBA
Oracle
04.2010 - 01.2011
- Company Overview: Excelcom (XL Axiata), one of the biggest telecom operator in Indonesia has selected Oracle Corporation as their prime partner in the Managed Utility project.
- Lead and Mentor a Team of DBAs, Driving Excellence in Database Management and Performance.
- Provide Daily Support, including maintenance, monitoring, and troubleshooting, to ensure seamless operation of all Billing Databases and address issues such as space constraints and performance degradation.
- Lead Installation and Setup of Oracle 11gR2 RAC, ensuring high availability and scalability for critical applications.
- Optimize Database Performance by conducting regular tuning, including gathering statistics for large tables to enhance query performance and overall efficiency.
- Develop and Implement Database Monitoring Tools to proactively track database health and performance metrics.
- Perform Data Housekeeping, ensuring data cleanliness and effective database management by regularly purging obsolete or unnecessary data.
- Apply Patches and Bug Fixes as needed to address identified issues or user requests, ensuring stability and security across all systems.
- Lead Database Migration Projects, including the upgrade from Oracle 10.2 to 11gR1 as part of the Billing Application upgrade (Amdocs 7.3 to 7.5), ensuring smooth transitions with minimal disruption.
- Support Disaster Recovery (DRC) Activities, leveraging Oracle GoldenGate (OGG) for real-time database replication to maintain business continuity and minimize downtime.
- Provide Capacity Planning and Forecasting for database storage, anticipating growth and ensuring adequate resources to handle future demands.
- Generate Daily and Weekly Health Check Reports for all Billing Databases, ensuring continuous oversight and quick identification of potential issues.
- Implement Security Policies for database users, ensuring compliance with internal and external regulations and protecting sensitive data.
- Establish and Maintain Comprehensive Documentation for database configurations, procedures, and best practices to ensure consistency and facilitate knowledge transfer.
- Excelcom (XL Axiata), one of the biggest telecom operator in Indonesia has selected Oracle Corporation as their prime partner in the Managed Utility project.
DBA Team Lead and System Analyst
Logica
02.2009 - 12.2009
- Company Overview: LOGICA implement project in PT Natrindo Telepon Seluler (AXIS) as The Prime Contractor to design, build and operate the Service Platform Network (SPN) that includes IP-based Next Generations Messaging architecture and prepaid charging solutions.
- Develop Gap Analysis Documentation comparing the Test Environment with the Production Environment, identifying discrepancies, potential risks, and areas for optimization to ensure consistency and alignment across both environments.
- Manage the Build and Release Process, collaborating closely with both Development and Operations teams to ensure smooth integration, efficient workflows, and timely deployment of software across all stages.
- Create Detailed Physical Architecture Documentation for the Test Environment, capturing all system components, configurations, and dependencies to ensure accurate replication of production-like conditions and facilitate effective testing.
- LOGICA implement project in PT Natrindo Telepon Seluler (AXIS) as The Prime Contractor to design, build and operate the Service Platform Network (SPN) that includes IP-based Next Generations Messaging architecture and prepaid charging solutions.
DBA Team Lead and System Analyst
Logica
02.2009 - 12.2009
- Company Overview: LOGICA implement project in PT Natrindo Telepon Seluler (AXIS) as The Prime Contractor to design, build and operate the Service Platform Network (SPN) that includes IP-based Next Generations Messaging architecture and prepaid charging solutions.
- Develop Gap Analysis Documentation comparing the Test Environment with the Production Environment, identifying discrepancies, potential risks, and areas for optimization to ensure consistency and alignment across both environments.
- Manage the Build and Release Process, collaborating closely with both Development and Operations teams to ensure smooth integration, efficient workflows, and timely deployment of software across all stages.
- Create Detailed Physical Architecture Documentation for the Test Environment, capturing all system components, configurations, and dependencies to ensure accurate replication of production-like conditions and facilitate effective testing.
- LOGICA implement project in PT Natrindo Telepon Seluler (AXIS) as The Prime Contractor to design, build and operate the Service Platform Network (SPN) that includes IP-based Next Generations Messaging architecture and prepaid charging solutions.
Senior DBA – Operation & Implementation
UTIBA
03.2008 - 02.2009
- Company Overview: UTIBA implement project in PT. INDOSAT Tbk and PT Natrindo Telepon Seluler (Axis) as The Prime Contractor to design, build and operate the E-TopPup (U-Choose) system and M-Wallet (U-Trust) system.
- Upgrade and Patch Oracle Database: Successfully upgrade Oracle Database from version 10.2.0.1 to 10.2.0.4, ensuring improved functionality and security.
- Install and Configure Oracle Real Application Clusters (RAC): Expertly install and configure Oracle RAC for both Solaris and Red Hat Linux environments to ensure high availability and scalability.
- Conduct Integration Testing for Oracle RAC and Sun Cluster: Perform thorough integration testing to validate seamless operation between Oracle RAC and Sun Cluster.
- Implement Database Replication with Data Guard: Set up and configure Oracle Data Guard to replicate data across Oracle RAC environments for enhanced disaster recovery and high availability.
- Install and Configure Oracle Enterprise Manager (OEM) Grid Control: Deploy and configure Oracle Enterprise Manager Grid Control for centralized database monitoring, management, and diagnostics.
- Design and Size Storage for Oracle Database (M-Wallet Implementation): Conduct comprehensive storage design and sizing for Oracle databases to support the implementation of M-Wallet solutions.
- Data Migration Execution: Oversee and execute seamless data migration processes to ensure accurate and timely database transitions.
- Provide Technical Support and Consultation: Offer expert technical troubleshooting and provide consultative support to development teams to resolve complex database issues.
- Implement Auto Housekeeping for Database Systems: Automate database housekeeping tasks to optimize database performance and reduce manual intervention.
- Database Performance Monitoring: Continuously monitor and optimize the performance of all production databases to ensure operational efficiency.
- Daily Health Check Reports for All Databases: Provide comprehensive daily health checks and status reports to proactively identify and resolve potential database issues.
- Database Recovery Testing: Perform Point-In-Time Recovery (PITR) and complete disaster recovery testing to validate backup strategies and recovery procedures.
- Capacity Planning and Database Growth Analysis: Analyze database growth patterns and perform capacity planning to ensure optimal scalability and resource allocation.
- Database Security Management: Implement and enforce robust security policies for database users to safeguard sensitive information and ensure compliance with industry standards.
- Database Migration Management: Oversee and execute complex database migrations, ensuring data integrity and minimal disruption to business operations.
- User Acceptance Testing (UAT): Facilitate and support User Acceptance Testing (UAT) to ensure the successful deployment of new database solutions and features.
- Database Security Implementation and Maintenance: Implement, manage, and maintain database security protocols, ensuring data confidentiality and regulatory compliance.
- Database Hardening: Perform database hardening activities to mitigate security vulnerabilities and enhance the overall security posture.
- Comprehensive Database Troubleshooting: Provide expert troubleshooting for database issues, addressing performance, security, and operational challenges.
- Engage with Oracle Technical Support: Liaise with Oracle Corporation’s technical support teams for advanced issue resolution and product guidance.
- Maintain Detailed Documentation: Develop and maintain thorough documentation of database systems, configurations, and operational procedures to ensure knowledge transfer and support future reference.
- UTIBA implement project in PT. INDOSAT Tbk and PT Natrindo Telepon Seluler (Axis) as The Prime Contractor to design, build and operate the E-TopPup (U-Choose) system and M-Wallet (U-Trust) system.
Senior DBA – Operation & Implementation
UTIBA
03.2008 - 02.2009
- Company Overview: UTIBA implement project in PT. INDOSAT Tbk and PT Natrindo Telepon Seluler (Axis) as The Prime Contractor to design, build and operate the E-TopPup (U-Choose) system and M-Wallet (U-Trust) system.
- Upgrade and Patch Oracle Database: Successfully upgrade Oracle Database from version 10.2.0.1 to 10.2.0.4, ensuring improved functionality and security.
- Install and Configure Oracle Real Application Clusters (RAC): Expertly install and configure Oracle RAC for both Solaris and Red Hat Linux environments to ensure high availability and scalability.
- Conduct Integration Testing for Oracle RAC and Sun Cluster: Perform thorough integration testing to validate seamless operation between Oracle RAC and Sun Cluster.
- Implement Database Replication with Data Guard: Set up and configure Oracle Data Guard to replicate data across Oracle RAC environments for enhanced disaster recovery and high availability.
- Install and Configure Oracle Enterprise Manager (OEM) Grid Control: Deploy and configure Oracle Enterprise Manager Grid Control for centralized database monitoring, management, and diagnostics.
- Design and Size Storage for Oracle Database (M-Wallet Implementation): Conduct comprehensive storage design and sizing for Oracle databases to support the implementation of M-Wallet solutions.
- Data Migration Execution: Oversee and execute seamless data migration processes to ensure accurate and timely database transitions.
- Provide Technical Support and Consultation: Offer expert technical troubleshooting and provide consultative support to development teams to resolve complex database issues.
- Implement Auto Housekeeping for Database Systems: Automate database housekeeping tasks to optimize database performance and reduce manual intervention.
- Database Performance Monitoring: Continuously monitor and optimize the performance of all production databases to ensure operational efficiency.
- Daily Health Check Reports for All Databases: Provide comprehensive daily health checks and status reports to proactively identify and resolve potential database issues.
- Database Recovery Testing: Perform Point-In-Time Recovery (PITR) and complete disaster recovery testing to validate backup strategies and recovery procedures.
- Capacity Planning and Database Growth Analysis: Analyze database growth patterns and perform capacity planning to ensure optimal scalability and resource allocation.
- Database Security Management: Implement and enforce robust security policies for database users to safeguard sensitive information and ensure compliance with industry standards.
- Database Migration Management: Oversee and execute complex database migrations, ensuring data integrity and minimal disruption to business operations.
- User Acceptance Testing (UAT): Facilitate and support User Acceptance Testing (UAT) to ensure the successful deployment of new database solutions and features.
- Database Security Implementation and Maintenance: Implement, manage, and maintain database security protocols, ensuring data confidentiality and regulatory compliance.
- Database Hardening: Perform database hardening activities to mitigate security vulnerabilities and enhance the overall security posture.
- Comprehensive Database Troubleshooting: Provide expert troubleshooting for database issues, addressing performance, security, and operational challenges.
- Engage with Oracle Technical Support: Liaise with Oracle Corporation’s technical support teams for advanced issue resolution and product guidance.
- Maintain Detailed Documentation: Develop and maintain thorough documentation of database systems, configurations, and operational procedures to ensure knowledge transfer and support future reference.
- UTIBA implement project in PT. INDOSAT Tbk and PT Natrindo Telepon Seluler (Axis) as The Prime Contractor to design, build and operate the E-TopPup (U-Choose) system and M-Wallet (U-Trust) system.
DBA Team Lead – Operation Team
LOGICA
03.2006 - 03.2008
- Company Overview: LOGICA implement project in PT Natrindo Telepon Seluler (AXIS) as The Prime Contractor to design, build and operate the Service Platform Network (SPN) that includes IP-based Next Generations Messaging architecture and prepaid charging solutions.
- Leading and mentoring a team of DBAs, including setting objectives, delegating tasks, and ensuring the team meets organizational goals.
- Oracle Database Installation, Configuration, and Upgrades: Lead the installation, configuration, and upgrade of Oracle Database (versions 9i and 10g) across various environments, including Intec Servers, Provisioning Servers, Mediation Servers, and FirstHop Servers, on both production and development machines.
- Successfully upgrade Oracle Database from version 9.2.0.1 to 9.2.0.6, ensuring smooth transitions and minimal downtime.
- Database Health Checks and Troubleshooting: Perform comprehensive cross-checking of Oracle Databases to verify successful installation and error-free operation.
- Provide ongoing technical troubleshooting and expert consultation to the development team to resolve issues efficiently.
- Perform daily health checks for all database systems, ensuring optimal performance and system stability.
- Backup and Recovery Management: Establish and maintain robust backup and recovery policies using RMAN, integrated with HP Data Protector, ensuring high availability and business continuity.
- Perform regular backups (full, logical, and incremental) for Oracle, Informix, and MS SQL Server databases, ensuring consistent and reliable data protection.
- Regularly clean up expired and obsolete backup information from the RMAN catalog for efficient backup management.
- Conduct periodic test recoveries for Oracle Database, including Point-in-Time Recovery (PITR) and Disaster Recovery (full recovery), ensuring readiness for any disaster recovery scenario.
- Implement Ignite Backup for all systems, providing an image-based backup solution for disaster recovery.
- LOGICA implement project in PT Natrindo Telepon Seluler (AXIS) as The Prime Contractor to design, build and operate the Service Platform Network (SPN) that includes IP-based Next Generations Messaging architecture and prepaid charging solutions.
DBA Team Lead – Operation Team
LOGICA
03.2006 - 03.2008
- Company Overview: LOGICA implement project in PT Natrindo Telepon Seluler (AXIS) as The Prime Contractor to design, build and operate the Service Platform Network (SPN) that includes IP-based Next Generations Messaging architecture and prepaid charging solutions.
- Leading and mentoring a team of DBAs, including setting objectives, delegating tasks, and ensuring the team meets organizational goals.
- Oracle Database Installation, Configuration, and Upgrades: Lead the installation, configuration, and upgrade of Oracle Database (versions 9i and 10g) across various environments, including Intec Servers, Provisioning Servers, Mediation Servers, and FirstHop Servers, on both production and development machines.
- Successfully upgrade Oracle Database from version 9.2.0.1 to 9.2.0.6, ensuring smooth transitions and minimal downtime.
- Database Health Checks and Troubleshooting: Perform comprehensive cross-checking of Oracle Databases to verify successful installation and error-free operation.
- Provide ongoing technical troubleshooting and expert consultation to the development team to resolve issues efficiently.
- Perform daily health checks for all database systems, ensuring optimal performance and system stability.
- Backup and Recovery Management: Establish and maintain robust backup and recovery policies using RMAN, integrated with HP Data Protector, ensuring high availability and business continuity.
- Perform regular backups (full, logical, and incremental) for Oracle, Informix, and MS SQL Server databases, ensuring consistent and reliable data protection.
- Regularly clean up expired and obsolete backup information from the RMAN catalog for efficient backup management.
- Conduct periodic test recoveries for Oracle Database, including Point-in-Time Recovery (PITR) and Disaster Recovery (full recovery), ensuring readiness for any disaster recovery scenario.
- Implement Ignite Backup for all systems, providing an image-based backup solution for disaster recovery.
- LOGICA implement project in PT Natrindo Telepon Seluler (AXIS) as The Prime Contractor to design, build and operate the Service Platform Network (SPN) that includes IP-based Next Generations Messaging architecture and prepaid charging solutions.
Webmethod Developer | Database Administrator
WebMethods Inc.
10.2004 - 01.2006
- Company Overview: WebMethos Inc is an Enterprise Software Company, acquired by Software AG, focused on application integration, business process integration and B2B partner integration.
- Integrated Internal Control Management System (IICMS) Project: This project involved implementing a robust solution at PT. Telkom Indonesia using webMethods EAI v6.5.1, along with BPM (Business Process Modeling) and BAM (Business Activity Monitoring) tools from webMethods.
- Installed and configured Oracle Database to support the business-critical services and applications for Telkom's internal systems.
- Developed services using WebMethods Developer Tools, integrating them seamlessly into Telkom's infrastructure to enhance operational efficiency and support real-time business processes.
- Allocated system storage and planned for future storage requirements, ensuring optimal performance and scalability for growing database needs.
- Designed and created primary database storage structures (tablespaces) based on application requirements provided by developers.
- Created and maintained all necessary database objects, including tables, views, and stored procedures, to support the smooth operation of webMethods services and ensure seamless integration.
- Developed PL/SQL API packages and integrated them with webMethods services to enhance functionality and streamline business processes.
- Modified and optimized the database schema as needed based on requirements from application developers, ensuring that it aligned with business logic and application needs.
- Developed and implemented scripts to monitor database performance, identify bottlenecks, and optimize queries to ensure high system performance and uptime.
- Configured and implemented Oracle High Availability (HA) using Oracle Data Guard (ODG) to ensure minimal downtime and data redundancy for critical databases.
- Planned and implemented comprehensive backup and recovery strategies to ensure the integrity and availability of critical business data.
- Led efforts in hardening the database, including securing sensitive data and enforcing access controls to protect against unauthorized access and potential threats.
- Managed and controlled user access to the database, ensuring compliance with internal security policies and maintaining appropriate levels of privilege for database users.
- Acted as a liaison with Oracle Corporation for technical support, handling escalations and resolving complex database-related issues in collaboration with Oracle support teams.
- Provided thorough documentation for all database configurations, customizations, and services developed, ensuring clear communication and knowledge transfer.
- WebMethos Inc is an Enterprise Software Company, acquired by Software AG, focused on application integration, business process integration and B2B partner integration.
Webmethod Developer | Database Administrator
WebMethods Inc.
10.2004 - 01.2006
- Company Overview: WebMethos Inc is an Enterprise Software Company, acquired by Software AG, focused on application integration, business process integration and B2B partner integration.
- Integrated Internal Control Management System (IICMS) Project: This project involved implementing a robust solution at PT. Telkom Indonesia using webMethods EAI v6.5.1, along with BPM (Business Process Modeling) and BAM (Business Activity Monitoring) tools from webMethods.
- Installed and configured Oracle Database to support the business-critical services and applications for Telkom's internal systems.
- Developed services using WebMethods Developer Tools, integrating them seamlessly into Telkom's infrastructure to enhance operational efficiency and support real-time business processes.
- Allocated system storage and planned for future storage requirements, ensuring optimal performance and scalability for growing database needs.
- Designed and created primary database storage structures (tablespaces) based on application requirements provided by developers.
- Created and maintained all necessary database objects, including tables, views, and stored procedures, to support the smooth operation of webMethods services and ensure seamless integration.
- Developed PL/SQL API packages and integrated them with webMethods services to enhance functionality and streamline business processes.
- Modified and optimized the database schema as needed based on requirements from application developers, ensuring that it aligned with business logic and application needs.
- Developed and implemented scripts to monitor database performance, identify bottlenecks, and optimize queries to ensure high system performance and uptime.
- Configured and implemented Oracle High Availability (HA) using Oracle Data Guard (ODG) to ensure minimal downtime and data redundancy for critical databases.
- Planned and implemented comprehensive backup and recovery strategies to ensure the integrity and availability of critical business data.
- Led efforts in hardening the database, including securing sensitive data and enforcing access controls to protect against unauthorized access and potential threats.
- Managed and controlled user access to the database, ensuring compliance with internal security policies and maintaining appropriate levels of privilege for database users.
- Acted as a liaison with Oracle Corporation for technical support, handling escalations and resolving complex database-related issues in collaboration with Oracle support teams.
- Provided thorough documentation for all database configurations, customizations, and services developed, ensuring clear communication and knowledge transfer.
- WebMethos Inc is an Enterprise Software Company, acquired by Software AG, focused on application integration, business process integration and B2B partner integration.
Oracle DBA and Developer
PT. Asuransi Rama Wibawa
03.2003 - 10.2004
- · Database Installation and Setup
Install and configure the database to meet system requirements. - · Backup and Restore Management
Perform regular database backups and implement restoration processes to ensure data integrity and disaster recovery. - · Database Performance Tuning
Optimize database performance through query optimization, indexing, and system resource management. - · Database Design and Implementation
Plan, design, and implement efficient database structures that align with business needs. - · Security Policy Implementation
Establish and maintain robust security policies for database users and applications to protect sensitive data. - · Troubleshooting and Issue Resolution
Identify and resolve database-related issues to ensure system reliability. - · Database Synchronization
Synchronize databases between production and development environments by cloning data as needed. - · Application Support and Development
Fix application issues and develop new applications to support the main system. - · User Access Monitoring
Control and monitor database user access to maintain system security and compliance. - · Technical Support Coordination
Liaise with Oracle Corporation or other vendors for technical support and issue resolution. - · Documentation
Create and maintain comprehensive documentation for all database-related processes and configurations.
Oracle DBA And Developer
PT EXPERT
10.2001 - 03.2003
- · Install and set up databases to ensure efficient and secure deployment across systems
- · Install and configure Linux RedHat 73 to create a stable operating environment for database applications
- · Allocate system storage and plan future storage requirements for the database.
- · Create primary database storage structures (tablespaces) based on application designs provided by developers.
- · Create and manage primary database objects (tables, indexes, etc.).
- · Perform regular backup and recovery operations to ensure data protection and minimize downtime
- · Modify the database structure as needed based on requirements provided by the application development team.
- · Monitor and optimize database performance.
- · Troubleshoot and resolve database issues to maintain system stability and minimize disruptions
- · Implement database hardening for security and compliance.
- · Control and monitor user access to the database.
- · Prepare and execute User Acceptance Testing (UAT).
- · Coordinate with Oracle Corporation for technical support.
Education
Bachelor of Science - Computer Information Systems
Gunadarma University of Technology
Jakarta, JK10.2001
Skills
- Analytical problem solving
- IT service management expertise
- Oracle RAC expertise
- Oracle Data Guard management
- Experience with Oracle GoldenGate
- PostgreSQL database management
- SQL Server database management
- Database management with MySQL
- Operational efficiency management
- Operational performance tracking
- Operational efficiency enhancement
- Guidance and support
- Process optimization
Certification
ITIL V3 Foundation Certified (IT Services Management)
Industry Experience
- Telecommunication
- Government
- BUMN
- Banking
- Insurance
- Transportation
- Retail
- Manufacturing
- Oil and Gas
Interests
Data Engineering
Cloud Technology
AI Prompt Engineering
Achievments Summary
- Over 23 years of ICT experience across multiple industries, including telecommunications, government, banking, transportation, retail, manufacturing, insurance, and oil & gas.
- Pioneered Indonesia’s first integrated train reservation and payment system, a landmark project in the transportation sector.
- Led DBA teams at global and national enterprises (Tata Consultancy Services, Sisindokom, XL Axiata, Axis, Oracle, Logica, Utiba, and WebMethods), ensuring high availability, performance, and security of mission-critical systems.
- Managed 190+ database instances (including 45 clustered databases) with 24/7 availability for Indosat Ooredoo and other high-profile clients.
- Implemented Oracle EXADATA at PT. KAI, significantly enhancing performance and scalability of core systems.
- Delivered enterprise-grade High Availability and Disaster Recovery solutions using Oracle Data Guard, Oracle GoldenGate, and Attunity for banking, telco, and government clients.
- Optimized Very Large Databases (VLDB > 90 TB), improving reliability, query performance, and operational efficiency.
- Architected and tuned enterprise data warehouses and complex database infrastructures to support digital transformation and regulatory compliance.
- Hands-on expertise in multiple database platforms (Oracle, PostgreSQL, MS SQL Server, MySQL/MariaDB, Informix) with proven ability to deliver cross-platform solutions.
- Recognized as a trusted Database Solutions Architect and Team Leader, combining strong technical skills with leadership in large-scale, mission-critical projects.
Timeline
Team Lead DBA & Database Solution Architect
Tata Consultancy Services
05.2016 - Current
Team Lead DBA & Database Solution Architect
Tata Consultancy Services
05.2016 - Current
Team Lead DBA
Sisindokom Lintasbuana
05.2015 - 05.2016
Team Lead DBA
Sisindokom Lintasbuana
05.2015 - 05.2016
IT Infrastructure Manager (Database & System)
XL Axiata
03.2014 - 04.2015
IT Infrastructure Manager (Database & System)
XL Axiata
03.2014 - 04.2015
IT Infrastructure Manager (Database & System)
Axis Telekom Indonesia
02.2011 - 03.2014
IT Infrastructure Manager (Database & System)
Axis Telekom Indonesia
02.2011 - 03.2014
Team Lead DBA
Oracle
04.2010 - 01.2011
Team Lead DBA
Oracle
04.2010 - 01.2011
DBA Team Lead and System Analyst
Logica
02.2009 - 12.2009
DBA Team Lead and System Analyst
Logica
02.2009 - 12.2009
Senior DBA – Operation & Implementation
UTIBA
03.2008 - 02.2009
Senior DBA – Operation & Implementation
UTIBA
03.2008 - 02.2009
DBA Team Lead – Operation Team
LOGICA
03.2006 - 03.2008
DBA Team Lead – Operation Team
LOGICA
03.2006 - 03.2008
Webmethod Developer | Database Administrator
WebMethods Inc.
10.2004 - 01.2006
Webmethod Developer | Database Administrator
WebMethods Inc.
10.2004 - 01.2006
Oracle DBA and Developer
PT. Asuransi Rama Wibawa
03.2003 - 10.2004
Oracle DBA And Developer
PT EXPERT
10.2001 - 03.2003
Bachelor of Science - Computer Information Systems
Gunadarma University of Technology