SUMMARY:

• More than 15 years of experience in IT industry and has been Oracle administrator with an expertise in Oracle 8/8i/7.x, 9i.10g, 11g,12c 12.1.0.2.0
• Well versed in the analysis, design, development, testing, implementation and administration.
• Strong experience in the installation and configuration of Oracle 9i / 10g R2,11gR2,12c, applying latest Oracle patches for Oracle 9i DB and oracle 10g R2,11g R1,11gR2, 12c,backup and recovery using RMAN backup script and recovery through OEM console, migrating data from 9i to 10g/11g, Flash back database, encrypted tablespace setup for Oracle 11gr2 and 12c.
• CPU patches on databases, application and SSO servers, applying CPU patches on database, installation of OMS and GRID Agents on RAC database and non - RAC databases. Oracle 10g, 11g SGA tuning, Real Application Tuning.
• Installations of OWB 9i, 10g, 11g on UNIX, design Center, Repository Browser, Target Schema, and Control Center Services.
• Strong experience in PL/SQL, SQL, SQL* loader, SQL*plus, Developer 2000, Oracle 9i DS, Oracle10g DS. (Oracle forms and reports 3.0/2.5).
• Working experience in developing packages, procedures, functions, and database triggers using Oracle PL/SQL, and database tuning, query optimization.
• Knowledge of Oracle 11i GL module with FSG.
• 24*7 system support, on call schedule and maintenance of servers/databases.
• Oracle RAC installation 11gR2 - 2 nodes and Configuration on Sun Solaris RHEL6. 12c GI installation on RHEL 7.
• Oracle 11g R2, 12c 12.1.0.2.0 GRID Infrastructure ASM and CRS installation and configuration.
• Configuration of Oracle Streams using DBMS packages and Oracle Golden Gate s/w.
• PSU patch GI +DB on 11g r2 RAC and 12c RAC.

TECHNICAL SKILLS:

RDBMS: Oracle 8i/8.0/7.x, 9i, 10g r1, 10g r2, 11gR1, 11gR2,12c, SQL Server 2000/2005/2008

Languages: PL/SQL, SQL

GUI/Tools: Developer 6i, Developer 2000, Developer 9i, Developer 10g, Forms .5/5.0,.5/3.0,9i, 10g, 11g, 12c

Oracle Utilities: SQL*Plus PowerBuilder 7.0, SQL loader, import/export, expdp/impdp, ETL tools.

OS: Windows 95/98/NT/2000, Sun Solaris Operating System (SPARC) 64 bit, IBM AIX 5.2, Redhat Linux AS 2.1, SUSE Linux., RHEL6, RHEL7.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SR Oracle DBA

• Applying PSU patches to production and non-production cluster Oracle 11g and 12c databases and non-cluster databases on RHEL 6, RHEL 7.
• Schema refresh, staging database creation, RAC database rename, refresh databases from production environments.
• Archive log removal scripts, RMAN backup script analysis, scripts for environment variable setup on Linux OS.
• Oracle Cloud Control 12c and 13c installation on Linux OS with cluster repository, Installation of Oracle cloud control agents on different hosts to register targets to 12c and 13c cloud control.
• Working with developers to resolve development issues and release support.
• Performance tuning using Oracle cloud control 12c, Cloud control 13c, ADDM, AWR and ASH reports.
• Re-IP configuration for RAC databases Changing public, VIP and SCAN IPs during data center relocation.
• Working with internal auditors to resolve audit related issues for production databases.
• Setting up new 12c databases on RHEL 7, installation of all required RPM, kernel parameter settings, database s/w installation and database creation.
• Oracle database Backup and recovery DR drill .

Environment: Linux, Oracle 10g, Oracle 11g, Oracle 12c, PL/SQL, TOAD, data guard, cloud control 12c and cloud control 13c, RMAN.

Confidential, Ashburn, VA

SR Oracle DBA

• Installation & configuration of Oracle Cloud Control 12c Grid control on Linux server.
• Installation of 12c agents and plug-in on hosts for target registration through Oracle Cloud Control 12c.
• Performance tuning, SQL advisors, SQL PLAN MANAGEMENT using GRID Control 12c.
• Migration of Oracle 10g R2 databases on Solaris OS non-RAC to 2 nodes RAC - 11g R2 on Linux using RMAN convert and transportable tablespaces.
• Applying CPU patches to Oracle instances on both prod and non-prod environments.
• Installation and configuration of Oracle RAC ASM, GRID Infrastructure and SCAN 11g R2 on Linux.
• RMAN backup and recovery of databases on UNIX.
• Performance tuning of SQL queries using Oracle Grid control, ASH, AWR, ADDM and SQLT.
• DB performance tuning, index organized tables / clustering factors for fast output of Oracle SQL queries.
• CPU patches on production and non-production databases.
• RMAN duplicate for creating standby database, data guard and snapshot standby database for DR practice.
• Oracle Golden Gate 11gR2 configuration and monitoring on Linux.

