Glenn Johnson Email & Phone Number

Morrisville, North Carolina, United States

Lead Oracle DBA for Reged; Supporting Linux x86-64 Oracle 12c Database Appliance and legacy Windows 10g environments. Migrated legacy Oracle 10g environments on Windows to 12c Oracle Database Appliance non-prod and production environments. Non-prod X6-2M appliance. X6-2HA production appliance 2-node RAC ACFS/ASM. Patching Appliances, Support application development team: database refreshes, data scrubbing and data masking plsql, run code deployments, queries, update security-governed tables, resize and convert production data to non-production dev, qa, staging, and uat environments. Configure TDE and HSM. Configure RMAN backups with EMC media manager. Perform rman cloning of production database for testing, DR, and refresh of non-prod environment. Reorg production data for space saving including scripting of objects governed by data retention policy. Full time tellecommuting / work from home / remote.

Warrendale, Pa

Task and project work for multiple corporate clients.Variety of environments.

Cary, Nc

-employee status-Tier 2 problem management

Database Administration & Architecture - Lead DBA

Application DBA responsible for design and database implementation of the new High Availability FLPS application system (OLTP - automated fiber geo location ticket processing). Performing all database support functions of the application's system life cycle. Design, incorporate, and implement hardware configuration, Oracle Data Guard w/ remote primary/standby database configuration, RMAN, data mart report server, archive repository. Tune application's sql, pl/sql, and instance. Leverage/utilize 9.2 rdbms server memory and storage features for maximum performance (local extent mgmt, undo, auto space segment mgmt, multiple buffer pools, multiple blocksizes, statspack monitoring). Partition maintenance. Migrating customer data between Oracle and MS Acess databases. Installing and upgrading Oracle 9.2 software on database servers.

Discovery IT & Oracle Application Group. Oracle Database Administrator; Application DBA responsible for the support of all application groups within Discovery IT at RTP. In addition, working as U.S. team member of DBA applications group responsible for Oracle database design, coding, administration, database network administration, and all Oracle database support issues.

DBSS Oracle Database Support Systems. Oracle Database Administrator; Systems/Production support DBA assigned to USPS Command Center responsible for system and database support and sundry small-project assignments. Perform production support DBA duties on Postal Unix and NT databases.

Systems DBA responsible for shared administration of ~15 db servers, 60 Oracle development, test, validation and production databases supporting systems on SUN Solaris and VMS platforms. Responsibilities including Backup and Recovery procedures, server and database creation, tuning, replication, database maintenance, customer troubleshooting and support, database + schema migrations, sundry database maintenance, and procedural + company validation documentation.

Procedure Development Information System Technology, Oracle Development + Production Database Administrator; Lead Oracle DBA responsible for administration of 7 Oracle instances, comprising 11 databases supporting 5 systems on HP, NT, + SUN platforms. Created backup/recovery procedures, database support for "Vantive" system, upgrading Oracle RDBMS and preparing new + existing servers for database configuration - teaming with Unix system admins, documented database profile/standards, writing plsql procedures for sundry DB applications (e.g.: data purge), migrating "tracker" system from 7.1.6/Sparcstation to 8.0.5/Ultra, developed system architecture and database prototype on Oracle 8.05 utilizing partitions for secure ID system, providing database support for staff developers, monitoring and taking remedial steps for optimal production DB performance, and investigation/implementation of Y2K compliance procedures. Created Data Warehouse prototype for manufacturing Key-ID Security and Registration system. Performing as backup DBA to SQL Server DBA.

E.D.S, Oracle Development/Test Application Database Administrator; Maintain and administer database objects and web server on web-based user ID request system. Writing PL/SQL procedures and supporting development/test staff. Windows NT/Oracle Web Server platform. Wrote PL/SQL procedures to incorporate legacy application users into E1357, perform local data refreshes from remote databases, and SQLLOAD jobs for scheduled data replacement.

Support 24 X 7 Zenith Service Order transaction system. Maintain Oracle databases on 19 UNIX servers and 3 regions. Perform new system release modifications, add/build new databases, monitor performance, maintain export/imports, upgraded Oracle versions: 7.0.1 => 7.3.3 and 7.3.3 => 7.3.4, manage space, perform adhoc SQL for users, program PL/SQL scripts, and review production process logs.

Supported COPA, an on-line Sales + Commissioning system which received the '1994 Malcolm Baldridge National Quality Award'. Designed and implemented Cobol II/DB2/CICS modules utilized in all phases of the system life cycle. Participated in logical and physical system design, provided day/eve production support, performed system change requests, managed floppy disk generation subsystem, and project managed group's conversion to PC development platform(Microfocus Workbench + XDB

Supported MARC, a marketing analysis database system utilizing COBOL2/DB2. Participated in physical database design, coding, testing, and implementing new system software during design and development phase.

Performed system support duties for a residentialtelephone billing system. Responsible for table and file maintenance, writing JCL and Procs, running production report jobs, Cobol program maintenance, writing SCRs from client to accommodate new user requests.

Supervised and performed geotechnical soils investigations for a foundation engineering firm.

Associates, Computer Science

Bachelors Of Science, Physical Science