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 wif 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 wif Oracle Cluster ware, MC/Service Guard and configuration wif 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 wif Database Cloning and Refreshing pre-prod/dev databases wif 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 wif and wifout 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 (Confidential )

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g

Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

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

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

PROFESSIONAL EXPERIENCE

Confidential, Prussia, PA

Oracle DBA

Responsibilities:

• 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 wif 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 wif 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, Richmond, VA

Oracle Database Administrator

Responsibilities:

• 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 theirafter.
• 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 dat all application design and code is produced wif 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, Grand Rapids, MI

Oracle Database Administrator

Responsibilities:

• 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 wif zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively wif Physical Standby database, troubleshooting, switchover and switchback wif 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, Clayton, MO

Oracle Junior DBA

Responsibilities:

• 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 wif 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