Oracle Manager
Resume:
Glenn D. Johnson
Wake Forest, NC 27587
**********@*****.***
http://www.linkedin.com/in/glenndjohnsondba
SUMMARY: Database Administrator with senior level experience in Oracle and Sqlserver.
CERTIFICATIONS:
Oracle 11g Database Administration – OCP Oracle Certified Professional;
Oracle 10g Database Administration – OCP Oracle Certified Professional;
Oracle 9i Database Administration – OCP Oracle Certified Professional;
Oracle 8i Database Administration – OCP Oracle Certified Professional;
Oracle 7 Database Administration – Masters.
Microsoft Sql Server 2000 – Microsoft Certified
Microsoft Sql Server 2005 – Microsoft Certified
DATABASE:
. Oracle Enterprise RDBMS 7.* 8.* 8i Lite, 9.2, 10.2, 11gR2.
. 10g Cluster Ready Services, ASM, RAC.
. Oracle Applications ERP 11.5
. SQL, PL/SQL.
. Microsoft SQLServer 2000, 2005, Sqlserver Failover Cluster.
OS Environment:
. Linux: Suse SLES 9 & 10, Linux Red Hat RHEL3; bash
. Unix: SUN Solaris 2.9, HP-UX 10.20 11, NCR-Unix; ksh
. Windows: 2003, NT.
STORAGE Environment:
. Network Appliance Netapp SnapDrive, Snap Manager.
. Veritas Netbackup for Oracle.
. Clustering: CRS, ASM, OCFS2.
DATABASE TOOLS:
. Embarcadero DB Artisan, Performance Analyst.
. Quest Instance Monitor, Space Manager, SQLab.
. Oracle Enterprise Manager, SQLPLUS.
. Platinum Server Vision/DBVision, BMC Patrol, TOAD.
EXPERIENCE/ACCOMPLISHMENTS:
7/2004 – present; Contractor => Employee Sony Ericsson. Lead DBA and Database Architect.
> Managed all intranet + extranet domain Oracle and Sqlserver database instances for Sony Ericsson, North America. Provided Application database support to developers, application interface and project managers.
> Integrated and migrated database instances from Sun Solaris to Linux.
> Designed and built database backup/recovery process on Network Appliance architecture – SNAP technology.
> Install/upgrade/patch Oracle RDBMS from 9i to 10g to 11g. Upgraded Microsoft Sqlserver instances from 2000 to 2005.
> Migrated all production Oracle instances from standalone server to 10.2 Cold Failover with Oracle Clusterware CRS on OCFS2. Migrated all production Sqlserver instances from a 2000 standalone server to a 2005 Failover Cluster platform.
> Created Database Operations and Procedures Manual documentation.
> Built a working Demonstration project in staging – Oracle ERP Applications (financials, HR, Prod Mgmt). Two-node 11.5
> Built a working two-node Oracle 10g CRS ASM RAC environment in staging.
> Provided Performance Tuning and investigations on system and sql levels.
> Trained two junior database administrators.
10/2003 – 7/2004 Contractor on assignment at MCI-Worldcom. Oracle Database Administrator;
> Supported Production and Dev/Staging Oracle instances hosting the FLPS application, an OLTP automated fiber geo location ticket processing system. Provided DBA services and design to developers, production support and business.
> Provided sql and index performance tuning. Modified tablespaces and blocksizes for data and indexes. Created new buffer pool and new index blocksize.
> Designed roll-off partitions for historical data archiving.
> Migrated Oracle RDBMS from 8i to 9i.
> Built working High Availability Data Guard physical standby server configuration.
2/2003 – 10/2003 Contractor on assignment at Glaxo-Wellcome Smith-Kline. 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.
10/2002 – 2/2003 Contractor on assignment at United States Postal Service, Raleigh NC. DBSS Oracle Database Support Systems. Oracle Database Administrator; Systems/Production support DBA assigned to USPS Command Center. Performed system database support and sundry small-project assignments. Performed production support DBA duties on Postal Unix and NT databases.
6/2000 – 10/2002 Contractor on assignment at Glaxo-Wellcome Smith-Kline. U.S. Database Technologies – Research + Development, SCS Group Oracle Database Administrator; Systems DBA; Performed shared administration of approximately 15 db servers, 60 Oracle development, test, validation and production databases supporting systems on SUN Solaris and VMS platforms. Performed 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.
2/1999 – 6/2000 Contractor on assignment at Ericsson Inc. 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. Served as backup DBA to SQL Server DBA.
8/1998 – 2/1999 Contractor on assignment at United States Postal Service/E.D.S, Oracle Development/Test Application Database Administrator; Maintained and administered database objects and web server on web-based user ID request system. Wrote 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, performed local data refreshes from remote databases, and SQLLOAD jobs for scheduled data replacement.
12/1996 - 7/1998 AT&T (AT&T Solutions), Oracle Production Database Administrator; Support 24 X 7 Zenith Service Order transaction system. Maintained Oracle databases on 19 UNIX servers and 3 regions. Performed new system release modifications, add/build new databases, monitor performance, maintained export/imports, upgraded Oracle versions: 7.0.1 => 7.3.3 and 7.3.3 => 7.3.4, managed space, performed adhoc SQL for users, program PL/SQL scripts, and review production process logs.
12/1992 - 12/1996 AT&T (Consumer Communications Services), Applications Programmer/Analyst;
07/1990 - 12/1992 AT&T (Consumer Communications Services), Applications Programmer; 02/1989 - 10/1989 Electronic Data Systems, Applications Programmer;
12/1978 - 02/1989, 11/89 - 06/90 Melick-Tully & Associates, Field Engineer
EDUCATION:
Oracle Technical Education: ORACLE 7‘MASTERS’
> Database Administration
> Backup And Recovery
> Performance And Tuning
> PL/SQL
> Develop Applications Using Database Procedures
> Developing Databases And Complex Data Models
> Oracle Advanced PL/SQL
> Oracle 10gR2 RAC for Administrators
AT&T Corporate Technologies:
> Unix Shell Toolkit
> Unix For Programmers
Union College - Scotch Plains, NJ; Associates - Computer Science
Arizona State University – Tempe, AZ; Bachelors of Science - Physical Geography
Contact this candidate