SUMMARY:

• 8 years of IT work experience in Database administration on windows, RHEL, Sun Solaris, HP - UX and IBM-AIX platforms in Oracle 12c/11g/10g/9i versions.
• Experience in Oracle Database Administration includes installation, upgrade, migration and support 12c, 11g, 10g, and 9i databases and grid control (OEM 12c/11g/10g) for database monitoring.
• Experience in installing and supporting Oracle RAC- ONE (11g) and RAC (12c, 11g and 1og) with Multi node Cluster on Shared and ASM file system. Used SAN, XP and Netapp storage.
• Experience in working with SCAN LISTERNER in grid infrastructure (new features in oracle 11g and above) and used SRVCTL to create and manages services in RAC environment.
• Knowledge and Level 1 support (creating users, objects, granting privileges, installing NZ client in app servers) in Netezza databases.
• Experience in install and support database replication using dataguard and shareplex for disaster recovery. Exposure to goldengate replication.
• Hands on experience in using different tools like TOAD, DBARTISAN (8.7.2), DBCONTROL, SQL developer, QuestFoglight and GRID CONTROL.
• Experience in testing backups at DR sites using RMAN and tested the switchover and failver of standby databases using dataguard broker.
• Experience in applying changes to database objects such as Tables, Indexes, partitioned tables, Views, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Experience in backup and recovery (full and point in time) using RMAN and BCV.
• Hands on experience in export and import of Database objects, schemas and databases using exp/imp utilities and expdp /impdp Utilities.
• Hands on experience in upgrading the databases from 9i, 10g and 11g to 12c and solved the issued during and after upgrade and also applied PSU patches.
• Hands on experience in migrating the databases from one server (with same and different endian) using RMAN. Also used expdp/impdp utilities to migrate the database at schema level.
• Efficiently handled Space Management, Size and Capacity Planning in different versions of Oracle Databases.
• Experience in Oracle Performance Tuning like sql tuning and instance tuning using OEM, TOAD, AWR, SQLT, ADDM, TKPROF, EXPLAINPLAN and STATSPACK.
• Performed fine tuning by creating indexes, partitioning tables, partitioning the indexes.
• Handled the large database with size up to 15 TB on different platforms like AIX, RHEL AND HP-UNIX.
• Experience in creating the sizing document for storage as per the data provided by application team and also in preparing the documentation for all implementations.
• Coordinated with project management, application team and system management teams for new application releases and provided on call support on 24x7 on rotation basis.
• Good communication, organizational and interpersonal skills.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i.

Languages: C, C++, SQL, PL/SQL, HTML, DHTML, XML, Java Script, Assembly Language, UNIX shell scripting, Perl Scripting.

Tools: Oracle forms and reports, Toad, RMAN, Data Guard, OEM, SQL*NET, Import/Export, Data pump Import/Export, STATSPACK, SQL*Loader, SQL*PLUS, Erwin, Designer 2000, Clusterware, VERITAS.

Platforms: Windows Vista/XP/ 2008/2003/2000/98/ NT, Red Hat Linux (4.0, 5.5 SLES/SUSE), HP-UX, AIX, Sun Solaris, IBM-AIX.

PROFESSIONAL EXPERIENCE:

Confidential, CARLSTADT, NJ

Sr.Oracle DBA

Environment: Oracle 12c/11g/10g/9i, Netezza, DB2, GRID CONTROL (12c, 10g), TIDAL, RAC, RHEL (7.0), AIX (7.1), HP-UX, Windows (2008, 2003), SHAREPLEX, ASM.

Responsibilities:

• Responsible for Installing and support standalone, Multitenant (CDB and non-CDB) and RAC databases in 12c, 11g and 10g running on RHEL (7.0), AIX (7.1) and Windows (2008R2 and 2012R2) operating systems.
• Responsible for migrating grid control from 10g (10.2.0.5 OMS and 10.1.0.4 repository database) to 12c (12.1.0.4 OMS and 11.2.0.2 repository database).
• Installed and supported the database replication using dataguard and shareplex for disaster recovery and coordinated with the application team for testing the disaster recovery every year. Implemented and tested the Goldengate replication.
• Migrated 11g databases from HP-UX to AIX (7.1) using RMAN transportable tablespace and upgraded standalone and RAC databases databases from 11g to 12c. Involved in SAP database upgrade (from 11.2.0.4 to 12.1.0.2).
• Coordinated with application teams for downtime to apply the quarterly PSU and JVM patches. Applied the rollover patches (PSU) on RAC databases.
• Created, tested and implemented the TAF (Transparent Application Failover) services in RAC env. Also tested the load balance on RAC databases.
• Used ASMCA to create and manage (add, remove and rebalance) ASM diskgroups. Used SRVCTL, CRSCTL utilities to monitor and manage the RAC services.
• Coordinated with UNIX team to setup the BCV backup for databases running on AIX and tested the backups using RMAN. Used RMAN backup on
• Have setup databases backup using RMAN and BCV. Tested the backups and refreshed DEV and QA databases from PRD using rman. Also, used datapump (expdp & impdp) utilities to refresh schemas/tables between the env.
• Have used TIDAL jobs to schedule the database backups (Physical and Logical) and stats collection. Worked with HP-Openview team to setup the database monitoring and tested the alerts generation by HP-Openview.
• Deploy the changes requested by the application teams. Developed shell scripts for database backup, stats collection, tablespace monitoring and rotate the logfiles.
• Created oracle wallets for application service accounts to login without typing/hardcoding the passwords. Coordinated with application users in testing the database connection using wallet.
• Responsible for user management like creating users, creating roles, granting roles and privileges and creating profiles and granting them as per need.
• Created users, objects and granted required privileges and roles in Netezza databases. Loaded the external data from flat files to Netezza database using nzload.
• Support multiple databases of medium to high complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
• Have used different tools like TOAD, SQL Developer, SQLT, EXPLAIN PLAN, AWR, ADDM, STATSPACK, QUEST FOGLIGHT, Oracle enterprise manager (GRID CONTROL) 10g and 12c to monitor the databases and solve the performance issues.

Confidential, NYC, NY

Sr.Oracle DBA

Environment: Oracle 11g/10g/9i, TOAD, GRID CONTROL(11g,12c), STATSPACK, DATAGUARD, ODA, Golden Gate, EXADATA, AWR, RHEL(5.8), WEBLOGIC, ASM, PeopleSoft, RAC,RAC-ONE.

Responsibilities:

• Responsible for installing, supporting the oracle stand alone, RAC(2node), RAC-ONE databases of the version 11g on RHEL 5.8 and Windows 2008.
• Responsible for installing Oracle Enterprise Manger (OEM 12C) and setup email notification and rules of database monitoring alerts.
• Created RAC and RAC-ONE database on ASM file system on SAN storage and on shared file system and supported RAC databases running on ODA.
• Responsible for creating the disk groups and adding disks to diskgroups in ASM filesystem. Also, used v$views and ASMCMD utility to maintain and monitor ASM.
• Have used SCAN LISTENER (new feature in 11g) for load balancing in RAC environment and created services using SRVCTL to connect to RAC preferred instance.
• Worked on installing the data guard on RAC databases for disaster recovery and setup the dataguard broker. Tested the dataguard switchover on the RAC databases manually and also using dataguard broker.
• Worked on resolving the gap between primary and standby databases in dataguard by registering the missing archive logs in the standby database.
• Worked on setting up the flashback and restore points on the databases and also flashbacked the databases to restore point when required.
• Applied PSU and CPU patches manually. Worked on installing the Rollover patches for RAC databases.
• Kept tracking the database performance using oracle enterprise manager and checked the user sessions which consumes more CPU and taken the necessary steps to reduce the CPU usage.
• Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp. Also used datapump utilities for migrating the databases to 11gr2.
• Refreshed and cloned the databases from PROD to UAT, QA, and DEV using RMAN.
• Monitored the databases and added the data files to the tablespaces or resized the tablespaces and monitored the sessions running on the databases.
• Upgraded the databases from 10g to 11gr2 and resolved the issues during and after upgrade.
• Responsible for deploying and monitoring the daily jobs and resolving and finding reasons for failed jobs.
• Perform production system problem analysis and recommend corrective measures in a timely manner.

Confidential, WOONSOCKET, RI

Sr.Oracle DBA

Environment: Oracle 11g/10g/9i, TOAD, GRID CONTROL(11g), STATSPACK, DATAGURD, AWR, IBM-AIX(6.1), RHEL(5.5), WEBLOGIC, STREAMS, EXADATA, ASM, PeopleSoft, RAC,RAC-ONE.

Responsibilities:

• Responsible for installing RAC (grid infrastructure 11g), RAC-ONE (11g), standalone databases (11g) on ASM file system on AIX (6.1) and RHEL (5.5) on SAN storage.
• Migrated the databases from NON-ASM to ASM filesystem and on to different server using RMAN backup and recovery and upgraded the databases from 10.2.0.4 and 11.1.0.7 to 11.2.0.3 during migration.
• Used utilities like ASMCMD, ASMCA for monitoring and maintain the ASM file system. Used ASMCA and sql command prompt to alter disks from and to ASM disk groups.
• Have used v$views to monitor the disks rebalancing in ASM filesystem with necessary rebalance power and controlled the rebalancing with rebalance power parameter.
• Worked on scan listener, used SRVCTL to create and maintain the services on RAC-ONE and RAC databases.
• Used utilities like DGMGRL, SRVCTL, CRSCTL, CLUVFY, TOAD, and GRID CONTROL for monitoring and maintain the databases.
• Upgraded the databases from 10.2.0.4 to 11.2.0.2 and from 11.2.0.2 to 11.2.0.3. Resolved the issues during and after upgrade.
• Installed the data guard (11g) for disaster recovery and enabled the dataguard broker. Tested the read only feature (11g) on standby databases, switch over & switch back and failover scenarios using dataguard broker utility DGMGRL and also using GRID CONTROL.
• Responsible for scheduling RMAN backups in prod and non-prod environments. Worked with TSM team to find the reasons in case of backup failure.
• Validated the backup before the restore and recovering the databases using RMAN. Restored and recovered (point in time recovery and full recovery) the databases using RMAN when necessary.
• Refreshed the objects, schemas, databases using exp&imp and expdp&impdp utilities. Also used RMAN to refresh the databases from prod to non-prod environments. Have used ASM and NON-ASM filesystem for export and RMAN backup.
• Created the triggers to generate the trace (for oracle SR'S) for sessions causing the performance issues. Debugged the root cause for invalid packages, triggers and views.
• Worked on movement of objects from one tablespace to another and worked partitioning the tables based on range to improve the performance.
• Worked with oracle to resolve the issues caused during the refresh of the materialized views and performance problems after migrating and upgrading the databases to 11g.
• Responsible for creating the databases users and grant the necessary privileges. Created the wallets for batch jobs and tested wallets. Resolved the issues causing the login issues using wallets.

Confidential, BOSTON, MA

Oracle DBA

Environment: Oracle 11g/10g/9i, TOAD, DBARTISAN(8.7.2), DBCONTROL, GRID CONTROL(11g), STATSPACK, DATAGUARD, AWR, SUN SOLARIS(10), RHEL(5.5), WINDOWS(2008), AIX(5.3), PeopleSoft, E-business, Trading, WebSphere, Java, EXADATA.

Responsibilities:

• Responsible for installing, supporting the oracle stand alone, RAC(2node) and RAC(2node) with dataguard databases of the version 11g, 10g and 9i on Sun Solaris 10, RHEL 5.5, AIX 5.3 and Windows 2008.
• Used VERITAS Cluster File System (VCFS), ASM file system and SCAN LISTENER in installing Oracle 11g RAC and also installed oracle grid agents on standalone and RAC databases.
• Have used ASMCA to add or remove disks from diskgroups in ASM fielsystem. Used v$views to monitor the disks rebalancing in diskgroup after adding disks to diskgroup.
• Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.
• Worked on resolving the gap between primary and standby databases in dataguard by registering the missing archive logs in the standby database.
• Worked on installing CPU patches manually and also using enterprise manager grid control. Worked on installing the Rollover patches for RAC databases.
• Worked on refreshing the objects using exp & imp and also using expdp & impdp. Refreshed the databases from PROD to UAT, QA, and DEV using RMAN.
• Worked on DR tests using dataguard and VVR, resolved the issues during switch over and switch back.
• Migrated the databases from 9i and 10g to 11gr2 from Solaris 1o to RHEL 5.5. Supported PeopleSoft applications as backup dba.
• Recovered the databases (full recovery) during database upgrade and point in time recovery as per the user request using RMAN.
• Created the dblinks (private and public), synonyms (private and public) and views. Validated the views and compiled the views which are invalid.
• Have used different tools like TOAD (10.6), DBArtisan (8.7.2), EXPLAIN PLAN, AWR, ADDM, Tkprof, STATSPACK, Oracle enterprise manager (GRID CONTROL) 11g to solve the performance issues.
• Helped developer in installing Oracle Client, troubleshoot and establish the connection to Oracle database through JDBC.
• Responsible for monitoring RMAN backup jobs and analyze tables and indexes of Oracle database periodically for better performance.
• Responsible for monitoring the daily jobs and resolving and finding reasons for failed jobs.
• Perform production system problem analysis and recommend corrective measures in a timely manner.

Confidential, Parsippany, NJ

Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD(10.1), Recovery Manager (RMAN), Tivoli, Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, AIX-5.3, E-business, JAVA.

Responsibilities:

• Responsible for installing(manually), maintaining, performance tuning, and monitoring of Oracle databases version 10g and 11g on AIX-5.3 in dev, QA, test and production.
• Worked with developers and management team to ensure smooth life cycle progress from development through testing and production implementation.
• Extensively worked with dba jobs, dba scheduler jobs, functions, procedures and packages.
• Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned the tables and indexes for better performance.
• Have used different tools like TOAD (10.1), EXPLAIN PLAN, AWR, ADDM Oracle enterprise manager (GRID CONTROL) 10.2.0.4 to solve the performance issues.
• Kept tracking the database performance using oracle enterprise manager and checking the users sessions which consuming more CPU and taken the necessary steps to reduce the CPU usage.
• Analyzed the tables and indexes manually whenever required. Manually refreshed the materialized views (used for replication) whenever the job fails to refresh them.
• Created new schemas, tables, indexes, jobs, tablespaces and granting the privileges to the user as per demand and also written pl/sql code to delete million rows by committing after every 10,000 rows.
• Monitored and checked the invalid objects like jobs, procedures etc and recompiled manually after solving the problem for objects to become invalid.
• Deployed the patches for grid agent and oms for the version 10.2.0.4 and troubleshooted the problems in uploading agent and securing agent.

Confidential, Manhattan, NY

Oracle DBA

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), SQL*Loader, RMAN, STATSPACK, Data Guard, Shell Scripts, Grid Control, AWR, ADDM, HTML, DHTML, Windows 2008, RHEL 4.0, HP-UX 11.0.

Responsibilities:

• Responsible for administration and supporting Oracle 11g and 10g databases on 24x7.
• Upgraded the databases from Oracle 10.2.0.4 to 11.2 and implemented the dataguard on 11g databases. Installed the RAC on 10gR2 and 11g databases.
• Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.
• Setting and troubleshooting of oracle listener, network connection, user security and administration. Tuning for optimum performance like SQL tuning.
• Worked on import/export, import/export Data Pump and SQL- loader and also worked with RMAN backup and recovery.
• Tested the standby databases during switchover and failover scenarios and also tested the flashback feature on 11g dataguard and also worked on flash back recovery in recovering the tables, tablespaces, datablocks etc.
• Experienced in changing the modes of the databases and also maintaining or changing the time lag for a database in dataguard.
• Documented the upgradation, installation of dataguard and necessary steps to follow for database recovery using RMAN.