Ranko Mosic

Oracle 10g, 9i Certified Database Professional OCP      

24 Tucker Street

Toronto, Ontario

M4B 3P1

Canada

Phone: (416) 615-0869         

Cell:     (416) 450-2785

Email: mosicr@rogers.com

         

Senior Oracle Database Administrator / 19 Years Experience
Installation / Designing / Performance Tuning / Monitoring / Troubleshooting /                                          
Advanced Performance Tuning / Logical and Physical Database Design Migrations /
Backup & Recovery  / Oracle Financials / JD Edwards
 Data Warehouse and ETL Software/ Data Conversion
                                                 
My article about 10gR2 Streams was published in May 2006 issue of NOCOUG Journal ( Northern California Oracle Users Group ), Q3 2005 issue on New York Oracle Users Group Journal and on Jonathan Lewis’ Web site:
http://www.jlcomp.demon.co.uk/faq/streams_01.html 
  
 My profile was published in Oracle Magazine: Ranko Mosic Senior Oracle DBA, Toronto, Ontario

                   

  • Oracle 10g, 9i Certified Database Professional OCP      
  • An innovative and energetic leader, skilled communicator. Proven ability to work in a team environment and provide skills transfer to employees.
  • Proven ability to write technical documentation including technical assessments, DBA procedures, and technical proposals; I have articles published in NOCOUG Journal magazines and on Jonathan Lewis’ web site  ( world class Oracle expert )
  • Proven ability to analyze and correct databases that were performing poorly, especially production databases. Proven ability to perform database recoveries and disaster recovery testing
  • Proven ability to stay ahead of the mainstream technology direction using scientific approach
  • Expert knowledge of writing and tuning SQL, PL/SQL, and UNIX shell scripts.
  • An expert knowledge of Oracle RDBMS and all major options

 

Selected Accomplishments

Oracle DBA Stepped in and hit the ground running during highly critical period for client.  Relived pressure caused by high volume of work / high turnover problems. Stabilized highly volatile environment. Technical advisory to full time staff.

Oracle DBA on data migration project. Diagnosed and resolved bottleneck during production database ( Oracle RAC ) data load ( poorly configured online redo logs and log buffers ). Load time was cut from 38 to 10 days.

Oracle DBA in multi-platform environment. Designed and implemented backup and recovery procedures using RMAN/Tivoli/SAN.

Oracle DBA on production database in fast paced Silicon Valley culture. Successfully performed database migration from single node to multiple nodes, clustering setup.

Oracle DBA successfully configured advanced replication.

Oracle DBA on call to provide 24 hour support. Paged on the weekend that a disk crash had occurred and a database would not start up. Database required a recovery. Identified backup tapes needed to bring back database and archive log files. Performed recovery and database was operational in time for Monday processing.

Oracle DBA resolved production database crash problem ( Oracle bug on HP-UX ).

 

 

Employment History

Apr 2007 - present

Position: Lead/Senior Oracle DBA, Consultant

Lafarge North America

Toronto, Ontario

Environment: Oracle 10g, ASM, Oracle 9i, Oracle 9i RAC,  HP-UX, Red Hat Linux, HP Data Protector

 

  • 10,000 concurrent sessions OLTP database ( J.D. Edwards )
  • Advanced monitoring using HP Open View, BMC Patrol, Blackberry
  • Production database support, 7x24 on call rotation
  • Development support

 

 

 

Apr 2006 – Apr 2007

Position: Senior Oracle DBA, Consultant

Telus

Toronto, Ontario

Environment: Oracle 10g, Oracle 9i, Oracle 9i RAC,  Sun OS, PL/SQL

 

  • Very Large Databases, hundreds of instances ( 64-bit environment, Multi-Terabyte databases )
  • Partitioning
  • Production database support and maintenance
  • Backups/recovery

 

 

Oct 2003 – March 2006

Position: Lead Oracle DBA, Consultant

MPAC ( Municipal Property Assessment Corporation )

Toronto, Ontario

Environment: Oracle 10g RAC, Oracle ASM, Oracle 9i RAC,  Sun OS, Windows 2000, PL/SQL

 

  • Very Large Database ( 50G SGA, 64-bit environment, 5 Terabytes database )
  • Advanced performance tuning -RAC specific global cache tuning, high-speed interconnect tuning 
  • Logical, physical database design for tax system
  • Capacity planning
  • Star schema design ( Kimball method – facts, slowly changing dimensions)
  • Production database support and maintenance
  • Backups/recovery
  • Advanced PL/SQL tuning
  • ETL design and implementation. Data migration from legacy mainframe system.
  • Oracle 10g Streams Replication setup

 

 

 

 

May 2002 - Oct 2003

Position: Senior Oracle DBA, Consultant

Integrated Justice Project, Toronto, Ontario

Ministry of Public Safety and Security

Environment:  Oracle 9i, Oracle 8i,  Oracle Advanced Replication, Erwin, AIX ( HACMP ),

Windows NT, Tivoli (TDP, TSM), RMAN

  • Member of technical architecture group
  • Requirement analysis
  • Logical, physical database design for OLTP, Data Warehouses and Operational Data Stores
  • ETL design and implementation
  • Planned and performed capacity planning
  • Performed replication setup
  • Configured advanced security
  • Created backup and recovery strategy and scripts
  • Performance tuning in large environment (3000+ concurrent users, terabytes of data, SAN storage)
  • Planned and performed upgrade/migration from 8i to 9i

 

 

 

March 2001 - Feb 2002

Position: Senior Oracle DBA, Consultant

City of Toronto, Ontario

 

Environment:  Oracle 9i, Oracle 8i, interMedia, RMAN, OEM, PL/SQL, Erwin, UML, Rational Rose,  Sun Solaris, WebLogic, JSP, J2EE

 

  • Performed requirements analysis for web-enabled data mart project
  • Logical, physical database design using star schema, dimensional paradigms ( slowly changing dimensions )
  • Created and implemented data partitioning strategy
  • ETL design and coding
  • Evaluated new products to make sure they would fit project requirements
  • Monitoring, performance tuning
  • RAID setup
  • Designed and implemented disaster and recovery procedures

 

 

 

 

Apr 2000 - Feb 2001

Position: Senior Oracle DBA,  Consultant

Andale.com, Mountain View, California

 

Environment:  Oracle 8i, RMAN, OEM, PL/SQL, Advanced Replication, Standby database, Sun Solaris Clusters, Veritas File System, WebLogic

 

  • Production DBA duties in fast paced Silicon Valley culture
  • OLTP and  data warehousing day-to-day activities
  • Created and implemented backup and recovery procedures
  • Standby database creation and maintenance
  • Performance tuning ( RAID setup )
  • Database replication ( materialized views, multimaster replication).
  • Shell scripting
  • Database migration to highly available ( HA, clustered ) environment

 

 

 

 

Jan 2000 - April 2000

Position: Senior Oracle DBA,  Consultant

Wells Fargo, Des Moines, Iowa

 

Environment:  Oracle 8i, PL/SQL, Erwin, Rational Rose, Sun Solaris, Windows NT

  • Created data warehousing database using star schema, dimensional paradigms
  • Data processing routines for statistical system ( large installation, terabytes of data )

 

 

 

 

Jul 1999 - Jan 2000

Position: Senior Oracle DBA, Consultant

Nortel Networks, Toronto, Ontario

 

Environment:  Oracle 8i, Oracle8, Oracle Advanced Replication,  Sun Solaris, shell scripting, Rational Rose

  • Multimaster replication setup;created and implemented conflict resolution, notification methods
  • Database performance tuning, monitoring. Object oriented database design using UML method
  • Raw devices database setup
  • Backups, recovery

 

 

 

Mar 1998 - Jun 1999

Position: Senior Oracle DBA, Consultant

Rogers Cable, Toronto, Ontario

 

Environment:  Oracle 8i, Oracle 8, Sun Solaris, Java, AIX,  Windows NT, Oracle Application Server,   OEM, BMC Patrol, Erwin, Oracle Parallel Query, Multi-threaded Server

  • Database tuning, monitoring; backups, recovery.
  • Production and development database support; large installation ( 20+ servers, 80+instances;client server and Web-enabled applications; distributed database environment )
  • Performed logical, physical database design
  • Created and maintained data processing routines
  • Performed performance tuning and monitoring in large data warehousing database

 

 

 

Sep  1997 - Mar 1998

Position: Senior Oracle DBA, Consultant

DMR, Chapters, Toronto

 

Environment:  Oracle Financials ( GL, AP, AR), Oracle 7, Platinum Desktop DBA, HP-UX

 

  • Administered  Oracle Financials database ( 6 servers, 10 instances; largest database over 350G);
  • Monitoring, tuning;
  • Performed space management; database defragmentation
  • Resolved memory management problem that regularly crashed database  

 

 

 

May 1996 - August 1997

Position: Senior Oracle DBA,  Consultant

Livingston Group International, Toronto

 

Environment: ORACLE 7, AIX ( UNIX ), Windows NT, Intranet, AIX Clusters ( HACMP )

  • Development and production DBA in fast-paced, multi-project environment
  • Database installation and creation
  • Space management
  • Database monitoring and tuning
  • SQL optimization
  • Created distributed databases ( database links) replication
  • systems analysis (interviewing, data flow diagrams); enterprise data modeling using ERD's, DFD’s ( four major subsystems )
  • Logical and physical database design and implementation using relational and object oriented paradigms
  • Lead on data warehousing subproject  (loading strategies, data aggregation, optimization)
  • Conducted formal job interviews for full time and Consultant DBA positions

 

 

 

 

July 1995 - April 1996

Position: Oracle Consultant, Consultant

William M. Mercer, Toronto, Ontario

 

Environment:  ORACLE 7 (Pro*C, C), SQL*DBA, Erwin (CASE),  ODBC API, UNIX (HP-UX)

 

  • Systems analysis using interviewing techniques and data flow diagrams
  •  enterprise data modeling using ERD's (IDEFIX1 method)
  •  logical and physical database design and implementation using relational and object oriented paradigms
  • Performed regular  DBA activities (database creation,  users management; rollback segments, tablespaces; security; backup and recovery)
  • Created data loading routines using ODBC API
  • Participated in tools and methods evaluation.

 

 

April 1994 - June 1995

Position: Oracle Consultant, Consultant

Ministry of Health, Toronto, Ontario

 

Environment: ORACLE7, SQL*DBA,   Erwin (CASE), UNIX ( AIX), DB2 (distributed database)

  • Defined business requirements
  • Facilitated data modeling sessions
  • Logical, physical database design (ERD’s); defined application meta data repository
  • Denormalization
  • Conducted database tuning; defined security roles
  • Transformed specs written in 3GL style to specs suitable for event driven programming
  • Interacted with Systems Analyst and the rest of  the team
  • Created interface to access remote database (DB2) through stored procedures and Oracle Gateway

 

 

 

Nov 1993 - March 1994       

Position: Oracle Consultant, Consultant

Bell Canada , Toronto, Ontario

Environment: ORACLE 7 (SQL*DBA, Pro*C, SQL, PL/SQL, SQL*Forms, SQL*Plus, ORACLE Utilities), UNIX (SunOS) 

  • Consulted on database performance optimization; recommened indexing strategy for fast retrieval
  • Evaluated tools and techniques for data processing (team adviser for bottlenecks

in production process and for  SQL optimization)

  • Wrote data processing procedures (large tables) to improve execution time (very tight deadlines)
  • Conducted testing; wrote technical documentation
  • Performed network software installation

 

 

 

 

May 1993 - Oct 1993          

Position: Oracle Programmer Analyst, Consultant

XEROX Canada, Toronto, Ontario

Environment: ORACLE 7 (Pro*C, C, SQL*Forms, SQL*ReportWriter, SQL*Plus, SQL*Net), UNIX(SunOS), OPEN WINDOWS, SUN SPARCstation (client-server environment)

 

·         Wrote software modules to transfer formatted radio, TV survey data from ORACLE 7 database to

XEROX DOCUTECH device;

·         communicated with DBA and database modeler to provide optimal

database design for data retrieval.

 

 

 

Jan 1993 - March 1993

Position: Oracle Programmer Analyst, Consultant

Legislative Assembly, Toronto, Ontario

 

Environment: ORACLE 6 (SQL*Forms, SQL*ReportWriter, SQL*Plus, PL/SQL), UNIX

 

·         Troubleshooted of an inoperative application (adjusted applications to changed data model);

·         Conducted debugging

·         Added new  features

·         Corrected reports; corrected form - report coordination.

 

 

 

May 1988 - Dec 1992

Position: Oracle Programmer Analyst

 Public Enterprise for Distribution of Electric Energy Kragujevac, Serbia and Montenegro

 

 

Environment: ORACLE 6 (SQL*Forms, SQL*ReportWriter, PL/SQL, SQL*Menu,  SQL*Loader)

  • Delivered Information System for Inventory Management
  • Systems analysis using interviewing techniques and data flow diagrams - ORACLE CASE*Designer - Data flow Diagrammer)
  •  system design using ERD's ( ORACLE  CASE*Designer - Entity - Relationship Diagrammer)
  • system implementation (logical  and physical database design ).

 

 

 

 

 

 

SKILLS:  Oracle DBA, UNIX, Database modeling and design (entity -  relationship diagrams),

                    system analysis (interviewing, data flow diagrams), dimensional modeling

 

PRODUCTS: Oracle 10g, Oracle 9i, Oracle8i, Oracle 8, Oracle 7 Server (Pro*C, SQL*Plus, PL/SQL, SQL*Net), Oracle 6, Rational Rose, Erwin,  Oracle Designer

 

OPERATING SYSTEMS: UNIX (AIX, SunOS, HP-UX), Windows NT        

 

LANGUAGES:    JAVA, C, C++, COBOL, 4GL's        

 

APPLICATIONS: Banking(financial), Retail, Pension Funds, Accounting, Inventory Management,

                                         General Ledger,  Human Resources, Telecommunications, Health care, Government

 

 

EDUCATIONAL BACKGROUND:

1988 B. Eng. University of Kragujevac, Yugoslavia

1981 Diploma: High School for Computer Operators, Yugoslavia