BACKGROUND:

Over 17 years working experience as a Database Administrator, Database Architect, DB/Systems Infrastructure Architect and Database Developer, 10 years of which in Supervisory/Project Lead position. Business exposures include Telecommunications, Banking and Finance, Manufacturing, Retail, Healthcare and Education. Over 7 year experience in systems development (client - server and web based applications), data warehousing and E-Business applications running under Windows, Unix (Solaris, AIX), Linux (RedHat, Oracle) and VM (VMWare and Oracle VM) environment as well as IBM Websphere Application servers and Oracle Application servers.

TECHNICAL BACKGROUND:

• ORACLE RDBMS version 7.x, 8i, 9i, 10g and 11g
• Oracle 9i, 10g, 11g RAC
• Oracle Grid Control
• Oracle Enterprise Manager
• OEM 12c Cloud Control
• Oracle Exadata version x1, x2-2
• Oracle ZFS Appliance

Oracle Media Servers:

• Oracle RDBMS version 7.2, 7.3.3, 8.04, 8.0.6 on Windows NT and DEC UNIX
• Oracle 8i RDBMS version 8.1.5, 8.1.7 on WindowsNT/2000 and IBM-AIX version 4.3 and Sun Solaris
• Oracle 9i RDBMS version/release 9.2 on IBM-AIX version 5.1, Sun Solaris and Windows 2000
• Oracle 10g RDBMS on Sun-Solaris 9/10, IBM-AIX and Windows2000/2008, VMWare
• Oracle 11gR1/r2 RDBMS on Sun Solaris, Linux, AIX and Windows2008, VMWare ESX ver 4.x
• Oracle Real Application Clusters on Linux and Solaris Platform
• Oracle Exadata X2-2
• Oracle ZFS Appliance 7300/7420 Model

Oracle Database Appliance:

• Oracle 10g Application Server-Enterprise Ed.
• ORACLE Application Sever version 4.0, 9i, 10g, 11g
• Oracle Fusion Middleware
• Oracle BI/Discoverer
• ORACLE Development Tools(web and client-server)
• Oracle Developer/2000 release 1 for Windows95/98
• Oracle Forms version 2.5 to Oracle Forms 10g version
• Oracle Designer release 2, 10.g
• SQL, PL/SQL, PSP (PL/SQL Server Pages)
• Oracle Jdeveloper
• Oracle WebDB version 3.0
• Oracle9i Forms and Reports
• Oracle 9iAS Portal Developer
• Oracle 9iAS - Application Server
• Oracle 10g Application Server (Forms, Reports, Discoverer, Portal)
• Oracle PL/SQL Web Toolkit, MOD PL/SQL package
• Oracle HTTP/Apache Server, Oracle Application Express 3.0

ORACLE BI and Data warehouse Tools:

• Oracle 10g Discoverer BI and OLAP
• Oracle Discoverer 9Ias(Admin and User Edition)
• Oracle Discoverer3i (Admin and User Edition)
• Oracle Warehouse Builder
• Oracle Express Server
• Oracle Express Analyzer (DBA and Analyst edition)
• Oracle Personal Express

IBM Websphere Application Server:

• Apache/JBoss/Weblogic
• IBM Websphere Application Servers (Advance Edition) version 3.5, 4.0 under WindowsNT and IBM-AIX version 5.1
• IBM HTTP Server, APACHE Server

BEA Weblogic:

• Weblogic AppServer
• IBM Db2 UDB v8, 9.x, 10.x
• MySQL v4.1 5.x
• Sybase ASE 10, 12
• IBM Db2 UDB on LUW
• T-SQL
• MySQL Community Server, MySQL Enterprise Server version 4.x and 5.1, 5.5, 6.x

Cognos:

• Cognos Powerplay and Impromptu
• XML, EDI
• VMWare Server, VMWare ESX ver 30, 4.0
• VMware Virtualization Server, VMWare Virtualization Desktop Clients

PACKAGE APPLICATIONS:

• Oracle Human Resources
• Oracle based package application for Human Resources Management

QRS Sourcing (Tradeweave):

• A Web based and client-server Retail and Supply Chain applications. A true E-Business application that utilizes Websphere version 4.0, J2EE and Oracle 9i as software infrastructure.
• Oracle Financial Analyzer
• Oracle Financial Analysis and Reporting Tool

BPCS (Business Process Control System):

• IBM AS/400 based manufacturing applications. Running on OS/400 as platform using DB2/400 as database
• Banner-SCT And Oracle based packaged applications that handle Student Registration, Course and Grades Management, Accounting and Payroll Processing.
• Oracle Manufacturing Module - Oracle Application ver. 10
• Oracle Applications - E-Business Suite
• Oracle Express

OPERATING SYSTEMS:

• Windows
• Linux (Red Hat, Oracle)
• Sun-Solaris
• IBM-AIX
• HP-UX
• Novell Netware

EMPLOYMENT HISTORY:

Confidential

Sr. Oracle Architect/DBA

Toronto, New York

Responsibilities:

• I’m responsible for the overall design and implementation of Oracle Exadata Technolog and Db2 UDB and HADR y for Independent Health, I am responsible for the overall design and execution of database migration from legacy systems to Oracle Exadata Infrastructure.
• I also serve as the Technical Architect for Oracle within Independent Health making sure all critical and core applications and databases are properly migrated from Db2, MYSQL and MSSQL databases and converted to Oracle and Oracle related products.
• I also manage and design Independent Health’s systems and storage migration from conventional Windows environment to Sun Solaris and Oracle Linux platform as well as implementation of Oracle ZFS Storage appliance.

Confidential

Sr. Database Administrator/ Systems Infrastructure Architect/Oracle Exadata Implementation Specialist

New York, Chicago

• Worked as the Principal Consultant (Database and Systems Infrastructure) and Technical Project Lead for NexJ Systems, my role and responsibilities includes Oracle, Oracle EXADATA, MySQL, DB2 UDB and SQL Server Technology Stack implementation (i.e. Database, Oracle RAC, and Business Intelligence), Server Cluster Infrastructure, Application Server Infrastructure and Oracle Applications/CRM Application Technical Implementation and deploying Oracle, DB2 UDB and MySQL Server databases on VM(VMWare ESX ver 4.0) servers, Solaris, Linux and AIX platform. Manages 40 Physical Servers of Solaris and Linux platform and 100 VM servers running on Windows 2003, Windows 2008 utilizing VMware version 4.0
• I’m also responsible for managing Unix Systems Infrastructure (Solaris 10 servers and AIX 6.1) and Red Hat Linux systems version 5.4, SAN Storage Administrator (using EMC and Dell-Compellent) as well as client facing consultant and help them design and implement Business Intelligence Application and DB Infrastructure design (HA and DR).
• I also consolidated both the company’s and client’s Oracle, DB2 and MySQL Servers farms, reducing server count by 50% and saving over $200k in licensing in one year as well as SAN administration for over 280 terabytes of storage (Oracle, DB2 and MySQL Servers) and performed capacity planning, maintenance, evaluations, purchasing, benchmark testing.

Confidential

Sr. Oracle Systems Engineer

• Setup application and database integration between Oracle and DB2 UDB and DB2 on z/OS
• Install, Configure Oracle Weblogic, Oracle Entitlement Server and Oracle Identity Management software stack.
• Upgrade the existing Oracle RAC 10gR2 infrastructure to Oracle 11gR1 RAC on Sun Solaris 10 environment as well install/configure Oracle 11gR1 Physical Dataguard
• Responsible for deploying EHO One Portal applications and creating PL/SQL API’s for data integration migration and conversion from Db2 UDB ver 9.5 to Oracle 11gR1 environment.
• Create a “copy/clone” procedure for EHO One Portal DB infrastructure (Oracle) for their Development and QA environment.
• Perform database performance tuning, systems tuning and code tuning while working closely with EHO development team
• Suggest and implement best practices for managing Oracle and DB2 database infrastructure.

