Reginald W. Bailey

Sr. Database and Systems Consultant

E-mail: ad3ydy@r.postjobfree.com

Mobile no: 281-***-****

LinkedIn: www.linkedin.com/in/friendlyneighborhooddba/

Skills and Competencies

Experienced in Database and Systems Design, Creation, Administration/Management and Technology; systems analysis, software development, Agile methodology, software development life cycle, custom PL/SQL development, ETL processes and transformations; shell scripting (Power Shell, C, Bash, Bourne and Korn); ITIL, performance tuning, troubleshooting, root cause analysis, etc.

Technical

Summary

Hardware: IBM: PC and Compatibles, PS/2, Series 1, 30XX, 43XX, 9370, RS/6000; DEC: VAX 11/780, 6310, 3600, 3200, 5000, 8250, 4000, 600, VLC,MicroVAX, VAXstation, DECstation; Apollo Workstations, Compaq, Sun/Sparc Workstations and Servers, Burcon, Sytek LAN/PCU, MODCOMP, Apple Macintosh, SynOptics Lattisnet, Modems, Routers, Tranceivers, Concentrators, Intermec 944X Barcode Reader, Scanners

Operating Systems: VM, VMWare, UNIX, Xenix (System V), SUN OS, Solaris, Ultrix, AIX,Linux, VAX/VMS, OS/2, MS-DOS, Domain/Ix, Aegis, TOS, DOS/VSE, Vollie, VSAM, MVS, System 6; MS Windows (XP, Server, 7, 10)

Networks: Nestar LAN, LAN Manager (3COM & Microsoft), Sytek LAN/PCU,Token Ring, TCP/IP, Internet, NCP, NCS, Multinet, FTP, SFTP, LDAP, Active Directory

Protocols: NFS Server and Client, Excelan, Exos, Telnet, SL/IP, SNMP, UUCP, SMTP, Novell Netware, SQL*NET, DECnet, Vaxcluster, Ethernet, 10base-T, FDDI, VLM, SPX, PPP, SFTP, FTP

Languages: Ansi SQL, PL/SQL, Transact-SQL, Embedded SQL, Java, REXX, C, C++, CSP, Pascal, Cobol, PL/1, ALC, EXEC 2, CMS EXEC, FORTRAN, PDL, (VAX/VMS) DCL, Shell Programming (C, Bourne, Korn, Aegis, Bash), IRL, Basic, MS Visual Basic, MS Visual C++, WinBatch, Windows Interface Language (WIL), PERL, XML, MS PowerShell, Python

Databases: [SQL RDBMS] IBM SQL/DS & DB2, Oracle 19c,18c, 12c; Oracle 11g, 10g; Oracle 9i, 8i; Oracle7 Server; Informix, Ingres, Integra, R:Base, (OS/2) Data Manager, ANSI SQL, Sybase SQL Server, Sybase SQL Anywhere, Progress, (Gupta) SQLBase, Microsoft SQL Server, MySQL, ODBC, Rdb/VAX, [RDBMS] Microsoft Access, Lotus Approach, System 2000, C-Tree (Isam), RMS, Access, Informatica, Primavera, PostGresSQL

System Software:: SAS, QMF, Oracle Financials, Oracle9iAS & Oracle Application Server, Oracle Designer, Oracle Tools, Oracle Forms(SQL*FORMS), Oracle Portal, Oracle WebLogic, WebDB, Oracle Reports (SQL*Reportwriter), Oracle JDeveloper, Oracle Developer, Oracle SQL Developer, VMWare, Tivoli Storage Manager, ADSM, EASY*SQL, SQL*QMX, PRO*C, Powerbuilder, S-Designor, Erwin, Oracle Enterprise Manager, Oracle RAC, Oracle DataGuard, Server Manager, Scopus, CSP/AD, Xedit, Kedit, SQL*Loader, SQL*NET, Personal Rexx, Rexx For Windows, Vedit, RXSQL, Dirmaint, Brief, Script/VS, YALE, IIS, RACF, ACF2, JCL, ISPF, FSP, Telegraf, Phoenix, DCF, SMART, RSCS, VM BATCH, Quickgraf, R-Tree, Turbo: Pascal, Assembler & Debugger; Quattro Pro, Microsoft: Microsoft C, Pacioli 2000, Juris, Term, SQR, SQR for Windows, WinEDIT, IBM WebSphere, CommVault, etc.

