Data Oracle

Joseph Lizon

Toronto

Canada

Tel: 905-***-****

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

Professional Summary

Highly skilled senior IT professional with 25+ years experience in data architecture, solution architecture, business intelligence, database engines, data analysis and data administration.

Business-oriented team player with track record of successful technology implementations across multiple industries. Projects included data warehousing, building new DR environments, integration and migration of data centers, storage upgrades and integration and separation of different business units.

Skills

Broad hands-on knowledge of data architecture and database engines including Oracle software stack, Microsoft and cloud ecosystems from IBM, Amazon and MS.

Proven technical expertise in data architecture and database management processes.

Experienced with data governance.

Experienced providing technical consulting and leadership in Innovative technology, Data, Database Architecture on logical and physical level.

Experienced with capacity planning, installation, configuration, database design and implementation, proactive monitoring and performance tuning, both at database and application levels.

Oracle Database Logical/Physical Design, Administration, Monitoring and Performance Tuning.

Experienced in installation, configuration and migration of Oracle RDBMS to higher versions starting from version 7.x up to 12c including multi-tenant architecture with Oracle Real Application Cluster (RAC), Automatic Storage Management (ASM) and Data Guard (DG).

Experienced in installation, configuration, monitoring and migration of MSSQL Server to higher versions starting from version 7 up to 2016 including MS Cluster, HA solutions.

Excellent understanding of Oracle Architecture and Oracle Client Components.

Strong development skills using Unix/Linux shell scripting, SQL, PL/SQL, Visual Basic, C#, VBScript, HTML and Perl.

Experienced in deploying high transaction multi-instance architectures of Oracle RDMS server ver. 7.3.x, 8.0.x, 8i, 9i, 10g, 11gR2 and 12c on leading vendor server platforms like IBM AIX, HP, SUN Solaris and Microsoft Servers.

Strong leadership traits including an ability to lead teams to results.

Ability to learn quickly and adapt to new and challenging environments.

Excellent inter-personal and communication skills, good verbal and written expression.

Work Experience

5/2016 – 10/2017 Paradigm Quest Inc.

DBA/Data Architect

Standard DBA activities related to all existing environments including PROD, PRE-PROD, TEST and DEV.

Created, owned and managed all changes to the data models for newly create Data Warehouse (DW) initiative. The database model was created based on the mortgage industry standards and TOGAF principle.

Created data models, solution designs and data architecture documentation for DW, review data model for the existing systems and recommended innovative solutions for the metadata in the several production SQL Server databases.

Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.

Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.

Created the data mapping from several data resources to the DW newly create data model, work with ETL team to insure data quality.

Environment:

Framework - TOGAF for Data Architecture

Methodologies - IDEF1X, Structured Analysis/Design

Data Models - Logical/Physical

Platforms - Windows 2012-2016, Amazon Redshift, MS Azure, IBM SL

Databases - MS SQL Server 2008- 2016

11/2013 – 5/2016 Travelers/The Dominion Insurance Canada

Senior DBA

Ensured a consistent database architecture through adherence to proper logical and physical database design techniques.

All aspects of the DBA duties for the DW projects related to all lines of Canadian Insurance Businesses.

As a part of international team provided leadership for PL/SQL code reviews to adhere the best practice standards.

Database cloning with Data Pump, RMAN scripting and other in-house solutions as a part of support of the Development and Testing Groups.

All environments support to make them secure, scalable and reliable as per SLA agreements with all line of businesses which includes high level audit, user support, RDBMS and relevant OS patching.

PL/SQL code review with the development team to address performance issues, recommendation for improvements by applying new Oracle features including like partitioning, different type of indexes, adding new objects to the existing schemas and data model changes.

Data Center migration from Toronto to Norcross in USA from AIX platform to Linux and Exadata for DEV, QA and PROD environments.

Security review and alignment from SOX compliance perspective.

Monitors and tunes the use of database application logic to achieve business goals of availability, accessibility, security and performance including Policy, Claim and Billing Centers.

Environment:

DB Management - Grid Control and Oracle Enterprise Manager.

Framework - TOGAF for Data Architecture

Tools - Oracle GoldenGate, Shell scripts, Oracle Sql Developer with Data Modeler, PL/SQL

Methodologies - IDEF1X, Structured Analysis/Design

Data Models - Logical/Physical

Platforms - IBM, Linux, Solaris

Databases - 11g/12c Oracle databases with Data Guard (DG) and multi-tenant architecture, Oracle RAC, Automatic Storage Management (ASM)

BI - Cognos

12/2006 – 10/2013 RBC/Ally Canada/Resmor Trust/GMAC Residential

Senior DBA/Data Architect

Developed and maintained data architecture principles, standards, policies and models to define the Ally Bank/Resmor data architecture which complied with the TOGAF framework and meet all business requirements for CDIC, Compliance and Fraud Departments.

Provided full-life cycle architectural guidance and ensuring quality of technical deliverables.

Recommended and evaluated new tools and methodologies.

Proposed data archived strategies, DR solutions, backup and recovery policies.

Collaborated with clients, business analysts, technical staff and project team members to translate Architecture requirements to design, develop, implement, and enhance full technology stack based on multi-tier application environments.

New 11g Oracle RDBMS installation and configuration on RAC with ASM, patching, upgrade to 11gR2 and regular maintenance and tuning for the data warehouse environment.

Migrated applications/databases from development into Q.A. and production environments.

Collaborated with third party vendors on technology implementation for major vendors.

Collaborated on capacity planning and storage requirements.

Provided leadership for design and implementation of Disaster Recovery (DR) Environment with Oracle Data Guard ( for Oracle DB ) and MS SQL Mirroring ( for MS SQL Server ).

Cognos Cube implementation.

Environment:

DB Management - OEM

Framework - TOGAF, .NET

Tools - ERwin, Toad, Tuning Expert, SQL Analyze

Methodologies - Structured Analysis/Design

Data Models - Logical/Physical

Platforms - Linux, MS Windows 2003/2008R2

DB Environments - 10g/11g Oracle databases, Oracle RAC, ASM, Oracle Data Warehouse, ODI, OBIEE, Web Logic, DG for DR, MS SQL Server 2005/2008R2, SQL Cluster, IBM Websphere, BO XI R2, SAS, COGNOS

Storage - Hitachi storage – in ~40 – ~50 TB range

1/2006 – 12/2006 Fujitsu Consulting Inc.

Senior Oracle DBA - Consultant

Project: Development and implementation of the new system for the Family Responsibility Office in the Ontario Ministry of Community and Social Services with cooperation of Themis Team, Ministry Team and Fujitsu Consulting Team.

Oracle Senior DBA responsibilities included:

communication between different management levels and team members

new 10g Oracle RDBMS installation and configuration on Sun Solaris platform.

new 10g Oracle Application with Oracle Forms and Reports installation and configuration

capacity planning and storage requirements

creating new databases and Oracle objects as per documentation

maintaining existing databases to provide maximum performance capacity for the existing hardware configuration

security policy and auditing

disaster recovery and backups with RMAN utilization

data conversion and data movement between development, legacy databases and pre-production environments

performance and tuning

logical/physical design with ERWIN

reverse-engineering of legacy databases

the gateway configuration between MS SQL Server and Oracle databases

ongoing support

developers mentoring

Installation documentation, build books.

Environment:

DB Management - OEM

Tools - ERwin, Toad, Tuning Expert, SQL Analyze

Methodologies - IDEF1X, IE, Structured Analysis/Design

Data Models - Logical/Physical

Platforms - Solaris

Environment - 10g Oracle database with Oracle Web Server, Forms and Reports

Database size - 150 Gb – 1.5 Tb

5/2004 - 12/2005 Manion Wilkinson

Senior Oracle DBA

Oracle Senior DBA responsibilities include:

new Oracle RDBMS installation and configuration ver. 9.2 and 10g

upgrade and patch installation

capacity planning and storage requirements

creating new databases and Oracle objects

maintaining existing databases to provide maximum performance capacity for the existing hardware configuration

security policy

disaster recovery and backups

performance and tuning

logical/physical design with ERWIN

developers mentoring

Environment:

DB Management - OEM

Tools - ERwin, Toad, Tuning Expert, SQL Analyze

Methodologies - IDEF1X, IE, Structured Analysis/Design

Data Models - Logical/Physical

Platforms - Linux, Win-NT/2000

Database size - 150 Gb – logically very sophisticated

1/2004 – 4/2004 City of Hamilton

Oracle DBA

Responsible for migration process of all legacy databases to Oracle 9.2 and all aspects of DBA duties for various Oracle databases ver. 7.3.x, 8i and 9i. and MS SQL Server ver. 7.0 to MS SQL Server 2000 on Windows 2000/NT platform.

R Responsibilities included:

providing reliable production and test environments for existing Oracle databases.

installation and configuration.

performance tuning and optimization.

capacity planning.

database design and implementation.

planning storage requirements.

creating primary storage structures and primary Oracle objects.

maintain database security.

Environment:

DB Management - OEM

Tools - ERwin, Toad, Tuning Expert, SQL Analyze

Methodologies - IDEF1X, IE, Structured Analysis/Design

Data Models - Logical/Physical

Platforms - Win-NT/2000

Database size - ~50 Gb – 9 in total

6/2000-11/2002 SHAW (Cancom/Star Choice)

Senior Oracle DBA

Led a team of five, responsible for specification and implementation of a system servicing call centers in three different physical locations with 400 concurrent users. Designed hardware and software configurations for the system.

Designed and implemented purge/archive process related to account-receivable tables to trim growth yet make information available for future use by utilizing the archive database concept.

Designed and implemented a data warehouse for the Decision Support Team by implementing Oracle Data Warehouse and OLAP technology.

Performed logical and physical data modeling and PL/SQL and SQL programming to reengineer a system from a total rebuild to an incremental add architecture.

Prepared Oracle test environment for a 3-tier configuration based on Oracle 9i database server and OAS, Tomcat, Web sphere and JDBC middle-tier component on a Sun Solaris database server and a NT Web server.

Planned the backup strategy and evaluated backup methods including operating system backups, on-line backups and restore processes using standard OS utilities in conjunction with shell scripting and Oracle RMAN scripts.

Performed with logical and physical data modeling and metadata creation. Utilized ERWIN’s reverse engineering and target database schema conversion processes and custom PL/SQL and SQL programming.

Environment:

DB Management - OEM

Tools - ERwin, Toad, Tuning Expert, SQL Analyze

Methodologies - Structured Analysis/Design, Data Warehouse, DSS, OLAP

Data Models - Logical/Physical

Platforms - Unix (HP9000, Solaris), Win-NT/2000

Database(s) size - ~250 Gb – ~700 Gb, 27 in total

11/1991-6/2000 Canadian Broadcasting Corporation

Oracle DBA

Responsible for all aspects of DBA duties for various Oracle databases ver. 7.3.x, 8.0.4 and 8.1.5. Managed 16 databases in total on HP, UNIX and NT platforms.

Responsibilities included: capacity planning, installation, backups, configuration, database design and implementation, performance tuning, planning storage requirements, creating primary storage structures, creating primary Oracle objects, maintain database security and optimizing database performance.

As member of a Y2K team, designed, tested and implemented, Y2K compatibility processes. Set up a Y2K lab to perform Y2K readiness tests and QA processes in order to implement changes to production.

Designed the database and the network WAN infrastructure for the ScheduleAll system. Designed and implemented stress and volume tests. Implemented relevant data access strategies, such as bitmap indexes and data caching. Tuned database according to Oracle consultant’s specifications.

Environment:

DB Management - OEM

Tools - Erwin

Methodologies Data Models - Logical/Physical

Platforms - Unix (HP9000)

Database size - ~30 Gb – 16 in total

Education

Warsaw Technical University, Poland 1980–1985

MSc in Applied Mathematics, Department of Applied Mathematics

Certifications

OCP in 8i and 10g

Contact this candidate