SUMMARY

• Around 8 years of IT experience in Oracle administrator with streams, Data guard, installation, migration, designing, backup, recovery, scripting, performance tuning etc.
• Excellent experience in Installation and configuration of Oracle 11g and 12 on Linux and OEL.
• Expertise in upgrading the databases from 10 g to 11g to 12c.
• Expertise in RAC installation, administration on RHEL
• Expertise in Silent installation of 11g and 12c.
• Provided 24/7 on call production support
• Expertise in disk space management
• Expertise in performance tuning using dynamic views and OEM.
• Strong experience in logical and physical data architect of RDBMS
• Expertise in bash and korn shell scripting.
• Key Responsibilities include Installation Of software upgrades, Backup and Recovery, Performance tuning, database reorganization, Disk Management, Capacity Planning, Problem resolution.
• Excellent expertise in Data Loading Techniques using SQL* Loader.
• Set up and managed Automated Storage Management (ASM) for 10g and 11g/12c databases.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$, DBA views and Data modeling, Logical and Physical databases design using tools like Erwin and Visio.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with ComVault.
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure
• Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY
• Expert in SQL* Loader, export/import and data pump to load data in to tables.
• Expert in tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms etc.
• Setup Oracle Goldengate and supported uni - directional replication.
• Setup Materialize views.
• Expertise in setting up Physical and Logical Data Guard environment.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATSPACK/AWR and ADDM reports.
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• On-Call 24x7 DBA support for production databases.
• Database Restore using RMAN, Cold Backup, Export and Flash Recovery, Data Pump
• Configuring database entries and monitoring all of the databases using Oracle Enterprise Manager (OEM).
• Extensive experience in applying CPU / PSU and one off patches.
• Build 11g Grid Control and 12c Cloud control from scratch.
• Managed databases on VMWare
• Created and Managed 12c container and pluggable databases.
• Used SQL Developer
• Very familiar with Oracle Dictionaries.

TECHNICAL SKILLS

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

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Databases System: Oracle 12c, 11g R2, 10g R2, MSSQL, RAC, Standby

Web Technologies: HTML, XML

Application Server: Web logic Server, IIS.

Documentation Tools: MS Word, MS Excel, Microsoft Project, Visio.

Tools: /Utilities: SQL*Loader, TKPROF, Export, Import, RMAN, Erwin, OEM, Grid Control, DB Console, SQL Developer, 12c Cloud Control

PROFESSIONAL EXPERIENCE

Confidential | St. Louis, MO

Oracle DBA

Responsibilities:

• Applied PSU patches.
• Performed Disaster Recovery
• Used 12c Cloud Control to setup Job, alerts and thresholds.
• Build Data Guard for DR.
• Migrated Non-ASM to ASM
• Analyzed ASH, AWR and ADDM reports and guided Development team.
• Check performance of databases
• Involved in 24x7 support
• Installed 11g database on standalone servers
• Supported multiple database
• Setup Alerts in Cloud Control
• Re-Designed RMAN backup
• Used RDA, ADDM and AWR reports to monitor the database performance.
• Database refreshes using RMAN.
• Cloned databases using RMAN Duplicated Database feature.
• Installed, migrated, configured and tested Oracle 11g databases in various environments.
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• Written shell scripts.
• Analyzed database objects.
• Worked on finding Top SQLs and Top Wait events.
• Migrating data across different platforms.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package and PCBO STATS package.
• Creating listeners, services, public and private database links.

Environment: Oracle 11g AIX, ASM, Linux, Data Guard

Confidential | New York, NY

Oracle DBA

Responsibilities:

• Installing 11g RDBMS and 12 databases on RAC on ASM, applying Oracle critical patch updates, implementing and managing Data Guard, Replication, Backup and Recovery support and performance tuning
• Installing Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control 11g Installation
• Experienced in installing OEM agent and hooking up to the grid
• Working on OEM 12C grid for monitoring the Listeners present in the oracle environment
• Troubleshooting RAC and implemented ASM features
• Applying necessary patches during installation and also in upgrade of databases
• Extensively working in setting up Oracle physical standby database using Data guard
• Experience with Data Guard Feature, Implemented building and Rebuilding of Standby Databases
• Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases
• Handy in utilizing data pump tool for exporting and importing the data between databases
• Participating and upgrading databases from 10g to 11g
• Performance tuning of queries consuming Excessive Resources or slow running queries by providing Required Hints to the Query
• Well experienced in taking Cold, Hot & Logical RMAN backup for very huge Databases
• Experienced in managing Daily Online backups (Level-0 and Level-1) and Archive Backups using RMAN
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Weekly Data Refresh from Production to Development and Test environments using Data Pump export/import
• Experienced in managing space issues in the Database Level for table space
• Experience with peregrine ticketing tools for resolving the tickets
• Build 12c Cloud Control.

Environment: Linux Oracle 9i/ 10g/ 11g/ 12c OEM, SQL*Plus, XMing, Putty, ASM, Data Guard, TSM

Confidential | Boston, MA

Oracle Database Administrator

Responsibilities:

• This project pertains to upgrading Oracle 11G.
• Worked with offshore team on deployment and releases.
• Build 2-node RAC clusters.
• Responsible for administration and supporting Oracle 10g/11g.
• Provide ON-Call 24*7 Production Database Support having 5-6 TB in size.
• Implemented Data Guard for maximum availability.
• Installed databases using scripts and silent install.
• Responsible for restoring and recovering database as required for Oracle.
• Upgraded the database from Oracle 10g to 11g, configured on ASM, and applied oracle patches on need basis.
• Manages database security by creating and assigning appropriate roles and privileges to users depending on the user activity on different environment databases.
• Monitors and manages database access, storage, and utilization using Grid Control.
• Used Shell Scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installed, Configured, Upgraded and Performed Trouble shooting for oracle Golden Gate 10g/11g Version.
• Proactively monitored the database and database access, and maintained the database security.
• Extensively worked under UNIX environment to provide DBA support.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Involved in database administration for monitoring and tuning of production database.
• Ran the Oracle STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
• Enabling the Trace files for the sessions which experience a very bad performance and generate the Trace output using TKPROF utility for further analysis.
• Trace the SQL that have poor performance and identify the ways of improving the performance by adding necessary indexes or removing the unwanted indexes.
• Trace the frequently called procedures/packages and pinning them to improve the performance.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Scheduling jobs through oracle JOB SCHEDULAR, Control M, Crontab (UNIX), Scheduled Tasks (Windows) and Maestro 7.0 (Job Scheduling Tool).
• Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues - helping to transform business requirements into environment specific databases
• Closely Worked with Oracle support in identifying some long standing issues. Also extensively used new oracle Metalink.
• Provided guidance for developers in writing and tuning PL*SQL stored procedures and SQL queries.
• Developed PL*SQL stored procedures, Indexes, cursors and database triggers to implement business rules.
• Alert monitoring and Ticketing.

Environment: Oracle 10g/11g, UNIX, Linux (Red hat), Data Guard, RMAN, Shell Scripting.

Jr. Oracle DBA

Responsibilities:

• Installed databases using scripts.
• Setup tns entries
• Creating shell scripts
• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and Training.
• Document database creation and parameter changes.
• Shadow Sr. DBAs on releasing and deployments.
• Database configuration on parameter file and operating system file.
• Database User Creation with limited rights as per specific module under specific client. Creating roles and profiles as per system study and assign to users.
• Configured listener for external procedure calls.
• Setup backups using OEM
• Setup alerts and thresholds using grid control.
• Upgrade the databases from Oracle 9i to Oracle 10g using DBUA and Manual Upgrade methods.
• Creation of database objects like Tables, Indexes, Views, Users, etc.
• Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.
• Responsible for Data load on different databases using SQL*Loader.
• Managing table spaces, user profiles, indexes, storage parameters.
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 9i.

Environment: Oracle 9i and 10g, Linux, Solaris.