Environment: Oracle 10g, Oracle 11g, AIX, Linux, Solaris, PL/SQL, Oracle Golden Gate, RMANTOAD, data guard, Grid Control 11g and 12c.

Confidential, Richmond, VA

SR Oracle DBA

• Installation of Oracle 11g R1, 11g R2 DB on Sun Solaris 5.9, 5.10, Windows servers.
• Upgrading 9i, 10g databases to 11gR1 and 11gR2 on Sun Solaris, Windows Servers.
• Applying CPU patches and core patches on Databases and Application Servers.
• Creating Physical standby databases using COLD backup as well as using RMAN duplicate and RMAN copy, Oracle streams between two 11g databases.
• Monitoring SQL Server databases using QUEST Spotlight and Foglight for performance related issues, recovery of oracle database using RMAN / archive logs.
• Maintenance of Physical standby database, including applying patches to standby databases, RMAN backup, incremental backup, full backup, encrypted backup.
• Setting up flashback for selected databases.
• Installation of GRID control on Sun Solaris and agents on database servers, registering databases to GRID control and monitoring databases from GRID control.
• Installation of Oracle RAC -11gR2 Grid Infrastructure & DB - two nodes on Solaris servers using ASM.
• Installation of Oracle Cloud Control 12c Grid Control on Linux servers and pushing 12c agents to hosts to monitor Oracle products.
• Performance tuning of Oracle databases using OEM 11g and 12c, SQL Tuning Advisors, SQL Plan Baseline and/or stored Outline, Installation of MS SQL Server 2005 on Windows server.
• Creating indexes, sql profiles for better SQL performance tuning in Oracle database.
• Data mining in Oracle 11g, creating encrypted tablespace in oracle 11gR2 using wallet and encrypted key for protection of data.
• Resolving wait events in Oracle, ADDM, AWR, and ASH repots, SQLT, SQLHC reports, RDA.
• Database export using datapump and network link, collecting database stats.
• Installation of Apache on UNIX, LISTSERV mail server on UNIX.
• Disk space management, working with UNIX admin for OS upgrade, OS patches.
• Oracle SGA, PGA tuning based on ADDM reports, increasing SGA for performance.
• Oracle Real Application Testing RAT including Sql Performance Analyzer and Database replay.
• Oracle Golden Gate installation and configuration for replication between two Oracle databases.
• Oracle Golden Gate monitoring using inbuilt java agents.
• Knowledge of Oracle Exadata machine.

Environment: RMAN, OMS, OEM 11g, 12c, Encrypted tablespace, SQL PLAN BASELINE,Sql tuning advisor, Sun Solaris, Data Guard, Physical standby, RAC, streams, MS SQL 2005.

Confidential, IN

Apex Admin / ORACLE DBA

• Oracle 11g R1 Installation on Windows, Oracle Apex 3.2 with Oracle 11g R1.
• Migration of HTML DB to Oracle APEX 3.2 using 11g R1 EPG.
• Export/import 10g database schemas to 11g for APEX application.
• Installation of Apache for APEX 3.2 with Oracle 11g R1.
• Gathering user requirements for APEX application with Oracle 11g database.

Environment: Oracle 10g, Oracle 11g, APEX 3.2, HTML DB, Windows.

Confidential, Rochester, NY

SR ORACLE DBA

• Oracle RAC installation and maintenance, patches on Oracle RAC, physical standby creation, logical standby creation, Oracle replication, Oracle Grid installation, database replication using Shareplex Quest Software .
• Oracle database objects creations, tablespace management, RMAN backup, COLD backup, database recovery, transportable tablespaces, tape backup.
• Management of flash recovery area, archive logs, redo logs, spfile, pfile and profile management, incremental backup scripts, full hot backup scripts, schema comparison between different environments.
• Oracle database patches, CPU patches, other product related patches using OPatch, GUI and silent mode.
• PL/SQL tuning, Server Disk space management, JVM installation, EWR, Sql tuning advisor, ADDM, Segment Advisor of Oracle 10g database, EM console, database console.
• Working knowledge of Oracle streams and monitoring streams using OEM.
• PL/SQL, Oracle stored procedure, functions, packages, TOAD, SQL Developer, triggers, cursors.
• Tablespace usage alerts, listener up/down alerts, disk space usage alerts using OEM and Shell Scripts. Management of UNDO and TEMP tablespaces Non-auto extended .
• Oracle 11g Installation on Sun Solaris 5.9
• Creation of Physical Standby DB of existing primary database, Sftp, lftp, firewall, SCP, Shell Scripts, UNIX cron jobs setup, mailx,Xhost,Display settings, disk space management, directory structure, sudo privileges, audit, server scan, understanding of Internet & Intranet based technologies.
• SVN version control installation and configuration including repository and clients.

