SUMMARY

• Strong experience working as Oracle Production DBA/Application Support in large - scale high volume OLTP database environment.
• Excellent skills in Database creation, performance Tuning, Backup & Recovery activities (RMAN), installation and upgrade of database, storage management & maintenance on Oracle 11g, 10g, 9i, 8i, 8 and 7.x.
• Exposure in architecting Oracle physical and application database design.
• Extensively involved in Installation, Configuration, Patching, Upgrading and Recovery of Standby Databases on Redhat Linux, Sun Solaris, HP UX and Windows 2003 Platforms.
• Extensive and in depth knowledge about data integration using GoldenGate 11.2 and Shareplex V7.2.
• Expert in loading/unloading high volume data using expdp/impdp utilities.
• Recovered the Database from Index and Datafile corruption issues.
• Fixed cloning issues using RMAN Duplicate command.
• Experience in Optimizing database performance by analyzing database objects, gathering statistics, creating indexes, identify resource consuming and long running queries and provide suggestions/recommendations, checking for any locking/hanging queries.
• Exposure in using utilities like AWR, ASH,TKPROF, ADDM, SQL Tuning Advisor,SQLHC and SQLT.
• Performed Cloning using RMAN Duplicate command as well as using expdp/impdp, export/import, cold and hot backup.
• Implemented and Configured the RMAN setup integrated with Netbackup.
• Implemented Advanced Oracle DB Security TDE (Transparent Data Encryption) and VPD (Virtual Private Database).
• Applying CPU/PSU patch on Primary, Physical standby databases for 11.2.0.4,11.2.0.3 and 10.2.0.4 oracle homes on Linux, Solaris, HP UX and windows environment.
• Hands-on-experience in creating and maintaining Partitions for Large Tables. Supported space Management, patching activities on RAC. Created standby database on RAC supporting MAA (Maximum Availability Architecture). Carried out RMAN setup on RAC systems. Extensively used ASM filesystems.
• Experience in implementing EM 10g Grid Control Release 10.2 for monitoring DB’s and BEA Weblogic Applications.
• Shell Scripting and SQL Scripting to automate, schedule daily tasks on UNIX and Solaris based environments. Keeping Primary and Business Continuity Planning (BCP) side in SYNC and available 24*7 and monitoring the same using shell scripts scheduled on the standby server.
• OS Monitoring of CPU Utilization and its performance with tools like OSWATCHER, OEM, Top and SQL scripts.
• Sound knowledge of Sun Solaris 5.10, HP-UX 11.x, AIX 5.x, RHEL 6.X/5.x and Windows 2003 server
• Worked on Interface/Conversion and has developed normal to complex reports, forms and charts.
• Excellent communication and very good team player.

TECHNICAL SKILLS

Virtualization Operating System: Vmware Vsphere 4.1

Operating Systems: Redhat Enterprise Linux 5.x,6.x Sun Solaris (5.8, 5.10), HP UX (11.11, 11.23,11.31), IBM AIX and Windows 2000/2003Hardware Dell R820 series, Pure storage flash array,Vblock 300 Series, IBM eServer, HP superdome 9000 series, RP2400, RP8400, RP7410, Sunfire 6800, EMC storage Connectrix symmetrix, Veritas storageTek L700e.

Languages: Pro*C 1.6(NT), SQL, PL/SQL, UNIX shell scripting

RDBMS: Oracle 11g(11.2,11.1),10g, RAC, Oracle 10g, 9i, 8i, 8.x, 7.x,Empress.

Tools: & Utilities: Oracle Enterprise Manager Grid Control (10.2,12c), ShareplexV7.2,GoldenGate 11gR2,Streams,RMAN,SQL*Loader, Import/Export,ASM,Datapump,Statspack,AWR,ADDM, ASMCMD,ASMCA,DBCA,NETCA, TKPROF,ASH,SQLT,SQLHC,DBV,SRVCTL,LSNRCTL, CRSCTL,CLUVFY,OCRDUMP,OCRCONFIG,OCRCHECK, VIPCA,CRS STAT,Toad, Putty, Exceed,Xming, SFTP, SCP, Remedy Ears,USD (Universal Service Desk), Informatica Power Center v7.5 ETL tool, Sql Navigator,Vsphere Client,JIRA,Ab Initio ETL tool,HammerDB,Blip,Espresso.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Oracle DBA

