Ambrosius Bekti

Lead Oracle Database Administrator at Dallas Area Rapid Transit

acze1m@r.postjobfree.com

817-***-****

Summary

Dynamic, Team player, Competitive IT Professional with 20 years of experience

18 years of experience as Oracle 12c/11g/10g/ 9i/8i/7.3 database administrator.

10 years of experience as Oracle RAC environment

Experience in carrying Microsoft SQL Server DBA

Experience as an Oracle application 11.5.8/11.5.9–DBA includes Installation, Applications DBA (AD), Cloning (Rapid clone), Patching, and System Administration (OAM).

15 years of experience in Oracle Standby and Data Guard Technology

Extensive experience in carrying DBA activities such as Oracle Server installation, database creation, Backup and recovery using shell scripts, RMAN and Oracle Secure Backup, EMC, Database tuning, Problem solving, Database Upgrades and Migration, Client/server connectivity. Experience with design and administration of large Oracle database running in SAN environment, set up critical, secure and complex database for bank environment.

Experience in security technologies to protects data in database systems.

Post-Installation Troubleshooting and Support of Development/QA and Production databases Expert in backup & recovery and Oracle disaster planning.

Experience in doing end-to-end setup of multi tiers applications.

Developed processes and procedures to effectively implement security policy

Experience in interacting with the UNIX, Linux, Networking, Application and Business Teams to get database environment setup.

Experience

Lead Oracle Database Administrator at Dallas Area Rapid Transit

September 2015 - Present (1 year 5 months)

Managing and direct activities while maintaining a key technical, lead and managerial role in planning, Performance Management Program (PMP), implementation and maintenance of Agency Oracle ERP databases in a SAN environment. A key responsibility of this position will be working with ERP and Web teams to design and implement complex database layouts and strategies. Other duties include performance monitoring and tuning and the ability to apply new technologies and techniques to improve production systems. This includes capacity planning, data integrity, backup and recovery solutions and database security.

Senior Oracle Database Administrator Consultant at Dallas Area Rapid Transit

April 2015 - September 2015 (6 months)

Responsible for design of logical and physical database models.

Address and resolve complex database issues and troubleshoot reported database problems.

Monitor Oracle performance to ensure maximum system uptime.

Perform required database upgrade to ensure environment is up to date.

Perform installation of database systems to support all IT projects.

Support the development efforts for one or multiple diverse types of large database systems.

Perform requirements analysis, data modeling and database architecture functions for relational database system(s).

Act as a project member on various projects, including a supporter or consultant on the Oracle model. Work with cross functional operations teams such as systems, storage and network to design database technology stacks

Working knowledge of networking, systems and storage as it relates to database technology

Design solutions and utilization Oracle 10g/11g/12c features such as Oracle Grid, ASM

Oracle Database Administrator at Southside Bank. Formerly Omniamerican Bank

November 2006 - March 2015 (8 years 5 months)

Setup and maintain High-Availability and Disaster Recovery solutions for Oracle 10g/11g/12c database and Linux operating system

Oversee Implementation and configuration of Oracle Real Application Cluster

Review database design of application, providing conceptual and logical data model and translating into physical database

Provide advising on database sizing, physical database layout, security, disk partitioning and network configuration

Provide optimizing and tuning database to achieve optimized throughput for production

Manage Storage Provisioning – Planning, Preparation, Implementation on EMC data system

Approach to securing the database, network and operating infrastructure

Provide regular report on the database health check, security check follow up and recommendations.

Conduct troubleshooting on database, providing and monitoring follow up.

Manage database instances for production and development to ensure strong development environment and smooth transition to production.

Setup database backup encryption technology using oracle secure backup software.

Setup sensitive data in the database should be encrypted.

Responsible for Installation, upgrade, patching Oracle RDBMS software and LINUX

Review application design to achieve the purpose of application such as flexibility and reliability.

Provide support for Databases in 24*7 environment following SLAs and escalation policies

Review operational excellence to achieve higher availability (24x7), including backup and restore policy; putting Standard Operating Procedure and making recommendations.

Senior Oracle Database Administrator Consultant at RedSalsa Technologies, Inc

September 2005 - November 2006 (1 year 3 months)

Installing and managing Red Hat Enterprise Linux, managing software packages, Network Configuration, and enhancing security.

Deploys and manages multi-site, multi-vendor SAN storage environments.

Deploys and manages storage and EMC Disk Library.

Installation and configures Automatic Storage Management (ASM).

