SUMMARY

• Over 7 years of experience as an Oracle Database Administrator having hands on experience in database installation, administration, configuration, production support, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g & 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux environment.
• Proficient at performing major Database Release Upgrade (manually as well as using DBUA) along with applying various PSU patches using OPatch for 9i|10g|11g databases.
• Experienced in Designing, Installing, Configuring and Maintaining Real Application Cluster (RAC) using raw devices, OCFS, Automatic Storage Management (ASM) and SRVCTL utility.
• Experience in designing and configuring high-availability systems using DATAGUARD with physical standby. Effectively used DATAGUARD BROKER utility.
• Expertise in setting up Data Guard Fail-Over|Switch-Over|Read-Only scenarios
• Expert in implementing ORACLE STREAMS (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• Experienced in Oracle GoldenGate installation, configuration, troubleshooting GG issues using GGSCI.
• Fabricated multiple CLONING databases using traditional method (scripts) and RMAN utility.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks
• Performed FLASHBACK features to handle efficient database recovery.
• Qualified at writing SHELL Scripts and using CRONTAB for automatic backups.
• Adept at installation of OEM Database Control, OEM grid control and Deploying Agents
• In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard. Working knowledge of Auditing and Database Security.
• Experienced in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle databases.
• Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.
• Having hands on experience in Hot/Cold Backup, Recovery of databases using RMAN with VERITAS Net Backup.
• Hands on experience in Performance Tuning and Memory (SGA) Tuning by identifying top Sqls/Sessions and Tuning.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS packages and ANALYZE command.
• Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics, pinning objects.
• Experienced in loading data from flat files using SQL Loader and External Tables.
• Knowledge on Oracle Support processes for technical requests through Meta link.
• Monitoring & Reorganizing Tablespaces/Tables/Indexes.
• Skilled in using tools such as SQL Developer and TOAD.
• Experienced in converting Business Requirements to Technical Specifications.
• Supported the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with pager rotation to support during weekends, Holidays and beyond regular hours.

TECHNICAL SKILLS

Languages: C, C++, Java, PL/SQL, SQL,HTML

Database Management: Oracle 11g/10g/9i/8i

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

Utilities and Tools: Oracle Enterprise Manager, TOAD, GRID control, SQL Trace, 10g&11g RAC, Oracle Streams, Oracle Golden Gate 10x,11x Oracle Scheduler, SQL Developer, Putty, DBCA, DBUA, Oracle Data Guard, RMAN, ASM, Clusterware, VCS, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, TOAD Data Modeler, DBLINK, VERITAS Net Backup, SAN.

High Availability: Real Application Clusters (RAC), Oracle Streams, Cloning, Dataguard and Dataguard Broker

Tuning Tools: TKPROF, EXPLAIN PLAN,STATSPACK,AWR/ADDM/ASH,EM Dbtuner

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Oracle DBA

Responsibilities:

• Involved in Installing, Configuring and Administration of Oracle 10g/11g RAC on ASM.
• Upgraded databases from 11.1.0.7, 11.2.0.2 to 11.2.03.
• CRS upgrades from 11.2.0.2 to 11.2.0.3.
• Worked on 2 node and 4 node RAC databases from 200GB - 16TB
• Installed 10g /11g binaries on HP-UX and Linux servers and configured new production databases for the same.
• Installation of agent 11g and OEM Grid control 11g.
• Managing services on multiple nodes using srvctl.
• Created and maintained standby databases using database replication (Data Guard) for high availability.
• Worked on RAC S2S Metro cluster, where the database will be failover from site1 to site2 using service guard package.
• Configured Emcli setup for databases, which relocates the OEM targets when failover is done on S2S metro cluster.
• Table refreshes and schema refreshes using Datapump expdp and impdp.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
• Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.

Environment: Linux, HP-UX, SQL, PLSQL, SQL Developer, Toad, Oracle 10g/11g, RMAN, Oracle RAC, DATAPUMP, DATAGUARD, ASM

Confidential, Tampa FL

Oracle DBA

Responsibilities:

• Capacity planning, Install, configure OLTP, Data warehouse (DSS) databases( Oracle 9i & 10GR2) Either in shared environment/standalone environment as well as on VMware virtual machines.
• Involved in database upgrade from 10.2.0.6 to 11.1.0.7 for DEV, TEST, Prod environments.
• Used SRVCTL utility for managing multiple instances and nodes.
• Experience in configuring and maintaining Oracle Replication by using Oracle streams (CDC) for Data replication from production system to Data warehouse on 11g RAC Environment.
• Implemented the database with ASM storage, skilled towards database tuning and hands on experience in database security (auditing), recovery, archival concepts and procedures.
• Configured and Managed ASM disks and disk groups through both Grid Control and ASMCMD utility.
• Upgrade the production and development databases from 9i to 10g
• Created and maintained standby databases using database replication (Data Guard) for high availability.
• Configured databases on Veritas Cluster Server (VCS) and performed cluster failover/failback test.
• Cloned the databases using scripts, cold/Hot backups and Using RMAN.
• Regular monitoring of the databases with Oracle Enterprise Manager, Grid Control for operational databases with high sensitivity alerts
• Performing SQL*Loader jobs for loading data from text files
• Actively worked on performance tuning of instance (SGA and PGA) and Physical database that included resolving fragmentation and disk contention. Use Partitioning and indexing feature of Oracle 10g to improve performance.
• Disaster recovery planning; implemented database backups and disaster recovery strategies using RMAN and data pump export, import.
• Supported very large database with heavy OLTP and batch activities Writing and testing PL/SQL procedures (stored procedure, triggers, function, cursors and packages) for maintaining tables, retrieving data from tables and managing users. Responsibilities included working with developers to tune the PL/SQL, SQL.
• Designed and Implemented database security using Oracle roles and privileges.
• Experienced in optimizing SQL and PL/SQL tuning using CBO, explain plan, TKPROF, Statspack, ADDM, AWR.
• Involved In query optimization and using rule based optimizers and cost based optimizers
• Worked on sizing of database and tables, re-organizing of tables, tablespaces and users.
• Work with a geographically dispersed team for round-the-clock monitoring of production systems

Environment: Oracle 10g/11g, RMAN, RAC, ASM, OEM, DATAGUARD, DATAPUMP, TOAD, SQL, PL/SQL, LINUX, WINDOWS

Confidential, Pittsburg PA

Oracle DBA

Responsibilities:

• Involved in 24x7 support for 800GB 2 Node production RAC database with on-call pager
• Installation of Grid Control and creation of 10g and 11g databases with ASM for Testing, Development and Production.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack, and STATSPACK.
• Installing Data guard, Streams for faster Disaster Recovery.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Migration of Databases from Sybase to Oracle and applying patches whenever required.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Monitoring and Troubleshooting of Database Replication and Data Modeling issues and capacity planning.
• Experience in monitoring, tuning system resources and Enterprise Database Operations associated with the database performance, hit ratios, I/O, lock and latch contention.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL, PL/SQL statements, reorganize database objects and design indexes to improve response of queries.
• Experience in writing T-SQL procedures to backup and restore SQL server user databases.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS Net app storage snap manager.
• Scheduling jobs through Oracle Job Scheduler.
• Implement security configuration for Oracle software and database instances to comply with existing standards
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Upgrading DTS packages to SQL Server Integration Services (SSIS) for better performance.
• Experience using modeling tools, logical and physical database design and SAN storage and Proficient in Enterprise Database Operations
• Automation of Startup Shutdown on all Production and Development Database.
• Experience developing and maintaining Oracle Reports using Oracle Reports Builder. Proficient in Oracle eBusiness suite.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Installation and configuration of Oracle Client software and Tools on databases.
• Automated the process of analyzing tables every night and maintain require documents.
• Write SQL scripts queries to monitor table space and extent growth.
• Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.

Environment: Oracle 11g, 10g, 9i,Oracle Apps 11.x, Red Hat Linux 4.x, Solaris 10, AIX, RAC, Data Guard, ASM, PL/SQL, SQL Server, RMAN, CA Erwin, Shell scripting, PERL, TOAD .

Confidential, Portland, Oregon

Oracle DBA

Responsibilities:

• Installation of Oracle Database Software 9i/10g. Created database through DBCA and manually.
• Worked with other DBA’s for Capacity planning of new Databases. Data replication between different Oracle databases using DB Links. Setup test environment to simulate the migration process.
• Involved in Installing & Administering Oracle Real Application Cluster (RAC) 10g on ASM
• Convert database from Non RAC database to RAC database using RMAN and ASM.
• Implemented Oracle Uni-Directional Streams for a 10g database.
• Upgraded from 9.2.0.7 to 10.1.0.2 database and installed patches for new Oracle software and doing TAR support.
• Export/Import (Data Pump) of data using batch method. Backup and disaster planning using User Managed/RMAN. Prepare approach and steps of migration which will be carried for OLTP and DWH databases of production data. Installed and generated Statspack report on each server for benchmarking the database statistics.
• Responsible for database performance tuning for memory (SGA), disk I/O contentions, rollback segment contention and application tuning.
• Created PL/SQL Packages to move / transform data from OLTP to DWH. Gathering statistics of data objects using Analyze and DBMS STATS. Developed scripts to monitor the storage usage, object status for daily jobs. Database & Instance configuration using Grid control, ADDM, ASMM, etc.
• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log, v$session and checking the space for normal segments, rollback segments.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature. Created snapshots for some most queried tables to get the most refreshed data. Planned and installed replication of database also.
• Involve in the database community meeting with the client to discuss the methodology and decide the strategy of migration. Preparation of database migration document. Effort estimation for Data migration for all the databases. Helped in preparation of Project plan for the Migration.

Environment: Oracle 9i/10g, RMAN, RAC, ASM, OEM, DATAGUARD, DATAPUMP, Streams, TOAD, SQL, PL/SQL, AIX, UNIX, HP-UX, Solaris, RHELAS4.0

Confidential

Junior Oracle DBA

Responsibilities:

• The work involved overall Maintenance of Oracle Database, Backup, Recovery and other database related activities.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors.
• Day to day Performance Monitoring and tuning of database.
• Diagnose and Troubleshoot Database Problems and failures
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery Plan.
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Creation and maintenance of database.
• Handling day-to-day activities.
• Monitoring of database for growth and performance.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Storage and space management including table spaces and data files.
• Creating Databases and all database objects. Database Designing, Designing Tablespaces and Rollback Segments.
• 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.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.

Environment: Oracle 9i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting