Senior Oracle DBA/Architect

I V A N O V A C R A W F O R D

PROFESSIONAL SUMMARY

Certified Oracle DBA and ITIL with more than 20 years of experience in the IT industry.

Skilled at working in a team environment and fostering open communications

Proven success in managing a team of Quality Assurance specialists and coordinating database and development activities in a multi-project team organization.

Strong skills with performance and tuning of large (up to 40TB) Oracle 9i, 10g and 11g databases

Over 20 years of experience with Oracle 9i, 10g and 11g in UNIX/Linux/Windows environments.

Strong experience with Scripting (Korn, Crontab, Bash, Bat) and

Strong experience with OEM, PRECISE and RMAN.

SKILLS

Applications:

Oracle Applications (GL, AP, PO, AR, RA, FA,

INV, HR, PA)

HHSC Applications: TIERS, TLM, Document Center, Portal Migration.

Database Modeling: Erwin, Toad, Business Objects, Embarcadero

Database: Oracle RDBMS Versions 6, 7, 8i, 9i, 10g, 11g

Tools: Oracle Designer, Oracle Parallel Server (OPS) & RAC, Oracle Super Cluster, Oracle User Exits, Oracle Identity Management Solutions, Oracle Application Object Library, TCP/IP, Oracle Developer, Golden Gate,

Developer/2000, Forms Designer 4.5, Reports Designer 2.5, SQL*Loader, JAVA, PRO*C, PRO*COBOL, SQL*Plus, PL/SQL, Erwin, MS Project, JDBC/ODBC, SQL Server 200*-****-****

Languages: PL/SQL, SQL DML DDL, C, C++, Cobol, Fortran, Korn Shell,

C Shell, Bash Shell, Perl, Java and J2EE Database

Interactions, VSAM, MANTIS, MARK IV, PL/1 and JCL

Hardware: SUN Solaris Servers/Clusters, Super Cluster, IBM AIX Servers/Clusters, HP Servers/Clusters, DELL LINUX Servers/Clusters, HP Workstation, IBM PC and DELL Workstations, HP 9000, SUN, IBM S80, NOVELL Networks

OS: UNIX, Red Hat Linux, Windows NT, Windows 7, 10,

2000/2003, Solaris, DOS, NOVELL, IBM–AIX,, MVS, TSO

EDUCATION

Bachelor's Degree in Computer Science and Engineering – North University, Barranquilla, Colombia, January 1984

Humboldt High School - Jun 15 1979

CERTIFICATIONS

ITIL Certification – PeopleCert, Austin, TX June 18-2013

Master Certification in Oracle Database Administration –ORACLE UNIVERSITY, Irving, TX, April 1998

EXPERIENCE

HHSC Texas Health Department – Austin, TX

Apr 2009 – Today

Sr. Logical DBA Consultant/Functional Lead

In Compliance with Department and State policy, plans and work Rules and

In Compliance with Department and State guidance on system architecture and automation:

Performed highly advanced and managerial (senior-level) database administration work by providing direction and guidance in strategic operations and planning during Portal Migration, which included overseeing the effective and efficient storage, retrieval, customization and archiving of data by managing diverse datasets to ensure integrated database system after Migration. Worked under minimal supervision, with extensive latitude for the use of initiative and independent judgment.

Database Builds, Migrations, Upgrades. In charge of Logical Builds performed Upgrades and Migrations for different kind of environments and applications: TIERS, TLM, WCM, DEM, SSP, SDC STG, SDC RPT, Document Center

Performance and Tuning of TIERS, TLM and other Oracle Databases; around 200 mid to large size, from 100GB to 40TB. Performed SQL Forecast and Wait Events Analysis on Critical Database Stress Load Testing and provided efficient Recommendations for Improvement. Performed advanced logical database administration, performance monitoring & tuning for State Portal, Workflow Management, Portal Migration and other Social Services applications

Database Design and modeling; worked with different Application Teams in order to gather and implement Logical and Physical Design. Used different modeling Tools: Erwin and TOAD for ERD generation.

Oracle 11g Database Installation, Configuration and Performance: As a Lead for TLM System, set and configured 11g different scenarios to test the latest new features and API’s, producing different options for Performance Tune of the most critical and potential Impacts to Applications in a RAC Environment with 3 Nodes and 9TB Databases. Performed the same kind of Analysis and results for Super Cluster Migration to 6 Nodes and 40 TB databases.

