EXPERIENCE SUMMARY:

Over 30 years’ experience in advanced Database information management projects. Specialist in Database Architecture, Application Development and Support, Modeling and Administration supporting heterogeneous database environments to include Oracle, DB2, Sybase and SQLServer. Strong background in engineering database solutions that meet or exceeded customer service level requirements.

SKILL:

• UNIX, LINUX, AIX
• Windows XP, 7 z/OS
• Oracle 7, 8i, 9i, 10g, 11g, 12c
• Installation and Configuration
• Backup and Recovery (RMAN)
• Application Support (PL/SQL, SQL Developer, Oracle Forms, Oracle Reports)
• Performance and Tuning
• V7, V8, V10
• Installation and Configuration
• Backup and Recovery
• Performance and Tuning
• SQLServer 2005, 2008, 2012, 2016
• Backup and Recovery
• Performance and Tuning
• Shell script (Korn, C )
• Perl
• Python
• Modelling/Design Tools
• TOAD, ERWIN

PROFESSIONAL EXPERIENCE:

Confidential

Database Manager/Team Lead

Responsibilities:

• Lead and mentored group of 9 database administrators in support of large government agency.
• Interface between management, application stakeholders and DBA staff.
• Developed and insured adherence to Strategic plans, processes and procedures.
• Responsible for the availability, performance and security of over 1500 databases include Oracle, Sybase, MS SQLServer, DB2 (z/OS), IMS and UNISYS (DMS and RDMS).
• Developed automation tools for daily and mundane tasks allowing DBA’s to focus of bigger and high visibility issues.
• Successfully completed major database upgrades for Oracle (11g to 12c), DB2 (V8 to V10), SQLServer ( and 2016).
• Consistently ed 100% ratings from the customer during my tenure.

Confidential

Lead DBA/Engineer

Responsibilities:

• Analyst Subcontract to Contigo Strategies performing a study of database development procedures and practices for a major healthcare company.
• Ingres to Unix - Oracle transition working at the Confidential ’s Silver Spring Md.
• Project was to move a critical Confidential legacy application written in COBOL on a VAX4300 accessing Ingres Tables to a SUN/SOLARIS platform accessing Oracle Tables.
• Responsibilities were the strategic planning, design and project schedule to complete the project with 90 calendar days.
• Work include the redesign of the Ingres Schemas to better fit an Oracle 10g environment taking advantage of some of the Oracle features such as Oracle external tables.
• Implemented O&M processes as needed and developed scripts to manage new application for the end users and support staff. All new scripts were developed in KORN shell.

Confidential

Lead DB Engineer

Responsibilities:

• Database Engineering lead on project to convert a major Chinese Telecom’s 130tb Oracle database from HP’s Shared Logical Volume Manager (SLVM) to Confidential ’s Cluster Volume Manager (CVM).
• Installed multiple Oracle database versions (9i, 10g with and without RAC) to support the conversion.
• Created multiple terabyte sized database environments to support testing and troubleshooting procedures to support the conversion.
• Remotely supported project team when they went to China for the successful conversion of their Oracle environments.
• Other projects include establishing SQL Server databases to include testing clustered set of servers in support of high availability.

Confidential

Technical Lead/Architect/DBA

Responsibilities:

• Responsible for all aspects of the project architecture, execution and implementation.
• The migration moves the all the EIDS applications and associated infrastructure.
• Updated P5 AIX servers to support the applications were purchased as part of the migration and were used to re-host the applications.
• The infrastructure is based on Confidential P5 AIX servers, DB2 V8/9, Oracle 9i and 10g, Informatica, COGNOS, Business Objects and Websphere.
• Provided planning, engineering and technical guidance to teams of database, systems and software engineers for each phase of the project.

Confidential

Technical Lead/Architect/DBA

Responsibilities:

• Technical lead for the TED V4/Failover/COOP project for the Confidential .
• Responsible for all aspects of the project architecture, execution and implementation.
• The infrastructure is based on Confidential P5 AIX servers, DB2 V8/9, Oracle 9i, Informatica, COGNOS, Business Objects and Websphere.
• Provided planning, engineering and technical guidance to teams of database, systems and software engineers for each phase of the project.
• This project provided an enhanced version of TED that increased performance by over 50%, as well as creating a local failover for the primary production TED and PCDW servers.

Confidential

Data Base Architect/Engineer

Responsibilities:

• Provide broad spectrum of consulting services focused on database design, performance, operations and maintenance.
• These services were in support of multiple DBMS products that include DB2 V8, ORACLE 9i and 10g and SYBASE10.
• This system took advantage of HACMP in a symmetrical massively parallel processing configuration.
• Lead automation effort that resulted in a 50% decrease in the number of DBA required to support over 100 Oracle instances and 20 DB2 databases.
• Automation project required the architecting and standardizing of processes and scripts to achieve the successful implementation.
• I was the primary architect and lead script developer for this project.
• Oracle 9i and 10g and DB2 V8 were the primary versions supported.
• Responsibilities include: database logical and physical design reviews, performance tuning, performance monitoring, backup recovery processes (using SqlBacktrack and RMAN), applications technical support, supervision of other skilled DBA’s, evaluation and selection of third party COTS software support tools, integration analysis and environment migrations.
• Provided lead Database Architecture support for the Confidential proposal team.

Confidential

Senior DBA/Analyst

Responsibilities:

• Provided database administration and analysis for the Confidential modernization project.
• Oracle and DB2 analysis, logical and physical design of database and schema. Programming and script writing as required.
• Responsible for all database administration related activities for the SQL/DS, DB2 and Oracle (V7) environments utilized by the Confidential project.
• Responsibilities include: application design reviews, performance tuning, performance monitoring, backup recovery processes, applications technical support and environment migrations.

Confidential

DBA, Data Architect

Responsibilities:

• Logical and physical design responsibilities included analyzing a normalized logical model and process descriptions, then determining where the logical model required changes and what indexes were needed to meet user's operational requirements for performance.
• Mobil utilized the Texas Instruments IEF Toolset for the creation and maintenance of their logical models.
• Provided DBA support for existing IMS and DB2 production applications and development of new applications.
• Responsibilities included: availability, performance, capacity planning, recovery planning and physical table design.