Responsible for installing, troubleshooting, monitoring, managing and Configuring SQL server and Oracle databases

Setup Oracle Secure Backup to centralized tape backup management with advanced features such as encryption, vaulting, and dynamic drive sharing.

Setup Standby database/Data guard to achieve a highly available Oracle Database and Minimize the downtime associated with any outage and prevent data loss.

Setup Open Solutions Inc banking application to integrate core data processing applications built on a single centralized Oracle and SQL server database.

Responsible for general maintenance of the database, including adding storage as necessary, troubleshooting problems, backup and recovery.

Performed Oracle DBA consulting services for client. Duties include Oracle configuration, Oracle database administration, Oracle monitoring and migration of data and code.

Responsible for the implementation, maintenance, design extensions and support of mission critical database system.

Capable to provide 24X7 supports in a critical production environment.

Setup measurement of customer data security by selectively encrypting sensitive data before it is stored in the database.

Senior Oracle Database Administrator at IBM GLOBAL SERVICES

September 2004 - July 2005 (11 months)

Responsible for Carrefour Project production database on IBM pSeries 650 server cluster environment with Oracle9i/10g RAC configuration. Oracle Real Application Cluster:

Implementation and configuration Oracle9i/10g RAC on IBM pSeries 650 server cluster environment.

Determining the Oracle9i/10g RAC architecture

Configuring the Distributed Lock Manager (DLM)

Configuring the raw disks for Oracle RAC

Installing Oracle9i/10g RAC software

Installing and testing Oracle9i Transparent Application Failover (TAF)

Performance tuning for Oracle Real Application Clusters (RAC)

Setup database backup and restore strategies using RMAN

Senior Oracle Database Administrator at Emerio Globesoft

January 2004 - August 2004 (8 months)

Providing production database support to one of the world’s largest bank, Union Bank of Switzerland. There are close to 1000 Oracle databases 8/9 in Solaris & Linux environment.

Installation of oracle software

Database setup, database upgrades, space management, backup and recovery using either SQL Backtrack or

RMAN, database cloning

Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment

Setup and maintain High-Availability and Disaster Recovery solutions.

Working in Linux, BMC SQL BackTrack and BMC Patrol.

Proficient in Unix system administration relevant to Oracle database management Supporting multiple and large oracle databases environment.

Capable to provide 24X7 supports in a critical production environment.

Proficient in Standby and DataGuard Technology

Provide Oracle Production support in a critical production environment. Support GoldenGate Oracle Replication

Senior Oracle Database Consultant at BANK CENTRAL ASIA

February 2003 - January 2004 (1 year)

Assisted with the design, implementation and support a multi-terabyte data warehouse, performing database design, implementation, Advising on database sizing, physical database layout, disk partitioning and network configuration (with High-Availability) on IBM AIX 5.2.

Reviewing of database design of application, providing conceptual and logical data model and translating into physical database.

Reviewing of application design to achieve the purpose of application such as flexibility and reliability.

Reviewing operational excellence to achieve higher availability (24x7), including backup and restore policy; putting Standard Operating Procedure and making recommendations.

Propose model and design for Disaster Recovery. Optimizing and Tuning database to achieve optimized throughput for production. Conduct troubleshooting on database, providing and monitoring follow up.

Mentoring BCA staffs to achieve higher competencies in Oracle database design and tuning, development tools and methodology.

Oracle Database Administrator at COMPUTER SCIENCES CORPORATION

July 2001 - January 2003 (1 year 7 months)

The following are some of his responsibilities but not limited to:

Ongoing Database tuning, including the resolution of production performance issues.

Regular database reorganizations, which are necessary to ensure optimal performance and availability

Implementation of database change requests

Provision of standard user access maintenance

Ensuring License compliance, where it is within CSC control (it is common for DBMS licenses to be held by the client).

Database upgrade planning and implementation

Provision of database backup and restore strategies for both Production and Development systems.

Capacity planning for databases

Implementation of appropriate database performance monitoring and tuning software

Restoration of data - specialist involvement in non-standard restore tasks

Oracle Database Administrator at IBM GLOBAL SERVICES

April 2000 - June 2001 (1 year 3 months)

Oracle Database Performance Tuning

Oracle Database Maintenance on IBM AIX 5.1

Administer the AIX system and backup of Tivoli backup host system. Function as an information source for all backup issues. Performs analysis and design of backup processes and procedures at all levels of complexity. Works with internal clients to help identify the files and file dates required for recovery.

