SUMMARY:

• A highly result oriented skilled Oracle DBA with extensive experience in Database Administration on Production databases, good team player, organization with excellent communication skills.

• I have over 8 years of active experience in installation and configuration, system implementation and problem trouble shooting. Experience with Oracle 9i, 10g, 11G Installation, Administration, Data Guard, RMAN, ASM, and RAC Involved in different scenarios of OLTP and data warehouse farms.
• Experience in creating development, test, stage, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
• Expertise in installation and configuration of oracle 10g, 11g, 12c on various platforms like Confidential - AIX, SUN SOLARIS, HP-UX, Red Hat Linux and Windows.
• Having a sound knowledge of new features of Oracle 11g R2.
• Experience in implementing DR (Disaster Recovery) & High availability solutions using DataGuard (11g/10g), Standby Database (9i) and oracle 9i, 10g, 11g RAC.
• Proactive monitoring in identifying bottlenecks in the application and database using Statspack, AWR, ADDM and 12c OEM Cloud Control Monitoring.
• Experience in development and design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatics Power Center/Data stage.
• Expertise in database backup/recovery strategy (BCV mirroring, RMAN, Export/Import & Data Pump), Performance Tuning, Capacity Planning, Standby database (Logical, Physical), Oracle configuration management, database cloning, refresh, and patch management.
• Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Assisted in management and database administration of Oracle database applications on Exadata platforms
• Performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Application Tuning and Database/Instance Tuning.
• Experience in performance-tuning services like EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g/11g/12c OEM Grid Monitoring, custom scripts troubleshooting Oracle databases using sqltrace.
• Involved in oracle technical support process through Metalink and other procedures.
• Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in basic and advanced replication using Oracle Streams.
• Experience in using OEM, TOAD, Data migrations using export/import, Data pump, RMAN.
• Experience in configuring and troubleshooting shareplex replication.
• Maintaining Database Security using security compliance auditing, capacity planning.
• Experience in using SQL *Loader and External Tables for Export/Import of data.
• Experience in optimization of SQL statements using Techniques like cost based and Role based optimization and accordingly Generated Explain plan.
• Experience in DBA activities like creating of databases, users and table spaces, partitions, Indexes, constraints and permissions.
• Extensive use of TOAD for extracting scripts from the dictionary.
• Strong experience in working with multiple projects in high-pressure environment.
• Quick learner and willing to contribute in a team environment.
• Installation, configuration & administration of Oracle Grid control.
• Worked on the BMC remedy ticketing system.
• Capacity Planning and bench marking the data growth year over year.
• Experience as On-Call 24x7 production DBA support, Application/Development DBA.
• Very familiar in creating TAR/SR with Oracle Support and Metalink to resolve the production database issues.
• Excellent verbal and written communication and presentation skills and Strong interpersonal skills, ability to interact with people at all levels.
• Experienced in Oracle Golden Gate configuration, Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate, Upgraded production databases from 10g to 11g without downtime using Golden Gate.Golden gate basic administration and issue handling.
• Excellent Communication, Presentation and Analytical skills.

TECHNICAL SKILLS

Operating Systems: RHEL, CentOS, Windows, HPUX, AIX, Solaris

RDBMS: Oracle Server 9i/10g/11g/12c

Storage: ASM, Tivoli Storage Manager

Tools: Upgrade, Migration, RAC, Data Guard, ASM, GoldenGate, SQL*Plus, PL/SQL, SQL*Loader, TOAD, 12c Cloud Control, Export/Import, Data Pump, RMAN, Shell Scripts, RMAN Duplicate Database.

PROFESSIONAL EXPERIENCE:

Confidential, Bensalem, PA

Sr. Oracle Database Administrator

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager

• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Maintain and Administer SQL Server Databases on Windows Server VM
• Applied Patch’s to Oracle 10g, 11g tested.
• Upgraded oracle from 11g to 12c
• Worked on databases on VMWare
• Moved Oracle Databases between two HP-UX Servers using the Cold Backup.
• Installed Oracle Enterprise Manager Grid Control 10.2.0.5 on Windows Server and configured the same with the other Oracle Databases.
• Created and configured Oracle Enterprise Manager Grid Control Repository Database.
• Monitoring Oracle Databases and SQL Server Databases using Oracle Enterprise Manager and SQL
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC
• Strong physical and logical Data Guard skills.
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Experienced in Oracle Golden Gate configuration, Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate, Upgraded production databases from 10g to 11g without downtime using Golden Gate.Golden gate basic administration and issue handling.
• Configure and manage tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Worked on Space Management and Security.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.
• Back up of Archive Log files and monitoring space in that mount point.
• Responsible for taking full hot/cold and Differential database backup.
• Cloning and Refresh of Database (using backup and duplicate).
• Assisted in integration of Exadata applications into current IT actionable events and solutions
• Database health check using Statspack report, Tkprof, AWR
• Managing and Resolving end user request via HPSC ticketing tool
• Work on OEM issues, setup alerts thresholds.
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Implemented the Security using Oracle Database Vault
• Maintenance of installed Oracle database and supporting multiple production, development and test instances of varied complexity including Multiple Tier and RAC environments.
• Worked on the RAC environment for the high availability managed by ASM.

