SUMMARY

• 8+ years of experience in Oracle Database Administration. Worked extensively on Installations of Oracle Database Software 11g, 10g, 9i,8i on OEL, RHEL, UNIX, AIX, Sun Solaris and Windows environments. Experienced in Oracle Database's High Availability solution set like, configuration and monitoring of Oracle Real Application Cluster (RAC), Data Guard and GoldenGate.
• Experienced in Upgradation, applying oracle PSU and CPU Patches, Migration, Backup and Recovery, Cloning oracle database from production to development, Replication, Database Security, RMAN, User management, Performance tuning and monitoring the database using OEM Grid Control.
• Experience in Installation and administration of oracle 11g/10g/ 9i on OEL, RHEL, UNIX, and Windows Environments.
• Upgradation of databases applying patches, patch sets, critical patch updates.
• Performed Migration and Upgradation of databases from 9i to higher versions 10g,11g.
• Worked with very large scale Database environment and mission critical OLTP and OLAP systems ranging from 1TB to 4TB.
• Configuration of high availability solutions like RAC and Active Data Guard environments.
• Configuration of Real Application Cluster with ASM and monitoring RAC instances with CRVCTL and SRVCTL.
• Installation, Configuration and Maintenance of Logical and Physical standby databases in Active Data Guard.
• Experience in monitoring Oracle instances and managing databases using Oracle Enterprise Manager Grid Control (OEM Grid).
• Configuration and implementation of Oracle ASM.
• Backup and Recovery strategies using RMAN and configuration of Recovery catalog for multiple databases.
• Experience with logical backups of the database using Data Pump (Expdp and Impdp).
• Performed both cold and hot backups, periodical backups of both full and incremental and restoration, recovery of database using RMAN utility.
• Experience with Database cloning and refreshing production database with pre - prod and dev databases.
• Configuring Oracle GoldenGate for replications and troubleshooting it's issues.
• Experience in implementing and replication using Quest Shareplex.
• Good knowledge of Data Dictionary.
• Experience in Performance Tuning for better performance.
• Generate and interpret Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports, detect and diagnose the production system performance problem, also using trace files.
• Experience in monitoring and optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning and Optimization both in rule based and cost based.
• Oracle performance tuning services like explain plan, TKPROF, STATSPACK and SQL trace are delivered for customers.
• Implemented Oracle Advanced Security options such as data encryption for data privacy.
• Experience in installation and performing database related activities using Oracle Enterprise Manager (OEM) and TOAD and setup of Oracle Grid Control.
• Flashback Technology is implemented.
• Extensive experience with SQL*Loader, External tables and Oracle Application Express for Data Loading.
• Experience on Data replication using Materialized views, Snapshot and Oracle streams.
• Experience on Enterprise Storage solutions like Storage Area Network (SAN) and Network Attached Storage( NAS) for the enterprise databases.
• Proficient in designing ETL processes, PL/SQL procedures, Triggers and Functions.
• Experience in using Data Modelling Tools and designing DW model.
• Experience in capacity planning, space management and data transfer from flat files to Databases.
• 24*7 on call support for production database .
• Good at Root Cause Analysis and quick approach to solutions for various issues and strong at analytical skills.
• Good technical skills and willingness to learn and implement new concepts.

TECHNICAL SKILLS

Databases: Oracle 11g, 10g, 9i

Oracle Products: Oracle10g Grid ControlOperating System: OEL 4,RHEL 4, RHEL 5, WIN NT/2003/2008, Solaris 10HP-UX Itanium, IBM AIX

Utilities: Oracle Data Pump (expdp and impdp), SQL*Loader, RMAN, GGSCI, DGMGRL

Protocols: HTTP,TCP/IP,FTP,SFTP,TELNET

Languages: SQL, PL/SQL, UNIX Shell Scripting.

Other Tools: TOAD, Putty, SQL Developer, Erwin, Veritas Cluster Manager, Quest Shareplex

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, Missouri

Senior Oracle DBA

Responsibilities:

• Installation, Configuration and maintenance of Oracle 11g/10g database software on RHEL and Oracle Enterprise Linux (OEL).
• Configured 3-node Real Application Cluster (RAC) and monitored RAC instances with Oracle Enterprise Manager Grid Control.
• Oracle Enterprise Manager Grid Control 11g Software installation and Configuration.
• Upgradation of Oracle Grid infrastructure and Oracle Database software from 11.2.0.1 to 11.2.0.3 on 3-node RAC environment.
• Upgradation of databases applying patches, patch sets, critical patch updates. Configured and implemented Oracle 11g ACTIVE DATAGAURD for Database Disaster Recovery by using DATA GAURD broker (DGMDRL).
• Configured Physical Standby databases and logical Standby database for ACTIVE DATA GAURD.
• Configuration of Oracle ASM on RHEL and HP-UX and managing disks and disk groups.
• Configuration and implementation of Golden Gate based replications through GGSCI.
• Bi-directional replication and Uni-directional replication in Golden gate.
• Done migration of non-ASM database to ASM databases.
• Implemented ASM on RAC databases and standalone databases.
• Involved in monitoring the database related activities using Oracle Enterpriser Manager 11g Grid Control and monitoring the backup jobs scheduled in Oracle Enterpriser Manager (OEM).
• Performed oracle database refreshes using expdp/impdp from production to test database.
• Done with performance tuning related jobs like general health checks and maintenance of databases using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports by finding wait events.
• Performed logical backups of schemas and database using DataPump (expdp/impdp) as per requirement.
• Cloning of Databases using RMAN.
• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
• Managing the existing the GoldenGate replication process and setting up new GoldenGate replications for ETL process.
• Daily incremental backup and weekly full backup of databases using RMAN.
• Participated in regular on-call support for production databases.

Environment: Oracle 11g/10g, Oracle Enterprise Manager Grid Control, ASM, Real Application Cluster Loader, Oracle Enterprise Manager (OEM), TOAD, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Confidential, Cleveland, OH

Senior Oracle DBA

Responsibilities:

• Installation, configuration and administration of Oracle 10g and 11g databases on RHEL.
• Monitoring several database of Terabyte sizes using Oracle Enterprise Manager (OEM).
• Configured 2-node Real Application Cluster (RAC) through clusterware and ASM .
• Upgradation of databases applying patches, patch sets, critical patch updates.
• Performed upgrade of database from 10g to 11g with Oracle Database Upgrade Assistant (DBUA) in development, testing and production.
• Had installed Golden Gate on Oracle 11g Database.
• Successfully configured Oracle Golden gate for replication of database.
• Configured the parameters required for the replication.
• Configured parameters for the DDL support.
• Configured parameters for the Bi-directional replication. Had a good experience in resolving the conflicts in the Bi-directional replication.
• Implemented DataGuard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Performed HOT backup and COLD backup.
• Performed RMAN backup and also developed backup strategies using Incremental and Cumulative backup methods.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Worked on creation of users, granting roles and privileges to users, tablespace management.
• Performed daily monitoring of Oracle instances using Oracle Enterprise Manager (OEM) and Grid control to monitor users, tablespaces, memory structures, log and alerts.
• Performed large data loading from external tables to database using SQL*LOADER.
• Done migration of non ASM database to ASM database..
• 24x7 remote support and on call support for database developer users and end user.
• Experience in cloning of database using RMAN tool.
• Performance tuning of database by using the reports AWR, ADDM, ASH, TKPROF, STATSPACK, SQL TRACE, EXPLAIN PLAN.
• Planning the backups and scheduling them.
• Taken backups using RMAN, logical (import/export, impdp/expdp), hot and cold backup.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Creating and scheduling Oracle backend process jobs in crontab.
• Performed policies on data confidentiality, integrity, availability, and auditability, Based on Access Controls for Access to Data at the database level.
• Applying security patches both Server side and Client side and Performed testing.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.

Environment: Oracle 11g/10g, SQL, PL/SQL, ASM, Oracle Enterprise Manager Grid Control, Real Application Cluster Loader, Oracle Enterprise Manager (OEM),SQL Developer, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Confidential, Irving, TX

Senior Oracle DBA

Responsibilities:

• The work involves overall maintenance of Oracle 10g database, performance tuning, backup, recoveries and other database related activities.
• Installation and configuration of 2 node RAC.
• Configuration and installation tasks related to ASM.
• Configuring a Physical standby with Maximum Availability mode.
• Taking Backups on scheduled time and monitoring scheduled RMAN Backups.
• Creating and dropping of users, granting and revoking privileges as and when required.
• Day to day performance monitoring and tuning of database.
• Monitoring of database objects like rollback segments, temp segments and tablespaces.
• Diagnose and troubleshoot Database problems and failures
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery plan.
• Creation and maintenance of database.
• Configuration of Listener using NETCA.
• Experience in implementing and replication using Quest Shareplex.
• Handling day-to-day activities.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring of database for growth and performance.
• Monitoring Database for fragmentation and correcting them.
• Creating and implementing backup and recovery strategies.
• Setting up and maintaining user accounts and profiles.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Creating Databases and all database objects. Database Designing (Designing Tablespaces and Rollback Segments)

