SUMMARY

• Oracle Certified Professional having 10+ years of experience in Oracle DBA, mostly in financial environments database, production/development support and ability to learn new technical skills.
• Expert level experience/knowledge in oracle 10gr2 & 11gr1/2 Clusterware, Grid Infrastructure, ASM & database installation, configuration, implementation, administration and patching and upgrade.
• Installation, Configuration & Deployment of Oracle E - Business Suite R11i/R12i
• Strong level experience in oracle 11g/10g/9i database architecture, installation, configuration, implementation and reorganization and troubleshooting in DSS and OLTP databases.
• Strong experiences in oracle11gr1 & r2 /10gr2 DataGuard setup and manage Physical Standby databases and DR test in RAC and single instance environment.
• Expertise in database upgrade from Oracle 9i/10g to 11g and migrate and patching CPU/PSU.
• Expertise in setup and manage database backup/recovery using RMAN and (HOT/COLD) policy wif EMC Symmetrix Remote Data Facility (SRDF) and business continuity BCV.
• Steamily strong experience in database cloning/refresh using RMAN, HOT/COLD backup and database flash Recovery.
• Sound experience in data movement across the oracle database using database export/import, Datapump and transportable tablespaces.
• Strong experience in maintenance and management of databases using OEM Grid Control & 12C Cloud control.
• Experience in database replication tools and techniques, viz. Shareplex (setup & configuration of stream, replication and integration) and Oracle Golden Gate.
• Steamily strong experience in setup schemas, create objects, roles and permission, SQL, triggers, PL/SQL stored procedures, database Partitioning (List, Rage, Hash, Ref, etc.) and create, manage and refresh Materialized View.
• Good experience in database Capacity Planning irrespective to file system, memory, CPU.
• Strong knowledge/experience in data modelling, and SDLC from development to production
• Good experience in MSSQL server 2005/8 installations, database administration, refreshes and replications.
• Sound knowledge / experience in Oracle internal views, shell & SQL, PL/SQL scripting.
• Strong experience working wif oracle support center/service request.
• Sound knowledge/experience database advanced compression and security compliance.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Shell Scripting (ksh, bash, AWK)

Databases: Oracle 11gr1/r2, 10g (GI, RAC & ASM) & 9i/8i and MS SQL server 2005/8

O/S: HP-UNIX, AIX, Red Hat Linux, Solaris and Window NT/2000/3/8 server.

Tools: OCI, RMAN, OEM, SQL*Net, OID, Shareplex, Oracle DB2/SQL Gateway, TOAD, Oracle 12c cloud control, Oracle Golden Gate.

Others: EMC’S SRDF BCV Time finder, PVCS, Net Backup

PROFESSIONAL EXPERIENCE

Confidential, New York NY

Sr. Database Administration

Responsibilities:

• Perform oracle 11gr2 Clusterware, GI, ASM & RDBMS installation, configuration and administration, and apply CPU & PSU patch.
• Setup, configure and administration of Oracle Grid Infrastructure (11gr2) as one node cluster, and multimode cluster
• Perform database upgrade from oracle10g & 11gr1 to oracle11gr2.
• Implemented OW watcher to troubleshoot node evictions.
• Database refresh in RAC and single instance environments using RMAN and active database, HOT/COLD backup.
• Perform database archiving, reorg and compress to data warehouse database.
• Perform change migration development through production database.
• Setup, managed and troubleshoot Physical Standby database using DataGuard, and performed Disaster Recovery (DR) Test.
• Perform database data migration across the database platforms using Data pump.
• Create and manage database partitions, materialized views for multi terabytes data warehouse database
• Worked on database performance tuning using ADDM, AWR, and SQL tuning advisor etc.
• Managed most critical Guardian Anytime application databases, perform change migration development through production.
• Worked wif other teams as UNIX, Storage, application engineering for new changes/resolve issues.
• Worked on oracle 12c cloud control installation documentation, configuration to manage oracle databases.
• Exposed to MS SQL server in window cluster environment.
• Support SQL Instances/database, includes backup/recovery, login creation, data refresh, clustered Environment password changes.
• Setup oracle DB2 Gateway for Heterogeneous data transfer between oracle and DB2 Mainframe/UDB databases.
• Provide 24 X 7 "On-call" supports and closely work wif oracle SR and troubleshoot issue.

Environment: s: Oracle11gr1/r2/10r2/8i, oracle10gr2, Clusterware, Grid Infrastructure, ASM, RMAN, DataGuard, OEM Grid Control & 12C cloud control, Golden Gate, Net Backup, RedHat Linux 4.0/5.0, HPUX, SRDF BCV Sync-split, MS SQL Server 2005/8.

Confidential, New York NY

Sr. Database Administration

Responsibilities:

• Oracle11gr1/r2 RAC, ASM and Clusterware installation, configuration, setup services and patching & upgrade, each cluster had 2 to 5 nodes, and administration.
• Performed oracle10gr2 RAC, ASM & database upgrade to oracle11gr1 RAC, ASM and database.
• Worked on installation and configuration of oracle 12c grid control.
• Worked on performance tuning of Siebel application.
• Changed migration development through production, and managed user securities & accesses.
• Create, configure and manage Physical Standby database in 10g & 11g RAC environment using DataGuard which has number of nodes same as production.
• Worked on configure and setup RMAN backup at level 0, 1 wif NetBackup and Autosys job schedulers.
• Perform database restore, refresh and clone using RMAN and move database across environment using expdp/impdp.
• Worked on data migration from data centre to other data centre.
• Worked on database DR test in DataGuard environments.
• Implemented Golden Gate replication solution.
• Configured initial and incremental load using golden gate.
• Upgraded database from 10.2.0.4 to 11.2.0.3 using Golden Gate.
• Oracle10.2.0.5 Grid Control, OEM agent install, configures and manages in RAC environment.
• Extensively work wif Oracle Support Centre to troubleshooting database performance issues and other various issues.
• Perform 24 x 7 oncall support.

Environment: s: Oracle12c/11gr1/r2, oracle10gr2, ASM, Clusterware, RMAN, OEM Grid Control, MS SQL Server 2005/8, NetBackup, Autosys, RedHat Linux4/5.0, Solaris10, SRDF BCV Sync-split.

Confidential, New York NJ

Sr. Database Administration

Responsibilities:

• Perform oracle database architecture and RDBMS binaries installation, configuration, and administration, version/release upgrade, CPU & PSU patch, database connectivity, and database audit and change management and troubleshooting issues.
• Perform oracle10g/11g RAC, ASM and Clusterware installation, configuration, and administration and apply CPU & PSU patch, version upgrade, and database migration from HPUX to Linux RAC server, refresh using RMAN, and make TAR and troubleshooting.
• Perform database logical & physical design, schemas setup, create and manage objects (Tables, Indexes, and Partition table), Roles, Permission and space management and troubleshooting.
• Worked on Transportable Tablespaces to move data across the environment.
• Create, alter and manage database partitioning (Range, List, composite Range-Hash, and Interval).
• Create, refresh and troubleshoot materialized views.
• Perform database archiving, reorg and compress to data warehouse database.
• Perform database monitoring and tuning by doing query optimization, initialization parameters.
• Perform Change Management development through production database and manage using Remedy Tools.
• Setup and manage oracle10g DataGuard physical Standby and perform Disaster Recovery test.
• Perform and manage database backup/recovery/refresh using RMAN/HOT backup using EMC Symmetrix Remote Data Facility (SRDF) and business continuity BCV Sync/split technology and for disaster recovery test.
• Database clone/refreshes using RMAN/hot backup and data movement using exp/imp and Datapump.
• Perform database version upgrade 10.2.0.3 to 10.2.0.4 and support testing.
• Perform database performance tuning using OEM grid control, Explain Plan, SQL trace, tkprof and SQL tuning advisor and working closely wif application team to troubleshoot the performance issues.
• Perform database replication to DSS data warehouse database from OLTP database using oracle Streams.
• Setup, managed and troubleshoot Physical and Logical Standby database using DataGuard and performed Disaster Recovery (DR) Test.
• Performed database data movement across the database platforms using database export/import (expdp / impdp, exp/imp) and Transportable Tablespaces.
• Closely work wif SRM and UNIX team in Data Centre movement.
• Setup/manage oracle gateway for data transfer into oracle data warehouse database from MS Sql server database.
• Provide 24 X 7 "On-call" support rotation for Oracle database systems, products and services.

Environment: HPUX11.3, RedHat Linux, Oracle 11gr2/10gr2, RAC, ASM, Clusterware, DataGuard, OEM Grid Control, RMAN, Oracle Gateway, MS SQL Server 2005/8, BMC Remedy, EMC SRDF BCV Sync-Split.

Confidential, Secaucus NJ

Database Administration

Responsibilities:

• 24 X 7 Production Oracle database support, administration and on call rotation.
• Worked on oracle 11gR1 two node RAC clustered databases.
• Analyzed business recovery requirements and maintained strategies and plans for critical databases
• Troubleshooting high availability scenarios involving Clustering, Data
• Monitoring various targets through Oracle Enterprise Manager Grid Control.
• Configuring and Monitoring RMAN and Hot backups and performing recoveries.
• Implementing and maintaining of Database Security using auditing for SAS70.
• Applying Critical Patch Update (CPUs) every quarter in rolling mode wif no downtime.
• Worked on database upgrades from 10g to 11gr1.
• Creating table spaces, tables, and users for custom applications.
• Automation of Startup Shutdown on all Production and Development Database.
• Worked on configuration and monitoring standby databases.
• Configured fast refresh for Materialized Views.
• Maintaining schemas and partitioning tables.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced wif Space Management and Security.
• Data refresh from production to stage, test and development.
• Participated in developing backend Oracle batch processes, developed PL/SQL functions, procedures, packages and triggers. Database normalization and Logical and Physical design of database.

