Oracle DBA, UNIX Systems Admistrator and Network Admin
Resume:
D. Michael Green II (***********@*****.***)
PROFESSIONAL PROFILE
A detail oriented, experienced and personable database management professional with over 10 years experience with Oracle technologies including database design, configuration, security, optimization, data backup, disaster recovery planning and 10 years experience managing UNIX Systems with a broad knowledge of network administration.
SUMMARY OF EXPERIENCE
Oracle 8i, 9i, 10g and 11g (Design, Performance Tuning and Maintenance).
Oracle installations 8i, 9i, 10g and 11g.
Oracle migrations from 8i to 9i, 9i to 10g and 10g to 11g.
Oracle DataGuard (Automated fail over, data protection and cloning for develop/testing)
Oracle RMAN (backup/recovery/migrations)
Oracle ASM on 10g and 11g for large database instances.
Oracle RAC for clustering 10g and 11g database instances.
Data modeling; performing detail data analysis to develop the logical and physical models for dimensional (data warehouse) databases.
Database programming (PL/SQL, PHP & Perl), data integrity analysis and data migration.
Development of packages, functions, procedures, stored procedures, triggers, tables, tablespaces, indexes, customized views.
Customized report design and development.
Tape backup management via EMC Legato NetWorker and Solaris Solstice Disk Suite
Oracle SQL, Oracle PL/SQL, TOAD, PERL, Unix scripting, Visual Basic, ODBC, MS Access
UNIX Administration (Solaris, HP and RedHat) system administration, Samba, Apache
UNIX shell scripting for automation, reporting and performance monitoring.
Network Administration (Cisco & Extreme), VLANs, VPN. PROFESSIONAL EXPERIENCE
Freelance Web Design, E-commerce Installations, Database Implementations and Networking Support. 5/2012 - Current Self-employed
In May 2012, I relocated to West Virginia to serve as primary caregiver to my Mother having been diagnosed with lung cancer. I kept my work skills updated by doing independent freelance work for small businesses needing project based assistance.
Web site maintenance including design, updates, e-commerce solutions with integration with existing point-of-sale systems.
Database support including implementations, migrations, backup/recovery, tuning and data mining for report generation.
IT support including networking, data backups, disaster recovery planning and general PC support. Oracle Database Administrator / UNIX System Admin / Network Admin 5/2009 - 5/2012 Hitachi Communication Technologies America
Oracle Database Admin solely responsible for multiple Oracle 10g and 11g instances connected to a development project.
Installation of Oracle instances for product demonstration and customer testing.
Support of "pseudo-live" instances that were used by potential customers' integration teams.
Utilized a combination of RMAN and DataGuard for backups, migrations, disaster recovery and constant database availability in event of a hardware failure.
Utilized Oracle RAC clustering for scalability, load balancing and availability.
Developed an automated process with PERL, Java and PL/SQL to test scalability and stability of the software solution from 1,000 CPE units to over 1 million.
Provided testing support specifically in the areas of application connectivity with the oracle database and network communications between CPEs and the application servers.
Provided performance Oracle Database tuning support during product development and testing.
Managed several Solaris servers and well over a dozen UNIX servers housing the application solution and the Oracle database instances.
Provided Network support for the testing lab network including multiple VLANs using Cisco and Extreme switches & routers.
Sole Proprietor – Kozmic Designs 5/2007 – 5/2009
Daily duties and responsibilities involved with running a small business. Kozmic Designs is a small screen printing and graphic design company.
Sales and customer service. Work to established new customer accounts while maintaining current customer relationships.
Maintained inventory control and stock levels to insure smooth production in the warehouse.
Bookkeeping/Accounting skills necessary for the small business. Oracle Database Administrator / System Administrator 3/2007 – 10/26/2007 Sun Microsystems – Client Solutions, Atlanta, GA (on contract to AT&T Wireless).
Oracle subject matter expert on a team providing Tier 2 and 3 support for the thousand of systems throughout the AT&T enterprise located in four primary data centers.
Worked closely with production, development, application and architectural teams to provide both UNIX and Oracle support in a 24/7 environment.
Alerts and systems monitoring to prevent large scale outages. Oracle Database Administrator 11/2005 – 11/2006
Internet Security Systems, Atlanta, GA. 404-***-****
Provide 24/7 support for several Oracle databases utilized by Oracle E-Business Suite (CRM, Financials, Supply Chain) and corporate applications like PeopleSoft (HR management) and BroadVision (Web Content management). Support included both the Production databases and various development database environments.
Daily maintenance of production databases including Oracle instance tuning as well as SQL statement tuning using Oracle Statpack and TOAD.
Bi-weekly database replications from Production to the Development environments using Oracle Dataguard and RMAN.
Migration of Oracle 8i and 9i databases to Oracle 10g
Implement backup procedures for all databases utilizing Oracle RMAN written to tape arrays via Legato to insure timely recoverability of all production databases.
Implement Oracle’s DataGuard solution to insure uninterrupted availability and disaster recoverability of ISS’s customer facing web content management system. Oracle PL/SQL Developer (Contractor) 5/2005 – 11/2005 Spencer Reed Group, Atlanta, GA. 678-***-****
NewEnergy Associates, Atlanta, GA.
- System Implementation Engineer
- Develop new and modify existing PL/SQL code to customize NewEnergy's Software solutions to fit the needs of their Clients.
- Performance tuning and optimization of store PL/SQL procedures.
- Implement solutions in PERL, VBScript, and PL/SQL that are responsible for on-demand and scheduled imports of NewEnergy client's proprietary data for use in NewEnergy's software.
- Develop reports using Crystal Reports and plain email. Oracle DBA/Developer, Unix System Admin 3/2001 - 12/2004 T-Mobile USA, Inc., Atlanta, GA. 770-***-****
Design, develop, implement and maintain a near-Terabyte Data Warehouse for the Southeast Regional RF Engineering group. (Oracle 8i, 9i)
Implement disaster recovery procedures for the Data Warehouse and the 3 SUN servers in the lab. Oracle RMAN was used to take periodic hot backups of the database. Backups where written to a tape library via Solaris Solstice Disk Suite.
Develop processes for the parsing and loading of hourly data from the cellular network. (UNIX Shell Scripting, PERL, SQL*Loader, cron)
Design, develop, test, and tune Oracle PL/SQL procedures, function, and triggers. (TOAD)
Design, develop, and produce hourly, daily and weekly statistics reports used to show the general performance of the cellular network. (PERL, ksh, Excel)
Design, develop and distribute a Visual Basic application to the RF engineers in the Southeast Region. Application provided historical trending of statistics on specific network elements. Highly successful in reducing time spent on troubleshooting problems in the network. (VB 6)
Maintain UNIX (Solaris) lab of 10 SUN workstations and 3 SUN servers. Severs include the hosting of the Oracle Data Warehouse, File Shares for 40-50 Windows users, a RF Engineering Propagation tool, and a Departmental web-site. (Solaris, Samba, Sharity, Apache) EDUCATION
Bachelor of Science in Computer Science Florida State University, Tallahassee, FL. Graduated in December 2000 with Minors in Mathematics and Physics. TRAINING COMPLETED
Oracle University
2006 Oracle 10g Administration Workshop I Release 2 2006 Oracle 10g Administration Workshop II Release 2 2003 Oracle 9i Database Performance Tuning.
2003 Oracle 9i Database Administration Fundamentals II Backup & Recovery. 2003 Oracle 9i Database Administration Fundamentals I. 2002 Oracle 9i Introduction to Oracle 9i: SQL.
AWARDS/ACHIEVEMENTS
Special Recognition (T-Mobile, USA) for significant contribution to the success of the RF team in 2004. (December 2004)
Achievement Award for Excellence (Unisys) for the creation of the training documentation, classes and the retraining of employees. (November 1997)
Achievement Award (Unisys) for the creation of a database for the tracking of weekly and monthly performance statistics for the Data Entry department and the monitoring/control of medical claims.
(June 1997)
Contact this candidate