Reginald W. Bailey
Sr. Database and Systems Consultant
********@*****.*** 281-***-**** www.linkedin.com/in/friendlyneighborhooddba/
Summary
Veteran and IT Professional 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. Proficient in an assortment of technologies including Oracle databases, DB2, Access, Sybase, MS SQL Server 2016, JDBC, Java, PL/SQL, data warehouses, software development and more.
Technical
Summary
Hardware: IBM: Series 1, 30XX, 43XX, 9370, RS/6000; DEC: VAX, VAX Cluster, VLC,MicroVAX, VAXstation, DECstation; Sun/Sparc Workstations and Servers, Modems, Routers, Barcode Scanners
Operating Systems: VM, VSAM, MVS, VMWare, UNIX, Xenix (System V), SUN OS, Solaris, Ultrix, AIX, Linux, VAX/VMS, OS/2, MS-DOS, MS Windows
Networks & Protocols: LAN/PCU, Token Ring, TCP/IP, Internet, NCP, NCS, Multinet, FTP, SFTP, LDAP, Active Directory, NFS, Samba, Telnet, SL/IP, SNMP, UUCP, SMTP
Languages: Ansi SQL, PL/SQL, Transact-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, PERL, XML, MS PowerShell, Python
Databases: [SQL RDBMS] IBM SQL/DS & DB2; Oracle: 21c,19c,18c, 12c, 11g, 10g, 9i, 8i, 7); Informix, Ingres, Integra, R:Base, (OS/2) Data Manager, Sybase SQL Server & SQL Anywhere; Progress, (Gupta) SQLBase, Microsoft SQL Server, MySQL, ODBC, Rdb/VAX, [RDBMS] Microsoft Access, RMS, Informatica, Primavera, PostGresSQL
System Software:: SAS, QMF, Erwin, RACF, ACF2, JCL, ISPF, IBM WebSphere,
Oracle:[Financials, Oracle9iAS, Application Server, Designer, Tools, Forms(SQL*FORMS), Portal, WebLogic, WebDB, Reports (SQL*Reportwriter), JDeveloper, Developer, SQL Developer, Enterprise Manager, RAC, SQL Loader, Data Guard, Pro*C]; VMWare, Tivoli Storage Manager, ADSM, EASY*SQL, SQL*QMX, Powerbuilder, S-Designor, Server Manager, Scopus, CSP/AD, Rexx For Windows, Vedit, RXSQL, Brief, Script/VS, YALE, IIS, FSP, Telegraf, Phoenix, DCF, SMART, RSCS, VM BATCH, Quickgraf, R-Tree, Assembler & Debugger; Juris, SQR, WinEDIT,, CommVault, etc.
Storage/File Systems: NAS (Exadata, NetApp OnTAP), Oracle Cloud Integration (OCI);
JFS, ZFS, AWS (S3, etc.)
Other: ITIL, Agile, Data Warehousing, Oracle Data Integrator (ODI)
Education
United States Military Academy West Point, New York Major - Engineering
University of Houston - Major - Computer Science
University of Phoenix - Major – Information Technology
Houston Community College 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: Oracle Enterprise Manager, Oracle Database, PL/SQL, Replication, Java Development for Oracle;
Analysts International Corp.: IBM sponsored classes on CSP, QMF, SQL/DS, PDL, DDT and database design and performance;
Shell Development Co.: Telegraf, SAS, SQL/DS, EXEC 2, PROFS, Oil and Gas Expl. & Prod., Geology, etc.
AWS Certified Practitioner
AWS Partner: Accreditation (Technical)
AWS Partner: Cloud Economics Accreditation
Career History
ABBTech IT Consultant and Support Specialist Feb 2024 - Mar 2024
Provided IT support for Fort Bend County election services for county wide voting during Texas Primaries
to various polling sites ensuring secure internet connections, vote count veracity, troubleshooting, etc.
Environment: ExpressVote Universal Voting System, DS200 scanners and tablets, kiosks, Windows
laptops, Wi-Fi hotspots, etc.
Independent IT Consultant Jun 2023 - Dec 2023
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
NES Fircroft Sr. Business Systems and Database Consultant Aug 2022 – May 2023
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, AWS, Azure,
Oracle Middleware Fusion, VMWare, ServiceNow, XML.
Wipro Technologies Sr. Database and Systems Consultant Sep 2021- Jul 2022
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, Perl, 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
Wipro Technologies Lead/Sr. DBA and Lead/Sr. Solaris/Linux System Administrator Feb 2017- Aug 2021
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
Troubleshooting and resolution of installation and configuration issues with web and application servers and Primavera utilizing Perl, shell scripting and other tools
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, Perl and shell scripting)
Participated in the planning and migration of EBS applications to Oracle Cloud via OCI Data Integration
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, AWS, Azure,
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
iSphere at Thorne Specialty Services Software and Database Consultant Dec 2016- Jan 2017
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
Independent IT Consultant Apr 2016 – Nov2016
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.
CSI America & Wipro Technologies Sr. Oracle Consultant and Systems Engineer Aug 2015 – Feb 2016
Served as Lead Oracle DBA and Linux System Administrator for Infrastructure Team on Halliburton Divestiture
project
Responsible for 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.
Managed installation and configuration of various software and servers, offshore coordination with DBA support team and other resources.
Responsible for database refreshes and Disaster Recovery/Business Continuity drills and documented the results for improvements.
Environment: Oracle OEM 11g, Oracle 11g, ASM, Data Guard, Red Hat Linux 6, Windows 7, OCI Data Migration,
Windows Server, SQL Server 2012, SQL Developer, Toad for Oracle, Oracle WebLogic,
Oracle Middleware Fusion, Oracle OCI (Oracle Cloud), ServiceNow, XML, Perl.
Independent IT Consultant Feb 2015- Aug 2015
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.
Software Guidance and Assistance SR. Database Consultant/DBA Jul 2013-Dec 2014
Delivered expertise as Subject Matter Expert (SME) on Oracle Enterprise Manager, Data Guard and other Oracle tools as part of critical supported environments for GSO Database Services.
Established performance tuning, trouble shooting and problem resolution as well as collaborated with the Cyber Security team to integrate and implement safeguards to improve data accessibility and hardening of security protocols.
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, Perl
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, Perl, Veritas - Volume Manager, Veritas Cluster,
Veritas FS, ExaData, NAS and SAN storage environment.
NRG Energy (Reliant) SR. DATABASE ANALYST/ADMINISTRATOR Feb 2010 – Mar 2013
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.
ETL and maintenance of IBM Mainframe legacy environment on DB2, z/OS and AIX
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, IBM z/OS, z/VM, AIX; Solaris, Linux, Windows, Korn shell, Bash shell, MS SQL Server, MS Access, EXADATA, ServiceNow, XML, Erwin, Geoserver.
Client: AMPCO SR. ORACLE DBA/CONSULTANT Oct 2009-Jan 2010
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.
Monitoring of Informix database and related applications
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, Informix RDBMS, MS Windows Server.
Client: Jack Henry & Associates SR. ORACLE DBA/CONSULTANT Apr 2009- Oct 2009
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.
JP Morgan Chase & Co. SR. DATABASE ADMINISTRATOR/ANALYST Dec 1998- Aug 2008
(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
Installation and configuration of DB2,Sybase and Informix databases
Maintenance, configuration and migration of VAX Rdb system
ETL and maintenance of IBM Mainframe legacy environment on z/OS and AIX
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, IBM DB2, z/VM, z/OS AIX, Solaris, Korn shell, REXX, XML, MS SQL Server, Oracle WebLogic, Tivoli Storage Manager (TSM), EXADATA, VMWare, SDLC, Postgres., Node.js, REXX, Sybase, Informix, VAX Rdb
IBM Global Services - JPMC SR. ORACLE DBA/ANALYST (04/2003 - 12/2004)
Technology division of JP Morgan Chase outsourced to IBM. Same duties as before with JP Morgan Chase.
Additional Production, development, certification and support environment: IBM DB2, z/VM, z/OS;Oracle9i,Oracle8i, Oracle7, Oracle9iAS, Oracle10g, Oracle Designer, Oracle JDeveloper, Oracle Enterprise Manager, JDBC
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 and Informix databases
Maintenance, configuration and migration of VAX Rdb system
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 on z/OS and AIX
Production, development, certification and support environment: Oracle9i,Oracle8i, Oracle7, Oracle9iAS, Oracle10g, Oracle Designer, Oracle JDeveloper, Oracle Enterprise Manager, JDBC, Java, SDLC, WebSphere, Informix RDBMS, ODBC,IBM z/OS, AIX, Solaris, Korn shell, REXX, MS SQL Server, Sybase Server and Sybase Watcom, Informix, VAX Rdb, XML, EXADATA, Erwin.
Renaissance World Wide at Cable & Wireless Omnes SR. DATABASE CONSULTANT Sep 1998 – Oct 1998
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
Netcom Interim Staffing DATABASE CONSULTANT and DEVELOPER Sep 1994 – Aug 1998
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, Sun OS, Solaris, OS/2, Rexx, Visual Basic, MS Office Suite, RS/6000, Sun Sparc, SGI Workstation, Cc:Mail, Lotus Notes,