SUMMARY

• Over 11+ years as Oracle Database Administrator (Proficient in Oracle Database Administration Activities) like developing customized business applications, database design, database administration and experience on UNIX (Solaris, HP - UX, AIX), Linux, Windows NT 4.0/2000/2003 with Oracle(8.0.5,8i,9i,10g,11g),Developer 6i/9i,Sql net, Sql*Plus, etc.
• Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN (9i/10g), Export, shell scripts for hot/cold backups.
• Hands on Oracle Data guard (9i/10g) both logical & Physical Standby experience on Unix & Windows XP/NT servers.
• Hands on experience of 10g RAC implementation, maintenance and support.
• Expertise in 10g Grid Control.
• Used Oracle 10g streams for Data replication, Data warehouse loading, Event notification as well as business event management.
• Used 10g Data pump (expdp, impdp) and 9i Export Import (exp, imp)
• Extensive experience in Data warehouse environments with Star Schema and SnowFlake Architecture.
• Experience as On-Call 24x7 production DBA support, development DBA.
• Managing team, achieve team and individual targets, addressing any issues of concern.
• Extensive experience with Oracle Database Migration/Upgrade.
• Used Adaptive Cursor Sharing, Management, Automatic Memory Management & Automatic SQL Tuning features Oracle 11g.
• AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Database Replay features of Oracle 11g.
• Strong Knowledge on 11g & 10g Release and New Features (e.g. TDE, Flashback recovery, ASM, 10g/11g Grid control, AWR).
• Strong in data (system) analysis, DBA support of phases of Software Life Cycle (design & development, implementation) in large-scale multi-user (systems) environments.
• Strong experience in tuning database performance from system as well as query tuning perspective.
• Expertise in Creating/troubleshooting/monitoring script, creation of log files, packages & development of scripts for SQL*Loader, Export, Import, PL/SQL.
• Involved in optimizing SQL queries.
• Monitoring and optimizing the Performance of the database, tuning Management, Change Management, capacity planning, and SQL tuning.
• Expertise in Entity/Relation Data Modeling using ER-Win and Designer.
• Used and supported Informatica for ETL Transformations, Discoverer for adhoc query, Crystal Reports for reporting.
• Knowledge of Oracle E-Business Suite.
• Working experience with Very-Large databases (VLDB) up to 4 terabytes, data migration, against Oracle & other databases such as MS Access, SQL Server 2008.
• Managed 480 SQL and 200+ Oracle Production Support Databases with the total size of 3.0+ TB running on 75 SQL and 30 Oracle Instances on Dev/Test and Production Environment.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i/8i/8.x/7.X, SQL Server 2000/2005/2008, MS-Access

Hardware: Sun Sparc E series, HP 9000, IBM RS6000, Compaq, EMC

OS: Sun Solaris, HP-UX,Tru64 UNIX, IBM-AIX, Linux, Windows NT

GUI: Developer 2000(Forms 4.5, Reports 2.5), Developer 6i (Forms 6i, Reports 6i)

DB Tools: OEM, RMAN, Data Pump, Export/Import, SQL Loader, OWB, Oracle 10gAS, Oracle 9iAS,OID, 9i/10g RAC, Data Guard, Toad, DBArtisan, Schema Manager, Space Manager,9i/10g Data Guard, Oracle streams,BMC Patrol.

CASE Tools: ERWIN, Designer 2000/9i

Miscl Tools: Veritas Clusters, Veritas NetBackup, Tivoli Data Protection, Cron Processes, Dameware, Secure CRT, Remedy, VCS, Hummingbird, Actuate reporting, Callidus TrueComp Incentive Management System

Languages: SQL*Plus, PL/SQL, C, Pro*C, Unix Shell Scripting, Perl, csh, ksh, bash

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Senior Database Engineer

Responsibilities:

• Supporting, development and production databases of internal applications.
• Upgraded databases from 11.2.0.2 to 11.2.0.3 with full version upgrade.
• Deploying the database codes thru CVS/SVN control version tool.
• Worked on 11gR2 databases. Implemented new features of Oracle 11g like 11g streams, Automatic Memory Management, Query Result Cache, Read-Only Tables, Secure Files, SQL Access Advisor, SQL Performance Analyzer, and SQL Plan Management.
• Worked in Agile methodology environment in all projects and having daily scrum calls.
• Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof.
• Experience deploying the data models in the databses.
• Worked in conjunction with the development team to fine tune SQL and PL/SQL Code using Execution Plan, SQL TRACE, ANALYZE, DBMS STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Configuring RMAN backups and traditional backups.
• Used Materialized Views (snapshots) for replication of data.
• Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)
• Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Designed new meaningful shared documentation directory .Documented various repeatable ERRORS during on call, this helped lookup and troubleshooting time.
• Implemented backup and recovery thru RMAN tool.
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Automatic Segment Management.
• Deciding and implementing the naming conventions of datafile, redo log files, tablespaces, and segments.
• Knowledge on 12c databases.

Environment: Oracle11g/10g/9i,Linux(RHELAS4),SunE5000,EMC,SQL,PL/SQLUNIXShellScripting,AWR,ADDM, STATSPACK,TOAD

Confidential, San Jose, CA

Senior Oracle DBA

Responsibilities:

• Worked on 11gR2 databases. Implemented new features of Oracle 11g like 11g streams, Automatic Memory Management, Automatic SQL Tuning, AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Query Result Cache, Read-Only Tables, Secure Files, SQL Access Advisor, SQL Performance Analyzer, and SQL Plan Management.
• Implemented Oracle 11g features like Statistics Collection Enhancements, Table Compression Enhancements, Tablespace Encryption, and Temporary Tablespace Enhancements to the Dev/TST/PROD environments successfully.
• Worked on implementation of partitioning for peoplesoft tables had various extensive testing for different partitions.
• Implemented Range, List, Range-List and Hash partitioning.
• Installed Intelligent Agent at target hosts using Agent Download Method.
• Migrated the OMS repository from 10.2.0.3 Grid Control to newly setup 10.2.0.4 Grid Setup Successfully to see the historical reports using new Grid Control.
• Implemented or tuned the used of SQL Aggregation features in the database
• Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof.
• Worked in conjunction with the development team to fine tune SQL and PL/SQL Code using Execution Plan, SQL TRACE, ANALYZE, DBMS STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.
• Implemented RAT (Real Application Testing) for DB replay.
• Recovering the database from Block corruption, Objects-drop and using TSPITR.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Used Materialized Views (snapshots) for replication of data.
• Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)
• Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Setting up and managing RMAN, Hot and Cold Backups, Exports.

Environment: Oracle11g/10g/9i,10gAS,AIX,SQL,PL/SQL,UNIXShellScripting,AWR,ADDM, STATSPACK,TOAD

Confidential, Atlanta, GA

Senior Oracle DBA

Responsibilities:

• Implemented Oracle 11g features like Statistics Collection Enhancements, Table Compression Enhancements, Tablespace Encryption, and Temporary Tablespace Enhancements to the Dev/TST/PROD environments successfully.
• Installed and configured 11g Real Application Cluster (RAC) and added 2 Nodes to make it a 6 Node RAC. Maintaining large OLTP databases on RAC Environment.
• Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups.
• Did Extensive Performance Tuning of RAC Databases including Interconnect Tuning too.
• Installed Intelligent Agent at target hosts using Agent Download Method.
• Migrated the OMS repository from 10.2.0.3 Grid Control to newly setup 10.2.0.4 Grid Setup Successfully to see the historical reports using new Grid Control.
• Implemented and Monitored streams in RAC environment.
• Setup of Oracle two wayreplication using streams.
• Oracle streams. Configuring Streams for High Availability.
• Implemented or tuned the used of SQL Aggregation features in the database
• Daily monitoring and troubleshooting of streams issues.
• Monitoring the status i.e capture and apply rate and latency of streams.
• Generating the streams health check report provided by oracle and status of the streams apply rate and latency graph on daily basis.
• Applied the patch for memory leakage of the Apply server.
• Moving the SCN forward after restore, i.e. restoring the missing archive log from OLTP to reporting server. Executing the apply errors.
• Changing parameters by stopping and starting apply and capture processes as strmadmin user.
• Supported Oracle Exadata Storage Servers and features Smart Scan Processing (Offload processing), EHCC, IORM, Flash Cache etc.
• Enabled/Created Flash Cache for frequently accessed data and index are automatically cached and also for storage index for transparent I/O Elimination with No Overhead.
• Setup notifications on cell node.
• Worked on Exadata disk creation and management.
• Activated IORM plan on each cell node with CELLCLI command line.
• Knowledge on Exadata Hybrid Columnar compression
• Monitored the Cell node alerts from Grid Control.
• Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof.
• Worked in conjunction with the development team to fine tune SQL and PL/SQL Code using Execution Plan, SQL TRACE, ANALYZE, DBMS STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.
• Recovering the database from Block corruption, Objects-drop and using TSPITR.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Used Materialized Views (snapshots) for replication of data.
• Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)
• Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Setting up and managing RMAN, Hot and Cold Backups, Exports.
• Designed new meaningful shared documentation directory .Documented various repeatable ERRORS during on call, this helped lookup and troubleshooting time.