Confidential, Dubuque, WA

Oracle Database Administrator

Responsibilities:

• Managing and creating Oracle database.

• Installed and configured Oracle 12c, 11g, 10g 64 Bit on Linux for Production, Development and Testing.
• Installed, configured and tested oracle 10g and 11g RAC environment and trouble shooting.
• Implemented Migration of Databases from 10g to 11g and applying patches whenever required.
• Implemented Standby Database (Physical/Logical) using Data guard for faster Disaster Recovery and HA.
• Design and implemented a complete Backup solution utilizing RMAN via a Recovery Catalog, strategy-included development of daily, weekly and monthly strategy incorporating incremental backups.
• Monitoring & Managing the Tablespaces and datafiles growth
• Proficient in database design, triggers, snapshot and stored procedures in Oracle 9i,10g and 11G
• Database designing, Database administration.
• Defining backup & recovery plan, Database tuning.
• Refresh and Cloning of Database.
• Experience in Database migration from 9i to 10g,11g on Production/Development databases
• Enabling SSO services, Wallet manager, Oracle text installation
• Expertise on database backup/recovery strategy ( RMAN, Export/Import & Datapump ) on Production environment.
• Removing table fragmentation.
• Dataguard implementation and maintenance for Disaster Recovery.
• Alert Log Checking (Monitoring) and User Trace File and Archive log maintenance.
• Creating users, granting roles, Creating and Maintaining snapshot.
• Database Export and Import Utilities.
• Monitoring locks and various sessions.
• Managing OEM.
• Configuring Virtual Private Database for Application Access Control and row-level security policies
• Modified functions for specific query tuning on column-level VPD
• Performing Day-to-Day DBA tasks - performance tuning, database design, system security, database installation configuration, patching, technical database support in 24X7 environment.
• Responsible for quarterly patches, /maintaining/Monitoring/Upgrading the Production/Dev/Test and training databases for products.
• Setup/configured oracle RMAN for database backup and recovery. Application of different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & OS scripts like shell & cron job schedule.
• Installation of oracle database and clients on UNIX and windows (Silent installation, GUI installation.
• Restore and Recover of database from offline, online and RMAN backup.
• Maintaining 1300+ Database instances running on Linux in VERITAS cluster environments.
• Retrieval of backup from TSM (Tivoli Storage Management).
• OEM Monitoring (health, status, alerts, agents etc., Configuration of databases in different groups, Instances, agents, Listener, Setting/Removing Blackout)
• Managing Agent using OEM and manually (upload Matrix, Resynchronization etc.)

Confidential, Grand Rapids, MI

Oracle DBA

Responsibilities:

• Supporting 24*7 Production databases along with development and maintenance databases.

• Proactive monitoring through OEM 10G GRID Control.
• Database refreshes using RMAN backups and hot backups also extensively using RMAN for all types of recovery/backup scenarios.
• RMAN Catalog maintenance, purging sufficiently old backups from TSM Server etc.
• Troubleshooting problems of development and application teams.
• Experienced in Oracle Golden Gate configuration, Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate, Upgraded production databases from 10g to 11g without downtime using Golden Gate.Golden gate basic administration and issue handling.
• Upgradation of databases from Oracle 8i to 9i, 8i to 10GR2, 9i to 10GR2 etc..
• Day-to-Day Maintenance of multiple 10G RAC environments on ASM
• Applying Patches to RAC/Non-RAC databases.
• Upgradation of RAC databases from 10.2.0.1 to 10.2.0.2 etc
• Space Management in ASM Disk groups Addition of new disks etc
• Configuring TAF
• Work on Physical Standby databases in Dataguard environment and perform related activities i.e Perform Role Switchover for maintenance of Primary database etc.
• •Created physical standby setups in Dev/Production environments.
• •Troubleshooting day-to-day Standby database issues.
• Installation and Creation of new databases in Dev and Production environments.
• Handling Production databases on High Availability Clusters (HACMP) on Confidential -AIX platform.
• Export and import of tables, schemas and Full db as per development/Application team req.
• Configure rman backups for databases and schedule them through Crontab.
• Resolve common database issues like Locking, Free Space, connectivity issues, Applying patches.
• Performance Tuning of problem queries.
• Work on Materialized views and handle related issues.
• Configure Listener and tnsnames configuration and troubleshoot related issues.
• Tracing problem user sessions and analyzing TKPROF reports.