MIKE HORDILA, TORONTO - SENIOR ORACLE DBA - RESUME
Oracle DBA – OCP v.7, 8, 8i, 9i, 10g
office: 416-758-5220, cell: 416-473-3122
e-mail: mike.hordila @ hordila.com, office: mhordila @ ingdirect.ca
resumes: mhordila.doc, mhordila.txt
ORACLE TECHNICAL BOOKS AUTHOR
Oracle Space Management Handbook
by Donald Burleson, Jonathan Lewis, Mike Hordila, et.al.
ISBN: 0-9744355-0-3, Rampant TechPress, Oracle eBooks, Sep. 2003
ORACLE TECHNICAL ARTICLES PUBLISHED - available on demand
Troubleshooting Java Error ArrayIndexOutOfBoundsException, Part 2 (DBAzine.com, Jan 2004)
Troubleshooting Java Error ArrayIndexOutOfBoundsException, Part 1 (DBAzine.com, Dec 2003)
Automated Data Conversion Management (DBAzine.com, Oct 2003)
Automated Data Encryption Management (DBAzine.com, Aug 2003)
Auditing Past Transactions With Oracle LogMiner (DBAzine.com, Jun 2003)
Diagnosing The Efficiency Of Disk Striping And Load Balancing (Oracle Internals, Apr 2003)
Algorithms And Methods For Oracle Defragmentation (Oracle Internals, Mar 2003)
Automated Oracle Tuning Initial Procedures, Part 2 (DBAzine.com, Feb 2003)
Oracle Multilingual Systems Setup (DBAzine.com, Jan 2003)
Architecture Principles Of Web-Enabled Oracle Applications (DBAzine.com, Dec 2002)
Diagnosing Oracle Replication Timings (Oracle Internals, Dec 2002)
Automated Oracle Tuning Initial Procedures, Part 1 (DBAzine.com, Nov 2002)
Automated Replication Management (DBAzine.com, Oct 2002)
Automated Generic Performance Monitor (DBAzine.com, June 2002)
Automated Space Cleanup In Oracle (DBAzine.com, May 2002)
Automated Recompiling Of Invalid Objects In Oracle (DBAzine.com, Mar 2002)
Automated Table/Index Reorganization In Oracle8i (DBAzine.com, Feb 2002)
Automated Index-Rebuilding System (Oracle Magazine Online, Sept 2001)
Automated Cost Based Optimizer (Oracle Magazine Online, Sept 2000)
ORACLE TECHNICAL BOOKS EDITOR
EXPERIENCE HIGHLIGHTS:
- Databases - Oracle 7/8/8i/9i/10g, SQLSServer6/7/2000/OLAP, Access, dBase
- DB Management - OEM, BMC Patrol, Platinum ProVision, TSreorg
- Tools - ERwin, Oracle Designer, Orracle Developer, SQL Navigator
- Applications - Oracle ERP 10.7/11.x, Reteek 6.x, PeopleSoft 7.x
- Methodologies - IDEF1X, IE, DM, Structuredd Analysis/Design
- Data Models - ERD, KB, FA, TM, DBMS, Loggical/Physical
- Platforms - UNIX (AIX/SunOS-Solaris/HPP/AT&T/SCO/Linux), Win-NT/2000
- Networks - DBSNMP, SNMP, advanced rouuting (Cisco, 3Com, Gandalph, Ascend)
- Internet - firewalls, proxies, e-maill (Sendmail, GroupWise, Exchange)
- Languages - PL/SQL, Javascript, Unix sshell scripts, C/C++, Cobol
- Unix - since 1988 - expert level in major areas and platforms
- Oracle - since 1988 - certified OCPP DBA in Oracle 7/8/8i/9i/10g
- MS SQLServer - since 1997 - certified MCDDBA in SQLServer7
- Win NT/2000 - since 1994 - certified MCSSE in NT4/EXCH5
- Novell - since 1991 - certified CNEE in NW3/NW4/NW5
- Adaptable - performing well in a fast paced environment
- Fluent in - English, French, Romanian,, also some Italian
Oracle / MS SQL Server DBA functions:
- install, configure, upgrade software: servver, tools, applications
- monitor, tune, size, backup, recover, anallyze, defrag, migrate
- design and implement DB security, user mannagement
- SQL and PL/SQL: scripts, triggers, proceduures, packages, automation projects
- high availability, 24/7, clusters, replicaation, standby database, RMAN
- design/model DB structures to support a vaariety of software applications
- support developers in tuning DB and apps ffor optimal performance
- monitor DB growth and provide DB capacity planning for apps expansion
- design and implement backup methods and diisaster recovery strategies
- migrate DB between software versions, plattforms, DB products
WORK HISTORY:
1-Jul-2005 – present - consulting contract
ING Direct Canada, Toronto, Ontario
Major Banking Institution
Senior DBA
Environment:
AIX, Windows, Oracle, EMC,
Informatica, Oracle Enterprise Manager, Oracle Forms applications
Oracle Production DBA functions
high availability, 24/7, replication, standby, dataguard, clusters, data warehouses, ETL,
RMAN, Veritas NetBackup, tuning, application support, auditing
1-Feb-2005 - 30-Jun-2005 - consulting contract
MINISTRY OF TRANSPORTATION, Toronto, Ontario
Goverment of Ontario projects
Senior DBA
Environment:
Solaris 8/9, NT 4/2000 - Oracle 9i,
Oracle Enterprise Manager, Oracle Developer Suite 9i,
Oracle DBA functions
high availability, clusters, data warehouses, ETL
1-May-2002 – 31-Jan-2005 - consulting contract
JUSTICE TECHNOLOGY SERVICES (JTS), Toronto, Ontario
formerly INTEGRATED JUSTICE PROJECT (IJP), Goverment of Ontario project
Lead DBA
Environment:
AIX 4.3.x, NT 4/2000 - Oracle 8i, 9i,
Oracle Enterprise Manager 2.x, Oracle Forms applications,
SQL Server 7/2000
Oracle Production DBA functions
high availability, 24/7, clusters, replication,
RMAN, Tivoli TSM/TDP, tuning, application support
1-Sep-2001 - 30-Apr-2002 - consulting contract
PROFESSIONAL ENGINEERS ONTARIO, Toronto, Ontario
professional body,
Senior Oracle DBA
Environment:
Linux, NT 4/2000 - Oracle 8.1.x - 7 instances,
Oracle Enterprise Manager 2.x, Oracle Forms 6 applications,
SQL Server 6.5/7/2000, Sybase SQL Anywhere 5.5
Oracle Production DBA functions - for 7 instances
increased company’s main application performance - runs 8 times faster
setup 24/7 operation
5-Sep-2000 - 31-Aug-2001 - consulting contract
LOBLAW COMPANIES LIMITED (LOBLAWS), Toronto, Ontario
large size retail chain,
Senior Oracle DBA
Environment:
AIX 4.3.x, HP-UX 11, NT 4/2000 - Oracle 7.3.x, 8.1.x - 200 instances,
Oracle Enterprise Manager 2.x, Oracle Application Server 4.x,
PeopleSoft 7, Pro*C in-house applications, SQL Server 7/2000
Oracle Production DBA functions - for 30 instances
Tuning - the company's main production database:
increased company’s main application performance with 190%
(runs 2.9 times faster after tuning - 10% is good, 30% is excellent)
(detailed report for management available upon request)
Replication - developed PL/SQL software for replication management:
materialized views refresh run via the PL/SQL package
with errors, history, and performance logs
materialized views refresh used in data refresh, Data Warehousing
Oct.1999 - Aug.2000
PROTECTAIR, Markham, Ontario
medium size IT systems contracting company, part of Parsons Corporation,
Senior Oracle DBA,
reporting to The Director of Development, IT,
and Team Leader to a group of 3 DBA's.
Environment:
Solaris 2.x, 7, 8 – Linux - NT 4 - Oracle 7.3.x, 8.0.x, 8.1.x - 20 instances
Oracle Enterprise Manager 2.x, Oracle Application Server 4.x,
Oracle WebDB Server 2.x, PL/SQL in-house applications, SQL Server 7
Oracle Production DBA functions - for 10 instances
SQLServer 7 DBA functions - for 2 instances
responsible for setup/testing new technologies and directions,
depending on projects, liaison with third party vendors
Jan.1998 - Sep.1999
CHAPTERS INC., Etobicoke, Ontario,
largest bookstore chain in Canada,
Manager of Network Services,
reporting to The Manager of Technical Services And Operations
and responsible for up to 5 people
Environment:
HP-UX, SCO, LINUX, QNX, NT, NOVELL, HP-3000, AS/400,
Oracle 7.3.x, 8.0.x - 16 instances,
Oracle Financials 10.7, Oracle GLDI, Retek Retail 6/7,
Oracle Developer/2000, Oracle Designer/2000,
Customer Relationship Management (in-house Oracle system),
SQLServer 7, Data Warehouse, MS-DSS OLAP system, Btrieve6.
Oracle Production DBA functions - for 6 instances
SQLServer 7 DBA functions - for 5 servers
Nov.1995 - Jan.1998
BFC CONSTRUCTION CORP., Scarborough, Ontario,
large Construction Company (builders of CN Tower),
including former Banister, Cliffside, Foundation, Jackson-Lewis
DBA/Systems Engineer
Environment:
SCO, LINUX, NT, NOVELL - Oracle 7.1.x, 7.3.x - 3 instances
text based Oracle accounting software, Forms 4, Reports 3,
custom PL/SQL scripts, Cognos Impromptu reporting, Jonas DB
Oracle Production DBA functions - for 3 instances
Jan.1995 - Nov.1995
SAPIENS INT. LTD., Mississauga, Ontario,
small Computer Consulting Company.
Technical Support Specialist
Developing a job costing, sales/invoicing application in Oracle 7 and MS Access
as part of a larger project undertaken by Sapiens.
On site - installation/tuning, troubleshooting, training, support, for:
Unix, Win-NT, OS/2, Novell, Oracle 7, hardware, networks.
1990 - 1994
PARKGATE PROPERTIES, London, UK,
medium sized Property Management Company
Information Systems Manager
Design/devel. in Oracle 7 and MS Access: property management application
Maintaining the code for 3 old systems (in Cobol, Pascal, QBasic)
Maintaining the LAN's (Sage 3.0, Novell 3.12, Desk-to-Desk 1.1) on PC's
1980 - 1990
IIM, Bucharest, Romania,
large Manufacturer and Supplier of Irrigation Systems
IS Manager (1986-90), Project Leader (1983-86),
Programmer / Analyst (1980-83)
DBQ/SQL/Oracle: warehouse management system, stock movement tracking.
FoxPro: inventory control/reordering systems, with fleet management.
Cobol, Pascal, pCode: accounting/payroll, job costing/price management.
Fortran, Cobol: supplier/customer database, inventory control.
EDUCATION AND CERTIFICATION:
2005 ORACLE 10g DBA OCP - Toronto, Ontario
2002 ORACLE 9i DBA OCP - Toronto, Ontario
2000 ORACLE 8i DBA OCP - Toronto, Ontario
1999 NOVELL CNE 5 - Toronto, Ontario
1998 MICROSOFT SQL SERVER MCDBA - Toronto, Ontario
1998 ORACLE 7/8 DBA OCP - Toronto, Ontario
1997 MICROSOFT MCSE/MCP (WIN-9X/NT4/EXCHANGE5) - Toronto, Ontario
1995 NOVELL CNE/CNA (NETWARE 3/4) - Toronto, Ontario
1994 THE OPEN UNIVERSITY, UK - Credits: Operating Systems, RDBMS/SQL
1991 CITY AND GUILDS OF LONDON INSTITUTE, UK - Cobol Programming
1982 DATA MODELLING POST-GRADUATE SCHOOL, ROMANIA - Software Design
1979 UNIVERSITY OF BUCHAREST, ROMANIA - Bachelor of Science
REFERENCES: Available upon request