Responsibilities:

• Analyzing, capacity planning, building and setting up infrastructure in new Ashburn datacenter which involves coordinating and performing Installation/Configuration/Tuning of Oracle 11gR2 (11.2.0.4) RAC clusters for DEV/E2E/PERF and PROD env (3 Node RAC) and setting up 1 Node RAC for Physical/Logical standby at DR site.
• Planning, coordinating with multiple Infra pool teams and performing cross platform migrations of existing Oracle 10gR2 RAC clusters (10.2.0.5)/AIX 5.1/EMC VNX Storage to Oracle 11gR2 RAC clusters (11.2.0.4)/RHEL 6.4/Pure Storage Flash Array.
• Monitor existing production databases and recommend and assist with tuning activities to help sustain and improve performance and efficiency.
• Tested/Streamlined Backup and recovery process of PROD DB by integrating RMAN backup scripts with Pure storage LUN snapshots, attaching LUNS on to a mount server and bringing up ASM disk groups on mount server. Later cloned PROD DB on the mount server and kicked off RMAN Level0 and Level1 backups, thus offloading the overhead of RMAN backups from PROD nodes onto mount server.
• Automated PROD DB backup process by writing shell scripts which takes care of Pure storage SNAP-COPY-CLONE process, mounting/dismounting ASM disk groups on mount server, starting PROD cloned DB using backup control file on the mount server.
• Implemented bidirectional schema level streams replication between 10gR2 (10.2.0.5) and 11gR2 (11.2.0.4). Extensively used EXPDP/IMPDP utilities for synchronizing schemas,large tables on Target
• Benchmarking Pure storage Flash Array performance by configuring 1/2/3 Node 11gR2 (11.2.0.4) cluster and configuring HammerDB as the load generation tool.
• Worked with Developers and QA team members in troubleshooting application specific Code/Schema/Security changes (PL/SQL,DDL,DML,DCL) into DEV,E2E,PERF env by strictly adhering to ITIL Change Management, Release Management, Incident Management, Problem Management processes
• Manage database security and user access.
• Troubleshooting database performance problems faced by application developers/users with utilities like AWR, TKPROF, ADDM, SQL Tuning Advisor, SQLT and SQLHC.
• Supported space Management, patching activities on RAC (11.2.0.3/11.2.0.4 ). Created standby database on RAC using RMAN Duplicate command. Carried out RMAN setup on RAC systems.
• Resolving syncing issues on Standby Database like stopping managed recovery, transfer archive logs to standby site, perform Manual recovery and start the Managed recovery.
• Keeping Primary and Business Continuity Planning (BCP) side in SYNC and available 24*7 and monitoring the same using shell scripts scheduled on the standby server.
• Actively troubleshooting NODE EVICTION/INSTANCE EVICTION issues by reviewing trace files generated at OS level, OCSSD, CRSD, EVMD, ALERT LOG,OS watcher logs (OSW) and providing RCA (Root Cause Analysis) for EVICTION Issues as well as Resource level debugging.
• OS Monitoring of CPU Utilization and its performance with tools like Graphite/OEM GRID CONTROL, TOP,TOPAS and SQL scripts.
• Worked on creating Interval partition scripts to auto add partitions for next months and delete the partition weekly using shell scripts. Tested the scripts by creating/dropping partition table on DEV/E2E environments.

Environment: Oracle 11gR2 RAC, Oracle streams, PL/SQL, SQL, RMAN, Unix shell scripting, TOAD, Red Hat Enterprise Linux 6.3/6.4, Pure Storage Flash Array, Pure storage Zero Snap, JIRA,HammerDB,Graphite,Blip,Espresso.

Confidential, West Des Moines, IA

Sr. Database Analyst

Responsibilities:

• Manage Configuration and Administration of MODE Oracle 11g RAC Databases.
• Responsible for Oracle RAC,Dataguard, Oracle system architecture,upgrades and implementations.
• Closely worked with data architects for physical as well as application database designing.
• Worked with Developers, ETL Team members and QA team members in deploying application specific Code/Schema/Security changes (PL/SQL,DDL,DML,DCL) into DEV,SIT,UAT,PRODFIX and PROD env by strictly adhering to ITIL Change Management, Release Management, Incident Management, Problem Management processes.
• Streamlined and Optimized schema refresh process by creating shell scripts for exporting data from source schemas from multiple upstream OLTP database env’s and transfering compressed dump files over the network and loading data into MODE target schemas.
• Implemented multiple workstream schemas on DEV,SIT and UAT env that enabled PL/SQL development team,ETL development team, QA testing team and Performance testing team to concurrently work on their own team specific tasks thus increasing throughput for project delivery.
• Implemented Virtual Private Database (VPD) by creating security policies to control database access at the column level.
• Implemented securefile LOBs by using online redefinition method.
• Configured Ab Initio repository on DEV/SIT/UAT/PRODFIX and PROD env’s.
• Administering Shareplex replication using commands like sp cop - s &/shutdown status,qstatus, start/stop capture/post queue’s,troubleshooting replication issues by verifying event log and extensively used EXPDP/IMPDP utilities for synchronizing schemas,large tables on Target before activating shareplex config file on Source, performing Compare/Repair operations on out of sync tables and closely working with Quest Shareplex support.
• Experience in Optimizing database performance by analyzing database objects, gathering statistics, creating indexes, identify resource consuming and long running queries and provide suggestions/recommendations, checking for any locking/hanging queries.
• Supported space Management, patching activities on RAC (11.2.0.3). Created standby database on RAC using RMAN Duplicate command. Carried out RMAN setup on RAC systems.
• Resolving syncing issues on Standby Database like stopping managed recovery, transfer archive logs to standby site, perform Manual recovery and start the Managed recovery.
• Keeping Primary and Business Continuity Planning (BCP) side in SYNC and available 24*7 and monitoring the same using shell scripts scheduled on the standby server.
• Actively troubleshooting NODE EVICTION/INSTANCE EVICTION issues by reviewing trace files generated at OS level, OCSSD, CRSD, EVMD, ALERT LOG,OS watcher logs (OSW) and providing RCA (Root Cause Analysis) for EVICTION Issues as well as Resource level debugging.
• Planned and performed RAC Database upgrade from 11.2.0.2 to 11.2.0.3/RHEL 5.6 on DEV/SIT/UAT/PRODFIX/PROD and BCP env.
• Involved in SWITCHOVER and SWITCHBACK for BCP Simulation activities as and when required using Dataguard.
• Troubleshooting database problems faced by application developers/users with utilities like AWR, TKPROF, ADDM, SQL Tuning Advisor,SQLT and SQLHC.
• Used RMAN commands like crosscheck, delete expired and catalog to fix the RMAN backup jobs.
• OS Monitoring of CPU Utilization and its performance with tools like OEM GRID CONTROL, TOP and SQL scripts.
• Space management operations done on regular basis like Tablespace monitoring, archive space monitoring, going through the audit requirements checks, opening PAC2000 ticket with UNIX team to perform sysadmin tasks.
• Production on call support, troubleshooting, managing and taking care of production databases and customers request round the clock. Used EACO call for emergencies.

Environment: Oracle 11gR2 RAC, PL/SQL, SQL, RMAN, Shell/Perl Scripts, TOAD,NETBACKUP, RHEL 5.6,Shareplex V7.2,Remedy,JIRA,Ab Initio ETL.

Confidential, San Jose, CA

Production Oracle DBA

Responsibilities:

• Configuring Virtual Machines involving provisioning of Compute, Storage,Network resources using Vcenter and installing guest OS RHEL5.4.
• Manage Installation, Configuration and Administration of Oracle 11g(11.2.0.2)/10g(10.2.0.4) Databases on Virtual Machines.
• Administration and maintenance of Test/Production instances of QUAD APP tech stacks.
• Planned and performed Oracle Database upgrade from 10.2.0.4 to 11.2.0.2 on Test and Production env running RHEL 5.4.
• Supported space Management, CPU/PSU patching activities on 11.2.0.2, 10.2.0.4. Created standby database using RMAN Duplicate command.
• Capacity planning before creating database on new server. Suggesting the OFA for the filesystems that will be used for storing data, archivelog and others files.
• Performed Upgrade for QUAD DB stack that involved physical standby database. Ensure before upgrade that necessary packages, patches are installed, kernel parameters are set and has adequate disk space to do the upgrade.
• Database and system monitoring that involved checking of Alert Logs, monitoring File System regularly to keep space available.
• Extensively used EM Db console for monitoring DB performance.
• Implemented and Configured the RMAN setup.
• Used RMAN Duplicate command for cloning and creating physical standby database.
• Troubleshooting database problems faced by application developers/users with utilities like AWR, TKPROF, ADDM, SQL Tuning Advisor and SQL PROFILES.
• Used RMAN commands like crosscheck, delete expired and catalog to fix the RMAN backup jobs.
• Scheduled scripts to autostart and stop the database for Database maintenance jobs, Tablespace and Filesystem monitoring, perform RMAN incremental backups.

Environment: Oracle 11gR2(11.2.0.2)/10g(10.2.0.4), PL/SQL, SQL, RMAN, Shell Scripts, SQL Navigator,NETBACKUP, Red Hat Enterprise Linux 5.6,Vsphere 4.1,Vsphere Client,QUAD.

Confidential, San Francisco, CA

Production Oracle DBA

Responsibilities:

• Manage Installation, Configuration and Administration of Oracle 11g/10gDatabases. Apply Oracle Software patches (CPU/PSU) when required.
• Administration and maintenance of embedded Database “EMPRESS” on branch servers.
• Creation of new Oracle home by installing 11gR2 software and applying the necessary CPU Patches.
• Installed, managed and tuned several mission critical databases.
• Supported space Management, patching activities on RAC (10.2.0.4). Created standby database on RAC using RMAN Duplicate command. Carried out RMAN setup on RAC systems. Exposure of working on ASM, OCFS2 filesystems.
• Configured and created listener and Database on 10gR2 RAC on ASM Filesystem
• Configured Oracle Clusterware (CRS) which provides High Availability (HA) to RAC databases and other applications so it can restart these critical resources either on the same node or relocate them to another node.
• Extensively used Cluster Verification Utility (CLUVFY), the Database Configuration Assistant (DBCA), the Database Upgrade Assistant (DBUA), the Net Configuration Assistant (NETCA), the Virtual Internet Protocol Configuration Assistant (VIPCA), Server Control (SRVCTL) for configuration of RAC environment.
• Configured mirroring for OCR (Oracle cluster Registry) and VOTING DISK by multiplexing these files on multiple mountpoints within the shared storage to avoid single point of failure.
• Actively troubleshooting NODE EVICTION issues by reviewing trace files generated at OS level, OCSSD, CRSD, EVMD, OPROCD and providing RCA (Root Cause Analysis) for EVICTION Issues as well as Resource level debugging.
• Planned and performed Database upgrade from 10.2.0.4 to 11.2.0.1/Solaris 5.10 on Development, Standby (BCP) and Production boxes.
• Performed Upgrade for some critical application that involved standby database. Ensure before upgrade that necessary packages, patches are installed, kernel parameters are set and has adequate disk space to do the upgrade.
• Applied the 10.2.0.4 patchset on Solaris 5.10 platforms.
• Implemented Multimaster Replication on 11.2.0.1 and extensively used EXPDP/IMPDP utilities for synchronizing schemas before implementing replication.
• Recovered the database from index and datafile corruption issues.
• Recover the database from failure to clone the standby database using RMAN duplicate command.
• Involved in SWITCHOVER and SWITCHBACK for BCP Simulation activities as and when required.
• Troubleshooting database problems faced by application developers/users with utilities like AWR, TKPROF, ADDM, SQL Tuning Advisor and SQL PROFILES.
• OS Monitoring of CPU Utilization and its performance with tools like OEM, TOP and SQL scripts.
• Implemented and Configured the RMAN setup.
• Used RMAN Duplicate command for cloning and creating physical standby database.
• Used RMAN commands like crosscheck, delete expired and catalog to fix the RMAN backup jobs.
• Applying CPU security patch on Primary, and physical standby databases for 11.2.0.1 and 10.2.0.4 oracle homes on Solaris and Unix platforms..
• Cloning production database for testing, development, QA environment using EXPDP/IMPDP, cold backup, hot backup and RMAN.
• Create database, create schema, grant required privileges/roles and refresh it from production.
• Capacity planning before creating database on new server. Suggesting the OFA for the filesystems that will be used for storing data, archivelog and others files.
• Keeping Primary and Business Continuity Planning (BCP) side in SYNC and available 24*7 and monitoring the same using shell scripts scheduled on the standby server.
• Scheduled scripts on UNIX boxes to autostart and stop the database for Database maintenance jobs, Tablespace and Filesystem monitoring, perform RMAN Tape backup.
• Resolving syncing issues on Standby Database like stopping managed recovery, transfer archive logs to standby site, perform Manual recovery and start the Managed recovery.
• Space management operations done on regular basis like Tablespace monitoring, archive space monitoring, going through the audit requirements checks, opening PAC2000 ticket with UNIX team to perform sysadmin tasks.
• Production on call support, trouble shooting, managing and taking care of production databases and customers request round the clock. Used EACO call for emergencies.
• Worked on creating partition scripts to add partitions for next months and delete the partition weekly using shell scripts. Tested the scripts by creating/dropping partition table on DEV/UAT environments.

Environment: Oracle 11gR2/10g/9i, PL/SQL, SQL, RMAN, Shell Scripts, TOAD, SQL Navigator, NETBACKUP, HP-UX,AIX and Windows XP, Sun Solaris, Linux.

Confidential

Sr. Technical Support Analyst

Responsibilities:

• Extensively involved in resolving Installation, Configuration, Patching and Upgradation of Oracle 10gR2 RAC databases issues on Linux, Sun Solaris, HP UX and AIX.
• Supported space Management, patching activities on RAC. Created standby database on RAC using RMAN Duplicate command. Carried out RMAN setup on RAC systems. Exposure of working on ASM, OCFS2 filesystems.
• Configured and created listener and Database on 10gR2 RAC on ASM Filesystem.
• Configured Oracle Clusterware (CRS) which provides High Availability (HA) to RAC databases and other applications so it can restart these critical resources either on the same node or relocate them to another node.
• Extensively used Cluster Verification Utility (CLUVFY), the Database Configuration Assistant (DBCA), the Database Upgrade Assistant (DBUA), the Net Configuration Assistant (NETCA), the Virtual Internet Protocol Configuration Assistant (VIPCA), Server Control (SRVCTL) for configuration of RAC environment.
• Configured mirroring for OCR (Oracle cluster Registry) and VOTING DISK by multiplexing these files on multiple mountpoints within the shared storage to avoid single point of failure.
• Actively troubleshooting NODE EVICTION issues by reviewing trace files generated at OS level, OCSSD, CRSD, EVMD, OPROCD and providing RCA (Root Cause Analysis) for EVICTION Issues as well as Resource level debugging.
• Troubleshooting RAC related problems faced by application users with utilities like AWR, TKPROF, ADDM, SQL Tuning Advisor and SQL PROFILES.
• OS Monitoring of CPU Utilization and its performance with tools like OEM, TOP, OSW and SQL scripts.
• Implement RMAN Setup for taking full, incremental backups integrated with Veritas Netbackup.
• Analyze database objects, Gather Statistics, Rebuild indexes, Recompile the invalid objects in the Database
• Performance tuning and analysis using Statspack, AWR Reports, 10046 and 10053 traces.
• Exporting and Importing of Data to different databases using Datapump utility.
• Monitoring of long running queries, database locks, long running sql session, sort space usage etc..
• Database and system monitoring that involved checking of Alert Logs, monitoring File System regularly to keep space available
• Tuning applications using Explain-plan/ SQL-trace/ TKPROF.
• Resolving syncing issues on Standby Database like stopping managed recovery, transfer archive logs to standby site, perform Manual recovery and start the Managed recovery.
• Tuned oracle database parameters for performance.
• Experience in Optimizing database performance by analyzing database objects, gathering statistics, creating indexes, identify resource consuming and long running queries and provide suggestions/recommendations, checking for any locking/hanging queries.
• Responsible for general maintenance of the database including adding storage as necessary, troubleshooting problems, backup and recovery, database creation, cloning and monitoring.
• Extensively worked on reproducing RAC related issues faced by Customers in Lab environments and closely worked with Development team by filing Bugs related to CRS/RAC components.

