Senior Oracle Dba Contractor Resume Profile
Charlotte, NC
Technical Skills
- Oracle Database RAC 10gR1,10gR2,11gR1,11gR2, 12c1, database security, Very large databases.
- Middleware Implementation/Support - OAS, Forms/Report Servers, Weblogic, Glasshfish, Tomcat.
- Development/Deployment of Application codes in Oracle SQL, PL/SQL, Korn, Perl, C/C , Java
- Replication technologies, Business Continuity, Disaster Recovery - Oracle DataGuard, GoldenGate.
- Working knowledge of MS SQL Server, MySQL, IBM Informix.
- Working knowledge of DW/BI technologies - Oracle Data Integrator, BI Publisher, Business Objects
WORK HISTORY for last 15 years .
Confidential
Senior Oracle DBA Contractor
- Database administration - implementation, maintenance and support including upgrades, patching, and performance tuning as project/development and production support DBA.
- Shell/PLSQL development and Oracle support on several projects and live production systems.
- Data Management migrations/refreshes/partition maintenance of very large databases.
- Replication and maintenance with Oracle Data Guard and GoldenGate on several databases, etc.
- Oracle Database RAC 10gR2, 11gr1, 11gr2, RAC One-Node 11g in IBM AIX 6.2, RedHat Linux 4 environments.
- Oracle GoldenGate 10g, 11g, RMAN, SQL Developer , Oracle Data Guard, OEM Grid/Cloud Control 11g, 12c, MS Project.
Confidential
- Installation, configuration and upgrade of Oracle Database 11gR2 RAC OneNode with 2 nodes server pool.
- Integration of Oracle Enterprise Manager Database Control 11g with Tivoli Enterprise Control - Forwarding SNMP traps to Tivoli EC.
Confidential
IT Consultant Contractor
- Replication of Database Schema tables between SQL Server 2008 database instances and a central Oracle Database 10gR2 and between Oracle Databases using Oracle Golden Gate 10g within the local bank site.
- Demonstration of Oracle Database 11gR2 RAC OneNode in a Virtual Infrastructure environment Oracle VM Server 2.1 servers and administered with Oracle VM Manager both running in 3 Linux virtual machines VM in a 8-processor, 64Gb RAM Windows Servers 2008 R2 Hyper-V .
Confidential
Senior Oracle DBA/Manager
Systems Used/Supported:
Oracle Database 10g RAC, Oracle 11g RAC, Oracle WebLogic Suite 11g, Oracle Application Server 10g, Oracle Reports Services, Oracle Beehive 1.3,1.5, Oracle Enterprise Linux 5 32/64-bit , Oracle JDeveloper 10g, 11g, Oracle DataPump, OCFS2, NFS, ASM, OEM Grid Control 10g3,4,5, 11g,
Oracle Data Guard, Advanced Replication, Oracle GoldenGate 10g, MS Project.
Accomplishments :
- Installed, configured and supported Oracle Database 10g RAC 10.2.0.3, 4 and Oracle RAC 11gR1 3-node clusters in development, QA and production environments.
- Upgraded and patched many instances of Oracle 10g 10.2.0.3 RAC to Oracle 10g RAC 10.2.0.4 , Oracle 10g RAC to Oracle 11g RAC 11.1.0.7 , 3 -node RAC Cluster . Cluster Homes, Oracle Homes, ASM Homes, Database.
- Implemented Oracle Audit Vault/Database Vault in Dev. and Prod. Environments.
- Led the implementation of Oracle Data Guard Physical Standby for Disaster Recovery and Business Continuity between two site locations.
- Implemented/Supported Oracle GoldenGate 10g, GoldenGate Director and Veridata for sets of table data replication across Oracle Databases.
- Led in the implementation of Oracle Application Server OAS 10g in dev, QA, cert/gold, and production environments using the OHS, OC4J, Portal, OID/Single-Sign-On.
- Web/java application deployments on Oracle WebLogic servers and OAS 10g servers.
- Implemented Windows Automatic Login with SSPNEGO for an Oracle ADF application deployed on a 3-node clustered Oracle WebLogic Servers running on Oracle Enterprise Linux.
- Led the implementation, configuration, upgrade and support of Oracle WebLogic 11g in cluster configurations in development, QA and production environments, and integration with MS Active Directory, OID, ADF.
- Led the implementation of Oracle Beehive 1.3,1.5 and integration with OID and MS Exchange Servers.
- Installed, configured Oracle APEX, APEX Listener and Oracle BI Publisher on Clustered Oracle WebLogic servers with integration with MS AD.
- Provided support for schema and application code changes and deployments and SQL query performance tuning and advisory on database object definitions and capacity planning.
- Supervised/mentored 2 Staff Oracle DBAs/Application Server DBA and worked with Developers/Analysts.
Confidential
IT Manager/Lead Senior Oracle Application
Systems Used/Supported :
Oracle E-Business Suite 11i 11.5.10.2 x 7 instances with 350 users access nation-wide on the Production
Oracle Database 10.2.0, 10.1.0 RAC/ASM. OCFS2, Oracle Application Server 10g, Oracle Forms/Report Server 6i, Oracle Discoverer 10g Server, Red Hat Linux Enterprise/Advanced Servers 4 32-bit , 7 Oracle 10.2.0, 10.1.0 RAC Servers., Perl, XML Publisher, Oracle Internet Directory, Oracle Data Guard, DataPump, Oracle Enterprise Grid, RMAN, Toad, Discoverer Admin, Plus/Viewer. Veritas NetBackup, MS Project, MS SQL Server 2000/2005.
Responsible for the Oracle E-business technical environment and manage outsource service provider, by delivering the following :
- Oracle Applications 11i administration and management.
- Oracle database administration and data management.
- Oracle Discoverer Administration and Support.
- Red Hat Linux ES System administration
- DBA Support to Java, PLSQL developers and BI / DW reports developers.
Accomplishments :
- Provided technical support for the Oracle Application 11i databases and Red Hat Linux servers.
- Streamlined Oracle Application 11i maintenance process, patching schedules and researches.
- Implemented Oracle XML Publisher or BI Publisher with Oracle App s 11i for financial reporting.
- Oracle RMAN Backup and Recovery Scripting for development, QA, cert, production databases.
- Performed Oracle Apps 11i upgrades, patching and cloning biweekly for project development.
- Performed Discoverer Patching, and upgrades and provided support also with Discoverer Admin.
- Incorporated Veritas NetBackup Oracle Agent into the corporate database backup strategy.
- Implemented of Oracle Workflow Notifications, Oracle iExpense module and DataLoader for uploading
- formatted data into Oracle Apps 11i Assets, etc.
- Implemented a SOX compliance plan at the Oracle EBS, database, application and Linux OS levels.
- Designed and implemented disaster recovery plan and implementation.
- Provided Oracle and SQL Server integration support.
- Managed other 3 contractor/DBAs remote and UNIX Administrator.