SUMMARY

• Experienced with over 7+ years in Oracle Database Administrator providing 24/7 production & development support for Oracle 12c, 11g, 10g & 9i in a diversified domains, on various versions of UNIX/LINUX and Windows operating systems.
• Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Experience with Oracle 12c/11g/10gRAC/9i/8i in Installation, Administration, Monitoring, Database Backup and Recovery.
• Preparing Clustered Environment including hardware and software installation, configuration of RHEL 3.0/4.0 & Windows 2003 Server for Oracle 9i/10g/11g RAC (Real application clusters).
• Expert level SQL, stored procedure programming and Performance tuning expertise.
• Expertise in Performance Tuning for 10g and 11g (I/O, Memory & SQL Tuning).
• Utilities used include AWR, ASH, ADDM, STATSPACK, TKPROF and Sizing of tables, indexes etc. Extensive knowledge on Exadata Architecture, Smartscan, and Advanced compression.
• Experienced with cross site (active - active) data replication using Golden gate.
• Extensive experience in Database Administration activities such as installation, patching, upgrading, migration, backup & recovery, performance tuning and capacity planning.
• Strong experience working in large scale enterprise environment containing OLTP and OLAP systems encompassing many terabytes of data.
• Design, test, implement, maintain, and control the companies physical, relational, and object-oriented databases like Oracle 11g,10g,9i,8i across multiple platforms like HP UNIX, Red hat LINUX, Confidential AIX, Sun Solaris, Windows including performance tuning and trouble shooting of the databases.
• Proven experience with database performance and tuning techniques to enhance database optimization plans.
• Extensive experienced in using Oracle Utilities & functions including RMAN Catalog, Data Guard, AWR, ASH, Statspack, Data Pump, exp/imp, OEM grid controls.
• Good Working Experience in Forms &Reports for both development and customization of several Reports& Forms as per the client specifications.
• Experience in Real application Clusters RAC and Standby database.
• Hand on experience in Backup, Recovery and Restoring of databases using RMAN catalog.
• Installation, Configuration of Oracle Data Guard for Physical and Logical mode.
• Extensive Experience working with Business users determining data/requirements needs and Data Modelling.
• SQL Tuning using HINTS and reframe SQL Queries.
• Hands on experience working with Golden Gate Director and configured ODI to use Oracle Golden Gate for Change Data Capture.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Experience working on TDE for Data Encryption in Database as well as Backups.
• Experience in PL/SQL, SQL and Shell Scripting.
• Hands on knowledge of CRONJOB.
• Closely worked with Network storage, OS, apps and development teams.
• Good understanding of web services and XML Technologies.
• Proficiency in designing complex ER diagrams, Data Flow Diagrams/Process Diagrams using ERWIN and MS Visio.
• Experience working with both onshore and offshore teams and coordinated onshore issues with offshore team.
• 24*7 production database support with Support to developers & end-users.

TECHNICAL SKILLS

Operating Systems: LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/ 2000, Windows Advanced Servers 2000/2003.

Databases: Oracle 11gR2, 10gR2 RAC, 9i, 8i, SQL Server 2005.

DBA Tools: SQL Developer, SQL*Loader, TKPROF, Toad, OEM, Oracle Goldengate, Control-M, Tortoise SVN, Fortify 360, Putty.

Tools: and Utilities: Export/Import, RMAN, Data Pump, Winscp3, ERWIN.

Languages: C, C++, JAVA, Unix shell scripts, PL/SQL, Perl.

RDBMS Tech: Oracle 8i, 9i, 10g, 11g R1, R2, 9i/10g RAC, Standby Database.

Web Tools: HTML and XML, APEX, SQL NET, ODBC, TCP/IP.

Terminal Emulation: Putty, Telnet, FTP

PROFESSIONAL EXPERIENCE

Confidential, Dublin, OH

Sr Oracle Database Administrator

Responsibilities:

• Install, test and implement all database software, upgrades, patches, and code fixes on all production and development database servers.
• Installation of Oracle 11gR2 Grid Infrastructure/Clusterware for 2 & 3 Node RAC on Red Hat Linux.
• Database upgrade from 9i, 10g to 11g and 11gR2 using DBUA and Manual upgrade.
• Involved in performing cross platform migrations from Oracle 9i, 10g to Oracle 11g.
• Proficient in upgrading data base from 9i/10g to 11g R2 by applying latest patch sets.
• Installing & configuring Oracle 10g, 10g RAC, 9i on Linux &AIX. Installation, Configuration, Upgrade, patching of Oracle RDBMS.
• Configured RAC on oracle 11g R2. Installed OEM agents and monitored them timely.
• Involved in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Installation, configuration, maintenance and tuning of Oracle 10g 11g on RHEL 5.0, 5.5, 5.7 & Confidential -AIX 6.1.
• Used Oracle streams for data migration and data distribution. Sizing the SGA, sizing the db buffers, shared SQL area, log buffer based on the requirements.
• Installed 12C GRIDCONTROL and involved in registering of Databases in GRID.
• Experience in Oracle server administration. Created Users, Implementing Backups, Cloned the Databases, Backing up and Refreshing ORACLE DB’s.
• Performance tuning and diagnosing DBMS and individual Production databases
• Implemented zero downtime migration and upgrade of 10g to 11gR1 database using Oracle Streams. Configuration, implementation and production support of OLTP databases on Exadata Quarter racks.
• Replicated certain columns from a table and also certain values from columns by using Oracle Streams.
• Tuning which involved I/O, Memory, CPU utilization, SQL Tuning, SGA Tuning, Shared Pool Tuning, Buffers and Disk I/O tuning.
• Experience of Auditing, Oracle Security, OEM, SQL Navigator and TOAD.
• Experience in Very Large Multi Terabyte Database (VLDB) and also performed migrations in this environment.
• Documented all Oracle database installations and database operations

