SUMMARY:

• 8 years of experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Golden Gate and Enterprise Manager.
• Installation and administration of Oracle 11g/10g/9i on OEL, RHEL, Windows, HP - Unix, IBM-AIX and Sun Solaris in OLTPand OLAPenvironment.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting GoldenGateEXTRACT and REPLICATissues.
• Performed Migration and Upgrade of databases to 11g and 10g
• Upgrade of databases applying patches, patch sets and critical patch updates.
• As a DBA we use to give permissions to access the LDAPdatabases.
• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Experience on Oracle 11g/ASM/RAC and up gradation of standalone databases to 11g RAC environment
• Configuration of Automatic Storage Management (ASM)
• Configuration and Management of Data Guard on RHEL, OEL and Windows.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Golden Gate.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Migrating the databases from one platform to another platform.
• Implementation of Flashback Technology
• Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data loading.
• Detecting and diagnosing production system performance problem by analysingSTATSPACK reports, Oracle trace and log files, AWR, ADDM, analysing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Experience working with Database Resource Management
• Working experience in creating materialized views.
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• 24*7 on-call production database support and maintenance including remote database support
• Assisting in implementation of change control process in production.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS:

Operating Systems: OEL, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2 and Windows 98/NT/2000/2003.

Data Bases: Oracle 11gRAC/10gRAC/10g/9i/8i, SQL Server 2005/2008

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, JAVA

Tools: /Utilities: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch Management, SQLNET, ODBC, Export/Import, Data pump, DataGuard, VERITAS Net Backup, VMware, Logminer, CronTab, EXADATA

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation: Putty, Telnet, FTP, MobaXterm

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux andalso Upgraded from Oracle 10g to 11g.
• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment.
• Database Refresh from one version to another version.
• Manually monitor cell statistics with the help of CELLCLI.
• Installation and Configuration ofEM12C gridcontrol.
• Migration of database from one server to another server.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Installed, Configured and Administered Golden gate.
• Configured parameters for the Bi-directional replication.
• Implemented ASM on RAC and stand-alone databases. Managed disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Used cross platform transportable table space (TTS) to transport table spaces across platforms.
• Data Refreshin Test and Integration Databases using Transportable Table spaces.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Daily Health Check Up of the Database using AWR, ADDM.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Replication of tables to cross platformand Creating Materialized Views.
• Configured and Implemented Cold/Hot Backups.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Also configured database cloning using RMAN.
• Develop and enforce both database and OS-level security policies for data protection. Administer all databases in the areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Managing databases on multiple servers.

Environment: Oracle 10g, 11g, Linux 4/5, OEM, DBUA, RMAN, Golden gate, Grid, RAC, ASM, Exadata X2-2, Data guard, SQL*LOADER, AWR, ADDM, ASH, Data pumps, Exports/Imports.

Confidential, Mason, OH

Oracle Database Administrator

Responsibilities:

• Installed and Configured 2node RAC on Linux.
• Working Knowledge of installation and configuration of GOLDENGATE in Unix environment
• Done Installation and configuration of golden gate on 11g database for the replication.
• Implemented Bi-Directional replication in golden gate from target to source and source to target.
• Resolving the conflicts between the target and source database.
• Configuring parameters for DDL support in golden gate replication
• Installed and Configured and maintained oracle 10g and 11g.
• Oracle Grid Control11g Installation and Configuration.
• Involved in supporting 50+ production and development databases on RHEL.
• Refreshing the Database from one version to another version.
• Configuration of Physical Standby database for maximum performance mode - Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Involved in migration of applications of the clients.
• Loading data into database tables using SQL *Loader
• Implemented Materialized views, database links
• Regular database management on 10g and 11g OEM
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement
• Creating batch files and automating the tasks
• Granting roles and privileges to end users
• Managing, troubleshooting and resolving oracle database and application issues.
• Daily healthcheck-up of the database using TKPROF, AWR, ADDM.
• Monitoring alert log/system log and managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM, HTML

Confidential, UT

Oracle Database Administrator

Responsibilities:

• Installed and Configured Oracle 10gdatabases on Linux and also Upgraded Oracle databases from 10g to 11g
• Maintenance of around 20 databases combined on all the production, development and testing environments.
• Install and configured Oracle databases on windows server 2003 and 2008 platform.
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Involved in designing logical and physical data models using Erwin.
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implementedadvanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future .
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Environment: Oracle 11g/10g/9i, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle 10g RAC, TOAD, Erwin, STATSPACK, EXPLAINPLAN

Confidential

Junior Oracle Database Administrator

Responsibilities:

• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Involved in optimizing SQL statements using Indexes and Hints.
• Made use of the REF CURSORS in stored procedures for report generation.
• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.
• Involved in writing complex SQL statements.
• Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.
• Co-ordinated with System administrators, application developers for various activities.
• Maintained database security by managing users roles, privileges. Implemented new security rules via roles as per the company policies.
• Tuned the performance of the SQL’s using TkProf and Statspack reports.
• Performed security management and accessibility control by managing OS and Password file authentication, creating profiles, privileges and roles.

Environment: PL/SQL, Oracle 10g, TOAD, SQL PLUS, PL/SQL Developer, HP-UX 11.0