PROFESSIONAL SUMMARY:

Certified Oracle Database Professional (OCP) with over fifteen years of experience as an IT professional and over ten years of experience as a Database Administrator in UNIX and Linux environments. Experienced with Oracle Databases 10g, 11g, 12c, OEM, GRID Infrastructure, RAC, ASM, applications servers, data modeling, installations, migrations, patching, performance tuning, query tuning, Data Pump, RMAN database recovery and replication, PL/SQL, shell scripts, CRON scripts, data management, production support, and SSL security. Resourceful Oracle Expert with the ability to train, mentor, and provide strategic influence to lead and direct teams.

WORK EXPERIENCE:

Confidential, Richfield, MN

Oracle DBA - Consultant

Responsibilities:

• Oracle Database administration and performance tuning - AWR, ASH reports, and SQL Query tuning.
• Supported third-party applications to identify fraud, money-laundering, and other criminal activity.
• Created complex queries that supported developer maintenance of the databases.
• Monitored database activity, webservers, and data migration processes.
• Documented all procedures for colleagues and trainees.

Environment: Oracle 11g, RAC, Oracle SQL Developer, Linux, Bash and Korn Shells

Confidential, Minnetonka, MN

Oracle DBA - Consultant

Responsibilities:

• Oracle Database maintenance and administration during migration of all systems from a Minnesota service center to an out-of-state service center.
• Developed and implemented DML and DDL modifications for production data migrations and updates.
• Wrote and implemented PL/SQL, SQL Loader, and Bash Shell Scripts to automate database changes.
• Wrote automated scripts to archive and purge expired customer data.
• Developed and debugged Linux shell scripts, PL/SQL, and CRON jobs to provide reports.
• Reviewed SQL queries written by software developers for performance enhancements and code fixes.
• Performed database restores to locate lost data.
• Reverse engineered architectural design, materialized views, and DBLinks between multiple databases.
• Data analysis and data modeling. tnsnames file maintenance
• Fulfilled obligations of change management and security protocol.
• Took over all job duties of my supervisor three months into the position.

Environment: Oracle 11g, OEM 12C, RMAN, RAC, ASM, VPD, Oracle Job Scheduler, Grid Infrastructure, Partitioned Tables, SQL Developer, TOAD, Bash Shell, Subversion, and Service Now Incident Management.

Confidential, Minnetonka, MN

Oracle Database Administrator

Responsibilities:

• Contracted to fix several issues with their crashed Oracle databases and RMAN backups.
• Day one - Fixed broken ASM Instance and brought crashed Oracle databases back up.
• Reconfigured RMAN scripts and all CRON jobs running against the data warehouse.
• Performed SQL query, Index, and memory performance tuning on Oracle databases running in Linux.
• Managed partitioned tables to reduce the size of a 7 TB database and free up space on overfilled drives.

Environment: Oracle 10g/11g, ASM Disk Storage, Grid Control, Linux Shell Scripting, and RMAN.

Confidential

Oracle Database Administrator/Migration Consultant

Responsibilities:

• Worked with the Networking, Database, and Development teams to install new Oracle 11g Database Server, Grid Environment, and 11g Database.
• With Data Pump database exports and imports, migrated several instances from separate 10g and 11g databases to one new 11g database.
• Installed Oracle APEX Development Database.
• Planned, created data models, and diagrammed installation of new 11g Database with ASM.
• Performed Administration with Oracle Grid Control 10g and 11g.
• Configured and documented RMAN backups.
• Trained Junior DBA to run standard DBA tasks.

Environment: Oracle 10g/11g, Grid Infrastructure, ASM, Oracle Linux, RMAN, Data Pump, Capacity planning.

Confidential, Eagan, MN

Oracle Database Administrator/Development Lead - Consultant

Responsibilities:

• Performed as the Lead Oracle Expert to aid developers in data modeling and creation of a new Oracle 11g data warehouse using complete SDLC methodologies with several database environments.
• Created ER diagrams for new data warehouse, all database tables, and table relations.
• Wrote and executed scripts to migrate all records from two old databases to new database, scripts to obfuscate data, and scripts to eliminate duplicate records from old data.
• Routinely made database alterations to aid developers with their tasks and created new processes for automating Oracle SQL Loader scripts to be run on all old and new data.
• Researched and made recommendations for database upgrade from Oracle 10g to 11g.
• Routinely aided colleagues with database training and connectivity issues.

Environment: Oracle 10g/11g Databases, SUSE Linux on Sun Solaris, TOAD, SQL Developer, PL/SQL scripting, SQL scripting, SQL Loader, tnsnames, ETL, Micro Strategy. I attained a Federal Security Clearance for this job.

Confidential, St. Paul, MN

Oracle Database Administrator

Responsibilities:

• Hired to complete an upgrade of Oracle Databases from 9i to 10g, migration of the databases from a VMS environment to Red Hat Linux, and to install new Oracle 10g application servers.
• After migration, managed Oracle 10g production, test, training, and development database functionality including role management, user management, data architecture, data analysis, and data modeling.
• Created and maintained the Linux code tree used to implement SunGard ERP business applications.
• Built from scratch two new Oracle 10g Application/Forms Servers (production and test) to run the SunGard Banner business applications.
• Performed all Oracle installations, upgrades, and ongoing patching.
• Created login scripts, profiles, and aliases to automate and control multi-departmental database access.
• Performed ongoing database administration including weekly replication of the production database to the test and training databases, RMAN data recovery, maintaining Linux shell scripts, PL/SQL scripts, patching and upgrading Oracle software, weekly upgrades of ERP business applications, compiling Oracle Forms, deploying JAR files, and maintaining the Secure Socket Layer (SSL) security services on several domains.
• Managed all data capacity resources, the data files of all databases, and Linux network functionality as it related to the Oracle databases and application servers.
• Created detailed documentation for all tasks.

Environment: Oracle Databases, Oracle Application Server 10g, SunGard Banner Business Applications, Red Hat Linux, RMAN, Shell Scripting, PL/SQL, CRON, OEM, opatch, rlwrap, and SSL Security.

Confidential, Minneapolis, MN

Oracle Database Administrator and Systems Consultant

Responsibilities:

• Maintained enterprise systems functionality and mission critical applications for IBM AIX UNIX servers, Windows 2003 Servers, Oracle 9i and 10g databases, and Veritas NetBackup.
• Racked, installed OS, and configured security settings for rollout of all new Windows 2003 servers.
• Monitored all systems and applications, resource management, and disaster-recovery planning.
• Kept software installations up-to-date and worked with third-party vendors on hardware upgrades.
• Automated functionality of UNIX email and reporting systems with CRON and Korn shell scripts.
• Performed Oracle user administration and troubleshooting.
• Wrote all new “Standard of Procedures” specific to each server, all new “disaster recovery procedures” for each server, and documented all processes which were implemented or changed.

Environment: Oracle 9i/10g, AIX, UNIX, Korn shell, SSH, FTP, SMIT, and Veritas NetBackup.

Confidential, St. Paul, MN

Oracle Database Administration and Application Support

Responsibilities:

• Maintained Oracle database integrity and availability in a 24x7 production environment.
• Performed analysis and data management on a variety of “litigation” and “financial service” products.
• Maintained data repositories for clients by serving as the central liaison between IT groups concerning procedures and web services for all Programmers, Project Managers, and Customer Service Reps involved with “Litigation Support” applications. The data repositories were a combination of Oracle products which allowed geographically separated clients to search, change, and print their centrally located data through a web interface; so basically, supported and developed cloud services before the “cloud” was even heard of.
• Wrote PL/SQL scripts for data transactions, triggers, stored procedures, reports, and data loading.
• Performed Database exports for personalized client databases and assisted with imports on the client end.
• Managed production floor people and processes including data loading, scanning, coding, and printing.
• Interviewed new database administrators, recommended for hiring, and trained new personnel.
• Maintained and managed the migration of legacy applications.
• Worked with all levels of the organization to ensure production goals were met and clients’ needs fulfilled.
• Performed SQL scripting, data migration, account administration, and system upgrades.
• Performed project management, identified application issues, and worked to resolve those issues.

Environment: Oracle Database 8i/9i, PL/SQL, TOAD, SQL Loader, Red Hat, Data Management, web servers.