Backup, Restore, Disaster Recovery: During Portal Migration in HHSC set Database Strategy to duplicate Web Content Management Database at DR server located in another

Place and provided Backup and Restore support of the same Database environment during

The entire Life Cycle of the Project. In the initial phases of this Project recommended and

Evaluated the implementation of necessary Procedures to save, retrieve and recover the databases from hardware and software failures.

Project Management. As a Lead Responsible for TLM and WCM Applications was actively involved in the planning phase for new Projects and worked closely with customers to determine their business need requirements and measured system performance against expectations. Developed Standards and Procedures to ensure the Integrity of the database environments.

Production Implementations. Deployed several Releases and coordinated implementation activities with other parts of Enterprise Applications, optimized performance and resolved production critical issues, including timely follow-up on problem reports.

Participated in on-call duty, 24/7 pager rotation.

Mentoring. Mentored employees within the LDBA group and other groups within IT by offering guidance and sharing business and technical knowledge. Set and Configured Initial Shared Point with all kind of DBA Practices, Procedures and Documentation. Later transferred this Knowledge to System Analyst IV

to continue with the work.

ON-CALL. Performed administration, operation, maintenance and support of production databases, including database triage support. Performed both workday and night/weekend on-call support for all development, test, training, and production databases to help maintain high availability of the databases for developers, testers, trainers, and production end users.

Software Acquisition. Evaluated policies and procedures to guide in the use of Software

And Resources

DRS Infrared Technologies – Dallas, TX

Sep 2008 – Jan 2009

Sr. Oracle Consultant

Backup and Recovery Strategies; Design and Implementation of a Corporate Backup and Recovery System in a multi OS and Applications environment, including Corporate Catalog Implementation.

Performance and Tuning of WIND Shill and other Oracle Databases; around 20 mid to large size. Instance Configuration and Tuning. Applications 12 and database production support.

Database Design and modeling; worked with different Application Teams in order to gather and implement Logical and Physical Design.

Dr Pepper Snapple/TRG – Plano, TX

Mar 2006 – Oct 27 2008

Sr. Oracle Consultant/Team Project Lead/Performance and Tune Expert

Performance and Tuning of SAP and other Oracle Databases; Around 200 mid to large size. Instance Configuration and Tuning. Application SIEBEL and database production support.

Project DBA Lead; in charge of 5 projects, delegated task to Intermediate and Junior DBAs. Backed up two other DBAs. Offshore Team Coordinator. Data Center Outsource.

Database Design and modeling; worked with different Application Teams in order to gather and implement Logical and Physical Design.

Cingular Wireless – Richardson, TX

Sep 2005 – Mar 2006

Oracle Consultant

Provided Production Support to 9i and 10G, 60G to 7TB Oracle database environment, by being On-Call responsible for Oracle Production DB troubleshoot performance issues under SLA.

Provided Support to PRECISE Install in order to measure performance by monitoring and tuning of production databases.

In charge of RMAN and Korn Shell backup/recovery procedures, provided daily backup status report to Upper database level.

Provided support for Replication and Log shipping for Standby Data guard Configuration.

Worked with Oracle 10g and 9i in a multi server Database environment with Veritas Clustered Solution for Sun Sparc Solaris, HP and AIX. Around 800 databases and Vtiers using Korn shell, sqlplus, PL/SQL, crontab Scripting and RMAN.

Securus Technologies – Addison, TX

May 2005 – Sep 2005

Oracle DBA

Set and Configured Oracle 10g Single Instance and RAC environment, including Database Design, Operating System SAN, Evaluation of ASM Vs OCFS Disk Configuration, OCFS Disk Configuration Implementation, Backup, Restore and Disaster Recovery in LINUX DELL Infrastructure.

Strategies using Bash shell and crontab scripting in LINUX environment.

Provided support and assistance to DATAWAREHOUSE CALLMART Set Up.

Assisted developers in the PL/SQL Packages, Procedures, Function Set Up and XML in Web Application Environment.

Generated Capacity Planning for three years related to Oracle Database Environment, Users, Process, Servers, Memory, CPU and Disk Configuration for a Corporate and Centralized Environment implemented by the Consolidation of several systems: DNA, CUMULUS, CALLMART, BECS.0

Provided auditory to data transfer from other platform and systems like SQL Server Interfaces to Oracle 10g.

Provided assistance to SQL Server DBA in Oracle Interactions and Interfaces.

Cingular Wireless – Euless, TX

Nov 2004 – Apr 2005