Environment: Oracle 10g with RAC and ASM, ORACLE 9i, SQL, PL/SQL, Toad, Pl/SQL Developer, Data Guard, Erwin, O/S: RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, ASM Packages.

Confidential, Los Angles, CA

Sr Oracle Database Administrator

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to 10g version.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• Involved in Tuning the RAC inter connect, Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Created databases in RAC environment and involved in moving databases from TEST to Production Environment.
• Configuration and administering the Golden Gate between Oracle-Oracle databases. Used Golden Gate for schema migration and as a DR solution.
• Proactive database monitoring using 11g grid monitoring tool. Managing the existing the Golden Gate replication process and setting up new Golden Gate replications for ETL process.
• Applied patching on 10g from 10.2.0.1 to 10.2.0.x.
• Involved in Up-gradation of HP- UNIX databases from 10.2.0.x to 11.2.0.x.(11gR2)
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for Migrating Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Export and Import of database objects using EXPDP and IMPDP.
• Maintained a Catalog server and involved in backup of Catalog database.
• Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF.
• Tuned the performance of the SQL’s using TKPROF and STATSPACK reports.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Query optimizing using CBO(Cost Based Optimization) and RBO(Rule Based Optimization).

Environment: Oracle 11g/10g, HP-UX 7.x/11.x, RHEL 5.x, ASM, OEM, RAC 11gR2, RMAN and Data Guard, Explain Plan, SQL Developer, PL/SQL Tuning, Data Pump, Informatica, Putty.

Confidential, San Diego, CA

Sr Oracle Database Administrator

Responsibilities:

• Tuning the Applications for optimal performance, designed the backup strategy for the applications, Designed and developed table structures, PL/SQL stored procedures and database triggers to implement business rules. Created Tables, Views and Indexes for the Project.
• Oracle 10g & 11g Databases maintenance and troubleshooting.
• Upgraded from 9i to 10g, 10g to 11g database and applied critical patches update (CPU) for latest versions.
• Good experience in managing Very Large OLTP and Data ware housing databases.
• Worked on replication tools like Golden Gate to extract and replicate Databases.
• Database Administration support (24x7) for large mission critical production databases
• Installation, configuration and administration of Oracle 11g RAC, 10g RAC, Standby Databases for High Availability and Disaster Recovery purpose.
• Working knowledge on NETAPP storage from disk to tape to copy the RMAN Backup Data and mirroring of databases (BCV Split backup) from one database to another using NETAPP utility.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Flash Back Recovery, SQL Loader, Data Guard, ASM and OEM.
• Designed conceptual schemas using Rational Rose like Entities, Relationships, and Integrity rules.
• Responsible for implementing backup procedures using RMAN.
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database. Implemented strong backup and recovery strategies and monitored backups.
• Extensive Conceptual knowledge on designing Data Modeling like Data Models, Conceptual, Logical, Physical Schemes, Data Modeling Process, Modeling Methodologies, Entity Relationship Diagrams, Generic Data modeling, Semantic Data modeling.
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• PL/SQL, Stored Procedures, Packages, Functions, Database Triggers and Shell scripting.

Environment: s: Oracle 9i, 10g RAC& 11g RAC, OEM Grid Control, Sun Solaris, HP-UX, RHEL, Windows 2000/XP, RMAN, TOAD, RATIONAL ROSE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM.

Confidential, Portland, ME

Sr Oracle Database Administrator

Responsibilities:

• Supported Oracle 11g, 10g and 9i databases
• Installed and created 11g databases
• Performed upgrades from Oracle 10g (10.2.0.3) to 11g (11.1.0.1) on Intel and HP boxes
• Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 10g over to HP Itanium boxes running Oracle 11g
• Installed Oracle 10g RAC software with ASM & OCFS2 file systems
• Installing, configuring and administering ORACLE 9i/8i on LINUX and Solaris.
• Create oracle databases (single instance) on configured servers using both the DBCA & Database creation scripts.
• Used Database export/import using EXP and IMP utilities to take logical backups.
• Performed Data loads using SQL loader utilities.
• Planning Backup and Recovery Strategies for various database environments using Recovery manager (RMAN).
• Perform capacity planning required to create and maintain database environments.
• Monitoring Database for fragmentation and correcting them.
• Management of table space growth, monitoring data files additions, extent growth
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.

Environment: ORACLE 9i/8i, Linux, Sun Solaris 10.0, RMAN, DBCA, EXP/IMP, SQLTRACE, TKPROF, EXPLAIN PLAN.

Confidential

Sr Oracle DBA

Responsibilities:

• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Performance Tuning i.e., tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Oracle Grid Control Management Server Installation.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures for performance testing and future 10g production implementation
• Installed Oracle 9i and 10g database on HP-UX 11.0, Red hat 4.x
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same
• Devised & Implemented backup strategies using hot, cold and exports based on the business requirements.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer

Environment: Oracle 10g/9i, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, Data Guard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, and TKPROF, Toad, PL/SQL.

Confidential

Oralce PL/Sql Developer

Responsibilities:

• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data Conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Implemented Cold Backup and Hot Backup depending on the requirement.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Cloning of databases from production to development and test databases
• Developed, Tested and debugged the code according to business requirements
• Worked on performance tuning and testing of Oracle PL/SQL database entities
• Monitored and maintained Security by managing Roles/Privileges for users of the databases.
• Monitoring the database daily activities.

Environment: Oracle, PL/SQL, Erwin 4.1, Windows 2000, Toad.