Project Experience

Senior DBA – Support Team
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.

Contribution:
• Upgrade (Patching) The Oracle Database from 10.2.0.1 to 10.2.0.4
• Install and Configure Oracle Real Application Cluster (RAC) (For Solaris And Linux RedHat)
• Adding Node (Database Instance) to existing Oracle RAC Environment
• Perform the Integration Test for Oracle RAC and Sun Cluster
• Replicate the Oracle Database RAC using Dataguard
• Install and Configure Oracle Enterprise Manager Grid Control
• Perform design and sizing layout Storage for Oracle Database
• Perform Data Migration
• Etc

Mar 2006 – March 2008 Senior DBA – Operation Team
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, comprising the Short Messaging Service Centre (SMSC), Multimedia Messaging Service Centre (MMSC), Wireless Service Broker(WSB) and Pre-Delivery Service Agent (PSA) and The SPN will enable NTS to offer superior messaging, browsing and content downloads capabilities. as well as IT and Business Suport System (BSS) that includes Interconnect Settlement (Intec),Rating, Mediation, Provisioning, Service Management and Customer Relationship Management (CRM) and also deliver Programme Management, System Integration (EAI) and Managed Service for the Solutions and provides 24×7 on-call support
• Contribution:
• Installation,Configuration and Upgrading Oracle Database (10g and 9i ) to Intec Server, Provisioning Server, Mediation Server, FirstHop Server on both Production Mechine and Development Mechine
• Upgrade The Oracle Database from 9.2.0.1 to 9.2.0.6
• Crosscheck the All Oracle Database to Make sure that the Installation of database is Completed Successfully without error
• Preparing the Schema which is request by Vendor
• Do the test FailOver and Load Balancer on Oracle Database that using Real Application Cluster (RAC) option
• Establish and maintain sound backup and recovery policies and procedures using RMAN which is integrate with HP Data Protector
• Etc

Dec 2005 – Mar 2006 Database Administrator and SysAdmin
• Integrated Internal Control Management System (IICMS) Project at PT. Telkom Indonesia using webMethods EAI v6.5.1 with BPM (Business Process Modeling) and BAM (Business Activity Monitoring) tools of webMethods products. This goals of the project is bring the Telkom to comply with the latest rules and regulations imposed by the NYSE related to Sarbanes-Oxley Act 2002 (SOA)
• Contribution:
• Install and Setup Oracle Database
• Allocating system storage and Planning future storage requirements for the Database
• Creating primary database storage structures (tablespaces) once developers have design an Applications
• Creating Primary Database Objects
• Creating API Package (PL-SQL) that required by Developer
• Modifying the Database structure as necessary from Information given by Application developers
• Provide Scripts for Monitoring and Optimation Database performance
• Replication database using Oracle Streams Technology
• Planning for Bacup and Recovery Strategies of Database
• Hardening Database
• Etc

Oct 2005 – Dec 2005 Database Administrator and Team Leader
Integrate system Maxi , Matrix ,Geneva and SAP using WebMethods EAI in PT. Telkom Indonesia Tbk
• Contributions:
• Develop EAI using Webmethods Developer to integrate system SAP, Maxi, Matrix and Geneva
• Provide Documentation.

Jan 2005 – Dec 2005 Database Administrator and Software Engineer
Support and Maintanance The EAI Applications in PT. Telkom Indonesia
• Contributions:
• Maintanance Oracle Database Server
• Allocating system storage and Planning future storage requirements for the Database
• Modifying the Database structure as necessary from Information given by Application developers
• Monitoring and Optimation Database performance
• Establish and maintain sound backup and recovery policies and procedures
• Perform general technical trouble shooting and give consultation to development team
• Hardening Database
• Controling and Monitoring user access the Database
• Contacting Oracle Corporation for technical Support
• Setup and Maintain Documentation

Mar 2005 – June 2005 Database Administrator and System Analyst
Telkomsel EAI (Enterprise Application Integrator) Project. Developing & Support integration services using webMethods Integration Server 6.1. Integrate Telkomsel CRM Application (GTX), Geneva Billing System Application, Inventory Card Application (Resource Management, Paradise), Network Element Application (IN, HLR, OCS, Prisma), Indira (Prepaid history tracking system), and other Telkomsel legacy system.
• Contributions
• Analys the requirement of design system for the database side
• Provide API package (PL-SQL) which is need by developer
• Provide the Script for tuning Database Performance
• Perform the backupStrategies of EAI Database (Oracle)
• Contacting Oracle Coorporation for technical support
• Prepare and Perform the UAT

Oct 2004 – Mar 2005 Database Administrator and Software Engineer
The CCF (Customer Care Flexi) project in PT. Telkom Indonesia Tbk, develop the EAI (Enterprise Application Integration ) using WebMethods.
• Contributions:
• Install,Setup and Maintaining the Database (Oracle Database) t
• Upgrade Oracle Database from 9.2.0.1 to 9.2.0.6
• Allocating system storage and Planning future storage requirements for the Database
• Creating primary database storage structures (tablespaces) once developers have design an Applications
• Creating Primary Database Objects
• Modifying the Database structure as necessary from Information given by Application developers
• Monitoring and Optimation Database performance
• Replication database using Oracle Streams Technology
• Establish and maintain sound backup and recovery policies and procedures
• Perform general technical trouble shooting and give consultation to development team
• Hardening Database
• Controling and Monitoring user access the Database
• Prepare and Perform the UAT
• Contacting Oracle Corporation for technical Support
• Setup and Maintain Documentation
• Skills Employed: Oracle Database 8i/9i/10g , WebMethods Developer, Shell Scripting