Sr. Oracle Consultant

Optimized partitioned objects in an Oracle 8.1.7.4, 3 TB DATAWAREHOUSE environments with tables with high fragmentation, and applied recommendations in order to make better usage of space.

Used OEM with the Diagnostic Performance Monitoring Package to monitor/tune/reorganize 3 TB to 7 TB Database environment 9i/10G and set scripts for reorganization online in 8.1.7.4.

Cloned 60G to 3 TB databases from production to development environment in a SUN Solaris environment.

Recovered Databases, using Korn shell, crontab scripting and RMAN.

Assisted Staff and developers in the application of Oracle Technologies.

Used UNDO Management in Oracle databases 9i/10G to get better performance on the undo segments and avoid errors related to snapshot too old that were associated with the traditional ROLLBACK Segments Management.

Upgraded 8.1.7.4 to 9i Oracle RDBMS and applied security patches.

Provided support to RAC and Clustering database environment

Brinks – Coppell, TX

Aug 2003 – Sep 2004

Sr. Oracle Database Administrator

Started Oracle 9i Environment from scratch and automated all the critical Oracle 9i task, Backup, Restore and Recovery, Performance and Tuning, Security, etc saving million of dollars to the Company by performing with the previous automation several task currently done by tools like: Foglight, Spotlight, Space Manager (From Quest), IBM Snap Tool for backups, Oracle 9i Configuration (Standby, Dataguard, RAC).

Also trained and set standards for 30 developers located remotely in India and 10 developers located on Site.

Mentored and in general assisted IT Organization with all the issues related to Oracle 9i in Windows and UNIX Platforms, saving to the company 100% of support provided by other companies like Meta-link, Oracle, Quest, etc.

Designed and implemented High Availability HA Clustering solution with 2 IBM AIX nodes and set the configuration and implementation plan for Real Application Clustering RAC coming from Oracle.

Mentored PeopleSoft Sysadmin, DBA and PeopleSoft Application and Veritas Cluster Services environment.

Coordinated with several areas: Network Administration, IBM AIX and Windows System Administration, Network Engineering, Managers, IT Directors and Vice-president for the setting of a new SAN LUN configuration using different disk drives IBM and Windows NT, consolidating with this storage environment and giving more than 50% effectiveness and faster access to the information accessed thru different applications in several environments.

Helped Primary SYBASE DBA with some Application Migrations.

KForce Consultants – Dallas, TX

May 2003 – Aug 2003

Sr. Oracle Consultant

Assisted Client Cash Sync Team with Oracle Database issues, and set Oracle Environments in Windows and UNIX AIX.

Configured Oracle databases; set standards, provided technical oracle support by structuring the Oracle 9i environment required by a Cash Sync Pilot Project and projected more than 100% savings for the company in Database Administration Support, comparing a rate of 50US$/hour to 400US$/ hour in average that was normally charged by a guru.

Alcatel USA – Plano, TX

Nov 1997 – Jan 2003

Sr. Oracle Database Administrator

Improved the Performance of more than 50 databases 20G - 400G in size by developing a Consolidated Database Tuning Tool using Korn shell, SQL, SQLPLUS and PL/SQL, resulting in significant Performance Improvements in Storage Allocation, Memory Used, I/O and Contention Rates.

Improved Recovery Time in more than 50% for around 12 databases by setting Korn shell UNIX Sun Solaris backup/recovery scripts in the Backup and Database Server.

Selected as a Pilot DBA for Migrate the Oracle RDBMS from 7.3.3 to 8.1.6 for 6 Payroll, Recruiting and Financial databases, resulting in more than 60% improvement of Company Productivity by fixing earlier bugs and providing better and faster access for Developers to the information in the Database and in general better performance in the Database Queries.

Also upgraded the same RDBMS from 8.1.6 to 8.1.7, getting improvements in the index speed access and also fixing bugs from previous releases.

Multiplied to other DBAs the knowledge acquired in Oracle RDBMS upgrade and migration from 7.x to 8i in order to accomplish the biggest Production Manufacturing and Financial Database Migration from 7.3.4 to 8.1.6, resulting in more than 50% significant improvement for Company Productivity.

Improved the number of task by using Task Simplification Techniques, Microsoft Project, SQLPLUS, SQL and PL/SQL in a previous Migration Plan, which was 80% automated for doing the Migration for Openshop and Datawarehouse Databases from 7.3.4 to 8.1.7 that decreased the number of resources: time from 24 hrs to 8 hrs and DBA from 10 to 2.