Coordinates directly with vendors to implement new equipment and evaluate alternative solutions. Installs and configures the server and client portions of backup and recovery software for all locations.

Management of the design of performance changes to the application, batch programs and tuning of the

Oracle database, including the re-design of the database to achieve increased performance.

Tuning of Disk I/O, Tuning of oracle parameter Investigating tuning related to PL/SQL and PL/SQL that can help performance, Specific tuning advancement in Oracle8.

Oracle Database Administrator at Fujitsu Australia Pty Ltd.

June 1998 - April 2000 (1 year 11 months)

Responsibilities are supporting the more than 100 Oracle Databases in Unix Production and Development environment. I was responsible for all Oracle DBA and work for a for Road & Traffic Authority project.

Monitoring database performance and security.

Problem resolution in a production environment.

Provision of technical advises, relating to database, to management and clients.

Database Upgrades, Reorganizations

Wrote database creation script, backup and performed media / object recovery in the event of database crashes or user accidents.

Predicted future storage /resource requirements for database production.

Proficient in Standby and DataGuard Technology

Oracle Database Support Analyst at ORACLE CORPORATION

August 1996 - June 1998 (1 year 11 months)

His responsibilities are supporting the more than 200 Oracle RDBMS customers in Indonesia resolve their problems and provide preventive maintenance. Tasks performed include but are not limited to:

UNIX environment set up and configuration

Oracle RDBMS and Tools installation, migration and upgrades

Database creation procedures, user management, database object rebuilding, space management consulting

SQL*Net configuration, se tup and tracing.

Act as a liaison between customers and Oracle Customer Worldwide Customer Support

Duties included all aspects of Oracle database administration including performance & tuning, Oracle installation and Oracle upgrade, database maintenance, and database recovery.

Senior System Analyst & Oracle Database Administrator at PT. INTI INDORAYON UTAMA

December 1994 - July 1996 (1 year 8 months)

Responsibilities included performance & tuning, database design, data modeling, database installation, technical support, and investigation of new technologies. Also managed the creation of a Decision Support System that was used by top management to decide long-term company goals, raining for all MIS

Programmer & System Administrator in UNIX and Oracle DBA tasks

Day-to-day operation and maintenance of a mission-critical Oracle 7 RDBMS Database.

Defined the DBA procedures and tasks from initial database sizing, setup, space allocation, user account creation and administration, security rules and procedures using the latest Oracle 7 security features and system resource (datafile, rollback, space limitations, temporary segments, et al) management.

Monitored system performance and performed tuning as needed to optimise database performance.

Performed as Unix and RDBMS (HP-UX) administrator.

Programmer at P.T. Citra Tubindo

May 1994 - November 1994 (7 months)

Using the Data Integrity Subsystem to specify Data Integrity Subsystem Attributes for production data base columns and compile a DIS source file.

Using Data Base Tools to generate data base statistics and data dictionary information; prevent problems related to shared memory and process management; perform day-to-day tasks such as database startup, shutdown and maintenance

Using Data Base Recovery tools to recover from failure, including backup and restore procedure definition # Configure the environment to maximize the performance of the UNIFY 2000 application.

Create, update and modify the existing ACCELL/4GL application as per user requirement. Process involved getting user requirement, database and application design, coding and testing.

Coding of application software for various Clients using Unify/Accell

Junior Programmer at P.T. Duta Anggada Inti Mulia

April 1991 - April 1994 (3 years 1 month)

Created, updated, modified and maintained an Informix database using Informix SQL and Informix 4GL, based on end user requirements.

Defined and implemented backup and recovery procedures to protect and safeguard mission-critical production database

Defined security rules and procedures within the database to prevent unauthorised access to the system.

Performed DBA duties, including monitoring and tuning system performance.

Skills & Expertise

PL/SQL, Oracle RAC, Oracle Enterprise Manager, Unix, Performance Tuning, Databases, Linux, Data Warehousing, Solaris, RMAN, Data Guard, Oracle, Data Modeling, Shell Scripting, Database Design

Disaster Recovery, System Administration, AIX, SQL Tuning, Oracle Applications, IBM AIX

Certification:

ITIL® Foundation Certificate in IT Service Management, Dallas on 26 November 2016

Trainings from Oracle Corporation:

Advanced Administration for Oracle Applications

Oracle Database Administration

Tune and Troubleshoot Oracle

Oracle 11g Database Administration

Oracle Real Application Cluster

Contact this candidate