Storage/File Systems: NAS (Exadata, NetApp OnTAP), Oracle Cloud

(OCI); JFS, ZFS, AWS (S3, etc.)

Other: ITIL, Agile

Education

United States Military Academy at West Point, West Point, New York

1978 - 1980 Major - Engineering

1982 - 1988 University of Houston - Major - Computer Science

2001-2003 University of Phoenix - Major – Information Technology

Houston Community College

2003 - 2010 Major – Information Technology

Training / Certifications / Achievements

Wipro Technologies: ITIL, Python, Agile Methodology, AWS Practitioner training, AWS Architect training, etc.;

IBM Global Services: Oracle Performance Tuning;

Oracle Corp. and JP Morgan Chase: Training in Oracle Enterprise Manager, Oracle8i, Oracle9i, PL/SQL, Replication, Java Development for Oracle, Oracle10g;

Analysts International Corp.: IBM sponsored classes on CSP, QMF, SQL/DS, PDL, DDT and database design and performance;

Shell Development Co.: Training and classes in Telegraf, SAS, SQL/DS, EXEC 2,PROFS, Oil and Gas Exploration and Production, geology and various software packages

AWS Certified Practitioner

AWS Partner: Accreditation (Technical)

AWS Partner: Cloud Economics Accreditation

Career History

Jun 2023 - Oct 2023 Independent IT Consultant

Various short term and freelance IT tasks with small businesses and individuals: assessments, custom development (Python, REXX, Power Shell, shell scripting), ETL tasks, integration, consulting, troubleshooting office PCs, MS Access Database issues, network bandwidth problems, virus infections, custom PC builds, hardware problems, etc.

Environment: Windows Server, MS Access, Oracle 19c, Red Had Linux, Oracle Linux

Aug 2022 – May 2023 NES Fircroft at Woodside Energy (formerly BHP Petroleum Services)

Sr. Business Systems and Database Consultant

Participated in migration and support of effected systems that were to be migrated to new company

as part of the divesture.

Developed Automation via scripted programs to manage and the maintenance of data partitions for

RMAN backups, verification of SMTP setup of host servers, etc.

Managed Change Management submissions and documentation for the DBA team;

BAU creation, refresh and administration of production and non-production databases and related

PL/SQL packages, etc.

Creation and update of documentation for database procedures, protocols, runbooks, etc.

Creation and Update of CMDB designated databases and servers.

Administration, configuration of OEM and extend monitoring capabilities.

Preparation to migrate on premise database systems to AWS cloud.

Documented and participated in Disaster Recovery planning and drills.

Performance tuning and troubleshooting of databases

Security vulnerability assessments and remediation of databases and host servers.

Environment: Oracle OEM 13c, Oracle 12c, 18c, 19c, ASM, Data Guard, Red Hat Linux 7, Windows 10/11,

Windows Server, SQL Server 2016, SQL Developer, Oracle WebLogic,

Oracle Middleware Fusion, VMWare, ServiceNow, XML.

Sep 2021- Jul 2022 Wipro Technologies/Limited

Sr. Database and Systems Consultant

Remote support of new project involving major utility provider upgrading the

Power grid with implementation of ITRON smart meters into a HA & DR

environment using Oracle technology: DBMS 19c, RAC, DataGuard, OCI, Exadata.

Participate in planning of HA & DR protocols, procedures and safeguards.

Review of project documentation including design and implementation.

Inspection of databases and servers for possible performance and configuration issues.

Automate as much functionality as possible via OEM, shell scripts, etc.

Environment : Oracle 19c, Oracle OEM 13c, Oracle DataGuard, Oracle Exadata (X8M-2), Oracle RAC,

Oracle Enterprise Linux, Oracle OCI (Oracle Cloud), Windows Server, VM Ware, CommVault

Feb 2017- Aug 2021 Wipro Technologies/Limited

Lead/Sr. Database Administrator and Lead/Sr. Solaris/Linux System Administrator

