PROFESSIONAL SUMMARY:

• Over 6 years of experience as an Oracle Database Administrator
• Build Data Guard for Disaster Recovery.
• Build and Administered multimode RAC Cluster
• Worked with Developers and application users on performance of databases.
• Experience in Upgrading database from 10g to 11g to 12c.
• Experience in PSU patching databases.
• Experience in administerering and managing database on Exadata.
• Experience in setting up GoldenGate Replication.
• Expertise in writing SQL from Oracle Dictionaries tables and views.
• Performed Data Center Migration.
• Expereince in Database and Instance Tuning.
• Experience in Index Management.
• Experience in Analyzing ASH, AWR and ADDM reports.
• Experience in analyzing Explain plan, SQL Trace and SQL Tuning.
• Experience in Tablespace and User management.
• Experience in managing 12c Cloud Control, OEM.
• Experience in writing Shell scripts.
• Expertise in Backup, restores, recoveries via RMAN.
• Expertise in refreshing database environment using Oracle Data Pump and export Import utilities.

PROFESSIONAL EXPERIENCE:

Confidential, Elkhart, IN

Oracle DBA

Responsibilities:

• Installing, upgrading and maintaining Oracle 11g and 12c databases RHEL platforms.
• Setup Data Guard from scratch
• Migrated Data Center to new Data Center.
• Maintaining databases from all the environments from all pre - production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.
• Extensive work in ORACLE 11g installation, configuration, and upgrading.
• Experience with rolling upgrade to Oracle 11G RAC.
• Performed Cross platform migration using transportable tablespaces and RMAN.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Add new nodes to RAC 11g Cluster to distribute the load.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
• Worked with lead DBAs for preparing cluster, configuring, installing Clusterware and Oracle
• Build 2-node and 4-node RAC cluster.
• Worked on EMC SAN with ASM.
• Installation, Configuration, Upgrading, Migration and Maintenance.
• Configure, maintain and deploy the Data Guard and grid control.
• Installing and maintaining Oracle GRID CONTROL
• Troubleshoot performance related issues.
• Design and implement Auditing and other security features for the existing Production systems.
• Worked with system administrators, business analysts in designing and implementing backup and recovery procedures using RMAN, SAN based backups using EMC BCVS
• Raised SR and TAR with Oracle Support.
• Add 12c cloud control agents.
• Performed Database and SQL tuning using TKPROF, Explain plan, AWR and ADDR.
• Written SQL, PL/SQL programs such as functions, procedures, packages and triggers.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
• Worked on tuning SQLs to get better performance.
• 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.
• Typically involved in database Designing, creation and maintenance.
• Created users and grant privileges according to the requirements.
• Using 12c cloud control to setup jobs and setup alerts.
• Installed uni directional GoldenGate
• Experience in replication using Golden Gate and Materialized Views
• Replication and Extracting data and applying on production database’s using Golden Gate
• Using Enterprise Backup utilities for backup.
• Writing scripts for backup and recovery.
• Used transportable tablespace to migrated database from Windows to Linux

Confidential, Detroit, MI

Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Installation of Oracle 11g RAC Databases includes CRS and Applying Patches.
• Upgrading databases to Oracle 11g from Oracle 10g and 9i.
• System Study & Analysis, Design &Development.
• Created users and roles.
• Used shell scripting for automation of job.
• Migrated databases from Unix to Linux
• Creating and managing the database objects such as tables, indexes and views.
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Installation of ASM into various storage parameters like SAN and NAS.
• Oracle Database capacity planning, space management, storage allocation
• Setup Standby databases for disaster recovery.
• Setup Active standby for reporting services.
• Managed the flashback space and performed recovery of dropped tables and data using flashback recovery
• Monitoring of tablespaces, indexes, memory and logfiles.
• Monitoring of Listener and TNS names.ora files and storage space for better performance
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Worked on Data Replication using Materialized views, Snapshot, Streams.
• Worked on import/export, export datapump/import datapump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures. Implemented Hot, Cold and Logical backup plans.
• Setup backup and recovery procedures using RMAN.
• Migrated from non-ASM instance to ASM instance.
• Configured Streams to capture propagate; apply changes in multiple databases.
• Configuring database with suitable block size, multiple pools and storage parameters for best performance.
• Upgrade from Oracle 10g to 11g
• Create, maintain and support Oracle 11g databases and instances
• Automate database administration tasks with Oracle Enterprise Manager 11g Database Control
• Experience on RAC Installation and Administration on Oracle 10g environment
• Optimizing the SQL’s for optimum performance by using TKPROF, EXPLAIN PLAN & TOAD.
• Logical Backup/Restoration strategy of Export and Import.
• Security Administration and Creation of Users, Managing their roles and privileges.
• Control user access and ensure database security through privileges and roles in Oracle 11g
• Hands on experience of Oracle Real Application Clusters (RAC)
• Creation and maintenance of high availability databases using many techniques including Data Guard and standby databases. Shell scripting experience.

Confidential, Irving, TX

LAN Admin / Jr. Oracle DBA

• Provided user support via phone and email
• Worked on LAN
• Worked on Access DB
• Written SQL Queries to fetch data
• Worked on Client/Workstations.
• Worked on Database refreshes
• Database installation
• SQL Scripts
• Setup scripts through cronjobs
• Setup scripts through Windows schedular
• Export import
• Backup and restores
• User Managmenet
• Tablespace management
• Document writing.
• Installed SQL Server 2005.
• Worked with Oracle on troubleshooting
• Provided 24/7 on call support.
• Migrated databases from MS Access to MSSQL.
• Used TOAD
• Worked on Log shipping issues
• Troubleshot issues via phone and email with phone back-ups Assist in Windows7 deployment to include peripheral setup, data migration, and software installations.
• Recognized for outstanding work on special projects, Created and edited documentation.
• Configured Oracle tools like SQL*Net to access the database from the network.
• Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
• Implementation of nightly logical backup.
• Assign users appropriate rights and table’s access through roles.
• Add, change, and remove users.