Environment: Oracle11g/10g/9i,10gAS,,Linux(RHELAS4),SunE5000,EMC,SQLServer2005/2000,SQL,PL/SQL,UNIXShellScripting,AWR,ADDM, STATSPACK,TOAD

Confidential, Santa Ana, CA

Senior SAP Oracle DBA

Responsibilities:

• Installed and configured 10g Real Application Cluster (RAC) Maintaining large OLTP databases on RAC Environment.
• Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups.
• Did Extensive Performance Tuning of RAC Databases including Interconnect Tuning too.
• Worked on the Oracle Golden Gate for replication.
• Implemented and Monitored streams in RAC environment.
• Setup of Oracle two wayreplication using Oracle streams. Configuring Streams for High Availability in SAP applications.
• Daily monitoring and troubleshooting of streams issues.
• Monitoring the status i.e capture and apply rate and latency of streams.
• Generating the streams health check report provided by oracle and status of the streams apply rate and latency graph on daily basis.
• Applied the patch for memory leakage of the Apply server.
• Moving the SCN forward after restore, i.e. restoring the missing archive log from OLTP to reporting server. Executing the apply errors.
• Changing parameters by stopping and starting apply and capture processes as strmadmin user.
• Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof.
• Worked on SAP BR Tools, supported SAP system copy/clone.
• Supported Databases for SAP ECC, BW, and SRM etc.
• Worked on the SAP BASIS daily activities like scheduling backups, recovery and performance tuning and diagnosing using the transaction codes like ST04, Sm50, SM51, SM66, STAD reports etc.
• Worked in conjunction with the development team to fine tune SQL and PL/SQL Code using Execution Plan, SQL TRACE, ANALYZE, DBMS STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.
• Recovering the database from Block corruption, Objects-drop and using TSPITR.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)
• Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Integrated RMAN with Veritas Netbackup.

Environment: Oracle11g/10g/9i,10gAS,AIX,Linux(RHELAS4),WindowsNT/2003,SunE5000,EMC,VERITASNetbackup,SQLServer2005/2000,OWB,SQL,PL/SQL,UNIXShellScripting,AWR, ADDM, STATSPACK,TOAD

Confidential, Sunnyvale, CA

Senior Oracle DBA

Responsibilities:

• Manage all primary on-call DBA activities such as checking on table space problems, checking for fragmentation, checking on nightly/weekly backup problems, responding to any Oracle errors, and deadlock conditions
• Produce detailed game plans for monthly or quarterly database partition maintenance tasks
• Build, installed, upgrade and administration of Oracle 9i/10g instances of different dimension. Experienced in managing with features like Oracle Managed Files, Auto Space / Undo Management.
• Monitor and manage Oracle database Security by implementing SOX Policies through OEM
• Oracle Security Management and resolving of user conflicts by controlling access to data and database objects.
• Database Refreshing / Replicating from production site to testing site using hot backup and recreating control file from its trace backup.
• Regular build deployment in non-prod and Prod.
• Involved with aggregation of fact tables. Helped the ETL transformation developers in tuning and scheduling. Helping report developers (Crystal Reports and Discoverer Users).
• Worked with IBM data stage and oracle workflow to design and schedule. Installed and upgraded patches from 10.2.0.1 to 10.2.0.2 Cloning databases using scripts.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• AlarmPoint for monitoring alerts
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Oracle Enterprise Manager Grid Control (OEM GC) for monitoring production Oracle databases
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS JOBS to monitor the database performance.
• Produce the game plans and also write the scripts to perform regular DB reorganizations and SAN space reclamation
• Worked on OS/DB level diagnostics.