Remote Support of Alyeska Pipeline Services Company IT environment. Oracle Enterprise Manager (OEM) SME (Subject Matter Expert), Oracle E-Business Suite (EBS) Application/Database Support (refreshes, cloning, etc.); Support of Primavera, Informatica and Oracle Business Objects databases; Oracle 19c,18c & 12c, Oracle 11g- 9i database support; support and creation of Oracle Solaris and Oracle Enterprise Linux (OEL) servers including patching, updates,etc.; Provided ancillary support of SQL Server

Unix Shell scripting (Korn, C, Bourne, Bash) for maintenance, initialization, automation and problem resolution.

Performed database refreshes and Disaster Recovery/Business Continuity drills and documented the results for improvements.

Performed performance tuning, trouble shooting and problem resolution across production and non-production environments.

Automation improvements for daily tasks and routine events.

Server maintenance and updates

Logical server domain (LDOM) and Linux virtual server creation, maintenance, decommissioning, etc in VMWare and Solaris.

Conducted Structured Root Cause Analysis for various problems

Integrate/collaborate with application development and support teams on various IT projects

Contributed to the improvement of Standard Procedures and Documentation

Provided Production, Test and Development database and server support

Provided input on Oracle database architectures and strategies to meet application availability, scalability and performance requirements for various projects.

Worked on Change Tasks and Incidents to fix or enhance various applications using Oracle Databases, Oracle Solaris or Oracle Linux.

Server administration duties including user maintenance, performance tuning, security issues, etc.

Database performance tuning, trouble shooting and problem resolution across production and non-production environments

Development of ETL program to transfer financial data to vendor for NACHA processing

Development of ETL programs for data extraction and transfer of client’s data to new vendor applications and servers (PL/SQL, shell scripting)

Participated in the planning and migration of EBS applications to Oracle Cloud

Creation and configuration of data warehouse servers for Informatica project using VMWare.

Resolve security vulnerabilities for Solaris, Linux servers and Apache and

WebLogic application/web servers

Environment : Oracle 19c, Oracle 18c, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle OEM 13c,

Oracle OPS Center 12c, Oracle Solaris 8/10 and 11; Oracle Enterprise Linux 6 and 7;

MS Windows 7/10, MS SQL Server 2012, Oracle E-Business Suite R12c, Oracle Net,

ServiceNow, SharePoint, Quest Toad, Oracle SQL Developer, PL/SQL Developer,

MS Power Shell, Perl 5, Python, MS Windows Server 2012, Citrix, Oracle Middleware,

Oracle Primavera, Oracle OCI (Oracle Cloud), Oracle Business Objects, Oracle Informatica, VM Ware, VM Center, Oracle WebLogic, NetApp ONTAP, CommVault, ITIL

Dec 2016- Jan 2017 iSphere at Thorne Specialty Services

Software and Database Consultant

Modify Turnkey sales and manufacturing software and provide documentation of same.

Environment: MS Windows 10, MS SQL Server 2012, MS Access 2012, MS VBScript,

MS Visual Basic, MS Power Shell

Apr 2016 – Nov2016 Independent IT Consultant

Various short term and freelance IT tasks with small businesses and individuals: integration, consulting, troubleshooting office PCs, MS Access Database issues, network bandwidth problems, virus infections, custom PC builds, hardware problems, custom shell scripting, etc.

Aug 2015 – Feb 2016 CSI America & Wipro Technologies at Halliburton Energy Services

Sr. Oracle Consultant and Systems Engineer

Lead Oracle DBA and Linux System Administrator for Infrastructure Team on Halliburton Divestiture project

Provided database and Linux support for multiple teams and applications

Performed performance tuning, trouble shooting and problem resolution across production and non-production environments.

Responsible for developing and documenting standardization policies and procedures to insure proper set up, deployment and validation of servers and databases according to Best Practices and DB Standards as per industry standards.

Installation of Oracle: Enterprise Manager, Web Logic, Apache Webserver, Middleware Fusion; Linux Gnome Desktop and other software.

Offshore Coordination with DBA support team and various offshore resources.

Performed database refreshes and Disaster Recovery/Business Continuity drills and documented the results for improvements.

Development of PL/SQL procedures, etc. to extract needed divesture information from data warehouse repository

