SUMMARY:

• 8 years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.
• Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g on a varietyf operating systems including UNIX/LINUX, Solaris and Windows environment.
• Migrated database from 9i, 10g to 11g by using Scripts and applied patches by Opatch utility.
• Good Experience in creating and managing schemas, tables, indexes, constraints and materialized views.
• Good experience in Database Creation, Partitions, Setting - up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.
• Hands on experience in Cloning, Oracle Streams, Space Management, DatabaseSecurity..
• Installed Oracle 10g RAC software with ASM & OCFS2 File systems.
• Oracle RAC Database Administration including Installation, configuration, Analysis,Design, Backup and Recovery (RMAN).
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM & LEGATO Storage Manager.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning,and Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers with EXPLAINPLAN, TKPROF, STATSPACK, AWR, and SQL TRACE.
• Extensive experience in creating, testing, staging, production, RAC and standby database for OLTP DSS and data ware-housing.
• Exporting and Importing of dumps using expdp and impdp.
• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOADand Grid Controlling using OEM
• Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS
• Working knowledge of SQL, CouchDB, MongoDB and Cassandra
• Extensive Oracle Golden Gate design, configuration and implementation experience.
• Minimum 2 years experience installing, upgrading and supporting Oracle 11g RAC environment including Oracle Golden Gate.
• Expertise in replication technologies including Golden Gate, Streams, AQ and Materialized views.
• Design and implement modest changes to existing software architecture to meet changing needs. Oracle Golden Gate provides a complete solution in high availability, real time integration, transactional change data capture, data replication, transformations and verification.
• 24x7 on-call Production support for database activities.

TECHNICAL SKILLS:

Operating Systems: UNIX, Linux, Windows NT/2000

RDBMS: Oracle 11g/10g/9i/10gRAC.

Languages: SQL, PL/SQL, DOT NET, JAVA, XML, UNIX Shell Scripting.

DB Management: TOAD, OEM, DB Artisan, OEM Grid Control.

Tools /Utilities: RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server,Export/Import, RMAN, TOAD, Patch Management, Oracle Warehouse Builder,Rational Clear Quest, SQLNET, ETL, ODBC, Oracle Streams, Shareplex, Data pump, Data Guard, VERITAS Net Backup, VMware

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK,AWR,ADDR

PROFESSIONAL EXPERIENCE:

Confidential, VA

Oracle DBA

Responsiblities:

• Installed and Configured Oracle 11.2.0.3 databases on Linux and also migrated Oracle databases from Solaris to Linux.
• Worked with Infrastructure and Operation Database Engineering Team.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using DG
• Broker for RAC one Node Databases.
• Configured and installed RAC One Node Production Databases with Automatic Storage Management (ASM).
• Provided 24/7 on-call support for Oracle production/development databases to ensure maximum availability.
• Installed Automatic Storage Management (ASM) for stand-alone and RAC One Node databases and performed migration of databases from file systems to ASM.
• Configured and installed GoldenGate in unidirectional and Bi-directional replication for Oracle 11g Databases for High availability and reporting projects
• Upgraded and migrated the database to different version depending on Business requirements. (For Example 10g R2 to 11gR1, 11gR2 to 10gR1 on different OS).
• Configured RAC 11gR2 Data Guard Standby Databases using Data Guard Broker.
• Performed RMAN backup and also developed backup strategies using incremental and cumulative backup methods.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Configured and Implemented Oracle 11g Database node Real Application Cluster (RAC) using Automatic Storage Management (ASM) and responsible for High Availability.
• Performed various RMAN strategies like RMAN Backup, RMAN Restore and RMAN Recovery etc.
• Configured and Performed Hot and Cold Backups for Non-prod databases, and Cloning of Databases using RMAN methodologies for setting up UAT and DEV environments.
• Excellent experience of database Backups and Recovery strategies using RMAN, Export Import
• Utility (Classical & Data Pump) and Transportable tablespaces.
• Designed and developed NoSQL solutions for all users.
• Analyzed and resolved issues relating to database application performance
• Managed and administered all NoSQL database systems
• Design and build Disaster Recovery database with Golden Gate.
• Implemented High availability using Golden Gate Replication. Implemented Bi-directional replication using Golden Gate.
• Manage Oracle RAC database configurations utilizing Veritas Cluster Server (VCS), Golden Gate and Data Guard to ensure maximum availability and data protection.
• Architect Golden Gate (10.x and 11.x) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Architect and implemented Golden Gate replication between SQL Server data warehouse and Oracle capacity and performance management repository.

Environment: Oracle 10g/11gR2 RAC, Windows 2008, Sun Solaris 10, Red Hat Enterprise Linux 5, ASM, RMAN, GoldenGate, FTP, putty, Data Guard, OEM11 &12C, TOAD, PL/SQLSQL*Loader.

Confidential

Oracle DBA

Responsibilities:

• Involved in team management, team building exercises for the DBA team.
• Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Wrote several shell scripts for checking oracle errors in alert file and database backup log files.
• Cloning of application from production environment to test environment and application f patches.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Experience in Oracle server administration. Created Users, Implementing Backups, Cloned the Databases, Backing up and Refreshing ORACLE DB’s.
• Creating users with restricted access, with default and temporary table spaces. Partitions on tables and indexes .Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing hot and cold backups Restoration and recovery from backup.
• Sizing the SGA, sizing the DB buffers, shared SQL area, log buffer based on the requirements.
• Oracle Export, Import, SQL*Loader and data pump utilities.
• Installing & configuring Oracle 10g, 10g RAC, 9i on Linux & AIX.Installation, Configuration, Upgrade, patching of Oracle RDBMS.
• SQL issues and Tuning Considerations for Different Applications.
• Performed performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, ASH and Unix commands.
• 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 11g, SQL, PL/SQL, Import/Export, UNIX, Windows 8.

Environment: ORACLE 11g, SQL, PL/SQL, Import/Export, UNIX, Windows 8.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Supporting more than 40 instances.
• Maintenance of production database and development database which includes tablespace space management, user creation, privileges, roles etc.
• Automated hot backups using a combination of incremental, differential and full RMAN backups.
• Upgrading databases to Oracle 11g from Oracle 10g.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Involved in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and in network management.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Installation and maintenance of Oracle 10g Data Guard.
• Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Maintaining archive data on appropriate storage devices.
• Tracing, troubleshooting with database performance and tuning issues.
• Export/Import of oracle databases.
• Tuning SQL queries.
• Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
• Analyzing and validating database objects.
• Coordinating with team members.
• On call support 24x7.

Environment: Oracle Server 7.0.3/8i/9i/10g//11g, SQL Server, HP - UNIX, AIX, Sun OS, Clarify, SPIN, Business objects.