Environment: Oracle10g/9i, AIX5.3,EMCSAN,NetbackupFilers,OWB,SQL,PL/SQL,UNIX Shell Scripting, AWR, ADDM, STATSPACK,TOAD, Tivoli Axibase, RAC, ASM.

Confidential, Rhode Island

Oracle DBA

Responsibilities:

• Upgraded Oracle 9i to 10g and 10g to 11g.
• Implemented Oracle 11g features like Statistics Collection Enhancements, Table Compression Enhancements and Temporary Tablespace Enhancements to the Dev/TST/PROD environments successfully.
• Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups.
• Did Extensive Performance Tuning of RAC Databases including Interconnect Tuning too.
• Implemented Automatic Storage Manager (ASM). ASM on EMC SAN, ~10 TB.
• Control for monitoring over 40 Prod / Non Prod Hosts.
• Setup Successfully to see the historical reports using new Grid Control.
• Implemented Oracle Data Guard 10g (Logical and Physical) as Oracle’s data protection, High Availability and disaster recovery solution.
• Installation and Configuration of SQL server 2005 on windows server.
• Implemented Log Shipping for hot standby in SQL server 2005/2008 for High availability.
• Designed data marts using Star Schema (Logical and Physical) Design. Performance tuning using Star Query hint.
• Added and deleted dimensions from Star Schema.
• Involved with aggregation of fact tables. Helped the ETL transformation developers in tuning and scheduling. helping report developers (Crystal Reports and Discoverer Users).
• Worked with Oracle Warehouse Builder (OWB) and oracle workflow to design and schedule. Installed and upgraded patches from 10.2.0.1 to 10.2.0.2 and also managed OWB repositories, import export MDL files.
• Providing backup and recovery strategies, setting up and implementing the backup & recovery procedures for Oracle9i/10g databases.
• Worked in conjunction with the development team to fine tune SQL and PL/SQL Code using Execution Plan, SQL TRACE, ANALYZE, DBMS STATS and evaluating and monitoring database to resolve performance issues including troubleshooting errors, recovering database and failures as needed.
• Recovering the database from Block corruption, Objects-drop and using TSPITR.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Used Materialized Views (snapshots) for replication of data.
• Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure)
• Database refresh/replication from Production to Testing, Development, QA, & ITG Environments using RMAN / Data Guard / Hot Back-ups and Schema level Exports / Data Pumps.
• Provide Primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Interacting with developers in identifying the requirements and designing and implementing the database schema model.
• Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility, integrity and security of all databases by strictly following the SOX -policies and procedures and documentation of every step.
• Optimizing stored procedures and long running queries using indexing, hints, Business Logic/Requirements and query optimization techniques.
• Using Data Transformation Services - ETL loads from Production to Warehouse environments.
• Downsizing, Defragmentation / Reorganization of VLDBs Using Export/ Import, Data Pump, cloning them using RMAN Duplicate features.
• Created users, db links and grant privileges according to the requirements.
• Create Database maintenance plans, including updating statistics, re-indexing, structure modification,capacity planning and index analysis.Maintenance of system Documentation.
• Developed shell scripts and PL/SQL procedures and scheduled Cron jobs and DBMS JOBS to monitor the database performance.
• Mentoring the DBA team and imparting various DBA trainings .Helping in day to day activities.
• Rendering 24*7 on call production DBA support

Environment: Oracle11g/10g/9i,10gAS,AIX,Linux(RHELAS4),WindowsNT/2003,SunE5000,EMC,VERITASNetbackup,SQLServer2005/2000,OWB,SQL,PL/SQL,UNIXShellScripting,AWR, ADDM, STATSPACK,TOAD

