SUMMARY

• 7 years of experience with Oracle 11g/10g/9i/8i Installation on Linux, Sun Solaris, IBM AIX, HP - UX and Windows NT/2000/2003, Administration, Migration, Monitoring, Performance Tuning, Database Backup and Recovery
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM)
• Experience in installing, configuring and maintenance of Oracle Golden Gate and DataGuard
• Experience in providing 24/7 on-call support for both development and production databases.
• Experience in upgrading Database from 9i to 10g, 10g to 11g
• Implemented Best Practices for Maintenance, Monitoring, Backup/Recovery, Growth Management, Contention Resolution, Defrag etc. scenarios for the various Environments
• Knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM)
• Monitored performance and availability of the VIS application a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN
• Worked extensively with Oracle RDBMS; Comfortable with SQL, PL/SQL, and developing various Data Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc.
• Migrated single instance databases to multinode 10g RAC environment for high availability and load balancing
• Experience in Oracle 9i and 10g RAC environments using the OEM Grid Control tools
• Migration of Database from RHEL 4 to Sun Solaris and applying patches whenever required.
• Experience in Platform migration from SOLARIS to AIX
• Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target
• Good Intensive Knowledge in using operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT
• Experience using Oracle 10g Flashback on Database, Drop & Table features
• Proficient with 11g new features: Active Datagaurd, configuring Snapshot standby database.
• Working experience in both OLTP and Data warehousing environments
• Worked with z/OS 1.12 and OEM Grid Control to implement and maintain database functionality.
• Experience in Data Compression, table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM
• Install, maintain, enhance and intercede in Oracle 11G and 10.xG under Solaris 8.x working with Oracle Financials and utilizing Perl scripting for utility maintenance and enhancement
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities
• Knowledge on Oracle Support processes for technical requests with Metalink
• Expertise in creating and scheduling jobs through OEM
• Experience in providing support for development and testing environment
• Transferred compressed files on FTP servers, on UNIX platform
• Demonstrated ability to quickly adapt to new environments and to continuously learn and apply new technologies. Ability to work independently with minimum supervision in a team environment
• Automated Rebuilding indexes, Partition additions and space additions
• Transferred compressed files on FTP servers, on UNIX platform
• Highly motivated, results-oriented, self-driven IT professional
• Has good experience in SQL Server Clustering and MSSQL Server 2000/2005 Log Shipping, Database Mirroring.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i, Oracle 10g Real Application Cluster (RAC), ASM

Operating Systems: HP-UX 10.x,11.x, Sun Solaris 2.5,2.6,8,9,10, AIX 5.1,5.2, Red Hat Linux 2.1,3.x,4.x and windows 98/ME/NT/2000/XP

Languages: C, Java, PHP, XSLT,XML, SQL, PL/SQL, UNIX Shell Scripting.

Oracle Tools and Utilities: RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Web Technology: Web Portals, BMC Remedy, HP Quality Center .

Packages: Macromedia Flash, Dream-weaver, MS Office, Joomla.

PROFESSIONAL EXPERIENCE

Confidential, Temple Terrace, Florida

Oracle DBA

Responsibilities:

• Involved in the installation, configuration and support of Oracle 11g R2 databases.
• Installed Oracle 10g on Production DB Servers, applied Opatch to fix the known bugs.
• Upgraded Grid Infrastructure and Database from 11.2.0.2 to 11.2.0.3.
• Worked with SAN admins on EMC SRDF technology to provide replication and disaster recovery solutions for mission critical databases.
• Involved in installation and patching of 11gR1 Grid Control.
• Installed Oracle GoldenGate on an RHEL 5 platform.
• Performed bi-directional replication from source to target Database using Golden Gate.
• Performed Oracle GoldenGate configuration, troubleshooting GG issues.
• Experienced in using Change, Incident and Knowledge management using BMC Remedy.
• Actively participated in installing of 11g RAC on Linux environment with four nodes and ASM as storage.
• Upgrade and Migration of Databases from 10g R2 to 11g R2 and applying patches as per requirement.
• Writing documentation for Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g Standby Documentation.
• Supported 40 production and 200 plus development and testing databases with database ranging from 100GB to 2TB.
• Experience in using STATSPACK, AWR to check health of database & hardware.
• Knowledge in using tools such as TKPROF, EXPLAIN PLAN, ORADEBUG and TRACE FILE to tune SQL Queries.
• Worked on Distributed Database Configuration, Creation of Database links and Snapshots used Streams for 2 way replication of data.
• Performed database Cloning using hot backup and cold backup to setup test and development database.
• Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, me/O, memory, CPU, etc.)
• Maintaining schemas and partitioning tables.
• Experienced with SRVCTL for monitoring and configuring RAC Environment.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Designed and Developed shell scripts to automate the processes and to proactively monitor the database.
• Created table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Applied critical patch updates (CPU) released by oracle quarterly.
• Experienced with DATA GUARD implementation and Point in time Recovery.
• Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.

Environment: AIX 5.3.3, HP -UX 11.23, Solaris, Windows XP, VMware ESX 3.5.0, Oracle 10g/11g, RAC, OEM, GridControl, RMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0

Confidential, Westlake Village, CA

Sr. Oracle DBA

Responsibilities:

• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
• Installed, and patched Oracle software and associated applications.
• Designed ETL process using Informatica tool to load form sources to targets through data Transformations.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Applied the patch sets, one off patches, Opatch to the Development and production servers.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Illustrates using theGoldenGate direct loadmethod to extract records from an Oracle 11g database on Red Hat Linux platform and load the same into an Oracle 11g target database on an AIX platform.
• Data replication using Golden Gate with source and target on the same physical host.
• Debugging GG issues such as abend.
• Using LogMiner, track any DML and DDL statements executed in the database.
• Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.
• Created and maintained all databases required for development, testing and production usage.
• Worked as part of a team and provided 24/7 support when required.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
• Experience in configuring Data guard 10g R2 for physical standby database.
• Replicated database using Shareplex.
• Experienced in managing data guard configuration using DGMCRL tool.
• Develop PL/SQL Stored Procedures, Packages, Functions and Database Triggers to support application.
• Created and managed both system level and object level roles and privileges for various users. Killing sessions and revoking user privileges and roles.

Environment: Oracle 9i (9.0.1.2.0 & 9.2.0.4.0) 10g (10.2.0.1),11g, AIX 5.2, 5.3 RS6000,SQL*LOADERSolaris 3500, Informatica PowerCenter 8.1, Solaris 10k, Dell 5560 with Xeon Processors.

Confidential, Houston, Texas

Oracle DBA

Responsibilities:

• 24/7 Production Database Administration Support
• Installed and Configured Oracle 9i/10g RAC.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
• Managing two node RAC databases on Red hat Linux advanced server 2.1.
• Performed Database migration from Oracle 9.2.0. To 10.1.0.3
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and rewind entire database to a particular time respectively.
• Perform requirements gathering, data mapping, metadata management and database modelling.
• Designed and implemented OLS oracle 9i label cache to enable use of Hibernate with OLS and to improve performance by eliminating repeated use of Oracle conversion functions.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Cleaning the ORACLE HOME log file system by cleaning the log files, alert log file and listener.log file.
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Backup and recovery utilizing RMAN.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating users and database links, snap shots on production and development servers.
• Maintaining system security, defining of roles, profiles etc.
• Checking CRON jobs. Monitoring Application specific background processes.
• Creating materialized views and materialized view logs to implement the table level replication for the MIS databases.
• Use Oracle Metalink Support to resolve different issues related to database servers, security patches.

Environment: Oracle 11g/10g/9i, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 10g, RAC,TOAD

Confidential, Sanjose, CA

Sr. Oracle DBA

Responsibilities:

• 24x7 Oracle Production Database Administrations.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications.
• Installed and Configured Oracle 9i/10g RAC.
• Installed, configured and administered Automatic Storage Management (ASM).
• Expanded Physical Data Model (PDM) for the OLTP application using ERwin.
• Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance. written PL/SQL stored Procedures, Functions, Packages and Tiggers.
• Implemented Cloning using RMAN to migrate data from PROD to UAT/QA/SIT and DEV databases.
• Performance Tuning of the database (Memory Allocation Tuning, me/O Tuning, Tuning Contentions) Maintain Oracle schemas and SGA region.
• Performance Tuning includes AWR, TKPROF, EXPLAIN PLAN & STATSPACK,AWR,ADDM.
• Implemented Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery usingRMAN. Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Create table spaces, tables, and users for custom applications and Maintain user security.
• Assist Programmers and Developers with Oracle problems.
• Write Korn shell scripts to monitor and maintain the Oracle Applications database.
• Write SQL scripts to monitor tablespace and extent growth. Answer users' questions.
• Resolve various application failures due to data entry errors or system errors. Involves identifying problems and implementing corrective actions.
• Write SQL*Loader control files for uploading legacy data to interface tables.

Environment: Oracle 9i/10g, RAC/Oracle 9i/10g, IBM-AIX 5.1, TOAD, HP-UX, Linux, RMAN, Erwin 3.5.2, SQL*Loader, Data Pump, OEM/Grid Control, SQL, PL/SQL, ASM.

Confidential, Chicago

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Involved in the installation of Oracle 9i on Windows NT and Linux.
• Execute Hot, Cold backups and recoveries.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound backup and Recovery Strategy.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum me/O performance.
• Tuning the databases for optimal performance and monitoring CPU performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Cloned environments to create patch test, development and QA environments.
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Responsible for setting and managing user accounts, Granting required privileges to users
• Applied High priority, security patches downloaded from Metalink.
• Monitoring the Database storage and Day to Day activities.

Environment: IBM AIX 5.3, RHEL, Oracle 9i/10g, PL/SQL, SQL*PLUS, Exceed 6.2, OEM 9.2.0/10g, Quest Software (5.0), VERITAS Cluster, RMAN.

Confidential

Oracle Developer/ Jr. DBA

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture end of day transactions.
• Implemented UTL HTTP oracle built in package to acquire data from external websites.
• Preparation of design specifications document.
• Involved in designing the database, identification of the objects and creating tables.
• Designed and created database objects such as Tables, Views and Indexes.
• Tested and corrected errors and refined changes to data base.
• Implementing Database Security, Management of role-based security.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Wrote scripts for Loading Data using SQL * Loader and Import/Export Assisting the developers in tuning the SQL for optimized performance.
• Handling day to day activities along with schema and space management.
• Creating primary database storage structures (tablespaces, datafiles, tables, indexes etc)
• Planning for storage spaces requirements and placing them for optimum me/O performance.
• Cloning databases using scripts as well as HOTBACKUP.
• Extensively used Explicit Cursors in stored procedures.
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, Database Tools/Utilities, STATSPACK,TKPROF, UTL SMTP, SQL*LOADER, Cronjob Oracle forms.