SUMMARY:

• 5 years of experience in the field of Database Technology with experience in designing, developing, implementing Databases, Web development and Application development.
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, my oracle support.
• Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing
• Oracle Database Administration experience in variety of different environments like HP - UX, SUN SOLARIS, AIX, RedHat Linux and Windows.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to RAC environment.
• Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development and Documentation.
• Migrating and Upgrading the Databases between different environments and versions.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases.
• Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
• BACKUP, configure RMAN centralized backup for all database. Create standby database from Active database using RMAN. Cloning of RAC to Non-RAC database using RMAN. Test & validate restore and recovery for SLA.
• Responsible for all database activities such as User management, space management, database security management.
• Design, document, implement, and maintain all backup, recovery including disaster recovery.
• DBA activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, tablespaces, indexing, data maintenance, user management, and maintenance and solving critical errors like ORA-600, ORA 7445.
• Prepared backup strategy and disaster recovery management of the databases by using in-house tools written using UNIX Shell Scripts.
• Setting up Oracle read only replication with materialized views and developed scripts for automating the rebuilt process of replication.
• Regular DBA activities like Undo segments, Rollback segments, database auditing, space management, database issues, locking, creating database links, managing user groups and tuning. Applied CPU patches.
• Experience with Oracle Streams which enable the propagation and management of data, transactions and events in a data stream either within a database, or from one database to another.
• Maintained Very Large Multi-Terabyte (VLDB) in Data Warehouse Environment for DSS. Strong Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Planned and implemented Oracle 10g, 11g, 12c Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).
• Patching the databases with CPU/PSU on quarterly cycles or ad-hoc needs.
• Creating database objects like tables, views, indexes, constraints.
• Installed and configured Oracle Cloud Control and deployed agents on managed targets.
• Experience with Oracle Cloud Control, Oracle Grid Control, Oracle Enterprise Manager (OEM), ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.
• Proactive monitoring, identifying areas that need to be improved in the application and database using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
• Experienced in setting up/installation and configuration of release 11g R1 RAC with ASM and Raw Devices and 11g CRS.
• Automated many common tasks using Crontab including: Backups, exports and imports, archiving old records and verification of such processes.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Oracle Database Administrator

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g.
• Worked on proof of concept to switchover to standby database and switchback to production database using DG Broker utility.
• Worked on a project to migrate a 17TB data warehouse to Exadata from 5-Node Oracle RAC Cluster using Golden gate and successfully cutover 11g database to 12c Version in a down time of 30minutes.
• Worked on Configuring OEM 12c console and installed OEM12c agents on all different platforms using push method from console and also using silent method.
• Configured Goldengate 12c RAC -- RAC Active configuration with 11g database.
• Configured and worked in Oracle GoldenGate installation, configuration, troubleshooting GoldenGate issues.
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• 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”.
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
• Supported functional data warehouse projects.
• Applied January and April 2015 PSU & CPU patches for Oracle database servers in rolling fashion on RAC databases.
• Worked with database export & import scripts to backup database structures and automation procedures.
• Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different versions of Databases with OEM Grid control to maintain the database effectively.
• SQL tuning and Database Performance tuning has been done based on reports generated by SQL Trace, TKPROF, Explain Plan, AWR, ADDM and monitor the database Performance on daily basis.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed policies on data confidentiality, integrity, and availability Based on Access Controls for Access to Data at the database level.
• Automated the nightly RMAN backups for the Production, Test, Development Databases in crontab.
• Creating and Scheduling Oracle Backend Process Jobs using UNIX crontab.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Built 4 node RAC 10gr2 Standby database and set up DG BrokePerformed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using
• CRONJOB for Day-to-Day activities and Windows Task Scheduler)
• Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Perform user and Security Administration activities such as enrolling users, Granting Privileges to users and maintaining system security.
• Translating the logical data models to physical design and validate the SQLs (Adding PK's, triggers synonyms.
• Monitoring instance performance, tablespace utilization, database objects, connectivity and database availability, verification / validation of database backups, and server space availability and maintenance. Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• 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.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Confidential, Sunbury, PA

Oracle Database Administrator

Environment:: RHEL 4.4, HP-UX, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2, Autosys, Golden Gate, SQL*Plus, PL/SQL, SQL*Loader

• Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.
• Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on multiple platforms.
• Performed up-gradation of 10g to 11g.
• Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
• Automated routine DBA tasks like backup's and stats by using Grid control job's
• Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.
• Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
• Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration
• Adding and removing nodes to existing Oracle database RAC configurations
• Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
• Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
• Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
• Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.
• Performed activities like monitoring the database and provide maximum uptime.
• Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.