Ida Bagus Enderajana

Project Preview: Data Warehouse Build – Allianz Indonesia
As Senior DBA and Database Solution Architect, I led the preview phase of Allianz Indonesia’s enterprise Data Warehouse initiative. My role involved designing the overall database architecture and optimized schema design, and robust integration frameworks. On the DBA side, I provided expertise in performance optimization, backup and recovery planning, and high availability architecture. I collaborated with business and IT leadership to align the solution with enterprise data governance standards, delivering a comprehensive architecture blueprint that laid the foundation for full-scale implementation.

Contributions :

• 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
• Proven ability to learn quickly and adapt to new situations.
• Skilled at working independently and collaboratively in a team environment.
• Strengthened communication skills through regular interactions with others.
• Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
• Excellent communication skills, both verbal and written.
• Worked well in a team setting, providing support and guidance.
• Worked effectively in fast-paced environments.
• Demonstrated respect, friendliness and willingness to help wherever needed.
• Adaptable and proficient in learning new concepts quickly and efficiently.
• Assisted with day-to-day operations, working efficiently and productively with all team members.
• Proved successful working within tight deadlines and a fast-paced environment.
• Participated in team projects, demonstrating an ability to work collaboratively and effectively.
• Boosted overall efficiency by automating routine tasks through the creation of custom scripts and stored procedures.
• Collaborated with cross-functional teams to develop custom database solutions tailored to unique business needs.
• Implemented proactive monitoring solutions to identify potential issues before they escalated into critical problems, minimizing disruptions to daily operations.
• Streamlined database migrations by developing standardized processes and tools for seamless transitions.
• Conducted regular reviews of existing systems to identify areas for improvement, leading to continuous enhancement of database functionality.
• Collaborated with system architects, design analysts and others to understand business and industry requirements.
• Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.
• Documented and communicated database schemas using accepted notations.
• Planned and installed upgrades of database management system software to enhance database performance.

During my tenure at PT Sisindokom Lintasbuana as Lead DBA, I managed multiple database projects running in parallel across different industries. These included telecommunications, banking, oil & gas, government, and payment gateway clients, each requiring tailored solutions to meet mission-critical demands. I was responsible for end-to-end database strategy — from architecture and deployment to performance tuning, HA/DR, and security compliance — while leading DBA teams and coordinating with vendors and client stakeholders. This role showcased my ability to drive simultaneous complex projects and deliver consistent results under challenging timelines.

Contributions :

• Mentored junior staff members, helping them develop their leadership potential and advance in their careers.
• Collaborated with other department leaders to establish shared goals and ensure alignment across teams.
• Coordinated resources effectively to meet project deadlines and achieve desired results.
• Established clear communication channels to facilitate timely exchange of information between team members and stakeholders.
• Standardized database object naming conventions across multiple systems, resulting in easier management of objects during troubleshooting sessions.
• Enhanced communication strategies, ensuring clear and timely information exchange within team and with 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.
• Set performance expectations for the team, monitoring progress towards goals and providing constructive feedback as needed.
• Developed team members'' skills through targeted coaching sessions, resulting in improved individual performance.
• Empowered team members by delegating responsibilities according to individual strengths and areas of expertise.
• Managed conflict resolution among team members, fostering a positive and collaborative work environment.
• Established open and professional relationships with team members to achieve quick resolutions for various issues.
• Increased customer satisfaction ratings by closely monitoring service quality standards and addressing any issues promptly.
• Motivated team members to surpass their targets, recognizing and rewarding their achievements.
• Enhanced communication strategies, ensuring clear and timely information exchange within team and with clients.
• Set up and controlled user access levels across databases to protect important data.
• Provided ongoing support to direct reports, addressing concerns or questions promptly so they could remain focused on their tasks.
• Maintained database systems to track and analyze operational data.
• Streamlined backup and recovery processes, enhancing overall system stability and availability.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Optimized database performance by monitoring health and implementing tuning recommendations.
• Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
• Conducted tests to identify issues and make necessary modifications.
• Implemented capacity planning strategies to accommodate growth in data volume without compromising system performance or reliability.
• Ensured database security with implementation of role-based access control and regular vulnerability assessments.
• Created and updated database designs and data models.
• Created and implemented database designs and data models.
• Developed comprehensive documentation on database architecture, simplifying future upgrades and maintenance tasks.
• Modified databases to meet needs and goals determined during planning process.
• Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
• Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
• Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
• Set up and controlled user profiles and access levels for each database segment to protect important data.
• Streamlined database deployments, automating processes to accelerate development cycles and reduce errors.
• Optimized database operational efficiency by implementing automated backup and recovery procedures.
• Improved team productivity, coordinating database administration tasks and fostering collaborative work environment.
• Ensured high availability and disaster recovery capabilities, establishing and testing robust backup and failover strategies.
• Streamlined data retrieval and processing, designing and optimizing complex SQL queries for business intelligence.
• Achieved remarkable system performance improvements, fine-tuning database configurations and indexes.
• Cultivated detailed documentation library, capturing database schemas, configurations, and procedures for future reference.
• Facilitated knowledge sharing, conducting training sessions for junior DBAs and developers on best practices.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.

• Collaborated with cross-functional teams on large-scale projects to ensure seamless integration of new technologies into existing infrastructure environments.
• Coordinated with vendors on procurement processes, installation schedules, and warranty support services to ensure optimal equipment performance.
• 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
• Maintained high availability of services by overseeing regular backups, updates, and patches for all systems.

As IT Database Manager at Axis Telekom Indonesia, I successfully led the delivery of the Enterprise Data Warehouse project, providing the company with a robust platform for advanced analytics and decision-making. In parallel, I directed the migration of mission-critical databases from IBM DB2 to Oracle, ensuring seamless transition, high performance, and business continuity. My responsibilities included managing a team of DBAs, implementing HA/DR strategies, and collaborating with business stakeholders to align database initiatives with enterprise goals. This role showcased my ability to combine strategic leadership with deep technical expertise to deliver large-scale database transformations.

Contributions :

• 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.
• Worked in team-driven environments and communicated effectively with stakeholders.
• Developed comprehensive disaster recovery plans, ensuring business continuity during critical events.
• Collaborated with cross-functional teams on large-scale projects to ensure seamless integration of new technologies into existing infrastructure environments.
• Maintained high availability of services by overseeing regular backups, updates, and patches for all systems.
• Established key performance metrics to monitor infrastructure health and identify areas for improvement.
• Streamlined communication between departments, fostering a collaborative work environment for improved productivity.
• Reduced downtime with proactive monitoring, maintenance, and troubleshooting of network issues.
• Evaluated vendor proposals to select the most cost-effective solutions for infrastructure needs.
• Increased operational efficiency by automating routine tasks using scripting languages and tools.
• Implemented virtualization technologies to maximize server utilization and reduce hardware costs.
• Coordinated with vendors on procurement processes, installation schedules, and warranty support services to ensure optimal equipment performance.
• Tested network's performance and created strategies to maintain integrity of overall infrastructure.
• Managed complex IT projects for the successful deployment of new systems and software applications.
• Improved infrastructure efficiency by implementing strategic process improvements and system upgrades.
• Coordinated secure system access of users to various department systems and platforms.

Project Manage Utility – XL Axiata
As Team Lead DBA, I led the database administration team responsible for the Manage Utility Project at XL Axiata. I provided hands-on leadership in overseeing daily database operations, ensuring high availability, and implementing robust backup and disaster recovery strategies. My role encompassed performance tuning, capacity planning, and proactive monitoring to guarantee system stability and scalability. Beyond technical execution, I coordinated closely with project managers, application teams, and infrastructure stakeholders to ensure database solutions aligned with business requirements, security standards, and compliance obligations. This leadership contributed to the successful delivery of a mission-critical project supporting XL Axiata’s operational excellence.

Contributions :

• Generated reports detailing findings and recommendations.
• 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.
• Maintained database systems to track and analyze operational data.
• Optimized database performance by monitoring health and implementing tuning recommendations.
• Trained junior team members on best practices for database administration, promoting a culture of continuous learning within the organization.
• Set up and controlled user access levels across databases to protect important data.
• Modified databases to meet needs and goals determined during planning process.
• Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
• Streamlined backup and recovery processes, enhancing overall system stability and availability.
• Created and implemented database designs and data models.
• Reduced data retrieval times for business users by creating indexed views and optimizing stored procedures.
• Delivered successful database migration projects, ensuring seamless transitions with minimal disruption to business operations.
• Set up and controlled user profiles and access levels for each database segment to protect important data.
• Standardized database object naming conventions across multiple systems, resulting in easier management of objects during troubleshooting sessions.
• Optimized database operational efficiency by implementing automated backup and recovery procedures.
• Enhanced data security with development and enforcement of comprehensive database access policies.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Developed scripts and processes for data integration and maintenance.
• Implemented capacity planning strategies to accommodate growth in data volume without compromising system performance or reliability.