Environment: HPUX11.3, RedHat Linux, Oracle 11gr2/10gr2, RAC, ASM, Clusterware, DataGuard, OEM Grid Control, RMAN, Oracle Gateway, MS SQL Server 2005/8, BMC Remedy, EMC SRDF BCV Sync-Split.

Confidential, Glendale, AZ

Oracle DBA/Developer Lead

Responsibilities:

• Worked as Oracle Database Administrator; created database architecture and installations, configuration, administration and support for production/nonproduction environments databases.
• Worked as a lead for ETL team (off shore & on site).
• Responsible to maintain data warehouse database.
• Worked wif ETL team to upgrade informatica powercenter 6.1.2 to 7.1.2.
• Performed database logical & physical design, schemas setup, create and manage objects (Tables, Indexes, Partition table), Roles and Permissions, space management and troubleshooting.
• Security Administration; Creation of new Users, Roles, Permission and maintaining existing users.
• Performed Oracle backup and recovery configuration and procedures using RMAN wif EMC’s SRDF and BCV technology and Timefinder server.
• Setup, managed and troubleshoot Physical and Logical StandBy database using DayaGuard and pperformed Disaster Recovery (DR) Test.
• Perform database refresh/clone using RMAN and HOT/COLD backup.
• Performed database data movement across the database platforms using expdp/impdp, exp/imp and Transportable Tablespaces.
• Setup, managed and troubleshoot database replication using Shareplex to replicate data to data warehouse database from OLTP databases.
• Create and manage database partitioning (Range & List) and materialized views.
• Oracle Database Tuning and Performance - usage of statspack, AWR, ADDM, ASH and UNIX native commands.
• Gather database statistics and move it across the database as it require.
• Provide support for development and production activities simultaneously in a large environment.
• Created and monitor range, and range and hash composite table partitions and local and global index partitions.

Environment: Oracle10g/9i, PeopleSoft Finance 8.8SP1 & HCMS 9.0,People Tools 8.21/8.45/8.48 , Data Guard, OEM Grid Control, RMAN, SQL, PL/SQL, Informatica Powercenter 6.1.2/7.1.2

Confidential, Secaucus NJ

Oracle DBA

Responsibilities:

• Performed oracle server installation, configuration and setup database instance in various OS environment including VERITAS (VCS) cluster system in HP-UNIX and Solaris environment.
• Create and manage user schema, role, access and database objects.
• Performed application change migration development through production.
• Worked on user access control and securities, backup/recovery using (RMAN, HOT, COLD and logical backup) and database refresh, client/server database connectivity, hatcheck, storage & space management, and outage management of databases.
• Database migrate, and upgrade from version 9.2.0.3 to 10.2.0.3.
• Created and refreshed snapshot and materialized views and implemented best security practices for database access, tuning and troubleshooting of databases and UNIX Shell script.
• Database backup/recovery/refresh as policy using (RMAN, HOT, COLD, exp backup).
• Database performance tuning & troubleshooting of long running jobs.
• Database and application DR test and Capacity planning.
• Created and refreshed snapshot and materialized views and implemented best security
• Practices for database access and troubleshooting of databases and UNIX Shell script.
• Performed knowledge transfer to user, documentation and troubleshooting and on call support.

Environment: HP-UNIX, Solaris 8, Linux, Window server NT/2000/3, Oracle10g/9i/8i, SQL Server 2000, OEM, RMAN, StatsPack, NetBackup, Linux and Win 2000 server TOAD, Crontab.

Confidential

Software Engineer

Responsibilities:

• Performed oracle database implementation and administration support for Oracle and MS SQL Server 7.0 databases.
• Oracle server installation, configuration and creating database instances, upgrade, and security (CPU) patches, storage space maintenance, backup and recovery of databases using RMAN, HOT, COLD and exp, client/server connectivity, data archiving and purging, oracle database and application, cloning/refresh, patching using Adpatch, upgrade and database migration using SQL Loader and exp/imp.
• Create schema, user, role, table, index, package, procedure, function, and trigger.
• Database logical and physical design, code migration from development to production and setup AUDIT, users, role and permissions and database security and troubleshooting.

Environment: Oracle 9.2.0.3/8.1.0.7 , SQL*Loader; SQL, PL/SQL, MSSQL Server 2000/7.0, exp/imp utilities.