Confidential, San Francisco, CA

Sr. Oracle DBA

Responsibilities:

• Working with a team of 5 DBA’s and managing about 50+ production and non-production Oracle databases running on various platforms from oracle version 9.x.x to 10.x.x.
• Installed, managed and tuned several mission critical databases.
• Extensively involved in Installation, Configuration, Patching and Upgradation of Oracle databases on Linux, Sun Solaris, HP UX and Windows 2003.
• Carried out the Planning, Migration and Upgradation of ORACLE databases from Oracle 9i to 10gR2 for production and non production Databases in Dataguard environments.
• Planned and performed Database/Platform Upgrade from 9.2.0.8 to 10.2.0.4 and Solaris 5.8 to Solaris 5.10 on Development, Standby (BCP) and Production boxes.
• Performed Upgrade for some critical application that involved standby database. Ensure before upgrade that necessary packages, patches are installed; kernel parameters are set and have adequate disk space to do the upgrade.
• Upgraded database from 9.2.0.8 to 10.2.0.3 on Solaris, HP UX and windows 2003 platforms.
• Applied the 10.2.0.4 patchset on Solaris 5.10 platforms.
• Performed upgrade from 9.2.0.8 to 10.2.0.4 on Solaris 5.10 and Linux RHEL AS3 32-bit that involved standby database.
• Creation of new Oracle home for installing 10gR2 software and applying the necessary patchset for the upgrade.
• Implemented Oracle 10g (10.2) grid control for monitoring Oracle DB’s and BEA Weblogic middle tier Applications.
• Implemented Transparent Data Encryption (TDE) on highly sensitive columns within objects by creating WALLETS.
• Recover the database from failure to clone the standby database using RMAN duplicate command.
• Fixed the installation issues due to corruption in inventory file.
• Extensively involved in fixing the database syncing issues with the standby database.
• Performed Database Reorg activity that involved Primary and Standby database.
• Involved in SWITCHOVER and SWITCHBACK for BCP Simulation activities as and when required.
• Experience in Optimizing database performance by analyzing database objects, gathering statistics, creating indexes, identify resource consuming and long running queries and provide suggestions/recommendations, checking for any locking/hanging queries.
• Troubleshooting database problems faced by application developers/users with utilities like AWR, TKPROF, ADDM, SQL Tuning Advisor and SQL PROFILES.
• OS Monitoring of CPU Utilization and its performance with tools like OEM, TOP and SQL scripts.
• Implemented and Configured the RMAN setup, used RMAN Duplicate command for cloning and creating physical standby database & RMAN commands like crosscheck, delete expired and catalog to fix the RMAN backup jobs.
• Installation of Oracle Management agent on Windows and Unix servers and upgrade the agent from 10.2.0.3 to 10.2.0.4
• Setting blackout for weekend maintenance jobs, set threshold limits for particular metrics, exclude filesystems from monitoring in OEM, modify metrics to avoid unnecessary alerts to on-call DBA and Discover Targets in OEM like database, listener.
• Applying CPU security patch on Primary, and physical standby databases for 10.2.0.3 and 10.2.0.4 oracle homes on Solaris, UNIX and windows environment.
• Configured and created listener and Database on 10gR2 RAC on ASM Filesystem.
• Supported space Management, patching activities on RAC. Created standby database on RAC using RMAN Duplicate command. Carried out RMAN setup on RAC systems. Exposure of working on ASM filesystems.
• Cloning production database for testing, development, QA environment using export/import, cold backup, hot backup and RMAN.
• Converted Database from 32-bit to 64-bit on Redhat Linux 64-bit platform.
• Create database, create schema, grant required privileges/roles and refresh it from production.
• Scheduled scripts on UNIX boxes to autostart and stop the database for Database maintenance jobs, Tablespace and Filesystem monitoring, perform RMAN Disk backup.
• Worked on creating partition scripts to add partitions for next months and delete the partition weekly using shell scripts. Tested the scripts by creating/dropping partition table on DEV/UAT environments.
• Production on call support, trouble shooting, managing and taking care of production databases and customers request round the clock. Used EACO call for emergencies.

