A Detailed and goal-oriented Oracle Database Administrator with 5 years of experience in designing, implementing and maintaining Oracle 10g and 11g RDBMS. Proven technical knowledge of infrastructure management network, systems , combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.Supported a variety of mission critical applications with Oracle 8i, 9i, 10g and 11g. Worked across a multitude of platforms Solaris, UNIX, and Windows in production and development environments with responsibilities encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, auditing, RAC, Data Guard, Grid Control, Oracle Streams and production support

EXPERIENCE SUMMARY

• Full responsibility and expertise in database administration DBA , performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.
• Managed Oracle databases in very large over 3 TB databases and Oracle Application environment to support over 3,000 concurrent users.
• Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.
• Involved in each phase of life cycle SDLC including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities.

Extensive hands on experience with Oracle Cluster ware, MC/Service Guard and configuration with Oracle 10g and 11g RAC. Strong skills on Data guard.

• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control OEM and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Configuration and Management of Data Guard on RHEL, OEL.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks SAN /Network Attached Storage NAS .
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation of Backup and Recovery strategies both cold and hot backups and performing periodical backup, restoration and recovery using RMAN full and incremental
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.
• Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager ADDM .
• Proactively monitoring the database's health and taking preventive or corrective actions

• Proficient in Database Design Physical and Logical Database Design and Normalization.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, VeritasNetBackupand IBM Tivoli Storage Manager TSM .
• Used EXPDP IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD.
• Experience in Extracting, Transforming and Loading ETL data using SQL loader utility.

• Automated many common tasks using crontab including Backups, exports and imports,
• Unix shell scripting Korn shell and Windows command prompt .bat .cmd

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Role: Oracle DBA

• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
• Performed DBA day-to-day activities, ran queries, attended to alerts/emails accordingly and also was oncall duties.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Worked on application and database security data access, passwords, network, etc as well as application upgrades, data merge and syncronization using Oracle streams across databases.
• Analyzed SQL queries causing performance problems.
• Designing and developing SQL procedures, query performance tuning.
• Troubleshoot installation errors both independently and with Oracle support via My oracle Support
• Supported Oracle DB backups online/offline , logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Supported Oracle DB backups online/offline , logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities
• Export and Import of database objects to copy from one database to another database.
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN, CONFIO IGNITE and tuned problem areas to enhance performance.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Handled daily production problems/change requests with Oracle.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM client , Oracle 10g database control SQL Plus, as well as pre-developed UNIX shell scripts.

Tools Used: Oracle RMAN, Oracle 11g 11.2.0.2 , DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, Grid Control, Confio Ignite, Autosys, Crontab.

Confidential

Role: Oracle Database Administrator

DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 6.1. Database sizes range from 2GB to 3TB in ODS EDW environments .

Backup Oracle DBA for two major projects involving periodic administration, troubleshooting tuning of 10 Oracle databases 10g 11g single instances running on both IBM AIX 5.3, SunOS 5.8 HP-UX B.11.11.

Worked extensively on Performance Tuning, Memory SGA Tuning, Net backup, EMC Time finder and SRDF , RAID, RAW Devices

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration

Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

Analyzing schema of databases created to collect statistics using the DBMS STATS package.

Use AWR/ADDM for 10g Statistics management database tuning following creation of new databases and periodically thereafter.

Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard

Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.

Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance

Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins

Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1

Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Create oracle databases on configured servers using both the DBCA Database creation scripts.

Manage, tune and troubleshoot database issues both on UNIX command line, SQL Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third party tools TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle .

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM client , Oracle 10g database control SQL Plus, as well as pre-developed UNIX shell scripts.

Tools Used: Oracle RMAN, Oracle 11g 11.2.0.2 , DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential

Role: Oracle Database Administrator

• Cloned/Migrated databases using RMAN and traditional Datapumpexport/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups hot cold in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC Real Application Database.
• 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.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7support for all the production and development databases.
• 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 DatapumpExport/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.
• Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN,
• Confidential Role: Oracle Junior DBA
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Performed hot and cold backupand recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security data access, passwords, network, etc .
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup hot and cold as well as Logical backup Export/Import .
• Proactively managed the databases set up alarms for managing any exceptions in day to day management of the databases pre-empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Wrote Stored Procedures according to specs and control files for input to SQL Loader utilities for loading data from external files into the Oracle database.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigate suspicious database activity using Auditing.
• Write database documentation, including data standards, procedures and definitions.
• Tools Used: Oracle 10.2.0.1, Oracle 9i 9.2.0.8 ,RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN