Database Resume Boulder, CO - Hire IT People

Technical Skills

Databases: Oracle RDBMS 8.1.7–11.2
OS: Windows 2000/2003/XP Server/Professional, AIX 5.3, OpenVMS 7.3, Solaris Sparc 10
Languages: PL/SQL, ColdFusion 4.5-MX7.
Software: Oracle Enterprise Manager, 10g Grid Control, Toad Professional 9.7, Spotlight 6.1, Performance Analysis 6.5, SQL Server Management Studio, Cerner Millennium 2007, Lotus Notes and Domino 6.0, Visio.

Professional Experience

Jul. 2010 – Present Confidential
Database Administrator II, Ball Aerospace, Boulder, CO

Provided technical support for 30+ Oracle 9.2, 10.2, 11.1, and 11.2 production databases, and 75+ Oracle development/test databases.
Wrote a shell script that extracts data from Oracle OS audit logs to be used for reporting.
Wrote additional shell scripts to create new users in multiple databases, and to refresh databases to an off-network environment.
Upgraded Oracle development databases to 11.2.
Tuned and optimized queries, materialized views, and databases.
Applied Oracle security patches, and researched and implemented Oracle security best practices.
Created detailed documentation and followed the company’s change control process for all tasks performed.
Refreshed SQL Server 2000 databases.

Feb. 2008 – Jul. 2010 Database Consultant, Confidential, Mesa, AZ

Supported a 13+ TB Oracle 10.2 RAC database with 1 active and 1 passive node, in a 24/7 on call rotation.
Participated in a team project of migrating the production database from OpenVMS to AIX, and Oracle 9.2.0.5 to 10.2.0.3. This included planning storage requirements, installing Oracle and CRS, applying patches, configuring and testing rman backups and restores from TSM, and performance tuning.
Migrated an Oracle development database from OpenVMS to AIX.
Performed a database clone from production to a development database using rman.
Implemented a data guard solution - created a physical standby database, and a logical standby database for reporting.
Evaluated various Oracle performance monitoring tools – Quest Performance Analysis and Spotlight, and Embarcadero Performance Center.
Created shell scripts on AIX to check the alert, listener, and crs logs for errors, and to monitor tablespace usage.
Implemented several Cerner related projects such as refreshes, replicates, and adding and deleting domains.

Aug. 2006 – Jan. 2008 Database Administrator II, Confidential, Phoenix, AZ

Migrated the ADP time and attendance Oracle database server from Windows 2000 to AIX 5.3. Involved in all phases including capacity planning, installation, configuration, testing, and performance monitoring.
Wrote a shell script to automate all database refreshes from one central server.
Created documentation for Oracle installations on AIX and listener security. Maintained disaster recovery plans for several systems.
Upgraded 3 production databases from 9i to 10g, and assisted in the migration of an Oracle database to SQL Server 2005.
Provided 24/7 support for 30+ Oracle 9.2.x, 10.1.x and 10.2.x production databases.
Other routine tasks - applied the latest patchsets and security patches, created users, managed user security, tuned SQL statements, refreshed instances, resolved help desk tickets.

Jan. 2003 – Aug. 2006 Oracle Database Administrator, Confidential, Belleville, MI

Implemented and maintained a global multimaster and materialized view replication environment for 5 production databases. Wrote scripts to monitor replication status and errors.
Created and implemented a RMAN backup and recovery plan for each database.
Upgraded all production databases from 8i to 9i. Migrated test databases to 10g.
Wrote Windows scripts that monitored the alert log, tablespace usage, and instance availability.
Developed PL/SQL objects, including functions, triggers, packages, and cursors.
Trained developers to use bind variables in their code to increase application response time.
Performed all Oracle installations, enrolled users, maintained system security, created data models for each application, migrated data to test environments using the import and export utilities, created tables, views, and indexes, troubleshooted Oracle errors, and provided end-user support.
Team leader for a global information exchange system with over 130 projects and 1,700 users.
Managed people, groups, security, and installations in Domino for 20 users and 10+ databases.

Jan. 2002 – Jan. 2003 CIS Intern, Confidential, Belleville, MI

Installed, upgraded, and configured Windows NT/2000/XP workstations.
Supported LAN, software, and workstation issues for 300+ users.
Implemented a ColdFusion application to monitor employee Internet usage activity.

Education/Certifications