TECHNICAL SKILLS:

Databases: Oracle 7.3.2 - 12.1.0.2 , MySQL5, Sybase 10, FoxPro, MS Access, Alpha Four, Paradox

Operating Systems: Windows NT, 2000, 2003, 2008 Server, XP, Windows 7, Confidential 2.6, 10, 11; LINUX, UNIX SVR4

Application Servers: 10g Oracle Application Server, OAS 4.0.8.1, WebServer 3.0.1, Oracle Weblogic

Additional: 10g, 11g, Confidential, 13c Grid Control (OEM), SQL Developer, SQL*Loader, Opatch, Visio 2003, Oracle Fail Safe 3.4.2, SQL Developer, Developer/2000, Designer 2.1 & 6, Oracle ANO (Advanced Networking Option), TOAD, Permits+, PRISM 5 & 6.1, Erwin, TOAD Spotlight, Velocity

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Provides DBA support to a government agency requiring TS\SCI clearance, working with 12+TB T4-4 Oracle super cluster (SSC) running 11g RAC databases and Exadata on Confidential 11;
• performs switchovers; breaks Data Guard to stand up standby as a single instance for testing and flashes database back to standby mode; implemented TDE (Transparent Data Encryption) for Confidential
• establishes SRs w/ Oracle Support and communicate with field engineers to coordinate part replacements and provide support where necessary; provided solution that cut RMAN backup time issue from 24h to 4h, as well as resulted in 32TB of reclaimable space between primary and standby sites; supports other unit enterprise Oracle 11g databases using Confidential and 13c Grids, and Velocity tool for S390 mainframe.

Confidential

Oracle Database Administrator

Responsibilities:

• Provided DBA support to a government agency requiring TS clearance; worked with Oracle 9i - 11g databases doing migrations, performance tuning, RMAN, Data Guard in support of Maximo and Documentum as well in-house databases.
• Installed 11g Grid Control to assess problems within enterprise and be proactive.
• Installed Confidential database for analysis.

Confidential

Database Administrator

Responsibilities:

• Provided sole on-site DBA support for 1.1.TB clustered Oracle 11g EMR (Electronic Medical Record) database running Oracle Fail Safe, Data Guard on W2K8 along with 8 other databases.
• Created standby databases manually and using RMAN auto creation to enable Data Guard.
• Assisted in successful move of production and test databases to new SAN islands; completed upgrade of Grid Control 11g from 10g; upon coming aboard performed analysis of databases that deterred production and test databases from coming to a halt due to tablespace issues; installed updates and patches to database and grid control; collaborated with vendors, system engineers, and programmers.

Confidential

ORACLE DBA

Responsibilities:

• Served as sole DBA to migrate MySQL 5.1.4.1 database to Oracle 11g; installed and configured Oracle 11.2.0.1 on Confidential 10; performed migration using SQL Developer and SQL Loader; collaborated with tech writer on migration plan document, also sysadmin, and developers; performed Oracle quarterly patches. Granted TS clearance.

Confidential

Information Engineer III

Responsibilities:

• Served as Oracle DBA for OPS, PRISM, and BACS systems running Oracle 8i - 10g databases on Windows 2000 & 2003.
• Responsible for installation, configuration, and maintenance of databases utilizing SQL*Plus and Grid Control.
• Deployed Oracle security and Prism software patches as needed.
• Proactively monitored databases for performance issues and downtime using Oracle Enterprise Manager 9.2.0.1 and 10g Grid Control 10.2.0.3; resulting in events being caught and resolved without outside notification, and minimal if any, impact to users.
• Collaborated with server group to implement backup/recovery strategies; as well as with developers\analysts.
• WebVPN provides 24x7 capability and flexibility to resolve database issues. Installed and configured 10g Application Server R2 for developers and data analysts.
• Installed and configured Oracle 11.1.0.6 with Dataguard, and migrated PRISM for testing; provided ER diagrams via Schemester and Visio.

Confidential

Consultant

Responsibilities:

• Provided systems and security analysis; Oracle installations and performance tuning on NT/2000 server platforms; Back-Up/Recovery solutions; Computer diagnostics, upgrades, and repairs.

Confidential

Sr. Information Technologist

Responsibilities:

• Served as sole DBA for IRS Performance Measures Repository running 8i and 9i databases on NT/2000 server; Installed OAS 4.0.8.1 to support PMITS web application; Recovered database caused by media failure;
• Enhanced system performance by implementing table partitioning strategy tables having 2 - 4M rows; Authored SQL*Loader scripts that automatically load new data files using NT scheduler;
• Created database links to facilitate object creation, query, and analysis.
• Installed and configured OEM with recovery catalog in order to monitor, maintain, and run jobs on databases.
• Migrated Access database to Oracle. Installed, configured, and loaded data into Oracle 9i development database using external tables. IRS security clearance granted.

Confidential, VA

Systems Analyst/Oracle DBA

Responsibilities:

• Maintained test lab for databases 8.0.5-8.1.6 running on NT and Win2000.
• Lab was used for test data migrations, and to demo new technologies such as Designer 6, OAS 4.0.8, and WebDB 2.1, as well as mimic some client environments in order to troubleshoot.
• Discovered problem with Oracle Installer not being Y2K while running tests in this lab; preventing clients from encountering the disastrous consequences associated with the installer.

Confidential, VA

Systems Analyst/Oracle DBA

Responsibilities:

• Served as sole DBA for Crime Records Data Repository, a data warehouse, servicing 135 military sites; Migrated UNIX based 7.3.2 DB to NT4 8.0.3DB; Upgraded Oracle from version 8.0.3 to 8.05DB, and finally to 8i; Used Oracle ANO to encrypt database, Designer/2000 to generate ERDs and reports;
• Developed trigger used to populate unique column; Assisted in setup and maintenance of Oracle WebServer later upgraded to OAS; Monitored and tuned database using Oracle Enterprise Manager as well as a host of scripts running SQL/Plus command line.
• Responsible for analysis of business processes and hardware/software concerns regarding Oracle database.
• I also served as computer technician; Granted Secret clearance.