SUMMARY:

• Over 20 years of extensive experience in software engineering, database analysis and design, logical and physical database modeling, database and system administration, data warehouse and business intelligence processing.
• Designed, implemented, tuned and administered large production databases (up to 10Tb) installed over hundreds of servers and accessed by thousands of users.
• Installed, configured, upgraded and administered the day - to-day operation of a multitude of database environments for Oracle, Microsoft SQL Server, DB2 UDB and Sybase.
• Planned capacity, scaled up and tuned performance for Oracle, SQL Server, DB2 UDB, Sybase databases
• Designed and developed industrial-strength tools to support automated database upgrades/migrations, monitoring and alerting, auditing, SOX and patch policies.
• Designed and developed numerous business applications using Oracle PL/SQL, Java (JDBC), T-SQL, SQL PL, (stored procedures, functions, packages and triggers). Designed and developed Shell/Perl/SQL (PL/SQL, T-SQL, SQL PL) scripts for cross platform data migrations, large ETL data volumes batches, general database administration tasks, data archiving, performance trend monitoring and reporting, backup/recovery and housekeeping tasks.
• Developed database-related applications using C++/C (Oracle Pro*C/OCI/OCCI, DB2 CLI, Embedded DB2 SQL, Sybase (DB/CT) client libraries, Open Server) either for system administration purposes or data transformation and load.
• Developed web-related components for various applications using XHTML, CSS, PHP and MySQL.

TECHNICAL SKILLS:

Operating Systems: Solaris 10 - 2.5, HP-UX 11i (v.2)-10.x, AIX 5L, 5.x, 4.xWindows 2000/2003 Datacenter/Enterprise EditionsLinux Red Hat RHEL 5.1-4.x,3.x, Debian 3.0-2.x

Databases/Replication: Oracle 11g(Release 1), Oracle 10g(Release 2 and 1), Oracle 9i (Release 2 and 1), RAC10g, 9i, DataGuard 10g-9i, MS SQL Server, 2005,2000-7,6.xSybase ASE 12.5.x-11.x, Sybase Rep. Server 12.x-10.x

DB2: UDB V9.5, 8.x-V7.x ESE/EEEMySQL 4.x-5.0

ERP Applications: Oracle e-Business Suite 11i (11.5.9-11.5.4 ) Financials and HR packages, Peoplesoft 8.x-7.x, Peoplesoft Enterprise One

Application / Web Servers: WebSphere 5.x-4.0.xApache/Tomcat 4.1.x-3.x, PHP 5.x-4.x, XHTML, CSS 2.x-1.x

Languages/Technologies: Shell (ksh, csh, sh), Perl (Sybperl, DBI,DBD), PHPJava, XML, XML schema, XSL, C++/C

Java API/Technologies: J2EE 1.4-1.3 Servlet/JSP 2.2/1.1-2.4/2.0 , Enterprise Java BeansStruts, JSTL, JDBC

Methodologies: UML, OOA and OOD, Entity-Relationship Model

CASE Tools: Oracle Designer 9i-2000, Systems Architect 9.x, ERWin 4.1.x-2.x

Sybase: PowerDesigner 9.5.x-6.x

Database Administration: Quest Spotlight for Oracle, DB Artisan, Quest Central for DB2, Oracle Grid, OEM with Tuning Diagnostics and Change Management Packs, Toad, Veritas(Symantec) Storage Foundation for DB2, Veritas Oracle Database Edition

Unix Administration: Veritas(Symantec) Software Foundation for RAC 5.x, 4.x, 3.x, Veritas(Symantec) Software Foundation 5.x, 4.x, 3.x, Veritas NetBackup, Sun Cluster v.3.x,2.x.

Hardware: Sun SPARC E20K, M8000, Fire E 6900/6800-3800 Server, Sun Fire V480 Server, Sun Fire 280R, HP 9000 T500, HP 9000 series N/L, 800/300, Confidential pSeries 650-690,xSeries, RS3500, 4500, RS/6000IBM TotalStorage 256B/M, 32B/MEMC Symmetrix DMX-4/CLARiiON/Centera, 8000.