Confidential

Principal DBA/Systems Administrator

• Business Intelligence and Data Warehouse development, design and implementation using Oracle 10g and Oracle Discoverer BI Tools, developing PL/SQL packages, procedures and batch SQL scripts.
• Online Reservation System development using Oracle Application Server Software stack and Powerbuilder, PL/SQL ADFS development tools and Oracle Forms/Report Builder.
• Development of integration code between SQL Server and Oracle data exchanges.
• Responsible for Database Backup and Recovery. Install and Configure Oracle Standby database/Data Guard environment for database high availability.
• Oracle 10g RAC Design and Implementation on Red Hat Linux ES4
• Red Hat Linux Systems Administration
• Database Performance Tuning and SAN (Compellent) Storage Administration (Oracle ASM and non-ASM)
• Oracle 10g RAC Design, Implementation and Maintenance for a 2 Node and 3 node RAC Redundancy infrastructure.
• Support and manage SQL Server 2005 Database Infrastructure and integration with Oracle back-end systems.
• Perform database and software upgrade for Oracle, Db2 and MS SQL Server
• Setup application and database integration between Oracle and MS SQL Server
• Responsible for disaster recovery planning for Db2 Servers. Implemented database mirroring for constant availability of sales force automation and product routing.
• Implemented Quest LiteSpeed backups to network drives to replace outdated tape-based backups. Backup windows shortened from as long as 16 hours down to under 2 hours, enabling company to keep more backups online.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.

Confidential

Sr. Database Administrator /Architect

• Business Intelligence development, design and implementation using Oracle BI Technology (e.g. Oracle Application Servers Infrastructure, Oracle Portal, Oracle Discoverer BI and Oracle Reports, OLAP, AWM).
• Application Integration development using Shell scripts, SQL’s and Java for server to server integration and data communication.
• Responsible for Database Backup and Recovery. Install and Configure Oracle Standby database/Data Guard environment for database high availability.
• Database Architect for Data Warehouse, Banner and E-metering project
• Responsible for Oracle Database and Oracle Application Server infrastructure design and deployment
• Oracle database migration from Oracle 8i and 9i to Oracle 10g release 2
• Install, configure and maintenance of Oracle 10g RAC (Real Application Cluster) 4 Node Infrastructure.
• Setup application and database integration between Oracle and DB2 UDB, MySQL Server
• Setup Backup and Recovery Procedure for SQL Server databases.
• Evaluated OLAP tools, recommended Databeacon, and built web-based OLAP cube reporting systems around it.
• Designed and populated reporting tables, views and stored procedures.
• Trained developers on how to write better queries, optimize their applications and to become junior database administrators.

Confidential

Sr. Database Administrator/Architect

New York

• Back-end development using PL/SQL, PL/SQL Server pages for batch data loading and processing.
• Oracle PL/SQL, SQL code performance tuning.
• Responsible for Database Backup and Recovery. Install and Configure Oracle Standby database/Data Guard environment for database high availability.
• Database Architect for Data Warehouse, Banner and E-metering project
• Responsible for Oracle Database and Oracle Application Server infrastructure design and deployment
• Oracle database migration from Oracle 8i and 9i to Oracle 10g release 2

Confidential

Sr. Database Administrator

