SUMMARY

• Five years of IT experience as an Oracle administrator with RAC, data guard, installation, migration, backup, recove y, performance tuning etc. in production as well as development databases.
• Experience installation and configuration of Oracle 11g and 12c on RedHat Linux, Windows & CentOS platforms.
• Expertise upgrading the databases from Oracle 11g to 12c.
• Expertise in RAC 11g ASM installation, administration, production support, configuration, upgrades, patches, space management, database security, performance tuning, troubleshooting database design, and documentation.
• Key Responsibilities include Installation of software upgrades, Backup and Recovery, Performance tuning, database reorganization, Disk Management, Capacity Planning, Problem resolution.
• Experience in Data Loading Techniques using SQL1 Loader.
• Set up and managed Automated Storage Management (ASM) for 10g and 11g databases.
• Created, configured and managed Oracle 9i/10g/11g and 12c database instances.
• Experienced in Hot/Cold Backup, Recovery and Cloning of databases using RMAN
• Oracle Database capacity planning, space management, storage allocation.
• Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import and Data Pump utility.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY
• Experience t in implementing oracle standby databases supported by dataguard, logical standby and physical standby databases
• Knowledge in RMAN backup (Full, incremental and cumulative) and recovery options.

TECHNICAL SKILLS

Operating System: Window 2003/2008, Sun Solaris, UNIX, HPUX, AIX, RHEL

Databases System: Oracle 11g R2/10g R2/9i, RAC, Standby

Documentation Tools: MS Word, MS Excel, Powerpoint.

Tools: /Utilities: SQL Loader, Export, Import, RMAN, Oracle, OEM, Grid Control, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Oracle DBA consultant

Responsibilities:

• Used 11g and 12c Enterprise Manager / Grid Control to view database performance, user administration, run awr reports and add datafiles
• Used SRVCTL utility to manage RAC databases (shutdown database, shutdown instance)
• Performed database Cloning to setup test and development databases using RMAN
• Performed schema and table refreshes and created backups using datapump.
• Review alert logs, trace and dump files for errors using ADRCI utility
• Basic Performance tuning of Oracle databases 12c, 11g &10g.
• Worked very closely with development team on database change requests. Includes running / testing scripts in lower environment prior to release in production
• Created Service requests with oracle support and uploaded alert log, trace files and other information requested by Oracle support.
• Proactive database monitoring using 11g grid monitoring tool.
• Database Tuning by generating explain plans for long running queries, creating indexes on columns to improve performance and running stats for tables and schemas.
• Worked with application team to identify and kill long running or inactive sessions.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Generate Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Database dot release upgrades using oracle universal installer and catpatch.sql.
• Performed Security administration tasks, set up users accounts, passwords, roles, profiles and quota
• Helped individual users with database connectivity issues by checking user account status, checking listener and database status and checking TNS entry.
• Monitored data files, logical data storage and data growth activities
• Performing day - to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc
• Performed space management by analyzing current table space usage including TEMP tablespace and shrinking datafiles to gain space
• Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call support.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL1NET connectivity.
• Performed decom request for databases by dropping databases and delete any jobs scheduled through Crontab or EM and removing targets from Enterprise Manager.

Confidential, IL

Oracle Database Administrator

Responsibilities:

• Helped deploying RAC
• Helped deploying Data Guard.
• Installed Oracle clients on application servers.
• Worked on a faced paced working environment.
• Developed and implemented backup and recovery strategies.
• Developed policies and procedures for system operations to better serve clients.
• Setup Alerts via Grid Control.
• Load Data using SQL Loader from flat files
• Supported developers in running scripts
• Used TOAD to manage databases.
• Worked on SQL Server 2005 and 2008 instances.
• Schedule daily and weekly maintenance jobs in SQL server
• Setup the log shipping to create standby database in DR data center.
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production
• Supported multiple accounts on versions 9i to 11g
• Silent Installation of Oracle 11g on CentOS
• Create and maintain users, roles and privileges.
• Installed and configured Oracle Grid control.
• Extensively used data moving utilities like export/import, Data pump, Migrated flat files from different sources into Oracle Database using SQL*Loader and Performed DB cloning.
• Performed Online/Offline database backups.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.

Environment: Oracle 9i, 10g, and 11g, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, Unix, ASM, RAC, Goldengate.