Responsible for creation and maintenance of various database and OS scheduled jobs for data migration (ETL), updates, data refreshes, etc.

Performed various Linux System Administration tasks such as adding and modifying users, adding devices, adding storage and filesystems, etc.

Unix Shell scripting (Korn, C, Bourne, Bash) for automation, maintenance, initialization and problem resolution.

Environment: Oracle OEM 11g, Oracle 11g, ASM, Data Guard, Red Hat Linux 6, Windows 7,

Windows Server, SQL Server 2012, SQL Developer, Toad for Oracle, Oracle WebLogic,

Oracle Middleware Fusion, Oracle OCI (Oracle Cloud), ServiceNow, XML.

Feb 2015- Aug 2015 Independent IT Consultant

Various short term IT tasks with small businesses: integration, consulting, troubleshooting office PCs, MS Access Database issues, network bandwidth problems, virus infections, custom PC builds, etc.

Jul 2013-Dec 2014 Software Guidance and Assistance at JP MORGAN Chase

SR. DATABASE CONSULTANT/DBA

Subject Matter Expert (SME) on Oracle Enterprise Manager 10g, 11g, 12c configuration, installation, Agent installs, monitoring, etc.

Supported various environments as part of GSO Database Services which entailed break-fix containment for Production, QA/UT, SIT and Development environments.

Performed performance tuning, trouble shooting and problem resolution as part of regular BAU (Business As Usual) activities.

Administration tools like Enterprise Manager/Grid Control, Genesys, etc..

Set up and administration of Oracle Data Guard.

Install, configure, upgrade & patch Oracle RAC and non-RAC databases, listeners and software. Create and configure instances.

Backup and recovery, configuration and maintenance using RMAN.

Database and Application SQL Performance Tuning;

PL/SQL, Stored Procedures, Triggers, Packages expertise

Database design and logical modeling knowledge

Knowledge of database creation, log segments, disk initialization, disk mirroring, taking backups of databases and restoration in case of failure.

Unix scripting (Shell (Korn, C, Bash), Perl, etc.) for maintenance, initialization and problem resolution.

ETL solutions involving Unix scripting and REXX on mainframe

Monitor databases using provided monitoring tools.

Developed and enforced database standards with development and project teams.

Database Auditing – provided comprehensive reporting and accountability to management.

Setup and configuration of Oracle Fusion middleware components to support OEM: WebLogic, OID, Name Server, OMS, SOA suite/ Oracle BPM Suite

Strong interpersonal and communication skills and worked in a team as well as independent problem-solving & self-directed.

Responded and Resolved Help Desk and Incident database support tickets.

Provided Onsite and Offsite (On Call) support 24x7 in a group rotation.

Work issues with Vendor support, provide root cause analysis & incident reports.

Participated in weekend Project / Business as usual (BAU) / Adhoc tasks.

Environment: Oracle OEM 11g, ASM, Golden Gate, Data Guard, RAC, RMAN, TSM, ServiceNow, XML,

Genisys, Oracle Solaris, Oracle Enterprise Linux, AIX, Oracle WebLogic, Windows,

VMWare, IBM Mainframe, REXX, Veritas - Volume Manager, Veritas Cluster,

Veritas FS, ExaData, NAS and SAN storage environment.

Feb 2010 – Mar 2013 NRG Energy (Reliant)

SR. DATABASE ANALYST/ADMINISTRATOR

Performed database Backup and Recovery in support of business continuity using RMAN and other means for backup and recovery of databases; remediated older databases to comply with corporate standards.

Performed performance tuning, trouble shooting and problem resolution as part of regular BAU (Business As Usual) activities.

Supported high availability database infrastructure including Oracle RAC and Data Guard technology.

Subject Matter Expert (SME) and Lead DBA on Oracle Enterprise Manager 10g, 11g, 12c configuration, installation, Agent installs, monitoring, etc.

Handled production and non-production installation, upgrading, patching, maintenance and support activity of Oracle 10g and 11g databases.

Administration, maintenance and installation of OID (part of Oracle Fusion) for enterprise wide name resolution.