• Oracle Database from 9i to 10g
• Db2 UDB version 8.x and 9.3
• FundCOM - IBM DB2 UDB Database Migration/Conversion to ORACLE
• FundCOM Oracle Application Server 10g Upgrade and Deployment
• SQL Server Database Management for MS CRM applications running on SQL Server 2000/2005
• Design and Development of Confidential Data Warehouse Application of 2.4 TB
• Confidential SAN (Storage Area Network) Design for Oracle DB Infrastructure
• Setup Oracle High Availability Infrastructure (Sun Hardware Cluster)
• Design and develop Data Warehouse report applications using Oracle BI Discoverer, OLAP and Oracle Reports and Forms 10g.
• Create and build database stored procedures/packages using PL/SQL, batch SQL scripts, PL/SQL server pages (PL/SQL Web toolkit) in support for FUNDcom applications
• Responsible for the overall design, build and implementation of database migration and data conversion from an IBM DB2 UDB databases to ORACLE RDBMS version 10g environment.
• Responsible for Database Backup and Recovery. Install and Configure Oracle Standby database/Data Guard environment for database high availability.
• Responsible for creating RMAN backup jobs for online backup for 24x7 production databases.
• Responsible overall design, conversion and migration of all Production Databases to a SAN infrastructure (EMC environment) - 3 TB
• Responsible for implementing High Availability Infrastructure for Oracle Application Server, BEA WebLogic and Oracle Databases
• Responsible for database performance tuning both for Application Server and Database Servers.
• Monitor database performance and perform necessary database tuning for application support. Apply database software patches and upgrades, create and maintain database users and manage and monitor database growth.
• Install, upgrade and deploy Oracle Application Server 10g from version 9iAS to 10g.
• Upgrade existing client-server Oracle Forms 6i to Oracle10g Forms and Reports
• Design, build and deploy web reporting using Oracle Discoverer 10g. Create End-User Layer, design and create Oracle Discoverer reports for end-users.
• Implement Oracle Application Server 10g Farm Infrastructure within Confidential and maintain high availability by implementing failover servers.
• Perform Database backup and recovery using RMAN, Data Pump and Standby Server.
• Manage 4 SQL Server databases that houses MS CRM Applications
• Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server, all Microsoft SQL Server 2000.
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
• Wrote, designed and produced customer site allowing customers to view reports, place orders, download newer software versions, and set up their own surveys.
• Wrote installation and procedural manuals for support staff.
• Wrote triggers and stored procedures to integrate 3rd party applications into in-house apps such as project management systems with a minimum of development time, helping the company build new partnerships faster

Confidential

Sr. Database and Web Systems Architect

• Student Online Registration and Payment System (SCT-Banner / TouchNet)
• Course Management System (WebCT)
• University’s Data Mart Systems
• Responsible for Database Backup and Recovery. Install and Configure Oracle Standby database/Data Guard environment for database high availability on a Sun Solaris 9 and HP-UX environment.
• Responsible for creating RMAN backup jobs for online backup for 24x7 production databases using Oracle Enterprise Manager.
• As the Database Administrator responsibilities include designing database for the different school applications. Creating data models (entity-relationship diagrams) using CASE Tools like CA-Erwin Data Modeller, BPWin Process Modeller. Working together with 2 other DBAs, responsible for creating and maintaining database objects (Tables, Views, Synonyms, etc.) both on the testing and production environment using Oracle RDBMS version 8.1.7 and Oracle RDBMS version 9i release 2 under Windows2000 Server and Sun Solaris Server. Responsible for installing and upgrading Oracle Client applications for 105 business users.
• Create project documentation both technical and non-technical.
• As the Web Architect, responsible for creating web applications using Oracle PSP (PL/SQL Server Pages), Java Server Pages, JDBC utilizing Oracle RDBMS version 9i release 2 under Windows2000 Server and Sun SPARC Solaris box. Creating a Oracle Web Applications using Oracle Forms6i, Oracle Reports6i using Oracle Forms and Reports Server while utilizing Oracle Application Server version 9i (Oracle9iAS) and Oracle 10g Application Server. Creating database packages, stored procedures and database triggers that performs business logic and back-end transaction processing.
• Responsible for creating and upgrading Web Forms applications using Oracle Forms9i version while utilizing Oracle Application Server version 9i release 2 and Oracle Application Server 10g that handles XML formatted data.
• Responsible for maintaining and customizing the University’s packaged web applications called Banner by SCT, Portal Administration and Development using Luminus Portal Software and Oracle Portal as part of Oracle Application Server9i and Oracle 10g Application Server.
• Responsible for the maintenance, installation and upgrade and security of all Oracle Application Servers.
• Supports and maintains 2 DB2 UDB Server production boxes under Windows2000 platform. 30% of daily work period is spent on Server performance monitoring, backup/recovery and data integration between Oracle and SQL Server databases.
• Creates DTS packages for Data Integration and some T-SQL (procedures) for data manipulation and cleansing.
• Participates and conduct user requirements gathering, business process re-engineering and project presentations. Serve as a liaison between business users and IT development team.

