Oracle Application DBA in Medavie Blue Cross

Halifax, Canada Area Canada
Current:Medavie Blue Cross
Past:DCNA Consulting Limited
Education:Computer Technology

Job Experience

Oracle Application DBA

Medavie Blue Cross

October 2011 to Actually working here

PL/SQL and PL/SQL Developer on a data Conversion team initially and then working on the team responsible for loading data to the corporate warehouse environment - using PL/SQL and PL/SQL Developer and UNIX scripting.

Owner

DCNA Consulting Limited

June 1999 to Actually working here

Contract with organizations requiring Oracle expertise - mainly as an Oracle Application DBA and to do PL/SQl Development

Consultant - Focused On Oracle Contracts

Andersen Consulting

Actually working here

Oracle DBA - Senior Consultant

DMR-Fujitsu

Actually working here

Oracle DBA

DMR Consulting Group

Actually working here

Oracle DBA

Fujitsu Consulting / DMR Consulting

Actually working here

Oracle DBA

Maritime Life

Actually working here

Application Oracle DBA

xwave

Actually working here

Oracle Application DBA

Property Valuation Services Corporation

October 2011

Filling the role of application DBA for a property valuation application; Acted as a key Oracle resource in the go live activities of this application; Responsible for developing and managing the refreshes of the production data to a testing environment and to a query environment; Supporting the IT staff coding efforts by reviewing their developed code and making recommendations as appropriate; Performing development tasks such as making corrections / adjustments / suggestions to vendor SQL code, PL/SQL code and Oracle 6i Reports; Developing new application reports; Liaising with the Government IT organization (CIO) DBA group with issues involving the implementation of the application, and in particular the DB, to the Government?s infrastructure; Working as a part of the team that liaised with municipal units to determine the best format for XML files and then re-writing the XML extraction process to move from a single file XML method to a multiple XML file format; Implementing DB table partitioning for large year based tables; and, Making tuning recommendations to the two vendors involved in the application. Environment: · Oracle 10g on UNIX AIX - scripting; · Oracle 11g on UNIX AIX - scripting; · PL/SQL coding; · PL/SQL Developer tool; · SQL*Plus; · SQL scripts; · Oracle Reports 6i; · Oracle Forms 6i; · SQL*Loader; · Filezila ftp software; · HP Openview Ticket tracking application; and, · Windows

Education

Computer Technology

Southern Alberta Institute of Technology / SAIT

1982 to 1983

Acadia University

1969 to 1974

Languages

IT skills

Other Skills

Database Design Unix Data Modeling AIX SQL Oracle SQL Tuning Testing Oracle Applications XML PL/SQL Shell Scripting Databases Enterprise Architecture Requirements Analysis

More (Al)exander

Career Goals

Industries of interest

Areas of interest

Availability to travel and work outside the city

No

Interests and hobbies