Setup and configuration of Oracle Fusion middleware components to support OEM: WebLogic, OID, Name Server, OMS, SOA suite/ Oracle BPM Suite

Participated in successful efforts to set enterprise wide standards for database design, deployment, backups and security and enforcement of Best Practices and DB Standards as per industry standards.

Lead DBA / Subject Matter Expert (SME) on Oracle database auditing and compliance enterprise wide. Managed the Oracle database compliance for quarterly QAR as part of Compliance and Governance processing. This included development using PL/SQL, Oracle APEX, SQL*Plus and shell and batch scripts.

Provided problem resolution, installation and integration between MS SQL Server, MS Access and Oracle databases for client’s legacy data.

Supported client base that included developers, business users, etc. Supported users in EDI, PCI, Web development and applications, MMAS, SMART Systems, etc. Gained understanding of basic operations of client business areas, and basic applications.

Initiated and authored several policies and informational documents that became part of the Standard Operating Procedure (S.O.P.) for the DBA team. Generally documented procedures or processes that are done on a regular basis to share the knowledge with my team mates.

Maintained good rapport with users and developers especially when discerning the nature of their problem or request from vague descriptions and their point of view. Often I was able to diffuse a situation before it became an “official” problem or request.

Worked closely with all functional and development groups to assure a smooth implementation and to ensure compliance with all corporate adopted system standards, policies and directions.

Applied creative solutions to some problems and situations (thinking outside the box) that were resolved successfully.

Implemented standard configurations and tools to enable back up operations, analyzing of objects, and cleaning of file systems and logs using PL/SQL, shell scripts, etc.

Participated in regular 24/7 On Call support duty rotation for production databases and after hours support.

Continually evaluated the merits/ benefits of available system upgrades and enhancements.

Participated in the design, testing, and implementing specific database structural changes across all environments.

Excel at researching solutions to questions, problems, and inexplicable errors.

Environment: Production, development, certification and user acceptance support environments: Oracle10g/11g RAC, Oracle 10g/11g/12c Enterprise Edition, Oracle9i, Oracle Developer, PL/SQL, Oracle JDeveloper; Oracle Enterprise Manager 11g/12c: Oracle Grid Control, Oracle Cloud Control and Administration; TOAD, SQL Developer, SQL Loader, JDBC, Java, Oracle RMAN,

Oracle WebLogic, ODBC, AIX, Solaris, Linux, Windows, Korn shell, Bash shell, MS SQL Server, MS Access, EXADATA, ServiceNow, XML, Erwin, Geoserver.

Oct 2009-Jan 2010 Client: AMPCO

SR. ORACLE DBA/CONSULTANT

Planned, coordinated and implemented security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.

Implemented backup and recovery strategies and disaster recovery strategies utilizing backup scripts and RMAN.

Tested programs and databases, corrected errors and made necessary modifications.

Modified existing databases and database management systems or directed programmers and analysts to make changes.

Implemented changes to bring databases into audit compliance and company and best practices standards.

Upgraded and migrated databases from Oracle 9i to 10g.

Production, Test and Development environment: Oracle9i, Oracle 10g, Oracle Enterprise Management, PL/SQL, MS Windows Server.

Apr 2009- Oct 2009 Client: Jack Henry & Associates

. SR. ORACLE DBA/CONSULTANT

Performed installations, upgrades and configurations of Oracle database software, databases, Oracle Enterprise Manager (OEM) Grid Control, etc.

Tested programs and databases, corrected errors and made necessary modifications.

Modified existing databases and database management systems or directed programmers and analysts to make changes.

Planned, coordinated and implemented security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.

Implemented backup and recovery strategies and disaster recovery strategies utilizing backup scripts, RMAN, Tivoli, standby databases and servers, etc.

Supported high availability database infrastructure including Oracle Data Guard technology.

Worked with vendor and client staff to improve performance of database and vendor’s turnkey application.

Setup and configuration of Oracle Fusion middleware components to support OEM: WebLogic, OID, Name Server, OMS, SOA suite/ Oracle BPM Suite

Managed database performance and capacity, provided plans for increases and/or decreases, ensures improvements were successfully implemented and made tuning adjustments as necessary.

Initiated scripted maintenance procedures utilizing PL/SQL, SQL*Plus, Node.js and shell scripting.