Confidential

Sr. Database Developer/Project DBA

• QRS Sourcing System (Tradeweave)
• RETEK (Retail Management System)
• KARAT/Gerber System
• As the Sr. Developer and Project DBA, responsibilities include managing and delegating works to 2 programmers and 2 other technical analysts and 1 DBA. Responsible for coordinating and assigning work assignments and creating project status report to make sure deadlines are being met. Coordinating with other IT groups for needed resources and attending project business meetings and occasionally doing project presentation.
• As a Project DBA, responsibilities include installation and configuration of database servers and database software (Oracle 8.1.7 and MS SQL Server 2000) under Windows2000, creating and maintaining database both for development and production environment. Creating and maintaining tables, indexes, snapshots, stored procedures, user enrollment including privileges and access rights both for ORACLE and MS SQL SERVER. Creating batch programs for data extraction, cleansing and summarization in support for on-demand report generation. Performs daily database backup, database and application tuning and server performance monitoring.
• Serve as the Lead Person (Technical) in the implementation, customization and maintenance of QRS Sourcing System.
• As a database developer, responsibilities includes developing interface programs for extracting data from different data sources (e.g. MS SQL Server, Informix, DB2) and uploading it to an Oracle Database using SQL, PL/SQL and Oracle Developer Tools. Also responsible for creating reports using Crystal Reports version 8.5 for client-server and web deployment.
• Maintenance and enhancement of existing intranet site for Merchandizing and Logistics Division of Sears Canada using Oracle JDeveloper version 3.2 for Java Server Pages/Applet development, MS SQL Server2000, MS IIS version 4.0 and MS Frontpage/2000.

Confidential

Regional Database Administrator and IT Project Leader

Responsibilities:

• As the Regional DBA and IT Supervisor, responsible for doing project presentation to business regionally, delegating work assignments to 2 DBA’s, 1 System Administrator and 3 programmers. Responsible for coordinating project plan across ASIAN affiliate companies, managing project financial resources (Hardware and Software purchases, Trainings/Education, external consultant hiring).
• Responsible for Database Backup and Recovery. Install and Configure Oracle Standby database/Data Guard environment for database high availability.
• Responsible for creating RMAN backup jobs for online backup for 24x7 production databases.
• As the Regional DBA, duties and responsibilities includes preparing hardware/software requirements, installation and configuration of database servers and database software, creation and maintenance of development and production databases, backup and recovery. Also responsible for database performance tuning, users enrollment and their access rights, database upgrade and migration, back-end programming (creating stored procedures, functions and database packages).
• As the Technical Project Leader, duties and responsibilities includes coordinating with hardware and software vendor, coordinating with other regional DBA and Project Leaders, coordinating with business experts regarding user requirements, presiding on group meetings and project presentation with middle management. Also responsible for creating technical documentation’s (e.g. programming standards and conventions, system rules and policies and designing Graphical User Interface policies) base upon on Bestfood System Standards and Policies.
• Programming and Development works includes (Forms and Reports development using Oracle Developer Suites), SQL and PL/SQL programming, creating batch programs, SQL Tuning, HTML, JavaScript programming) using Oracle Developer (Forms, Reports, Graphics) version 6.0 and 6i, Oracle Discoverer version 3.26/3.36 and Oracle Express Analyzer version 6.0.
• Also responsible for conducting technical training’s on how to use different Oracle Tools both for the technical and non-technical personnel
• Worked as the last line of support in the event of any system/application crashes or failure.

Confidential

Associate Computer Systems Analyst

Responsibilities:

• Database objects maintenance (tables, views, synonyms). Create and Test database stored procedures and functions.
• Planning and design for database migration and data conversion.
• Creating project and system documentation both technical and business concepts.