We provide IT Staff Augmentation Services!

Oracle Consultant Resume

5.00/5 (Submit Your Rating)

Houston, TX

SUMMARY

  • Seasoned Infrastructure architect with over 18 years of experience in the Industry with exposure to several Domains, namely Oil and GAS automation, Toll Industry, Medical Insurance, Airlines, Retail Industry, Banking Domain - Investments Banking, Retail Banking, Private Banking, Global Finance, and Global Consumer Banking.Specialized in architecting and delivering Enterprise Systems.
  • Architect and Implement Operating Systems (RedHat, Oracle Linux, AIX, HP-UX & Solaris), Databases(Oracle, MySQL, MongoDB),CA Identity Suite and Application Servers (OAS).
  • Managed teams of System administrators, Database administrators, Data analyst and developers.
  • Supported Java based Applications/OBIEE reporting Project and Application User Management environment in 24/7 model.
  • Worked on Supercluster M7 administrating 3 node RAC databases, Deployed Oracle RAC 10 and 11.x as HA solution.
  • Patches/upgrade RAC/non RAC Database systems and Solaris environments.
  • Participate, validate and verify Business application strategies and testing.
  • Propose, design, validate, tested and implement Disaster Recovery Site and configured and performed Disaster Recovery using DATAGUARD/RMAN.
  • Planned and implemented serveral Datacenter forklifts as a DBA,systems administrator and Middleware admin.
  • Participate in identifying new tools to enhance the existing Infrastructure Architecture and operations.
  • Participate in planning and deploying Security and audit applications for Database hardening.
  • Extensive Experience in Performance Tuning.
  • Deliver timely and quality incident resolution focusing on root cause analysis, prevention, and knowledge transfer.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux AS 7.5, Unix (Solaris 9/10,11, Tru-64 UNIX), MS Windows server 2003, 2008 & 2012

Hardware: Oracle Supercluster M7,NetApp filer, Compellant, EMC2, Sun Fire Servers, Sun E series, Digital alpha series, DLT/SDLT Tape Drives, ATL, L80 Storage Array

Databases: Oracle 7.x,8.x,9i, 10g, 11g,12c,Sql Server 2008,Mysql, MongoDB

Scripting/ Programming: Plsql/sql,Shell Scripting, Python

Applications: CA Identity Sutie 14.1,Oracle 10g Application Server,Oracle APEX, Oracle OBIEE 11g and 12c, Apache, Oracle Weblogic Server,JBoss, dWEB, Summit, Report Servers, Risk Engines, Ifaces, PTSI, TSAR, Armor, Oracle Directory Server Enterprise Edition. OpenLDAP

Tools: Oracle Enterprise Manager Grid Control, DataGuard Broker, RAC, Rman, Uptime, Nagios, Cacti, AWR, ASMCMD, ADDM Reports, SQLBack Track, Tivoli Server Manager, ODMA, DBCA, MIG, Export/Import, Sql*Loader, Remedy, Toad, Control-M, Legato Networker 5.x/6.x

PROFESSIONAL EXPERIENCE

Confidential - Houston, TX

Oracle Consultant

Responsibilities:

  • DataCenter fork Lifting planning, design and implementation
  • Oracle fusion Middleware setup and configuration
  • Integration of RealTime interfaces and identity access management.
  • OFM,Database maintance and migrations.
  • Datewarehousing and BI configuration for data anlaysis and reporting.
  • Advisory for Installation and configuration of Weblogic,Tomcat,HeartBeat and Eclips.
  • Process and guidelines for Production Support for Application availability.
  • Onsite-Offshore Support model.

Confidential - Houston, TX

Senior Security Consultant

Responsibilities:

  • SME support for preparing Proposals for Federal & State RFPs.
  • Providing Oracle Database Administration services best practices.
  • Installation of Oracle Database 12c and Oracle weblogic for CA Identity Suite with Fail safe environment using Dataguard.
  • Implementation of CA identity Suite.
  • Requirements gathering, Design and planning for replacing existing Security System with CA Identity Suite
  • Provisioning User using CA Policy Express
  • Setting up END POINTS using CA Connector Express
  • Oracle Database upgrade plans and assisting in implementation.
  • Oracle Database Disaster recovery testing and plans
  • Change management participation for releasing new changes.
  • Provided assistance in testing and implementing Oracle Database audit vault

Confidential

Enterprise DBA/ Middleware Admin / System Admin

Responsibilities:

  • General OracleDatabase monitoring, troubleshooting and Administration in 3 node and 4 node RAC database and Data Guard Environment.
  • Database Cleansing for PCI Compliance.
  • Develop sql/plsql packages and procedures for Daily loads and Adhoc requirements.
  • Managed Oracle 10g BI and assisted in building Pl/sql blocks for custom reports.
  • Managing Informatics Tool Power Center/Power Exchange installation, Failover to New Hardware and testing Functionality.
  • Managed and monitored Database Alerts/Spaces and errors using Oracle APEX.
  • Oracle Database upgrade with zero downtime.
  • Documentation and Implementation steps for Oracle Database migration from AIX to Solaris.

Confidential - Houston TX

Sr. Oracle DBA/Middleware Admin - Team Lead

Responsibilities:

  • Database administration, monitoring, patching/upgrades, troubleshooting and database backups using RMAN.
  • Designed and Performed Disaster Recoveries by failing over to DR site and failback to Primary Site, both Datacenter level and single instance.
  • Managed 3 database administrators,2 data analyst and 4 developers.
  • Performed migration of Databases from Compellent SAN to Hitachi VSP without outage.
  • Performed installation/upgrades of ASM/Database from oracle 10.2.0.4 to Oracle 11.1.06, 11.2.0.1 & 11.2.0.3, Oracle 11.2.0.1 to 11.2.0.3 using DBUA/catupgrade.
  • Performed Physical Standby Database Set up and monitoring using Data Guard Broker.
  • Implemented Oracle TDE by migrating from existing third party encryption software.
  • Installed, configured and administration of Oracle Application servers 10.1.2 and 10.1.3.
  • Installation and configuration of Content Management Applications.
  • Performed various Performance tuning activities, SQL tuning, memory tuning and DB I/O distribution which improved the stability of the Database performance.
  • Involved in testing Oracle 11g reports using Web logic for upgrading from 10G AS to 11G and deploying Oracle OBIEE
  • Responsible for identifying new tasks, assigning and delivering.
  • Configured, scripted and set up automated jobs for different databases jobs and application vendors.
  • Scripting using Bourne shell for various application related jobs.
  • Tested moving standalone databases to RAC on Linux

We'd love your feedback!