Environment: Oracle 10g/9i, PL/SQL, SQL, ORACLE 10g GRID Control, RMAN, Shell Scripts, SQL*Loader, TOAD, SQL Navigator, HP-UX, AIX and Windows XP, Sun Solaris, Linux, Remedy

Confidential

Consultant

Responsibilities:

• Manage Installation, Configuration and Administration of Oracle 10g/9i Databases. Apply Oracle Software patches when required.
• Create database, database objects like table partitioning, index, DB Link, table space, rollback segments, views and analyze relevant objects to collect statistics to tune the system performance.
• Used direct and conventional path methods for SQL Loader to insert data from flat file to oracle tables.
• Optimized Instance parameter settings for Shared Pool, Buffer Pool, Log Buffer, Sort Area and log files, data files on multiple disks to balance I/O.
• Tuned frequently used SQL Statements and PL/SQL Blocks and increased performance.
• Detect Data Block Corruption on system running DB Verify utility, Validate Structure Cascade Command and troubleshoot errors.

Environment: Oracle 10g/9i,PL/SQL, SQL, Shell Scripts,, RMAN, OEM, Linux AS 3, Windows 2000/NT,Toledo, Informatica Power Center 7.3 ( Workflow Monitor module).

Confidential

Oracle DBA

Responsibilities:

• Manage Installation, Configuration and Administration of Oracle 9i/8i Databases and Developer 2000. Apply Oracle Software patches when required.
• Create database, database objects like table, index, DB Link, tablespaces, rollback segments, views and analyze relevant objects to collect statistics to tune the system performance.
• Used direct and conventional path methods for SQL Loader to insert data from flat file to oracle tables.
• Optimized Instance parameter settings for Shared Pool, Buffer Pool, Log Buffer, Sort Area and evenly distribute control files, log files, data files on multiple disks to balance I/O.
• Tuned frequently used SQL Statements and PL/SQL Blocks and increased performance.
• Detect Data Block Corruption on system running DB Verify utility, Validate Structure Cascade Command and troubleshoot errors.
• Test and Implement different physical and logical backup and Recovery methods like crash point in time recovery, Full/partial export/import.
• Automated the scripts for backups, alert checking and Remote archive copying, monitoring and tuning database using cron jobs.

Environment: Oracle 9i/8i, PL/SQL, SQL*Loader, RMAN, NETBACKUP, OEMOracle CRM, Shell Scripts, Sun Solaris 2.8/2.7, Windows 2000/NT

Confidential

Oracle DBA

Responsibilities:

• Performed Business analysis and create High-level design and detail design of the entire process. Up gradation and Migration of Oracle Software.
• Logical and Physical Data Modeling and scripts development using Erwin. Also worked with ER Modeling.
• Design and implement Data warehouse Architecture, which can grow up to 2 terabytes.
• Local and Remote Installation of Oracle Database (10g/9i) on single and multimode systems.
• Installation and configuration of Oracle 10g/9i and implement Oracle 9i/10g new features like Table and Index Partitioning, Parallel Query, RMAN, LOBS, Drop Column, Dynamic SGA, Automatic Undo Management, Oracle Managed Files, Flashback Query.
• Extensively involved with creating Backups & Recovery procedures using Recovery Manager.

Environment: Oracle 9i/8.x, RMAN, PL/SQL, SQL, Shell Scripts, OEM, HP-UX 10.x, Solaris 2.8/2.7, Windows 2000/NT

Confidential

Oracle DBA

Responsibilities:

• Installed and maintained Oracle 8.x/7.x for development, testing and production purposes.
• Performed processes of advanced replication and data synchronization.
• Created and maintained UNIX scripts for Oracle maintenance and statistics.
• Created stored procedures and triggers using PL/SQL for database managing utilizing TOAD developing environment. Worked with SQL queries in Oracle database.
• Utilized Oracle Enterprise Manager for scheduling Alert jobs to provide 24X7 availability and space management.
• Assisted in designing and creating Oracle schema using Rational Rose. Platforms used were Windows NT and Sun Solaris.

Environment: Oracle 8.x/7.x, PL/SQL, SQL, OEM, RMAN, NETBACKUP, Windows NT