Confidential, Piscataway, NJ

Oracle DBA

Responsibilities:

• Installed Oracle 10.2.0.3 on Production DB Servers, applied Patches to fix the known bugs and Upgraded 15 production databases sizing between 700GB and 5 TB from Oracle 9.2.0.7 to 10.2.0.3.
• Implemented the Oracle 10.2.0.3 Physical Data Guard in Maximum Performance Mode
• Implemented the 4 Node Oracle 10g RAC on Sun Cluster and did all the trouble shooting to make the CRS and RAC Setup a stable one.
• Implemented the MAA (Maximum Availability Architecture) having 10g Physical Data Guard for 4 Node RAC System.
• Installed Oracle Clusterware CRS, Clustered Install of Oracle 10g, applying patches in clustered environments, created database / instances using DBCA on a four node cluster, troubleshooted RAC at OS / OCR / CRS / DB Level.
• Installed & Configured Oracle 10g Grid Control.
• Member of SOX team in implementing security on DB side.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Provided Support for 70 Production Databases and 40 Test Databases. Managed 600+ concurrent users.
• Installation & configuration of 9iAS/10gAS for Single sign on (SSO).Well versed with OID/LDAP configuration & troubleshooting.
• Involved in Database Upgrade/Migration from 9i to 10g, Server Patching at O/S and Database Level.
• Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof.
• Recovering the database from Block corruption, Objects-drop and using TSPITR.
• Involved in Level 2 and 3 Technical Supports in a Multi-Vendor Unix/Linux Environments.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Monitoring logs, alerts, managing Batch Jobs (Alteration, Automation, Tuning, Failure).
• Integrated Virtual tape backup (Oracle secure backup) with RMAN.
• Integrated RMAN with Veritas Netbackup.
• Database refresh/replication from Production to Testing, Development, QA, & ITG Environments using RMAN / Data Guard / Hot Back-ups and Schema level Exports / Data Pumps.
• Working with BLOBS and CLOBS, Materialized Views with Query Rewrite, Bitmapped Indexes etc.
• Diskgroups on RHEL Linux 4.0, 5.0
• Responsible for monitoring and optimizing all database performance including the design, creation and structural integrity of database objects in the production environment.
• Installation, Setup and Configuration of Physical Standby database.
• Planned, Scheduled and assisted in implementation of Infrastructure enhancements, patches and upgrades from design, development, test, pilot, production and demo environments.
• Interacting with developers in identifying the requirements and designing and implementing the database schema model.
• Designed data marts using Star Schema (Logical and Physical) Design. Performance tuning using Star Query hint.
• Added and deleted dimensions from Star Schema.
• Involved with aggregation of fact tables. Helped the ETL transformation developers in tuning and scheduling.
• Worked with Oracle Warehouse Builder (OWB) and oracle workflow to design and schedule. Installed and upgraded patches from 10.2.0.1 to 10.2.0.2 and also managed OWB repositories, import export MDL files.
• Using Data Transformation services - ETL loads from Production to Warehouse environments.
• Downsizing, Defragmentation/Reorganization of VLDBs Using Export/ Import, Data Pump, cloning them using RMAN Duplicate features.
• Designing strategy for Application version upgrades & effective co-ordination with different teams (Offshore / Onsite) during deployment.
• Rendering 24*7 On call Production database support.

Environment: SunSolaris9,10,AIX,Linux(RHELAS4),HPUX11.0,Tru645.1BWindowsNT,SunE5000,EMC,VERITAS Netbackup, Oracle (10g/9i), SQL Server 2005/2000, OWB,Erwin,BMC Patrol, PL/SQL, SQL Scripting, UNIX Shell Scripting, AWR, ADDM, STATSPACK, DBArtisan, TOAD

Confidential, Cypress, CA

Oracle DBA

Responsibilities:

• Creation and setup of Dev/TEST/QA environment from Production database
• Installation, Upgrade and Configuration of Oracle 9i, 10g and 10g EM.
• Installation, Configure, setup of 10g RAC.
• Add new nodes to RAC 10g Cluster to distribute the load
• Performed several RDBMS upgrades from 8i to 9i, 8i to 10G, 9i to 10G on HP 64 bit platforms.
• Setting up and Auditing RMAN Hot and Cold Backups, Exports.
• Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).
• Installation of Oracle 10g, creating database, users.
• Migration of Oracle Databases from Solaris to IBM AIX 5.3.
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager), Statspack, and V$ dynamic views.
• Installed and configured OEM and RMAN.
• Automates failover of applications within a data center or to remote data centers. Allows administrators to monitor, manage, and report on multiple Veritas clusters on different platforms from a single web-based console.
• Worked with Oracle Warehouse Builder (OWB) and oracle workflow to design and schedule. Installed and upgraded patches from 10.2.0.1 to 10.2.0.2.
• Provides disaster recovery testing without affecting the primary environment.
• Used DataStage Designer for developing various jobs to extract, cleansing, transforming, integrating and loading data into Data Warehouse.
• Installation, setup and configuration of logical and physical Standby Database using DataGuard.
• Assist with database tuning and best practices involving OS level tuning, SGA tuning, SQl Tuning and considering other contention / IO issues.
• Data Replication, Event Management and Notification,Data Warehouse Loading, Data Protection .
• Involved in Perl Scripting
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication.
• Extensive Performance Tuning, Memory (SGA) Tuning, etc.
• Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE DBMS STATS and evaluating & monitoring database to resolve performance issues including troubleshooting errors, recovering databases and failures as needed.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Database Refreshing / Replication from production to testing using hot backup.
• Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Rendering 24*7 Oncall Production database support.
• Worked on ETL tools like OWB (Oracle Warehouse Builder), and managed OWB repositories, import export MDL files.

Environment: Linux (RHEL), Sun Solaris, HP-UX 11.0,Tru 64 5.1B, AIX 5.3, Windows NT, Sun E5000, SAN, VERITAS, Oracle (10g/9i), SQLServer2005/2000,OWB,Erwin,BMC Patrol,PL/SQL, SQL Scripting, UNIX Shell Scripting, STATSPACK, DBArtisan

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Setting and Installing 10g RMAN and 10g OEM.
• Implementation of 10g RAC.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Installing and configuring Recovery Manager (RMAN).
• Cloning databases using scripts as well as RMAN.
• Installed and configured RMAN for 8i, 9i and 10g.
• Installation, setup and configuration of Data guard.
• Configuration, maintenance and tuning of Oracle 9iRAC and 10gRAC.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.
• Applying patches both Server side and Client side.
• Setting up new environments (Development, Production etc).
• Upgrading to Oracle Server 8i and then to 9i/10g.
• Migration of Oracle Databases from IBM AIX 5.1 to Linux.
• Installation, Upgrade and Configuration of Oracle (8i, 9i, 10g).
• Installed and created 10g databases and 10g OEM.
• Involved in Database design & Data modeling using ERWIN.
• Physical and Logical Database Modeling, including ER Diagrams and Normalization.
• Taking Hot and Cold Backups, Exports etc.

Environment: Oracle Server 10g/9i,SQL Server 2000, OEM, HP-UX 11i,Tru 64 5.1, Sun Solaris5.9, IBM AIX 5.1,Linux Red Hat, Veritas Clusters Failover, Net Backup

Confidential, Newark, NJ

Oracle DBA

Responsibilities:

• Applying patches both Server side and Client side.
• Cloning databases for QA and testing
• Scheduling and Managing Hot and Cold Backups, Logical Backups using Export/Import
• Setting and Installing Oracle 9i Enterprise Manager
• Creating and altering the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, passwords(security).
• Designed data marts using Star Schema (Logical and Physical) Design.
• Managing Datawarehouse databases. Helped the ETL transformation developers in tuning and scheduling
• Database Sizing,Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
• Defragmentation and Reorganizzation of database
• Deciding and implementing the naming conventions of datafile, redo log files, tablespaces, and segments.
• Writing scripts for backup and recovery, Import and export procedure.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases.

Environment: Orasssscle8i/9i,OEM,SQL*Plus,PL/SQL,Tru645.1,SunSolaris5.8,SunSparce3200e2400e800,Windws NT