Post Job Free
Sign in

Oracle Database consultant

Location:
South Africa
Posted:
November 09, 2015

Contact this candidate

Resume:

Curriculum Vitae

R.E.Balmer

Private and Confidential

** *****’ Oracle database administration and management experience, which include production-, QA- and the development/ testing environment.

8 years’ experience in SQLServer in a Production and DWH environment.

3 years’ experience in Oracle Spatial, developing a train tracking system.

8 years small business management experience.

Focused, hardworking and goal orientated

Functions equally well in a team environment or individually

Most recent client working in PCI-DSS environment General Information

Name: Robert Eugene Balmer

ID: 700**********

Address: 46 August Str.

Riviera

Pretoria

Postal: PO BOX 11906

Queenswood

0121

Rep. of South Africa

Communication: (work) +27-12-329-****

(Cell) +27 (0-84-555-****

Home +27-12-329-****

(E-mail) ******@****.**.**

Web www.aare.co.za

Age: 45

Dependants: 1

Marital Status: Married

Nationality: Swiss; South African

Language: Afrikaans, English, German (basic), Sotho – African language (basic)

Hobbies: Game farming, hunting, herpetology

Spouse: My wife is a renewable-energy consultant at GIZ

( Deutsche Gesellschaft für Internationale

Zusammenarbeit) and is currently busy completing her Doctorate studies at the University of Pretoria,

Engineering Department

Academic Information

Education: University of South Africa

(BA degree in Environmental Management -

Geography)

COM101X 50 Passed

GGH101Q 75 Passed with Distinction

GGH102R 69 Passed

GGH103S 66 Passed

STS1055 63 Passed

AGE1014 83 Passed with Distinction

APY101E 75 Passed with Distinction

ENN1504 67 Passed

EUP1501 82 Passed with Distinction

GGH201T 66 Passed

GGH202U 76 Passed with Distinction

GGH203V 64 Passed

ECS208H 50 Passed

ENE2601 84 Passed with Distinction

GGH204W 67 Passed

GGH205X 57 Passed

GGH206Y 59 Passed

LEG2601 60 Passed

PYC1502 61 Passed

RSC2601 61 Passed

APY3704 65 Passed

GGH301W 68 Passed

GGH3043 80 Passed with Distinction

GGH3076 60 Passed

DVA2601 57 Passed

PLS3701 59 Passed

AGE3702 75 Passed with Distinction

Other courses attended: Change Manager DS

Oracle SQLPlus

Oracle Fundamentals I

Oracle Fundamentals II

Oracle Performance Tuning

Certification: Introduction to Oracle9i SQLPlus & iSQLPlus Summary of Work Experience

Current employment

2013-2015

Consulting Company owner in South Africa:

Data Management Services

Aare manages, develops and administrates small, medium and large databases in various sectors of the economy, including transport, infrastructure and demographic studies. Aare specializes in Oracle/SQLServer Database

Administration, Development and Management services. Services also include support in MySQL if required. We provide senior level knowledge and operational experience at below market price.

Services include:

Performance management (Optimize data object use)

Development and design of new structures and objects

Day to day administration such as statistical collection, user access/control, rights and privileges

Business intelligence analyses and reporting

Space management (table spaces, partitions and

physical storage)

Recovery management (DB backups)

Additional data management can be included as

required

Business competitiveness

With more than 15 years’ experience in the field of data management, Aare delivers quality service tailored to the client’s needs. We work on an hourly tariff basis, so no need to employ a fulltime contractor if not needed. We are able to execute most of our work on a remote connection basis, so as to cut operational cost and extend support time to our clients.

“Operation managers may lack visibility into employee productivity and cost, which leads to over/under-estimating labour costs in maintaining operational - or live systems, which eventually erodes profits and competitiveness.” 2010-2012

Consulting: Senior Oracle DBA, Test Engineer, Test Manager Traffic Management Technologies: Cape Town,

Johannesburg, Samrand based

Electronic Toll Collection – Senior Oracle DBA,

VPC (Violation Processing Centre) monitoring and

performance tuning

Electronic Toll Collection – DWH Test Engineer for Transaction House Clearance

Electronic Toll Collection – DWH Test Engineer for Back Office

Electronic Toll Collection – Traffic Analyses

System - Test Manager and Test Engineer

Electronic Toll Collection – Transaction Integrity Verification -Test Engineer

Latest HR performance score July 2012 : 87.7%

Other:

MEIBC – Oracle maintenance and performance

tuning

2007 -2010

Consulting: Oracle Spatial, 10g+11g DBA & Data Management Computer Foundation (CF Centurion)

Eskom - Oracle Spatial Repository Development

(Senior DBA Spatial Development)

SABC - Election Result System 2009

(Senior DBA SQL Server)

Transnet - Infrastructure Maintenance Management

(DBA, SQL and PLSQL)

Transnet - Integrated Asset Tracking System

(DBA, Spatial Asset Developer)

Periodic work for:

Palmer Development Corporation

ProBEC/GTZ

MEIBC

Performance Tuning using plsql Developer

Performance Monitoring using Oracle “Statspack “

Patch Scripting and Deployment

Bug fixing on database Stored Procedures/Functions

DCL on database (Security)

Change Manager Administrator

Application Meta Configuration

Application Meta Management

Data recovery management

Development DBA (Oracle)

Domain Meta Configuration

Metadata management

Change Manager DB + Meta

DML & DDL

Spatial asset development

Spatial asset tacking

Spatial asset integration

Database Installing

Database Configuration

Application testing

2006

E-Logics (up to 30/04/2007): Oracle 9i &10g DBA on Win2003

Production DBA (Oracle)

Performance Tuning using plsqlDeveloper

Performance Monitoring using Statspack information

Patch Scripting and Deployment

Application (Infrastructure Maintenance) tuning

Bug fixing on database Stored Procedures/Functions

DCL on database (Security)

Change Manager Administrator

Application Meta Configuration

Application Meta Management

Development DBA (Oracle)

Domain Meta Configuration

Metadata management

Change Manager DB+Meta

DML & DDL

Database Installing

Database Configuration

Application testing

2005

E-Logics: Oracle 9i DBA on Win2003 & System Administrator

Production DBA (Oracle)

Performance Tuning using Oracle SQL,

PLSQLDeveloper and TOAD

Performance Monitoring using Statspack information

Patch Scripting and Deployment

Application (Infrastructure Maintenance) tuning

Bug fixing on database Stored Procedures/Functions

DCL on database (Security)

Change Manager Administrator

Application Meta Configuration

Application Meta Management

Application Support

Development DBA (Oracle)

Domain Meta Configuration

Metadata management

Change Manager DB+Meta

DML & DDL

Database Installing

Database Configuration

Application testing

2004

E-Logics: Oracle DBA 8i & 9i on Windows 2000 O/S

Production DBA (Oracle)

Performance Tuning using Oracle SQL,

PLSQLDeveloper and TOAD

Performance Monitoring using Statspack information

Patch Scripting and Deployment

Application Configuration

Application (Infrastructure Maintenance) tuning

Bug fixing on database Stored Procedures/Functions

DCL on database (Security)

Change Manager Administrator

Application Meta Management

Application Support

Development DBA (Oracle)

SQL Scripting and testing

DML & DDL on databases

Database Installing

Database Configuration

Application testing

2003

E-Logics: Oracle DBA 8i & 9i on Windows 2000 O/S

Production DBA (Oracle)

Performance Tuning using Oracle SQL,

PLSQLDeveloper and TOAD

Performance Monitoring using Statspack information

Patch Scripting and Deployment

Application Configuration

Application (Infrastructure Maintenance) tuning

Bug fixing on Stored Procedures

DCL on database

Development DBA (Oracle)

SQL Scripting and testing

DML & DDL on databases

Database Installing

Database Configuration

Application testing

2002

E-Logics: Oracle DBA 8i & 9i on Windows NT O/S

Production DBA (Oracle)

Performance Tuning using using SQL,

PLSQLDeveloper and TOAD

Performance Monitoring using Statspack information

Patch Scripting and Deployment

Application (Infrastructure Maintenance) tuning

DCL on Database

SQLServer DBA on Windows 2000 O/S

Development DBA (Oracle)

SQL Scripting

DML, DDL & DCL on Database

Backup & Recovery

Application Management (optimal routing system)

System Support

2000 -2001

BernTech: Internet Training

Course Presentation

Development of material

Marketing of course

Network & Hardware Support

LAN Networking

Component and Peripheral support

1998-1999

Legal Information Tech. Manager Networking

LAN Networking

Software Training

NT Network Administration

DBA SQLServer & InterBase



Contact this candidate