MIKE HORDILA, TORONTO - RESUME OCP (Oracle Certified Professional) - DBA v.7, 8, 8i, 9i, 10g, 11g, 12c, ADB Cloud 2019 CCAH (Cloudera Certified Hadoop Admin) IBM Certified Database Administrator - DB2 9.1, 9.7 Cell: 416-473-3122 - mike.hordila@hordila.com - work samples, resume: www.hordila.com . ORACLE TECHNICAL BOOKS CO-AUTHOR Oracle Index Management Secrets by Donald Burleson, Jonathan Lewis, Mike Hordila, et.al. ISBN: 0-9740716-9-2, Rampant TechPress, Oracle eBooks, Sep. 2003 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: Automation, Data Conversion, Data Encryption, Auditing, Disk Performance, Tuning, Replication, Reorganization, High Availability, Oracle Applications, Space Management EXPERIENCE HIGHLIGHTS: Oracle RDBMS 7/8/8i/9i/10g/11g/12c - 15+ years, also MySQL 5.6, MS SQLServer 2005/2008/2012, OEM 9i/10g/11g/12c, Oracle Goldengate, Oracle Designer/Developer, ERwin, OEBS 11/12, UNIX - AIX, Solaris, Linux, HP-UX - 15+ years Windows servers, Cloudera Hadoop, EMC storage, NetApps, Data Domain, Greenplum, Tivoli, Veritas, Websphere, Weblogic, HA, Replication, Auditing, PL/SQL, Unix shell scripts, Cobol DBA functions: install, configure, upgrade, software patch (server, tools, applications), monitor, tune, size, backup, recover, analyze, defrag, migrate, design and implement DB security, auditing, replication, data management, SQL and PL/SQL (scripts, triggers, procedures, packages, automation projects), high availability, 24/7, clusters, replication, standby, RMAN, design/model DB structures to support a variety of software applications, support developers in tuning DB and apps for optimal performance, monitor DB growth and provide DB capacity planning for apps expansion, design and implement backup methods and disaster recovery strategies, migrate DB between software versions, platforms, DB products. WORK HISTORY: 1-Dec-2012 - 17-Dec-2019 - Senior DBA - consulting contract TD Canada Trust, Toronto, Ontario AIX 5/6/7, Linux RH 6, Oracle 11g/12c, IBM DB2 LUW 9.5, TSM Storage/Backup, OBIEE 11, DAC 10, Informatica 9, OEBS 11/12, high availability, 24/7, RAC, standby, Dataguard, clusters, data warehouses, ETL, RMAN, tuning, application support, automation. linux servers, root cause, shell scripting, performance tuning, cloud solutions. New apps projects from the ground up, migrations DB2 to Oracle, OEBS 10 to 12, Rman, monitoring, scripts, automation, auditing, high availability solutions - RAC, Dataguard, Goldengate, HACMP based cluster for Informatica auto failover (custom solution for a single node version). Tuning - maintained, tuned SQL in LDB's up to TB's in size. Disk architecture - TSM storage, double striping, SAME architecture. 1-Jul-2005 - 31-Jul-2012 - Senior DBA - consulting contract ING Direct Canada, Toronto, Ontario AIX 5/6/7, Oracle 9i/10g/11g, Netbackup 7, EMC Clariion, Data Domain, OEM 9i/10g/12g, Goldengate, Informatica, SAS, Java, Hadoop, Greenplum, MS-SQL 2005/2008/2012. high availability, 24/7, replication, standby, dataguard, clusters, data warehouses, ETL,RMAN, Veritas, tuning, application support, advanced auditing, data encryption, automation, data subset extraction. I have setup an enterprise level process standardization, including automation, and also environment control, process control, error control, resource control, etc. linux servers, root cause, shell scripting, performance tuning. Tuning - maintained, tuned SQL in VLDB's up to 10 TB in size. Disk architecture - EMC storage, double striping, SAME architecture. Many SQL's improved by factors of 10-20 times. Created advanced RMAN scripts (hundreds of lines of code), and automated patching scripts, standby maintenance scripts, data load scripts, etc. Developed a number of oracle applications in PL/SQL. Advanced Auditing - includes a local auditing application (2,400 lines) and a central repository application (2,000 lines), plus a number of scripts to create support tables, to upgrade the apps to match all oracle versions, and a number of other objects like triggers, etc. These are complex applications which detect and store a multitude of audit events. The system is also able to enable granular levels of auditing and to block certain connections if required. The system can also capture application errors, which the developers may not even know are there. About 100,000 errors/week were captured in the beginning in the EDW database because of some Informatica procedures. Additionally, I have developed an application (300 lines) to extract and feed audit data to a comercial reporting system. Also, I have written another application (1,200 lines) to extract audit data and generate reports for the risk assesment group as per their specification. Another application (350 lines) is used by the DBA’s to scramble production data in the EDW QA. Another application I created at the request of the Informatica and Data Warehouse teams. This application (3,300 lines) can generate unix scripts of tens of thousands of lines that handle the extraction from a source database and the load into a target database, of correlated data sub-sets. 1-Feb-2005 - 30-Jun-2005 - Senior DBA - consulting contract MINISTRY OF TRANSPORTATION, Toronto, Ontario AIX, Solaris, Oracle, OEM, Oracle Developer Suite 9i, high availability, clusters, data warehouses, ETL. PL/SQL - designed and developed a complete ETL solution (oracle-to-mainframe) 1-May-2002 - 31-Jan-2005 - Senior DBA - consulting contract JUSTICE TECHNOLOGY SERVICES (JTS), Toronto, Ontario AIX 4, HP-UX 11, NT 4/2000, Oracle 8i, 9i, OEM2, Oracle Developer/2000, SQL Server 7/2000 high availability, 24/7, clusters, replication, RMAN, Tivoli TSM/TDP, tuning, application support 1-Sep-2001 - 30-Apr-2002 - Senior DBA - consulting contract PROFESSIONAL ENGINEERS ONTARIO, Toronto, Ontario Linux, NT 4/2000, Oracle 8i, OEM 2, Oracle Forms 6, SQL Server 7/2000 Performance Tuning - increased performance with 900%, setup HA (high availability), 24/7 operation 5-Sep-2000 - 31-Aug-2001 - Senior DBA - consulting contract LOBLAW COMPANIES LIMITED (LOBLAWS), Toronto, Ontario AIX 4, HP-UX 11, NT 4/2000, Oracle 7, 8i, OEM 2, OAS 4, PeopleSoft 7, SQL Server 7/2000 Tuning - increased performance with 190%, PL/SQL complete solution for replication management Oct.1999 - Aug.2000 - Oracle/SQL DBA PROTECTAIR, Markham, Ontario Solaris 7, 8, Linux, NT, Oracle 7, 8, 8i, OEM 2, OAS 4, SQL Server 7 PL/SQL solutions for data management. Jan.1998 - Sep.1999 - Systems Manager CHAPTERS INC., Etobicoke, Ontario HP-UX, SCO, LINUX, QNX, NT, NOVELL, HP-3000, AS/400, Oracle 7, 8, Oracle Financials 10.7, Retek Retail 6/7, Oracle Developer/2000, Oracle Designer/2000, SQLServer 7. Nov.1995 - Jan.1998 - DBA/Systems Engineer BFC CONSTRUCTION GROUP, Scarborough, Ontario SCO, LINUX, NT, NOVELL - Oracle 7, Forms 4, Reports 3, Cognos Impromptu EDUCATION AND CERTIFICATION: 2020 - ORACLE Autonomous DB Cloud 2019 Specialist - Toronto, Ontario 2017 - ORACLE 12c DBA OCP - Toronto, Ontario 2012 - ORACLE 11g DBA OCP - Toronto, Ontario 2012 - CLOUDERA HADOOP ADMIN - Toronto, Ontario 2012 - IBM DB2 9.1, 9.7 - Certified DBA - - Toronto, Ontario 1998-2005 - ORACLE 7/8/8i/9i/10g DBA OCP - Toronto, Ontario 1995-1998 - NOVELL CNE 3/4/5 - Toronto, Ontario 1997 - MICROSOFT MCSE/MCP - Toronto, Ontario DATA MODELLING SCHOOL, ROMANIA - Software Design UNIVERSITY OF BUCHAREST, ROMANIA - Bachelor of Science REFERENCES: Available upon request