Set the environment and developed a Migration plan including Korn shell and sql/sqlplus scripts for performing the Merging between Alcatel Richardson and DSC Plano. Moved more than 2000 database objects tables and indexes from Oracle version 7.1 in an Alpha VAX Cluster with VMS Operating System to target databases in 7.3.3, 7.3.4 and 8i UNIX Sun Solaris environment, resulting in Company Productivity improved significantly by letting the developers coming from Richardson and the ones in DSC continue their job.

Completed Payroll Database Restore Automation in Development and Preproduction Environment by setting 7 Restore Operation and 6 Monitoring Scripts, improving the Restore Operation and decreasing the possibility of errors. Reduced the Readme txt file Instructions from 11 to 5 Operation steps. Also produced and distributed a document with the changes in Payroll database operation to DBA group.

Implemented Partitions, Materialized Views and Query Rewrite Mechanism for Infowarehouse/Datawarehouse Database and coordinated with Infowarehouse Marketing Datamart users the New 8i Features testing by designing a test plan and a form to be filled with the results of the testing, which showed the Refreshing and Query Performance improved more than 50%.

Implemented interactive SQL/SQLPLUS and PL/SQL scripts in order to automate DBA task for the setting of 9i databases including the New Features, resulting in a significant improvement in the Productivity for Database Engineering Process.

Provided assistance to Financial Database users in Storage Parameters definition for tables and indexes, Query Tuning and Database Performance by using Quest Tools like Space Manager, SQLLAB and IWATCH. Used Space Manager also to provide Managers with Alerting Reports for Objects with too much fragmentation, Tables with chained rows, under use of storage by other ones, etc, etc. Used Space Manager also to accomplish Reorganization activities for 12 databases resulting in improvements of more than 80% in the Productivity, compared with previous method Export/Import.

Developed an ON-CALL Problem Solution Prototype System in order to help DBA on-call solve problems. Also by participation in the weekly DBA meeting, implemented a new form designed to help the DBA in the time and in general resources utilized during the Duty Pager Week. Resulting in significant improvement in the Productivity and also enforcing Team Relations and Task Standardization.

Provided On-call support once a month for more than 80 databases, resulting in a better DBA task distribution.

SEUS LTDA – Barranquilla, Colombia

Jun 1996 – Jul 1997

SQL Server Database Administrator

Used SQL SERVER versions 6.x and 7.x in a Client/Server architecture with 2 servers, 15 clients and Windows 95 in the Clients (PC workstations) working with Oracle Tools Developer 2000, Forms 4.5, Report and Graphics 2.5 and Windows NT from Microsoft and RDBMS in the Servers. Resulting in Productivity improvements for the Complete Network, Database and Applications by using the best combination price/performance support for several platforms and easy to use SQL Server graphical management tools including Enterprise Manager.

Created Logical and physical design of databases for Billing System. Included the creation of the Data Dictionary with 300 tables. Developed 15 procedures in SQL language.

Project Manager

Managed a team composed by 5 Information Systems Engineers in order to develop a complete Sales Information System.

Coordinated the work of the team, who developed the interface systems: Inventory, General Ledger, Accounts Receivable and Accounts Payable. This coordination work was done with Project tool. The complete system was installed and 20 users were trained in its use at 2 different companies generating a profit of more than 50% earning for the Company.

Developer

Developed a complete Bill Information System. Used PL/SQL language in the PC work-stations with Developer/2000 and Forms Designer 4.5 to develop 50 forms and 2 menus of 50 options each one.

Developed about 1000 triggers in order to implement the sale functions in the system, like: Quotation, Requesting Orders, Dispatching, Invoicing and Return of Products.

Used Reports Designer 2.5 in order to develop 30 different reports of Sales statistics and government tax reporting forms.

Used Graphics 2.5 in order to develop 3 sales statistics graphics showing comparisons between monthly sales, accumulative sales and net sales in a year. Created additional graphics showing sales by vendors, customers, agencies, products, etc.

Exxon Corporación – Guajira/Colombia

Jan 1984 – Jun 1995

Computer System Analyst and Quality Coordinator

Developed and supported several Financial, Payroll and Compensation systems using EXXON standards, IBM, MVS, TSO, COBOL, VSAM, MANTIS, MARK IV, PL/1 and JCL, adopted companywide methodologies significantly improved their efficiency and e effectiveness.

Contact this candidate