Senior Oracle DBA

Employment History

Position: Senior Oracle DBA
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.

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.

Position: Senior Oracle DBA
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
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

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.

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

Position: Senior Oracle DBA, Consultant
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
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.

Position: Senior Oracle DBA, Consultant
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.

Position: Oracle DBA, Consultant
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

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

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

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

Position: Oracle Programmer Analyst
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:
B. Sc.