SUMMARY

• I have over 6 years of experience as an Oracle Database Administrator with working knowledge on database installation and configuration, production and project support, upgrades and patches, performance tuning, backup and recovery, database security and auditing, database cloning, migration, shell scripting and documentation.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD.
• Participated in planning and implementation of off - site Disaster-Recovery planning and testing.
• Worked with development and operations staff in resolving problems quickly and efficiently.
• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g.
• Configured physical and logical Standby Database (Data Guard) and tested for business continuity/Disaster recovery plan.
• Oracle 11g RAC Data Guard configuration with various types of standby like Physical Standby, Logical Standby, Snapshot Standby (11g), and Active Data guard (11g). 
• Implemented Oracle solutions like High-Availability, Disaster & Recovery and ongoing support of Oracle RAC and Core databases. 
• Installed and Maintained Oracle RDBMS Software (12c, 11g and10g) on different flavours of UNIX (HP-UX, AIX), Linux (RHEL, SUSE, and OEL), Sun Solaris
• Installation of 3 Node Oracle 11gr2 RAC on Linux, Maximum number of nodes installed and maintained was 3. 
• Installed Oracle 11g & 10g RAC software with ASM & OCFS2 file systems on RHEL, HP-UX. 
• Experience in migration of Non RAC database to RAC, RAC to NON RAC using RMAN, RCONFIG and DBCA. 
• Experienced with Adding and Deletion of Nodes in RAC. 
• Expertise on Installation/Configuring/Maintenance of Oracle Streams for replication, integration and transmission of data between different databases and applications.
• Experience in applying several patches such as CPU/PSU patches, One-Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations.
• Wrote scripts to inform the DBA team on the status, performance and space management of the database.
• Monitoring VLDB (Very Large Databases) using Grid Control
• Solid experience in oracle database migration, upgrades, applying patch sets, code reviews, database release and deployments and data center consolidation activities. Proficient with Database Cloning, Migration, and Patching of Oracle Databases. 
• Extensive Experience with RMAN Backup & Recovery, Hot Backups and Logical Backups. 
• Provide weekly metrics to team lead for documentation on the health of Oracle databases. 
• Create SRs, administer and execute Change Requests(CR) for Oracle Database support 
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Wrote several Purging shell scripts on Linux which have been using as standard script at the workplace
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving, etc
• Developed RMAN scripts for database backup and recovery including- hot and cold backup
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ASH, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Installed Oracle 11g with ASM and OCFS2 File systems.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Team player with excellent interpersonal, analytical and communications skills
• Wrote scripts to inform the DBA’s regarding the status, performance and space management of the database
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Worked with development and operations staff in resolving problems quickly and efficiently
• Resolve the bottlenecks in all the database environments.
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.
• Experience in Logical backup using and full/ partial export/import and Data Pump.
• Monitored and managed various database components (logical & physical) like table- spaces, segments
• Worked extensively on Shell scripting for backup, recovery and maintenance for databases

TECHNICAL ENVIRONMENT

Databases Version Supported: Oracle 10g, 11g, 12c.

Database Tools Used: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, SQL Developer, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, ASH/AWR, DBCA, DBUA, ADDM, Oracle Migration Workbench, Remedy, Putty, Winscp.

Operating Systems: LINUX, UNIX, MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX),

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450 , San Storage 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-9000, Red Hat Linux 6.2

PROFESSIONAL EXPERIENCE;

Confidential, Irving, Texas

Oracle Database Administrator

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.
• Installation on Unidirectional Oracle Golden Gate Databases.
• Configured and administered Golden Gate.
• Creating database objects in operational data store and maintaining them in Golden Gate.
• Implemented initial Data Load, Batch/Online replication, Security in Golden Gate.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
• Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
• Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g on Linux platform using ASM.
• RMAN point in time recovery and Instance recovery done on 11g.
• Developed compliance reports and performed auditing at higher levels.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using OracleData Guard forOracle 11.2.0.3 and Oracle 10.2.0.5RAC databases
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Worked on both VMS and UNIX environments.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Experience in writing UNIX/SHELL scripts for providing the reports.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Oracle Database Administrator

• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Worked on disaster recovery of exadata dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.
• Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed troubleshooting of database using AWR and ADDM reports.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Installed Oracle and grid software on standalone servers on ASM and file system.
• Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN