SUMMARY:

• 7+ years of experience in Oracle database administration, system Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions
• Good experience in SQL, PL/SQL, Shell Scripting
• Supported the system 24x7. Ability to work beyond regular hours.
• Experience in Data Modeling using Data modeling tools such as Erwin and Toad.
• Skilled in setting up/Installation and configuration of release 11g RAC R2 with ASM and Raw Devices
• Worked on SQL Server 2008 and 2012
• Experience with installing and maintaining Oracle 13c Cloud Control
• Proficient in maintaining 10g, 11g, 12c and 18c databases.
• Proficient in oracle dictionary and oracle dynamic views.
• Managed and administered databases from command line and 12c/13c OEM
• Experience with setting up and managing standby database using Data Guard
• Intensively used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases
• Tune queries using SQL Plan, SQL profiler, Baseline etc.
• Build RAC Clusters from scratch including deployment of Linux operating system.
• Experienced with tools/utilities: OEM, RMAN, Statspack, TOAD, SQL Navigator, and SQL* Loader, Data Pump
• Expertise in Installation, Configuration, Patching, Migration, Trouble shooting and Performance
• Tuning of oracle databases on UNIX, LINUX and Windows environments
• Upgrade databases to 11g and 12c
• Installed 18c database on OEL
• Build configured and managed multi node RAC Cluster on RHEL.
• Experience in Oracle installations, upgrades, migration, designing logical/physical architecture, SQL*Net, Tuning, Capacity planning, database access and Security and auditing.
• Experience in datacenter migration.
• Supporting development 24/7 production systems. Providing on call support for mission critical applications.
• Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
• Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Vast Experience with RMAN to implement Backup/Recovery strategies
• Clone databases using RMAN Duplicate.
• Implemented data replication through materialized views.
• Refresh database objects using Data Pump
• Build and managed ASM Disks and Disk groups
• Migrated non - ASM database to ASM.
• Experienced in RAID, storage technologies and backup solutions

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/XP, Sun Solaris, HPUX, Redhat Linux, AIX

Languages: SQL, PL-SQL

RDBMS: Oracle 12c/11g/10g/9i, MS Access, MS SQL Server 2000, DB2

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADD

Tools: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Patch Management, SQLNET, ODBC Export/Import, Data pump, DataGuard, VERITAS Net Backup, VMware

PROFESSIONAL EXPERIENCE:

Confidential, Kansas City, Missouri

Oracle DBA

Environment: Oracle 11g, 12c,13c. RAC, AWS, Exadata, Golden Gate

• Supported database on Exadata X7
• Applied patches on computer nodes, Exadata home and storage cells.
• Migrated standalone databases to Exadata
• Implement disaster recovery with use of Exadata
• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Configuration, troubleshooting GoldenGate issues
• Setup Uni-directional GoldenGate setup.
• Worked on Data Migration project.
• Migrated databases from Windows platform to Linux
• Upgraded from 11g to 12c.
• Worked on 12c Multitenant databases
• Rolling install oracle patch in Oracle RAC 11g and 12c
• Upgraded database from 11g to 12c R2
• Cloned databases using RMAN Duplicate
• Installation of 11g, 12c clients/databases on Solaris and Linux.
• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Worked on Data Migration project.
• Migrated databases from Windows platform to Linux.
• Upgraded from 11g to 12c.
• Complete Build of 4-node 12c RAC Cluster on RHEL
• Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
• Performed database Cloning to setup test and development database.
• Migrated databases to different data datacenter.
• Handled RAC Node hangs and node eviction issues.
• Migrating database from NON-ASM to ASM
• Migrated databases to AWS
• Build new servers on AWS
• Worked on project to migrate databases to AWS instance
• Set up oracle instances on AWS cloud
• Maintained databases and alerts from 13c cloud control (OEM)
• Migrated standalone databases to RAC
• Maintaining schemas and partitioning tables.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery
• Responsible for administration and supporting oracle 11g, 12c databases
• Performed large batch jobs and tuning of SQL queries and database systems.

Confidential, Houston, TX

Oracle DBA

• Provided 24x7 operational support.
• Involved in gathering requirements from end users.
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Planned version control of production source code using Clear case.
• Writing SQL scripts, stored procedures, functions and transactions analysis for performance tuning
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.
• Provided System support for both development and 24*7 production environments.
• Performed automated backups and scheduling using scripting.
• Maintaining databases from all the environments from all pre-production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.
• Experienced in ORACLE 11g installation, configuration, and upgrading.
• Experience with rolling upgrade to Oracle 11g RAC.
• Installation, Configuration, Upgrading, Migration and Maintenance.
• Configure, maintain and deploy the Data Guard and grid control.
• Installing and maintaining Oracle GRID CONTROL
• Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.
• Worked extensively on Oracle Streams.
• Troubleshoot OCFS2 install issues and working with Enterprise Manager.
• Raised SR and TAR with Oracle Support.
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Confidential and installation of patches.
• Design and implement Auditing and other security features for the existing Production systems.
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Backup of database Logical and Physical (hot and cold) procedures and using RMAN.
• Restore and Recovery of database in case of database crash, disk/media failure.
• Applying patches and works closely with Oracle to make Application environment up to date.
• Backups & Recovery Maintenance, Databases Performance Tuning.
• Typically involved in database Designing, creation and maintenance.
• Good working knowledge of SQL, PL/SQL, and shell scripting.
• Created users and grant privileges according to the requirements.
• Working knowledge on UNIX administration on AIX server.
• Provided System support for both development and 24*7 production environments.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Involved in designing logical and physical data models using Erwin.
• Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Performed administrative maintenance, monitoring on Oracle database systems in a global
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes.