SUMMARY:

Sr. Oracle 11/12c Oracle Database Administrator (DBA), and SQL Server Database Administrator (DBA); with over 10 year of DBA experience. Duties include: Database installations, upgrades, patching, monitoring, SQL and tuning, troubleshooting issues, Experienced in Oracle RMAN, ASM, RAC, installed/Configured Oracle Data Guard, Disaster Recovery, High Availability, Oracle Application installation, Weblogic, Unix/Linux scripting, Oracle cluster ware and Windows Clustering, Worked on Windows 2000, 2005, 2008R2 and 2012; OEM Installation and configuration. Worked with SAP basis Team, Worked as a PeopleSoft Administrator, Worked with People Tools, and performed Oracle Financials patching. Installed Oracle databases on Linux, work well in a fast pace IT environment, I am a quick learner, detailed oriented; Possess strong communication skills; work well with IT Director’s, Managers, Projects Managers, and development team members.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

• Worked on the ADLS A5T Air Force - wide production, training, and development Learning Oracle databases. Duties included;
• Performed Oracle binary installations.
• Implemented Oracle Transparent Data Encryption for production Oracle database for a world-wide database system
• Created Oracle databases 10g, 11g, and 12c on Linux and Windows servers.
• Performed database migrations.
• Performed Oracle database Upgrades, Patching, performance Tuning.
• Use RMAN database backup and recovery, Oracle data pump.
• Implemented Oracle Transparent Data Encryption (TDE) Oracle backups,
• Implemented Client Server Database Server encryption Traffic security
• Reviewed and Implemented Database STIGS
• Worked with Infrastructure Team, development team, Project Leads, Managers, Directors, and DISA to provide critical database support. resolve application issues and implement upgrades.
• Created and Utilize OEM, used TOAD, performed Unix Shell scripting.

Confidential

Lead SAP Oracle Database Administrator/MSSQL Database Administrator

Responsibilities:

• Created Oracle 10g and 11g database for SAP support. -Used SAP Brtool.
• Performed Oracle 10 to 11g upgrades.
• Installed OEM agents, created OEM database.
• Performed Oracle Patching using OPatch.
• Utilize RMAN for database backup and recovery.
• Use AWR and ADDM reports to perform analysis.
• Performance Tunning
• Created MSSQL 2008R2 database on Windows Servers

Confidential

Sr. Oracle/MSSQL Database Administrator/MySQL

Responsibilities:

• Performed Oracle DBA production support in Oracle 10g, 11, Oracle Cluster Ware, ASM, RAC
• Configured/Installed Oracle Data Guard -Performed Daily Oracle RMAN database backups and recoveries
• Worked with Oracle RAC, OEM and Grid Control, performed statistics.
• Worked with LDAP, OID, TCP/IP, RAC, and OEM -Worked with tkprof, Statspack, and explained plans SQL PL/SQL -Perform Oracle database upgrades, used opatch, runInstaller, and more -Utilized performance tuning techniques -Created user accounts password assignments, worked with schemas, and tablespaces
• Ran AWR and ADDM reports, familiar with performance tuning -Used data pump, and performed database, schema, table export/imports -Wrote SQL code, Linux/Unix scripts. Use AWK, SED, and more -SQL SERVER DBA 2005/2008. Install, configure, monitored databases. Performed patching -Used activity monitor.
• Looked for deadlocks. Used profilier -Used and familiar with SSIS, SSRS.
• VMWARE -Performed SQL Database restores.
• Created maintenance plans.
• Used DBCC and more
• Performed other SQL DBA duties.
• Check alert logs.
• Created instances, monitored logs.
• Used clustering -Wrote Linux/Unix scripts, Structured Query Language (SQL)
• Provided Administer application Security

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Monitored daily Oracle 9i, 10g databases for performance to provide support to our users -Performed database 9i, 10g, 11i, upgrades, apply patches and fixes
• Installed and setup Oracle Applications.
• Applied frequent patches
• Installed and used OEM/Grid Control
• Provided support for Apache and Oracle Web support
• Configured Oracle workers. Installed Oracle Financials suite -Worked with Oracle Concurrent manager
• Searched Metalink to identify database trouble spots
• Performed database backups using RMAN
• Wrote Unix scripts in K shell and borne shell
• Administered application Security
• Provided IS management with database performance issues -Wrote documents to establish guidelines and procedures for application use
• Configured PeopleSoft install, upgrade, fixes, patches, and maintain PeopleSoft Application server, Process Scheduler, and Web Server for production and test/development environments Performed PeopleSoft Tools upgrade -SQL SERVER DBA 2005/2008. Installed, configured, monitored databases. Performed patching Used Activity monitor. Look for deadlocks.
• Used profilier -Oracle and SQL Server database upgrades -Programmed Unix scripting.
• Analyzed and used performance tuning techniques -Utilized database and application security

Confidential

Sr. PeopleSoft Administrator

Responsibilities:

• Installed PeopleSoft software applications (People Tools, Web app PIA), process scheduler
• Implemented Quarterly tax updates for HRMS application
• Configured and administered PeopleSoft Internet Architecture (PIA)
• Installed and configured BEA Tuxedo and Weblogic
• Performed database updates
• Applied PeopleSoft/Oracle and application patches, updates, and fixes
• Administered application Security
• Provided IS management with timely and accurate information regarding PeopleSoft
• Worked with Corporate production Oracle database administrators to install/upgrade/Patch PeopleSotf Application
• Wrote and prepared documents for training and established procedures
• Performed PeopleSoft Tools upgrade
• Programmed Unix scripting Analyzed and monitored system for performance.
• Diagnose problems. Tuned databases, Tuned SQL statements, worked with developers to fine-tune code

Confidential

PeopleSoft Oracle/SQL Server Administrator/ DBA

Responsibilities:

• Upgraded all applications -Configured and set PeopleSoft Internet Architecture (PIA)
• Performed PeopleSoft system Configuration using BEA Tuxedo, and Weblogic
• Created Oracle 8i/9i and SQL server databases -Applied PeopleSoft/Oracle patches, updates, and application fixes
• Understood PeopleSoft Security Administration including row-level security
• Provided IS management with timely and accurate information regarding PeopleSoft
• Created PeopleSoft Oracle instances and People Tools environments
• Configured PeopleSoft Install, upgrade, fixes, patches, and maintain PeopleSoft Application server
• Processed Scheduler and Web Server for production and test/development environments.
• Managed, created, and tuned Oracle Table spaces, indexes, views, procedures, and SQL scripts -Tune databases, Tune SQL statements, work with developers to identify bottlenecks. -Performed daily database backups -Performed database disaster recovery
• Provided application support
• Duties included creating backup schedules, creating indexes, tables, writing Unix Scripts
• Worked with the development group and users on a daily basis -SQL SERVER DBA 2005/2008.
• Installed, configured, monitored databases.
• Performed patching -Used Activity monitor. Look for deadlocks.
• Performed SQL Database restores. Created maintenance plans. Used DBCC and more
• Performed other SQL DBA duties.
• Checked alert logs.
• Created instances, monitored logs.
• Used clustering

Confidential

Systems Analyst

Responsibilities:

• Worked as a Systems Architect and Oracle database developer
• Worked on large Oracle Database Warehouse projects
• Wrote UNIX scripts (Sun Solaris, AIX). SQL scripts, Used ETL application tool -(INOFRMATICA) to migrate volumes of data across multiple database platforms
• Gathered user requirements
• Involved in performance testing, application upgrades, and production database
• Utilized PeopleSoft Tools, Oracle 8i, Crystal Reports, Crystal Info and SQL Server to support 20,000 users
• Researched new technologies -On call 24X7