Senior Oracle Rac Dba Resume
SUMMARY:
IT Professional with over 16 years demonstrated abilities in Agile/Scrum methodologies, consulting, managing, lead DBA, Unix Administration, Software and Application Development Life Cycle. Knowledgeable in a wide range of Programming Languages, Operating Systems, Hardware and Software. Enjoying the fast - paced and challenging environment.
PROFESSIONAL SKILLS:
Cloud Infrastructure: Amazon AWS(RDS and EC2) and VMware.
Databases: Oracle RAC 12c, 11g, 10g and 9i.
Netezza: Microsoft Sql Server 7.0 and 2000.
Database/Programming tools: Oracle Identity Management( Confidential ), Oracle Golden Gate, Oracle OEM Grid Control (OEM) 12c, Oracle SQL Loader, Sql Developer, Quest Toad and Spotlight.
Database design tool: Erwin.
Middleware: Oracle Fusion Middleware 11g, Oracle Weblogic 11g, Oracle Application Server 10g, Tuxedo.
Programming/Scripting Languages: JAVA, C, C++, Oracle PL/SQL, Unix Korn/Bash Sed, Awk, Html.
Operating System: Red Hat Server 6, 5 and 4, Unix (AIX and Solaris), Windows.
WORK EXPERIENCE:
Confidential
SENIOR ORACLE RAC DBA
Responsibilities:
- Maintaining current Oracle 12c RAC in development, test, and production databases on IBM AIX.
- Supporting Oracle Confidential ( Oracle Identity Management).
- Installing and configuring Oracle 12c RAC.
- Installing, configuring and supporting Oracle Grid Control (OEM) 12c.
- Setting up ( configuration and installation) Oracle ( EBS and db) in Amazon AWS ( EC2).
Confidential
SENIOR ORACLE CONSULTANT
Responsibilities:
- Maintaining Weblogic. 10.3.6
- Maintaining current 11gR2 development, test, staging and production databases on Red Hat Linux .
- Migrating Oracle 11g RAC to Oracle 12c RAC.
- Generating Oracle AWR and ADDM production reports daily.
- Assisting developers deployment codes to different environments ( test, staging and production).
- Maintaining and writing scripts ( SQL and Shell scripts) for backing up database.
- Assist developers with PL/SQL and performance tuning.
- Supporting Oracle Confidential ( Oracle Identity Management).
Confidential
SENIOR CONSULTANT (ORACLE/AWS)
Responsibilities:
- Migrating Oracle development and production databases to Amazon AWS(RDS and EC2).
- Following Agile methodology by integrating Oracle DML and DDL in Gradle and Jenkins for automating deployment.
- Installing and configuring ORACLE 12c and 11gr2 Real Application Cluster (RAC) on Red Hat Advanced Server for dev and test in Virtual Environments ( on VMware).
- Installing and configuring Mongo DB .
- Maintaining logical Confidential -ELIS2 model .
Confidential
SENIOR CONSULTANT
Responsibilities:
- Migrating and upgrading stand alone databases from various platforms( Windows and Linux) to Oracle 11gR2 ( RAC) on Linux ( production) and Oracle 11gR2 ( RAC) on Linux in VMware environments
- Installing Mongo DB on Red Hat in development.
- Monitoring and maintaining Data Guard daily for Disaster Recovery site.
- Installed and configured Oracle Fusion Middleware 11g (Weblogic) on Red Hat .
Confidential
ASRC PRIMUS CONSULTANT- SENIOR CONSULTANT
Responsibilities:
- Assisting developers deployed Java applications to Weblogic.
- Migrating Oracle 10G RAC (Real Application Cluster) on Red Hat Advanced Server to Oracle 11G RAC that supported Confidential ’S Registrant Support Network (RSN) application.
- Installing Oracle Golden Gate.
- Maintaining Oracle Stream.
- Migrating Oracle 10g Application Server( Reporting, Form and Mod PL/SQL) on Red Hat Advanced Server to Oracle 11g Fusion Middleware and Oracle Weblogic 11g.
- Migrating Confidential ’s ARCOS application mainframe to Oracle 11g RAC ( logical design tables and objects using Erwin and using PL/SQL and SQL* loader to extract data (ETL) from IBM’s M204 to ORACLE) and transfer to Netezza Data Warehouse Appliance.
- Migrating Oracle 9i on Windows 2000 Server to Oracle 10g (RAC) on Red Hat Advanced Server that supported Registrant Support Network (RSN) application (registration application for doctors, dentists, pharmacies, and drug companies).
- Installing and configuring Oracle Grid Control 11g and 10g.
Confidential, Washington, DC
COMPUTER ASSOCIATE
Responsibilities:
- Migrated Oracle 9i (RAC) to Oracle 10G (RAC) on Red Hat Advanced Server.
- Maintained large clustered for government investigative service test and production Oracle 9i database on Red Hat Linux Advanced Server on EMC Storage Area Network (SAN).
- Designed, writing proposal and implementing disaster/recovery that include Data Guard and Oracle Recovery Manager (RMAN) (for backup/restore).
- Ongoing support for development, test and production system that include rolling back, rolling forward, monitoring, and tuning clustered database on Linux Red Hat.
Confidential, San Francisco, CA
JAVA DEVELOPER/SENIOR ORACLE/SQL SERVER DBA
Responsibilities:
- Maintaining /supporting client java applications.
- Installing and configuring Oracle 8I, 8.1.5, 8.1.7 and 9i on Solaris 2.6 and 2.7
- Tuning Oracle server (I/O, tablespace fragmentation, data dictionary, library etc.) by utilizing Oracle TKPROFT, EXPLAIN PLAN, and USTAT/BSTAT, etc….
- Implementing Oracle 9i Real Application Cluster (RAC) and Data Guard.
- Utilizing Oracle Rman and Veritas NetBackup to backup and recovery database on production database.
Confidential, Sunnyvale, CA
JAVA DEVELOPER / LEAD DBA
Responsibilities:
- Writing and implementing scripts to monitor, refresh, backup (using Veritas NetBackup)
- Oracle Application 11.0.3 and Oracle Database 8.0.5.2.
- Migrating and configuring Oracle Application and Oracle database from test to staging.
- Writing scripts to monitor Concurrent Manager, rollback segments, indexes etc….
- Installing, sizing, monitoring, backing up and restoring (using Veritas Backup Exec) SQL
- SEVER 7.0 on Windows 2000 for development, test, and staging and production environment for Siebel CRM.
Confidential, Atlanta, GA
ORACLE DBA/DEVELOPER
Responsibilities:
- Tuning various data warehouse applications.
- Utilizing Developer 2000 to write report for billing system.
- Life cycle of Traffic Management System and Lockbox Projects that consisted of:
- Modeling and creating the database using Designer 2000.
- Automating back end process by utilizing Oracle SQL* Loader, Unix Shell Scripts and PL/SQL to transfer files from mainframe to Oracle8.
Confidential, Piscataway, NJ
PROGRAMMER ANALYST
Responsibilities:
- Modeling (application tables) and coded client/server applications (NPA Split, etc. in C/Tuxedo) that enabled client (UNIX) request message transaction to Data Server (Oracle and DB2 data server).
- Designing and creating tables, databases for Transaction Server’s Oracle databases.
- Utilizing Oracle’s utilities (PL/SQL, PRO*C, embedded SQL) to extract data from Oracle tables for bundling services (bundle service is the service that enable Confidential & Confidential to combine all the services such as long distance, calling card, WorldNet, local, cellular. etc. into one package).
- Utilizing Oracle’s SQL LOADER, EXPORT, IMPORT to migrate data from DB2 tables to ORACLE tables.