SUMMARY

• Around 5 years of experience as Oracle Database Administration
• Provided 24X7 production and development support on 10g, 11g and 12c databases
• Worked on different platforms like HP - UX, Solaris, AIX, Linux and Windows.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, capacity planning, space management, database security, auditing, troubleshooting, physical and logical database design, oracle SR support, Unix shell scripting and documentation.
• In-depth knowledge of Oracle internals and architecture.
• Experience in installing, configuring and maintaining Standalone and RAC databases
• Supported 24/7 mission critical huge databases.
• Experience administering database architecture, building database and backup & restores.
• Worked extensively on Oracle Upgrades, Migrations and Patching.
• Experience in migrating from SQL to Oracle, Replications, and Clustering.
• Experience with installing and maintaining Oracle Grid Control.
• Good experience managing ASM disks.
• Migrated database from non-ASM to ASM
• Experienced in RAID, storage technologies and backup solutions
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux
• Skilled in using tools such as SQL Developer and TOAD.
• Dealing with database security and auditing.
• Experience on Oracle Support processes for technical requests through Metalink.
• A self-motivated, responsible and team player with a set of strong technical skills.
• Worked on Migration project.
• Pose expert knowledge in cloning databases
• Worked extensively on refreshes using Data Pump and Export Import.
• Extensive work building queries using dictionary tables and dynamic views.
• Experience in security implementations using FRA
• Installed 12c Grid agent
• Recovered database from block corruption.
• Worked on database triggers, stored procedures and functions using PL/SQL.
• Worked on GoldenGate project for migration.
• Provided 24/7 production support
• Worked on 12 cloud control.
• Worked with offshore teams

PROFESSIONAL EXPERIENCE

Confidential, Grand Rapids, MI

Oracle DBA

Responsibilities:

• Build and managed RAC Clusters
• Build and supported Data Guard Environments
• Worked with storage teams for ASM needs.
• Upgrade of Databases from 10g to 11g
• Installed and configured Oracle 10g/11g RAC high availability
• Installation of Oracle cluster ware, Configuring public and private network and VIP
• Experienced with SRVCTL, OCR and Voting Disk of 10g/11g RAC
• Developing and Implementing Disaster Recovery (DR) Plan.
• Implemented Data Guard for high availability/disaster recovery purpose
• Worked on much performance related issues.
• Managed and met SLA’s timing’s
• Evaluated Team performance’s and helped by mentoring team if needed
• Managed in-house Oracle Databases running on various operating systems like Windows
• Installation of Oracle Database and Oracle products.
• Implementing Backup/Recovery Strategies.
• 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.
• Database creation, Installation, patching and database upgrades.
• System tuning for better performance.
• Applied CPU and quarterly patches
• Used 12C OEM to run AWR reports, 12C MA agents registration
• Installed 12C MA Agents on Linux, AIX, and Solaris Platform.
• Creating packages and database triggers.
• Creating users and maintaining database security.
• Worked with application developers to debug PL/SQL procedures, tuning queries and
• Writing UNIX shell scripts for backup and recovery.
• Database/Schema Refresh as per client requirement.
• Worked on capacity planning
• Worked on weekends for deployments with offshore teams.
• Used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics.
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Job scheduling using crontab
• Creation of database maintenance plans, rebuild indexes and integrity checks
• Implemented RMAN Backups, Creation of catalog database.
• Support migration and loading of data into oracle database using SQL*Loader

Confidential, Bentonville, Arizona

Oracle DBA

Responsibilities:

• Silent Installed 11g database on standalone and RAC
• Build Database Servers on Linux and OEL
• Managed databases on VMWare/
• Involved in 24x7 Production Database Administration and support.
• Build Data Guard environment at DR data center/
• Extensive work using RMAN Backup and performed restores/recoveries.
• Tuned SQL and performed instance tuning using ASH, AWR and ADDM
• Created users, roles and granted privileges according to the business requirements.
• Build SQL Scripts and shell scripts using bash and korn shell.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including database locking, block corruption, disk space issues etc.
• Regularly applied CPU and PSU patches.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Creating and refreshing materialized views, views, synonyms, and indexes.
• Developed UNIX Shell scripts for day to day maintenance and monitoring.
• Worked with offshore team and provided 24/7
• Monitor and optimize database performance.
• Worked with Oracle support to resolve database critical issues
• Installed and configured Oracle 10g and 11g Real Application Cluster (RAC) Instances with stand by database (data-guard) using CRS and ASM.
• Added nodes to the RAC cluster for the increased load and removed it when not necessary.
• Successfully installed oracle 10g on RHEL 4 on VMWare Environment.
• Worked on database cloning using data pump
• Installation and configuration of Oracle 9i, 10g RAC in Linux and Windows.
• Knowledge of Erwin for Data Modeling and Dimensional Data Modeling.
• Design and implementation of backup and recovery strategy using tools Veritas Net backup and RMAN for disk and tape backup.
• Installing 9i and 10g databases on Linux and SOLARIS 10.
• Created SQL Server stored procedures and triggers utilizing T-SQL.
• Experienced with Space Management and Security.
• Detect corrupted blocks by using DBVERIFY utility.
• SQL tuning using SQL Trace and TKPROF, Explain Plan and SQL Analyze.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Proactive database monitoring using automated scripts based on v$views.
• Frequent Database audits to maintain the security standards.
• Developer Environments setup using database cloning and refresh procedures.
• Managed disks and disk groups using ASM
• Performed day-to-day DBA activities for managing Production/Development databases
• Monitored tablespace and extents growth.
• Good use of 11g grid control and TOAD to manage databases.
• Provided 24/7 on-call support.