• Designed robust database structures that supported efficient data management and reporting capabilities.
• Develop Gap Analysis Documentationcomparing 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.)
• Collaborated with cross-functional teams to develop and implement effective IT solutions for business needs.
• Optimized data storage and retrieval processes, ensuring timely access to vital information for decisionmaking.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.

Led database administration for two strategic projects: Utiba Mobile Money (DompetKu) and SEV (System Electronic Voucher). I ensured the stability, scalability, and high availability of mission-critical databases handling millions of e-money and prepaid top-up transactions daily. Collaborated closely with vendor teams and internal stakeholders to deliver secure, compliant, and high-performing database solutions that supported Indosat nationwide services.

Contributions :

• Managed multiple projects simultaneously while adhering to strict deadlines and quality standards in a fast-paced environment.
• Ensured reliable data integrity by enforcing strict adherence to organizational policies during data management processes.
• 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.
• Diagnosed and resolved critical database issues promptly, minimizing the impact on business operations.
• Implemented disaster recovery plans to safeguard against unexpected events, minimizing potential losses.
• Communicated effectively with key stakeholders regarding database changes or improvements that affected their responsibilities within the organization.
• Managed Oracle databases, maintaining high levels of performance, availability, and security.
• Assisted in the migration of legacy systems onto modern platforms, ensuring smooth transitions without affecting business continuity or user experience.
• Maintained detailed documentation of database configurations, changes, and procedures for easy reference by team members and future troubleshooting efforts.
• Worked closely with developers to optimize SQL queries for better query performance across various applications utilizing Oracle databases.
• Evaluated system needs and recommended appropriate hardware or software upgrades to optimize Oracle database performance.
• Developed custom scripts for automating routine tasks, increasing productivity and reducing manual labor.
• Provided technical support during application development processes to ensure seamless integration with existing databases.
• Maximized efficiency through continuous improvement initiatives such as streamlining workflows or automating repetitive tasks.
• Collaborated with IT teams to develop effective solutions for complex database issues.
• Optimized database performance by conducting regular system updates and implementing new features.
• Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
• Troubleshot database issues to create and resolve trouble tickets.
• Proposed database changes to ease monitoring and administrative effort.
• Provided resources and skill sets to support DBA functions for applications.
• Worked with customers and other third parties to support DBA functions.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Modified databases to meet needs and goals determined during planning process.

Project Overview – LogicaCMG at PT Natrindo Telepon Seluler (AXIS Telekom Indonesia)
Contributed to a greenfield project that built PT Natrindo Telepon Seluler’s (later AXIS Telekom Indonesia, acquired by Saudi Telecom Company) entire telecommunications system from the ground up. Led the design and implementation of the Service Platform Network (SMSC, MMSC, WSB, PSA) and Business Support Systems (interconnect settlement, rating, mediation, provisioning, CRM). Ensured high availability and performance through Oracle 9i/10g database architecture, clustering, disaster recovery, and tuning. This project established AXIS as a fully operational national mobile operator, delivering 2G/3G services with scalable and secure infrastructure.

Contributions :

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.
• Set performance expectations for the team, monitoring progress towards goals and providing constructive feedback as needed.
• 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.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.

Backup and Recovery Management:

• Created a robust disaster recovery plan to ensure business continuity in the event of hardware failures or natural disasters.
• 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.

Performance Monitoring and Optimization:

• Modified databases to meet needs and goals determined during planning process.
• Proactively monitor and analyze database performance for Oracle, Informix, and MS SQL Server, identifying and addressing performance bottlenecks.
• Use Oracle Enterprise Manager (OEM) for version 9i and Oracle Enterprise Manager Grid Control for version 10g to create Key Performance Indicator (KPI) reports, providing insights into database performance trends.
• Monitor and analyze ArchiveLog usage with LogMiner, ensuring efficient log management and timely archiving.

Real Application Clusters (RAC) and High Availability:

• Conduct failover and load balancing tests on Oracle Databases utilizing Real Application Cluster (RAC) technology, ensuring high availability and fault tolerance.

Database Cloning and Synchronization:

• Perform database synchronization between production and development sites by cloning Oracle and Informix Dynamic Server databases, ensuring consistency across environments.
• Design and implement a system for seamless RBT provisioning transfer, enhancing operational efficiency.

Database Security and Compliance:

• Implement and maintain stringent database security policies, including the creation and management of database users, roles, and privileges.
• Perform database hardening to strengthen security and protect sensitive data from unauthorized access.
• Conduct operating system hardening to ensure secure database hosting environments.
• Enforce security policies for database users, ensuring compliance with internal and external security standards.

Capacity Planning and Growth Analysis:

• Conduct capacity planning assessments to forecast future database growth and resource requirements, ensuring system scalability.
• Perform database growth analysis and develop plans to accommodate future demands, maintaining optimal system performance.

Testing and User Acceptance:

• Perform comprehensive operational testing (including User Acceptance Testing or UAT) to validate system functionality and ensure it meets business requirements.
• Create and maintain baseline scripts using shell scripting to monitor and evaluate system performance, database uptime, and user activity.
• Established open and professional relationships with team members to achieve quick resolutions for various issues.

Scripting and Automation:

• Develop scripts to monitor critical database metrics, including instance uptime, database growth, transaction commits, user logons, and System Global Area (SGA) statistics.
• Developed scripts and processes for data integration and maintenance.
• Maintained database systems to track and analyze operational data.
• Generated reports detailing findings and recommendations.
• Optimized database performance by monitoring health and implementing tuning recommendations.
• Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.

Project Overview:

• 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. The primary objective of this initiative was to ensure that Telkom complied with the latest regulations imposed by the NYSE in accordance with the Sarbanes-Oxley Act of 2002 (SOX).

Key Contributions and Responsibilities:

• 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 strategiesto 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 across teams.
• Debugged complex software issues, leading to a more stable product release.
• Reduced development time by creating reusable code libraries for future projects.
• Built databases and table structures for web applications.

Key Contributions:

• 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.
• Optimized database performance by conducting regular system updates and implementing new features.
• Ensured reliable data integrity by enforcing strict adherence to organizational policies during data management processes.
• Maintained detailed documentation of database configurations, changes, and procedures for easy reference by team members and future troubleshooting efforts.
• Evaluated system needs and recommended appropriate hardware or software upgrades to optimize Oracle database performance.
• Utilized advanced analytical skills to identify trends in data usage patterns and take proactive measures for capacity planning purposes.
• Managed Oracle databases, maintaining high levels of performance, availability, and security.
• Enhanced data security by implementing backup and recovery strategies, ensuring minimal data loss.
• Developed custom scripts for automating routine tasks, increasing productivity and reducing manual labor.
• Worked closely with developers to optimize SQL queries for better query performance across various applications utilizing Oracle databases.
• Provided technical support during application development processes to ensure seamless integration with existing databases.
• Diagnosed and resolved critical database issues promptly, minimizing the impact on business operations.
• Streamlined database operations for efficient use of resources, applying patches and upgrades when necessary.
• Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
• Troubleshot database issues to create and resolve trouble tickets.
• Reviewed database design to recommend enhancements or improvements.
• Provided resources and skill sets to support DBA functions for applications.
• Worked with customers and other third parties to support DBA functions.
• Created and updated database designs and data models.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Modified databases to meet needs and goals determined during planning process.

Project Overviews : Developed, Delivered and Maintain Indonesia’s first train ticketing gateway integrated with BCA ATMs, acting as both DBA and Developer (Delphi & VB).

Contributions :

• 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 (tablespace) based on application designs provided by developers.
• Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
• 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.
• Optimized database performance by monitoring health and implementing tuning recommendations.
• Set up and controlled user access levels across databases to protect important data.
• Conducted tests to identify issues and make necessary modifications.
• Implemented capacity planning strategies to accommodate growth in data volume without compromising system performance or reliability.
• Set up and mintain comprehensive system documentation
• Streamlined backup and recovery processes, enhancing overall system stability and availability.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
• Collaborated with cross-functional teams to develop custom applications that supported business objectives and met user needs.
• Created and updated database designs and data models.
• Standardized database object naming conventions across multiple systems, resulting in easier management of objects during troubleshooting sessions.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
• Supervised work of programmers, designers and technicians, assigned tasks and monitored performance against targets.