SUMMARY

• 6 plus years in Oracle Database Administration.
• Best practices for Oracle Database Infrastructure, Standards and Implementation.
• Build 4 - node RAC cluster on RHEL, OEL
• Setup DR using Oracle Data Guard.
• Extensive experience in Oracle Partitioning.
• Extensive experience in Oracle ASM and ACFS
• Worked on 12c Cloud Control
• Worked on 11g Grid Control
• Applied CPU, PSU and one off patches.
• Analyze application activity, tuning the particular data caused for poor performance
• Installation of Oracle Databases on Standalone and RAC cluster.
• Data Guard setup with Primary and Standby Databases.
• Strong Oracle RAC Installation, Configuration and Tuning Skills on RAC and Solaris
• Clone databases using RMAN duplicate database
• Extensive experience in RMAN restore and recoveries.
• Good replicating experience using Materialize Views.
• Worked on setting up Data replication using Oracle GoldenGate
• Strong SQL skills to perform the data base operations
• Very familiar with Oracle Dictionary Views.
• Experience with configuring/administering Exadata environments.
• Implementing, configuring, and hands-on support on Oracle Exadata
• Worked on many export import and Data Pump tasks.
• Used Shell scripts to automate jobs.
• Scheduling backup Jobs using Cron (UNIX) and Schedule Task (Windows).
• Experience with configuring/administering Exadata environments.
• Implementing, configuring, and hands-on support on Oracle Exadata
• Disk space monitoring and Database availability.
• Physical database design, Logical database design, normalization, de-normalization
• Set up Oracle GoldenGate unit-directional and Bi-directional setup.
• Familiar with Database security and auditing.
• Setup procedure for Database statistics gathering
• Worked on Upgrade and Migration Project.
• Monitored databases using cronjobs and OEM.
• Written shell scripts to automate tasks.
• Worked with offshore DBA
• Provided on-call support on rotational basis.

TECHNICAL SKILLS

• Oracle Admin
• Database Installation
• Linux Shell Scripting
• Data Guard
• Storage and Space management
• Performance Tuning
• RMAN
• User
• Role
• Profile management
• SQL / SQL Developer / TOAD
• Patching
• Oracle GoldenGate
• Oracle Net
• TCP/IP
• 12c Cloud Control
• RAC Installation
• 12c Cloud Control
• SQL Loader
• Performance Tuning
• ASH
• AWR and ADDM
• Statspack tkprof
• Linux
• OEL
• RHEL and Fedora
• Microsoft Windows 2012
• AIX
• HPUX
• Solaris

PROFESSIONAL EXPERIENCE

Confidential, Danville, IL

Oracle DBA

Responsibilities:

• Build 4-node RAC Cluster
• Build and supported Disaster Recovery Site using Oracle Data Guard
• Supported different clients with multi-terabyte databases.
• Installed Standalone and RAC Database Servers
• Migrated databases from non-ASM to ASM
• Completely build RAC from scratch including OS and RAID configuration.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Worked and resolved Gaps in standby environment.
• Setup and Oracle GoldenGate uni-directional and Bi-directional replication
• Applied CPU/PSU patches.
• Worked on Migration project where a data center is moved.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Ensure databases adhere to corporate standards and policies.
• Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Migration of system from Oracle 9i to 10g, 10g to 11g using Database
• Configuring and using the OEM in 11g for Performance and maintenance.
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and
• Used SQL SQL Tuning Advisor and SQL Monitoring.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Worked with RAC implementation team. Added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Build Grid control for Monitoring 400+ database.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies using Data Pump.
• Applied PSU patches.
• Resolves cluster related issues.
• Implemented basic replication through Materialized Views.