
Senior Oracle DBA at Utiba
Indonesia

Senior Oracle DBA at Utiba
Indonesia
Database Administrator and Team Leader in a wide variety of business applications. Particularly interested in client/server and relational database design using Oracle,Informix Dynamic Server, MS-SQL Server. Always interested in Manage Services ,System Integration and Migration projects
-Oracle Database specialist
-Database design
-Datawarehouse
-High Availibility Database configuration
-Manage Services
-System Integration
-System Migration
(Privately Held; 11-50 employees; Information Technology and Services industry)
March 2008 — Present (1 year 9 months)
Senior DBA – Operation
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 Oracle Database from 10.2.0.1 to 10.2.0.4
•Install and Configure Oracle Real Application Cluster (Oracle RAC)
•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
•Do the housekeeping for the Database
•Monitoring Performance Database Oracle
•Perform Recovery Test for Oracle Database that includes Point In Time Recovery and Disaster Recovery
•Perform the Capacity Planner
•Hardening Database
•Perform Database Troubleshooting
•Contacting Oracle Corporation for technical support
•Setup and Maintain Documentation
(Public Company; Logica PLC; Information Technology and Services industry)
March 2006 — April 2008 (2 years 2 months)
• Installation,Configuration and Upgrading Oracle Database
• Do the test FailOver and Load Balancer on Oracle Database
• Establish and maintain sound backup and recovery policies
• Perform general technical trouble shooting and give consultation to development team
• Maintanance Catalog of RMAN
• Do the housekeeping for the Database
• Tuning Performance Database
• Provide the Daily Health Checks for All Database
• Creating Scripts for monitoring Instance Uptime, Database Growing , Commit Transactions and user Logon
• Configure High Availbility using Oracle DataGuard
• Perform the Capacity Planner
• Do the Baseline for All System
• Perform the Syncronyze by Cloning the Database
• Implement and maintain database security
• Hardening Database and Operating System
• Perform the Operational Test
• Perform The Database Troubleshooting
• Perform Ignite Backup for All System
• Contacting Oracle Corporation for technical support
• Setup and Maintain Documentation
(Privately Held; 501-1000 employees; Information Technology and Services industry)
October 2004 — March 2006 (1 year 6 months)
• 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
• Controling and Monitoring user access the Database
• Contacting Oracle Corporation for technical Support
• Develop EAI using Webmethods Developer to integrate system SAP, Maxi, Matrix and Geneva
• Provide Documentation.
(Public Company; 5001-10,000 employees; Insurance industry)
June 2002 — October 2004 (2 years 5 months)
• Install and Setup The Database
• Perform BackingUp and restoring the database
• Tuning Performance Database
• Take care Database design and Implementation
• Setting Security Policy of Database User and Application
• Troubleshooting Database
• Perform The Syncronise Database between Production site and Development site by cloning database
• Fix the Problem in Application
• Develop Application that Support the Main System
• Controlling and monitoring user access to the database
• Contacting Oracle Corporation for technical Support
• Provide Documentation
(Privately Held; 501-1000 employees; Information Technology and Services industry)
November 1999 — July 2002 (2 years 9 months)
• Install and Setup The Database
• Install and Setup Linux RedHat 7.3
• Backup and Recovery
• Tuning Performance Database
• Take care Database design and Implementation
• Implement and maintain database security (create and maintain users and roles, assign privileges)
• Troubleshooting Database
• Perform The Syncronise Database between Production site and Development site
• Configure The Standby Oracle Database
• Hardening Database
• Fix the Problem in Application
• Develop Application that Support the Main System
• Contacting Oracle Corporation for technical support
• Documentation.
1997 — 2001
organizational development, strategic planning,digital photography, professional networking, usability research, marathon running, international travel,Reading,Marketing
Education Association
Employee of the year at Expert,PT in 2002