Oracle Sql

Ranko Mosic

Email: *****.*****@*****.***

Phone: 408-***-****

Senior Oracle DBA

Employment History

Dec 2008 – present

Position: Senior Oracle DBA

CapGemini North America, IBM Global Services, Loblaw

Toronto, Ontario

Environment: Oracle 11g, Oracle 11g RAC, Oracle 10g, ASM, Oracle 9i, Oracle 9i RAC, Data Guard, AIX, Linux, VMware, Hitachi Storage, BMC Patrol

SC2013 is Loblaw enterprise-wide multi year project, $50M per year initiative which consists of dozens of projects ( Billing, Warehouse Management, Order Management, Transportation ) deployed simultaneously under very tight deadlines. Number of servers and systems deployed is measured in hundreds. Team size was couple of hundreds of members (DBA Team size alone is about 100 – including IBM, client, offshore ).

I developed Gold standard templates for mass database deployments in file system based, Oracle RAC and virtual environments. I provided DBA support and became part of Design team to help develop deployment blueprints for new systems.

I installed Oracle RAC databases for production, mission-critical, enterprise bus ( custom built messaging system ) and scheduling system ( Autosys ). I provided support for all newly built environments and helped client to support legacy production and lower environments.

I worked actively with monitoring development team to deploy monitoring agents to new servers and provided ticket resolution for servers in our domain.

I did extensive Disaster Recovery testing ( failover, recoverability ) for newly built systems, helped design and produce runbooks and related documentation.

I worked with Oracle support to resolve critical Service Requests.

Deployed database changes as requested by various parties ( mostly by vendors or client’s internal Design Team ).

I also provided support to client’s production systems ( high throughput OLTP systems and data warehouses ) when they faced critical issues.

My expertise was referenced and utilized during the toughest challenges client faced when dealing with emergencies and critical issues related to production databases system outages ( primary site SAN failure which implied failing over to DR, then rebuilding primary databases ), performance problems and organizational problems.

Apr 2007 – Dec 2008

Position: Senior Oracle DBA

Lafarge North America

Toronto, Ontario

Environment: Oracle 11g, Oracle 10g, ASM, Oracle 9i, Oracle 9i RAC, HP-UX, Linux, NetApp

Lafarge is a Fortune 500 company - global provider of construction materials. Environment consisted of approximately 500 database servers. I provided production database support for JD Edwards OLTP database with 12000 concurrent sessions, as well as other mission critical systems. Restored databases when file systems got corrupt or disks crashed. Provided SQL tuning, troubleshooting and configuration support to developers. I provided production database support in 7x24 on call rotation environment.

Apr 2006 – Apr 2007

Position: Senior Oracle DBA

Telus – Telecommunications provider

Toronto, Ontario

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

I helped client to deploy mission critical applications on tight deadlines. I developed and deployed new solutions for automated database partitioning ( split, exchange, merge partitions ). Took active part in deploying multiple simultaneous, mission critical projects.

I developed and implemented database synchonizing solution for Very Large Databases that utilized disk mirroring ( split mirror based on Hitachi Shadow) technology.

Oct 2003 – March 2006

Position: Senior Oracle DBA

MPAC, Ministry of Finance agency

Toronto, Ontario

Environment: Oracle 10g RAC, Oracle ASM, Oracle 9i RAC, Sun OS

Provided performance tuning and administration services for Oracle RAC database.

Performced advanced performance tuning -RAC specific global cache tuning, high-speed interconnect tuning.

Performed capacity planning activities based on historical storage usage.

Performed backup and recovery activites, as well as SQL, PL/SQL tuning.

Created 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

As Senior DBA for Technical Architecture group I performed requirement analysis and deployment options that would best fit client environment. I evaluated new technical features.

I created and deployed read-only materialized views replication setup. I configured and deployed advanced security option. I planned and performed upgrade/migration from Oracle 8i to 9i.

I planned and performed capacity planning activities.

Created backup and recovery strategy and scripts.

I performed performance tuning activities in large environment.

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

I created and implemented data partitioning strategy. Evaluated new products to make sure they would fit project requirements. I performed monitoring and performance tuning activities, as well as RAID setup. I 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, Advanced Replication, Standby database, Sun Solaris Clusters, Veritas File System,

I provided production DBA support in fast paced Silicon Valley culture ( standby database creation and maintenance, performance tuning, database replication ( materialized views, multimaster replication); shell scripting as well as database migration to highly available ( HA, clustered ) environment.

Jul 1999 - Apr 2000

Position: Senior Oracle DBA, Consultant

Nortel Networks, Toronto, Ontario

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

I deployed Oracle database on raw devices. I created multimaster replication setup; implemented conflict resolution, notification methods. I performed performance tuning, monitoring and developed object oriented database design using UML method.

Mar 1998 - Jun 1999

Position: Senior Oracle DBA, Consultant

Rogers,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

I performed database tuning, monitoring; backups, recovery. Created logical, physical database design. Created and maintained data processing routines.

May 1996 - Mar 1997

Position: Oracle DBA, Consultant

Livingston Group International, Toronto

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

I was development and production DBA in fast-paced, multi-project environment I performed database monitoring and tuning, SQL optimization. I performed systems analysis (interviewing, data flow diagrams), enterprise data modeling using relational and object oriented paradigms. I was technical lead on data warehousing subproject (loading strategies, data aggregation, optimization)

I conducted job interviews for full time and Consultant DBA positions

July 1995 - April 1996

Position: Oracle Consultant

William M. Mercer, Toronto, Ontario

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

I performed systems analysis using interviewing techniques and data flow diagrams.

Performed enterprise data modeling using ERD's (IDEFIX1 method)

I performed 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). I participated in tools and methods evaluation.

April 1994 - June 1995

Position: Oracle Consultant

Ministry of Health,

Toronto, Ontario

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

Defined business requirements. Facilitated data modeling sessions.

Performed Logical, physical database design (ERD’s); defined application meta data repository.

Conducted database tuning; defined security roles.

Transformed specs written in 3GL style to specs suitable for event driven programming.

Nov 1993 - March 1994

Position: Oracle 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; recommended 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.

Conducted testing; wrote technical documentation.

Performed network software installation.

Jan1993 - 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 help provide optimal database design for data retrieval.

May 1988 - Dec 1992

Position: Oracle Programmer Analyst

Public Enterprise for Distribution of Electric Energy,

Kragujevac, Serbia

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

Performed systems analysis using interviewing techniques and data flow diagrams - ORACLE CASE*Designer - Data flow Diagrammer).

Performed system design activities using ERD's ( ORACLE CASE*Designer - Entity - Relationship Diagrammer)

system implementation (logical and physical database design ).

EDUCATIONAL BACKGROUND:

1988 B. Sc. University of Kragujevac, Yugoslavia

Contact this candidate