PROFESSIONAL SUMMARY:

• Installed databases using silent install
• Designed and Build 2 - node RAC Cluster on RHEL
• Designed and build Data Guard
• Designed, developed, installed and maintain and administer bureau-wide Enterprise Production Oracle database running on 2 Nodes on virtualized RHEL6 using ASM on Shared Storage
• Performed administration and engineering for multiple Production, Quality Assurance, and Development databases in a 24/7 environment and multiple locations with direct reports.
• Administered, Patched, Upgraded Oracle 10g and 11g databases in a RAC. Also performed performance monitoring, reporting and tuning of these databases utilizing Oracle OEM grid control to apply patches(s) to the RAC infrastructure.
• Responsible for fast-paced complex distributed database environments supporting primarily OLTP on a UNIX/Linux platform (IBM Z10 infrastructure/RHEL6), with the ability to rapidly troubleshoot complex technical problems under pressure.
• Monitored and maintained database security and database software Developed, defined, and/or oversaw database organizations, standards, controls, procedures, and documentation.
• Reviewed, designed and developed data models in conjunction with the application development teams using ERWIN and TOAD Data Modeler
• Mentored oracle developers/DBAs on SQL and PL/SQL development skills and good oracle code writing skills.
• Experience in utilizing performance tools to include Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR), Remote Diagnostic Agent (RDA) and SQL Performance Analyzer (SPA).
• Advice on configuring and/or tuning the RAC clusters for optimal performance.
• Designed and configured Data Guard configuration for Disaster Recovery.
• Converted several databases to UNICODE AL32UTF8
• Performed various tasks to include user management and access, backup and recovery of databases, performance tuning, and SQL scripting to automate standard jobs.
• Poses advance knowledge of Oracle RAC deployments on UNIX platforms with Physical and Virtual configurations using EMC or SAN storage.
• Post knowledge in Golden Gate
• Worked with offshore DBAs
• Applied patches.
• Provided 24/7 support
• Cloned databases using RMAN, export import and Data Pump.
• Overall 7 plus years in Oracle Database Administration.

TECHNICAL SKILLS:

Operating System: UNIX, RHEL, Sun Solaris, AIX, Windows 2003/2008/2012, HP UX

Scripting: SQL, PL/SQL, Unix Shell Scripting / Bash / Korn

RDBMS: Oracle 9i to 12c R2 SQL Server 2005, 2008 and 2012

Documentation Tools: Sharepoint MS Office, Visio, Wiki

Tools: sqlplus, splldr, exp, imp, expdp, impdp, TOAD, OEM, DB console, rman, lsnrctl, srvctl, crsctl, orcconfig, ocrconfig

PROFESSIONAL EXPERIENCE:

Confidential, Norcross, GA

Oracle DBA

Responsibilities:

• Build multiple 2 node RAC Clusters on Linux.
• Provided day to day support for three applications.
• Provided support in refreshing schemas
• Provided support in cloning databases
• Used data pump, RMAN duplicate database and export/import for data moment.
• Set up grid control alerts and thresholds.
• Written shell scripts to automate database monitoring tasks.
• Constant monitoring of database space and space management
• Setting up Oracle Standby Data Guard.
• Support HA databases and resolved gaps in physical data guard environments.
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using Explain Plan, SQL tracing and tkprof.
• Perform Backup and Recovery thru RMAN.
• Strong experience in Installing, configuring, maintaining Data Guard environment.
• Strong experience in patching databases.
• Worked on locking and issues with latches
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Used ASH, AWR & ADDM tools to troubleshoot performance
• Used TOAD, Grid Control, SQL Developer as GUI tools aside from terminal.
• Installed, migrated, configured and tested Oracle 11g databases in various environments.
• Extremely dedicated, self - motivated, Pro-Active and willing to assume responsibility.
• Worked with offshore DBA and Developers
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Provided my support during off hours and weekends.
• Helped coordinating jobs with offshore team.
• Provided on-call 24/7 support

Confidential - Rosemont, IL

Oracle DBA

Responsibilities:

• Build Data Guard
• Configured and Managed ASM disks and disk groups
• Build 2-node cluster using Oracle RAC
• Conducting Installations of Oracle 10g, Oracle 11g on standalone servers
• Worked on Migration Projects.
• Upgraded Databases from 10g to 11g R2.
• Fully documented 11g GoldenGate installation for internal DBA team members
• Build database servers on VMWare.
• Performed work on Capacity planning
• Applied patches
• Worked on 11g grid control
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Worked on SQL Tuning and instance tuning
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Generated and analyze ASH, AWR and ADDM reports
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (SQL Backtrack and RMAN)
• Written shell scripts
• Worked with RAC implementation team. Added nodes.
• Refreshed multiple databases for Development and Testing upon short request.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Diagnosed Oracle bugs
• Performed Export/Import through Data Pump.
• Worked on basic replication through Materialized Views.

Confidential, Chicago, IL

Jr DBA / Desktop / IT Support

Responsibilities:

• Provided user support via phone and email
• Worked on LAN
• Worked on Access DB
• Written SQL Queries to fetch data
• Worked on Client/Workstations.
• 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