Environment: Oracle 11g, Oracle 10g,Sun Solaris, RMAN, PL/ SQL, RAC, GRID, Shell Scripts,Datapump,TOAD,SQL Developer.

Confidential, Columbus, OH

Oracle DBA

• Installation of Oracle 10g R2 on Sun Solaris using DBCA, create Database script.
• Statement retrievals from tape backup to disk.
• Physical database creation, maintenance of physical database, removing log gaps between primary and standby database.
• Large file transfers from primary to standby location using shell script.
• Oracle Apex administration, creating users, workplace, applications, security of Apex application.
• Creating processes for Oracle Apex application, restrictions based on different users.
• Responsible for RMAN backup level0, level1 and level2.
• Oracle Grid Monitoring, blackouts, installation of grid agent, startup and stop OMS.
• UNIX commands and utilities for performance monitoring of OS. Top,vmstat, SAR, grep, ptree, creating and reviewing SAR report and creating a graph of SAR report.
• Applying CRS patches, OPatch patches on different servers.
• Responsible for data compression, expdp,impdp, transportable tablespace
• Restore statements for legal department using shell scripts.
• Developing application for team using Oracle APEX for on call schedule,DCS/IMS information updates, instance registration with grid, end user request for a change. Oracle APEX using PL/SQL to update instance monitoring information, csv file upload and automated creation of table from csv file.
• Installation of ASM and CRS on UNIX.
• Oracle database range partitioning for monthly financial statements.
• Starting and stopping ASM, CRS and RAC database using shell scripts.
• ASM, CRS and creation of database - RAC environment 3 nodes .
• Knowledge of Oracle streams.
• Database tuning using OEM - ASMM, creation of DBconsole repository using EMCA.
• Installation and configuration of 10g Grid.
• Responsible for physical and logical database oracle backup.
• Installation of ASM on Solaris for Oracle 10g R1 and migration of database to ASM instance, adding new disk for ASM instance.

Environment: Sun Solaris, SUSE Linux, Partitioning, Oracle 10g,Oracle 9i, RMAN, EXPDP,IMPDP, PL/ SQL, RAC, GRID, Shell Scripts.

Confidential, Los Angeles, CA

SR. ORACLE DBA

• Installation of Oracle 9i / 10g R2 on AIX 5.2, Installation of AIX 5.2 on IBM Server.
• Configuration of RAID 5 on IBM AIX 5.2
• Adding new hard disk to IBM server and including new disks to RAID 5 array.
• Configuration of RAID 1+0 on IBM AIX 5.2.
• Applying latest Oracle patches for Oracle 9i db and oracle 10g r2 database on AIX 5.2
• Applying Oracle core, CPUXXX patches Oracle Critical Update Patches for 10g Application Server on Solaris, IBM AIX 5.2, oracle 10g database.
• Performance improvement of reports for Oracle 10g R2 Application Server. Oracle database 10.1.0.5.0 and 10.2.0.2.0
• Installation of 3rd party application Onestaff on Windows server Oracle database backend, Installation and configuration of 10g Grid.
• Comparison of schemas of different Oracle databases using TOAD.
• Creating indexes, dropping indexes on database tables using TOAD to improve performance of reports.
• Import / export of database schemas from one database to another database.
• Responsible for IBM Server OS: AIX 5.2 hardening, installation of Open SSH and Open SSL, OS level packages.
• TKPROF, session logs in for Oracle and getting detail output of application at OS level.
• Installation of ASM on AIX 5.2 for Oracle 10g R1 and migration of database to ASM instance, Installation of Application Server on SUSE Linux.
• IBM AIX 5.2 Server Hardening, installation of OpenSSH, configuration of sshd config for sftp, disables telnet, disable ftp, disable root for remote login.
• RMAN for HOT backup of Oracle 10g Database. Backup on disk .
• Working knowledge of primary database, Data Guard broker, standby database.
• Responsible for RMAN backup and recovery using RMAN backup script and recovery through 10g EM console.

Environment: IBM AIX 5.2, Oracle 10g R1, Oracle 9i, RMAN, Oracle Discoverer, PL/ SQL, RAC, GRID, Data Guard, Standby Database.

Confidential, Peoria, IL

ORACLE DBA / SYSTEM ANALYST

• Summary: Oracle 10g, Database upgrade, Migration using data pump, Sun Solaris, Oracle HTML DB, RMAN backup & recovery, PL/SQL, packages, functions, procedures, performance resolution, CRS, ASM, 10g AS, GRID, TOAD, OPATCH.

Confidential, Woodland Hills, CA

ORACLE DBA

• Summary: RMAN backup and recovery, Oracle 10g, TOAD, PL/SQL, ER Studio, OEM, GRID, TKPROF, ADDM, AWR, Database Advisors, SQL Tuning Advisor, APEX, PL/SQL, Form, Reports. Upgrade database to 10g, database migration from Windows to UNIX.

Confidential, Pontiac, IL

ORACLE DBA