Industry experience: Banking, Telecommunications, Government, Insurance, Manufacturing

EXPERIENCE:

Confidential

Senior DBA (Oracle/SQL Server/DB2 UDB/Sybase)

Responsibilities:

• Provided 7x24 production database support for the most critical back-office bank systems.
• In this capacity I performed the whole range of database administration-related tasks from setup and configuration, upgrades, migrations, patch installations, QA and production code promotions to monitoring, performance and tuning of Oracle 10g/9i single instances and HA systems RAC/DataGuard (10g/9i), ranging in size from small to tens of Terabytes.
• Designed and implemented physical Oracle database RMAN backup and recovery procedures as well as involved in benchmarking various storage options and tuning in order to reduce the backup and respectively the restore time, especially related to the largest bank’s Data Warehouse systems.
• Developed and deployed various shell-based fully configurable Oracle maintenance jobs such as collect and analyze AWR/STATSPACK, alert upon pre-defined thresholds as well as a full monitoring and alerting framework on a variety of Oracle 10g and 9i database serves (pseudo-Oracle GRID functionality).
• Optimized large numbers of under-performing Oracle database tasks such as current application queries, nightly batch data loads and transfers, massive DDL changes occurring during regular application upgrades, etc. reducing the duration of such operations generally from hours to minutes.
• Various means were employed to this end including OWI monitoring (implemented ASH-equivalent for 9i with built-in data archiving mechanisms), trace events (10046, 10053, etc.), TKPROF, etc.
• Developed a MTS TKPROF collector tool to allow for tracing shared server-enabled sessions (equivalent to trcsess in 10g).
• Developed and documented full Oracle 10.2.0.3 migration and upgrade procedures for the entire Confidential database farm base covering versions from 8.1.6.3, 9.2.0.4-9.2.0.7 to 10.1.0.x and 10.2.0.x either RAC-installed or stand-alone.
• All RAC installations were either VCS (Veritas Cluster Server)-controlled for 9.2.0.7 and 9.2.0.4 or a combination of VCS and Oracle CRS (10.1.0.4).
• The range of migration/upgrades involved every possible scenario, from the in-place ones (same hardware and storage) to out-of-place (different hardware and storage) and included OUI-driven processes (for convenience) to manual-driven ones (for reliability) using along the way DataGuard in order to minimize the real downtime for the production systems involved.
• Participated in Oracle DR exercises covering the entire lifecycle from preparing the required documentation for the exercise to its actual implementation.
• Participated alongside external DBA consulting groups (Sun/Oracle) in activities meant to significantly improve the day-to-day database performance.
• Managed the day-to-day SQL Server database activities and migrated SQL Server 2000 databases to SQL Server 2005
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Primary DBA for the DB2 CML systems supporting a variety of projects and environments including but not exclusive to, converting DB2 UDB v.7.2 databases to Oracle 10.2.0.4, day-to-day DB2 administrative activities related to the CPR/DW data-warehouse including upgrading from DB2 UDB 7.2/AIX to UDB 8.2/Solaris 10.
• Some of the responsibilities included performance & tuning of production databases, development of DW data migration procedures, instrumentation for SOX monitoring and auditing mechanisms.
• Involved as well in tuning of SQL queries, troubleshooting production issues, monitoring database performance, (bufferpool, package hit ratio, catalog hit ratios etc.), temp and swap space usage, installed fixpacks as required, implemented and tested incremental backups for EEE environment, reorgs, runstats, imports, exports, explain, db2advis, snapshots as well as supported the development teams with new releases.
• Designed developed and implemented the main Global Command Center Level 1 DBA support tool for all 4 major databases employed by the bank, Oracle, SQL Server, Sybase and DB2.
• The tool uses a framework based on XHTML/CSS, PHP, shell and SQL scripts and is intended to be used by all GCC L1 DBA and regular APS personnel to triage and diagnose normal HP-OpenView database-related alerts.
• Provided database expertise and mentoring to Confidential Oracle/SQL Server/UDB DBA groups as well as to other various application development groups.

Confidential

Senior DBA (Oracle/SQL Server/DB2 UDB/Sybase)

Responsibilities:

• Provided database expertise to a number of Confidential Global Services corporate customers including
• Chartered Banks, Provincial and Municipal Governments, Financial Institutions, Oil companies, Electrical Utilities and Manufacturing companies as well as various internal Confidential groups engaged in a number of development/support projects. Provided database expertise, as a lead DBA to 4 IBM (Oracle/SQL Server/DB2/Sybase) DBA and 8 customer DBA personnel engaged in various development and support activities.
• Provided 7x24 production database and UNIX support to a variety of Oracle 10g, 9i, 8i, DB2 UDB v8.1 and V7.2, SQL Server 2000 and Sybase 12.5.x,12.0.x database environments for a variety of Confidential internal and external customers.
• Performed the entire range of database administration-related tasks from setup and configuration, upgrades, migrations, patch/SP/fixpacks/SP installations, QA and production code promotions to monitoring, performance and tuning of Oracle, DB2, Sql Server and Sybase database servers as well as HA-equivalents (DataGuard(Oracle 9i,10g),warm-standby(Oracle 8i), HADR (DB2 8.2), log shipping(DB2 8.1))
• Installed and configured various HA clustering solutions for Oracle (RAC/Oracle Parallel Server), DB2 ( Confidential HACMP), SqlServer(MSCS) and Sybase (HP MC/ServiceGuard) database servers on a variety of hardware platforms (HP,IBM,Compaq).
• Designed and implemented physical Oracle database RMAN/conventional (online/offline) backup and recovery strategies either using Confidential specific media managers (TSM DPO) or directly to disk. Similar for DB2 (adapted various userexits to various HA purposes),Sql Server and Sybase. Implemented Perl/shell scripts to automate an Confidential HA DB2 v.8.1 log shipping solution.
• Developed and deployed shell-based fully configurable database monitoring and alerting frameworks on a variety of Oracle database servers v. 10g, 9i, 8i, DB2 v8,v7 and Sybase 12.5. Similarly implemented SqlAgent-driven maintenance/alert jobs for Sql Server.
• Optimized various Oracle/Sybase/DB2 maintenance and application related, shell/sql jobs and reports.
• Optimized Oracle database related application functionality by converting older database configurations to newer features like dictionary-managed to locally-managed, RBO to CBO, etc.
• Optimized various DBCC INDEXDEFRAG/REINDEX,etc. Sql Server jobs.
• Developed and deployed an Oracle shell-based database code promotion framework for installing regular QA bi-weekly new application releases as well as monthly production ones. Provided documentation for the installation/usage of this framework to the rest of the DBA group.
• Performed regular administration maintenance for Oracle 11.5.6-11.5.10 eBusiness Suite (HR and Financials), setup, configuration, cloning production environments to UAT, patchset installation, etc. for various Confidential clients.
• Participated in various Confidential database migration projects from Sybase (11.9) to SQL Server (2000) and Sybase (11.9) to Oracle (9i).
• Participated in Confidential DR exercises for Oracle/Sql Server and prepared build documentation for all environments Oracle/DB2/Sybase/Sql Server for Confidential external and internal customers.
• Performed capacity planning and implementation for UNIX/Windows SAN storage environments as they relate to various database purposes (Oracle/Sql Server/DB2).
• Designed and implemented proactive database management and troubleshooting policies.
• Monitored the Oracle/DB2/Sybase/Sql Server database server and formulated performance recommendations for proper database setup and optimum SQL/Java application response time.

Confidential

Senior DBA (Oracle/DB2 UDB)

Responsibilities:

• Researched, evaluated, recommended and implemented strategies to meet the functional, technical, operational, and strategic requirements as defined by the Provincial Government of Ontario for various web-based projects. Analyzed product requirements, available resources, project constraints, and technical strategies in designing solution architectures. Designed and developed application presentation and business tier components using Struts and several design patterns, including intelligent handling of exceptional conditions.
• Also designed, implemented and administered the entire Oracle 9i, DB2 UDB 8.1 ESE database supporting structures.

The environment used included: Java 1.4.1, J2EE 1.3, Servlet 2.3, JSP 1.2, Struts WebSphere Application Server 5.0.1, DB2 UDB, Windows 2000 and WebSphere Studio Application Developer 5.0.

Confidential

Senior DBA (Oracle/Sybase/DB2 UDB)

Responsibilities:

• Provided 24x7 production database and UNIX support to a multitude of Oracle 9i and 8i, DB2 UDB V7.2 and v8.1 as well as Sybase 12.x database environments. Performed database installations, configurations, upgrades, migrations and applied Oracle patches, DB2 UDB FixPacks and Sybase ESDs as required. Maintained Oracle, DB2 UDB and Sybase databases for production, QA and development environments. Created (cloned) production-like environments for QA, testing system performance, system integration, troubleshooting, etc. Planned and implemented logical and physical database backup and recovery strategies. Performed tuning to reduce backup and restore time. Performed capacity planning and implementation for UNIX storage requirements.
• Designed and implemented proactive database management and troubleshooting policies.
• Designed and development the Sun Management Center 3.0/3.5/4.0 Performance reporting data mart.
• The application provides full history analysis of performance and trend data as well as corresponding system capacity planning capabilities.
• Designed the logical and physical database including its capacity planning and space requirements. Used Oracle features like partitioning, transportable tablespaces, locally managed tablespaces, automated segment management in order to address anticipated inherent problems caused by heavy data volume processing. Designed and developed an Oracle ETL-loader based on OCI8 Direct-Path feature used to populate the data mart with data collected from up to 1000 Sun server nodes. Used Oracle features like partitioning, transportable tablespaces, locally managed tablespaces, automated segment management in order to address anticipated inherent problems caused by heavy data volume processing.
• Designed and developed a Java XML/XSL Database Object Persistence tool, which allowed various development groups to design and implement Oracle, DB2 or Sybase database repository schemas in support of various add-on modules. The tool allows for Oracle/Sybase/DB2 UDB object creation capabilities ranging from users, tables, indexes, sequences, constraints, triggers, etc.
• Designed and developed a large variety of Oracle/DB2/Sybase database tools (PL/SQL, SQL PL shell, Perl (DBI, DBD)) for the following purposes: fully automated and unattended data aggregation and archiving, instance and database creation and configuration, migration and upgrade between multiple database versions, patch installation, performance statistics and histograms collection.
• Monitored the Oracle/DB2/Sybase database server and formulated performance recommendations for proper database setup and optimum SQL application response time.
• Designed an Oracle monitoring instrumentation strategy and reporting framework based on Statspack.
• Designed and implemented the application backup and recovery strategy using a combination of logical and physical backups.

Confidential

Senior DBA (Oracle/SQL Server/Sybase)

Responsibilities:

• Designed and implemented the main Confidential Canada back-end database registration and authentication system and provided database support for the development teams on a number of different ISP projects on a Solaris/HP-UX and Oracle/Sybase environments. Designed and implemented a HA replication system that allows the distribution of relevant data from a central customer registration database to several authentication servers. Designed and implemented a number of database environments (Oracle/Sybase) including replicated systems to support a number of core ISP products including the main Confidential Canada VPN one. Provided 24x7 production support after application rollouts.
• Migrated the database environments related to Peoplesoft HR 7.51 and Finance 7.0 from OS400/DB2 to Solaris 2.7/Oracle 8.1.6. Administered the setup and configuration of the OS (Solaris 2.7) including VxVM, VxVMSA, VxFS, VxDB Extended Edition, the configuration of the I/O subsystem (Quick I/O) etc.
• Installed and configured the database environments, designed and implemented the backup strategy (RMAN), monitored the Oracle instances to insure the proper performance during migration and regular production cycles. Developed a scalable, integrated Oracle database administration and monitoring tool build entirely using UNIX Shell and PL/SQL scripts deployable on any UNIX environment.
• Administered over 25 database environments for various applications including Siebel and Paradyne and regularly monitored them in order to improve the overall performance (tuning application SQL and Oracle instance configuration). Set up and configured Solaris cluster environments running Sun Cluster version 2.x for HA mission critical applications. Designed and implemented maintenance monitoring scripts to assist with the overall performance of the Oracle databases and also designed and implemented regular Oracle backup/recovery policy. Designed and coded various modules using Shell and PL/SQL scripts to provide utilities for batch processing (via Oracle DBMS JOBS), like archiving of aged processed data.
• Designed, coded and tested a set of PL/SQL packages for canned customer reports
• Performed complete and incomplete database recovery as required by various single instance Oracle 8i, 8.0 and 7.3 databases on Solaris 2.7,2.6, HP-UX 11.0,10.20 and Windows NT 4.0
• Performed regular UNIX system administrator functions for a number of development and UAT servers, Sun and HP9000 including installation and administration of Solaris 2.7,2.6 HP-UX 11.0,10.20 as well as for other third-party packages including VxVM, VxFS, Veritas NetBackup etc.
• Installed, configured, administered, monitored and tuned the entire Confidential farm of Sybase database servers (over 50 in number) version 11.5.x up to 12.x
• Designed and implemented a Sybase replicated environment using Replication Server 12.0 in order to separate the heavy OLTP traffic from the DSS one which accounted for crippling database blocking.
• Administered, monitored and tuned a large number of Microsoft SQL Server 2000, 7.0 and 6.5 based production systems (BAS, NRT)

Confidential

Senior DBA (Sybase/Oracle)

Responsibilities:

• Responsible for all database related aspects of designing, developing and supporting of a corporate banking system (CCMS), written in Java and using as data repository Oracle 8i/Sybase 11.9
• Performed a variety of tasks, from providing development and production support standards, to setting up and maintaining development / UAT environments, as well as writing stored procedures, triggers, scripts (ksh, Perl) and Java programs for performing current database administration tasks and also investigate performance issues and provide corrective measures.
• Managed the daily operations of the database development/production related servers
• Developed a common infrastructure, Intranet-based environment for development and production databases, which included from common procedures/standards to a unified data model publishing methodology and substantially improved the overall database development process.
• Performed basic UNIX system administrator functions with focus on shell scripting for a number of Confidential AIX, Sun Solaris development servers like installing and configuring the OS, configuring the I/O subsystem, setting up user accounts, installing software, applying patches, performing OS and software upgrades as required.
• Installed and configured Apache 1.3.x web server with numerous third-party extensions, including SSL and PHP as well as GCC, Perl, DBI:DBD, etc.

Confidential

Senior DBA (Oracle/Sybase)

Responsibilities:

• Installed, configured and administered development, UAT and production database (Oracle and Sybase) environments. Developed stored procedures, triggers, scripts (shell, Perl) for performing current database administration tasks and also investigated performance issues and provided corrective measures.
• Performed both logical and physical database design for versions 1.3 and 3.0.x of the Symposium Call-Center Server (SCCS).
• Developed database installation, conversion/upgrade and migration procedures between different versions of the database software and hardware platforms.
• Performed daily database production support and performance and tuning activities for over 500 worldwide database servers.
• Provided database mentoring and technical support to junior DBA personnel and also other groups within Nortel.