Created and implemented the design and enforcement of Best Practices and DB Standards as per industry standards.

Production, User Acceptance and DR environments: MS Windows Server, AIX, Oracle 10g, Oracle Enterprise Manager, PL/SQL, XML, Oracle DataGuard and Standby Databases.

Dec 1998- Aug 2008 JP Morgan Chase & Co.

SR. DATABASE ADMINISTRATOR/ANALYST (01/2005 – 08/2008)

Insourced back from IBM to JP Morgan Chase on 1 JAN 2005.

Database support for Treasury and Security Services Line of Business.

Duties similar to before, including setting up server and database monitoring and participating in remediation of existing servers and databases; worked with Oracle 10g RAC, VCS clusters and standby databases. Implemented RMAN backups.

Handled team administrative duties for obtaining userids for new DBAs, access to servers, etc.

Participated in the design, testing, and implementing specific database structural changes across all environments.

Led team efforts for ESM (Enterprise Security Management) audit and remediation setup and reporting.

Participated in successful efforts to set enterprise wide standards for database design, deployment, backups, security and enforcement of Best Practices and DB Standards as per industry standards.

Lead DBA for implementing and configuring databases on standardized CUE (Common Utility Environment) platforms for data center.

Set up standby databases for Disaster Recovery requirements for business continuity; participated in regular disaster recovery exercises.

Setup backup and recovery of databases utilizing RMAN and other methods; remediated older databases to comply with corporate standards.

Performed performance tuning, trouble shooting and problem resolution as part of regular BAU.

Performed basic installations on 11g database: Setting Up, Configuring Grid Control.

Setup and configuration of Oracle Fusion middleware components to support Oracle Enterprise Manager (OEM): WebLogic, OID, Name Server, OMS, SOA suite/ Oracle BPM Suite

Maintenance and performance tuning using tools (OEM, Toad, Oracle Developer) as well as scripted methods (PL/SQL, shell scripts, SQL*Plus)

Installation and configuration of Postgres database for pilot application

ETL and maintenance of IBM Mainframe legacy environment

Installation, maintenance and troubleshooting for MS SQL Server databases that interfaced with Oracle clients or servers.

Production, development, certification and support environment: Oracle10g RAC, Oracle9i,Oracle8i, Oracle7, Oracle9iAS, Oracle Designer, Oracle EBS, Oracle Jdeveloper, Oracle Enterprise Manager, Oracle Grid Control, JDBC, Java, Websphere, ODBC, AIX, Solaris, Korn shell, REXX, XML, MS SQL Server, Oracle WebLogic, Tivoli Storage Manager (TSM), EXADATA, VMWare, SDLC, Postgres., Node.js, REXX

IBM Global Services - JPMC (04/2003 - 12/2004)

SR. ORACLE DBA/ANALYST

Technology division of JP Morgan Chase outsourced to IBM. Same duties as before with JP Morgan Chase.

JP Morgan Chase & Co.

VP/SR. ORACLE DBA/ANALYST (12/1998 – 03/2003)

Database Administrator for production, certification and development databases; duties included monitoring, backup and recovery, performance tuning, trouble shooting, database design and implementation, Oracle product installation, user and developer support, connectivity resolution, Oracle upgrades, patching, and configuration.

Development and Application support for OLTP, web based, OLAP applications including stock brokerage management systems, loan reporting systems, check imaging and archiving, lockbox operations, fraud management, Seibel, international check collections, escheats, mortgage analysis, investment

management, dashboard applications, CRM applications, Websphere, Vignette Server, Pega Systems.

Developed enterprise wide database security architecture consisting of modules and protocols to enforce IT standards for password management, role-based security and privileges, programmatic access (via PL/SQL packages, functions and procedures) to database meta data via common API.

Helped maintain and implement Oracle Names Server (LDAP) for Oracle database naming resolution and database connectivity trouble shooting.

One of the principal authors of many utility SQL and shell programs for use by DBA staff; principal author of majority of Treasury ISS department documentation.

Installation, configuration and management of system based monitoring tools: Oracle Enterprise Manager (OEM), Tivoli Storage Manager (TSM), various Quest products ( I-Watch, Navigator, etc.) and application and web servers: WebSphere, Oracle9iAS, Story Server, Vignette, Netscape Server, iPlanet and database software.

Installation and configuration of Sybase database

Data modeling and design of databases using Erwin and Oracle Designer; databases included OLTP and data warehouses.

ETL and maintenance of IBM Mainframe legacy environment

Production, development, certification and support environment: Oracle9i,Oracle8i, Oracle7, Oracle9iAS, Oracle10g, Oracle Designer, Oracle JDeveloper, Oracle Enterprise Manager, JDBC, Java, SDLC, WebSphere, ODBC, AIX, Solaris, Korn shell, REXX, MS SQL Server, Sybase Server and Sybase Watcom, XML, EXADATA, Erwin.

Sep 1998 – Oct 1998 Renaissance World Wide at Cable & Wireless Omnes

SR. DATABASE CONSULTANT

Analysis, design and implementation of a distributed database for a network service provider to improve global network management and reporting.

Analysis, requirements gathering, data modeling, database design and implementation.

Development and support environment: Client/Server architecture; Oracle8 (Parallel, Distributed And Enterprise Edition) Server Rdbms, Oracle Tools, Oracle Enterprise Manager, SQL*Loader, SQL*Plus, PL/SQL, Server Manager, Oracle OCI, Pro*C, Developer 2000, Discoverer 2000, Designer 2000, Erwin Erx, Net 8 (SQL*Net), Windows 95/NT, Solaris 2.6

Sep 1994 – Aug 1998 Netcom Interim Staffing at Andersen Consulting & Landmark Graphics Corp.

DATABASE CONSULTANT and DEVELOPER

Design and Development of a high capacity ETL data loader for loading, validating and inserting oil and gas related historic and production data into existing OpenWorks database.

Data loader used meta data of source and target databases to convert and translate incoming data to format of target database.

Extensive and innovative development of server side stored programs (triggers, procedures, functions and packages), SQL*Loader and SQL*Plus with Shell programs, database analysis and design of meta data database.

Database administration and system administration (NT, AIX, Solaris), network and system troubleshooting, database configuration, performance monitoring and tuning.

Participated in development of a Windows client/server suite of commercial products for oil and gas industry to manage production accounting, gathering systems, etc.

Analysis and redesign of database, database analyst and administration (DBA).

Development of stored procedures, functions and triggers for database back-end functions for applications, development of application server, database maintenance and referential integrity; system (NT, AIX, Solaris) and network administration, network and system trouble-shooting, database performance monitoring and tuning, integration of various vendor’s database architectures, technical and customer support and training.

Development of migration utility and procedures between different versions of Oracle based turnkey product database.

Development of conversion/migration utility to move data between Oracle, SQL Server and Sybase databases as back end as an option for customers.

Development of interface to import and export data from clients’s Oracle database to industry standard GEOSHARE formatted data stream and allow insertion and updating and extraction of data to an OpenWorks Oracle-based database. Utilized Pro*C, OCI and dynamic SQL for maximum flexibility.

Installation, configuration, training of support staff and clients on SQL Server, Windows NT Server/Workstation, Windows 95, Oracle Server and Client tools, AIX, OS/2, TCP/IP, SQL*Net, SunOS, Solaris 2.51, Sybase SQL Anywhere and SQL Server, Sybase SQL (Watcom).

Created technical and user documentation, including manuals, help files and HTML documents.

Development and support environment: Client/Server architecture; Oracle7 (Parallel, Distributed And Universal) Server, Oracle Tools, Oracle Power Browser, Oracle Enterprise Manager, Oracle Book, SQL*Dba, SQL*Loader, SQL*Plus, PL/SQL, Server Manager, Oracle OCI, Pro*C, Developer 2000, Discoverer 2000, Designer 2000, Erwin Erx, SQL*Net, MS SQL Server, Transact-SQL, Bcp, ISQL, Sybase SQL Anywhere, Sybase SQL, SQL Navigator, ODBC, MS Access, VBA, MS Windows.

For Workgroups, Windows 95/NT, Novell Netware, Shell Programming (Korn, Bourne, C), TCP/IP, AIX, SCO Unix

Contact this candidate