Environment: Oracle 10g, Sun Solaris, HP-Unix, UNIX, Linux 4.0, RMAN, DBCA, DataGuard, EXPLAIN PLAN Cloning, OEM, STATSPACK, TKPROF

Confidential, PA

Oracle DBA

Responsibilities:

• 24x7 Production database (Oracle 9i) administration.
• Configuring and maintaining a physical standby database.
• Backup/Restoration, scheduling Backups and taking Logical Backups.
• Coordinate with Unix Administrators for space management on various servers and help in Oracle.
• Monitoring of database performance during peak and non-peak loads.
• Conducting sizing and capacity planning for databases.
• Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Setting up Physical Standby Database in Remote Location for Disaster Recovery.
• Support & Maintenance of Production/Development Databases on various servers.
• Creating users, tables with appropriate table space, Indexing and database links.
• Performing Partial, Complete and Metadata Exports & Imports.
• Automating processes, scheduling jobs per user requirements using DBMS JOB.
• Used OLTP class of program by managing transaction oriented application for data entry and retrieval transaction.
• Tuning the Databases for optimization using STATSPACK and EXPLAIN PLANS, Estimating Table & Index Size.
• Partitioning Strategies for very large tables.
• Performed backup and recovery for both hot and cold backups.
• Daily monitoring and optimizing the performance of the database to ensure that database resource such as tablespaces, memory configuration, sessions, archive files, etc, are in their proper status.
• Scheduled jobs through Oracle Job Scheduler.
• Created/Altered/Modified database objects.
• Responsible to troubleshoot both Oracle applications and backend data base errors
• Configured and managed users, security and redo logs.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service when required.
• Oracle Installation, patch application and migration of databases to newer releases of Oracle.
• Supported test and development environments to ensure smooth transition of applications

Environment: Oracle 9i, Sun Solaris, HP-Unix, UNIX, Linux 4.0., RMAN, DBCA, DataGuard, EXPLAIN PLAN Cloning, OEM, STATSPACK, and TKPROF.

Confidential

PL/SQL Developer and Junior Oracle DBA

Responsibilities:

• Installed and configured oracle 8i/9i databases.
• Created database and location of initial data files, redo log files, control files and multiplexing them editing database initialization parameter files.
• Designed and implemented backup and recovery strategies by using cold and hot backups.
• Tuned application SQL using STATSPACK, SQL Trace and TKPROF.
• Optimized and fine-tuned the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes.
• Created users and assigned roles and profiles to users.
• Maintained data integrity, profiles, resources and password security.
• Used direct path loading vi SQL*Loader/ SQL INSERT statement, CREATE TABLE AS SELECT statements, specifying NOLOGGING on staging table, table spaces, parallelized SQL statement execution where appropriate tables.
• Developed PL\SQL code such as procedure, function, package or triggers as well as working with pre-defined oracle package to administrate database.
• Coordinated with developers and users connecting to different databases, setting policy and procedures as they relate to database maintenance, security, backup & recovery, SQL coding guide lines.
• Designing and creating schema objects like Database tables, Indexes, Views, Synonyms and all schema objects in Oracle
• Implemented the specific functionality by developing complex PL/SQL code like functions, procedures and packages.
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Creation of users and Granting them privileges and roles.
• Provided production support on the various databases and resolved production issues proactively.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory and operating system.
• Writing Shell scripts to automate the data loading processes using Cron jobs and PL/SQL procedures are scheduled using oracle job scheduler.
• Worked with non-technical team members assessing their requirements and preparing functional and technical specifications.

Environment: Oracle 8i,9i, SQL Server 7.0, PL/SQL, SQL Loader, RMAN, Oracle Parallel Server, Import, Export, Oracle Enterprise Manager (OEM), TOAD, Oracle warehouse Builder, Erwin Designer, SQL Navigator, HTML, JDBC, MS Access, Sun Solaris, HP-UX and Windows NT.