SUMMARY

• 7 years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.
• Experience in Installation, Configuration and Maintenance of Oracle 11g/10gRAC with ASM and single instance database.
• Oracle Database Administration in a variety of environments like Linux(Red Hat), Sun Solaris, and Windows NT/2000/2003.
• Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKProof, AWR, ADDM.
• Experience in installing, maintaining, upgrading, migrating and patching Oracle versions 11g/10g/9i/8i.
• Setup of Standby database for faster disaster recovery and Data guard setup for high availability.
• RMAN procedure for backup and recovery and also cloned database using RMAN Duplicate.
• Managed Oracle databases in High Availability environments using Failover, Clustering, Mirroring, Dataguard and Cloning technologies.
• Experience in performing needs assessment, database planning and design, application testing and integration, production cutover, change management.
• Experience in Database problem resolution, dealing with Oracle, creation of SRs.
• Migrated database from 9i, 10g to 11g by using Scripts and applied patches by Opatch utility.
• Worked on 10g New Features: Data Pump, Automatic performance and diagnostics, Flash Back Technology, 10g RMAN’s New Features and Dataguard(stand by database).
• Experience in database full Backup (hot and cold), Incomplete Backup, fail - over, DR methodologies, DataPump Export/Import, FTP, SQL Backtrack and Restore procedures.
• Experience in Space Management, Rollback segments, Undo segments and Capacity Planning.
• Production and Dev Support for RAC environment.
• Performance tuning of Oracle servers, databases and SQL.
• Experience in Database creation with RMAN jobs and security implementations in Oracle.
• Ability to write, debug and tune sql and pl/sql, packages, procedures, functions, triggers.
• Used parameters to configure, install and manage ASM instance in 10g RAC.
• Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Dataguard.
• Expertise in using imp, exp, SQL loader and also performing tablespace additions, database recovery and backups.
• Good experience in Database Creation, Partitions, Setting-up parameters, Tablespaces, Indexes, User Setup, Roles, Security, Storage and hands on experience in network management.
• Documented all Oracle database installations and database operations

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL 2.1, 3.x, 4.x

RDBMS: Oracle 11g/10g/9i/10gRAC.

Languages: SQL, PL/SQL,DOT NET, JAVA, XML, UNIX Shell Scripting.

DB Management: TOAD, OEM, DB Artisan, OEM Grid Control.

Tools: /Utilities RAC, OEM Grid Control, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, TOAD, Patch Management, Oracle Warehouse Builder, Rational Clear Quest, SQLNET, ETL, ODBC, Oracle Streams, Shareplex, Data pump, Data Guard, VERITAS Net Backup, VMware

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

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 0, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Oracle DBA

Responsibilities:

• Installed and Configured Oracle 11.2.0.3 databases on Linux and also migrated Oracle databases from Solaris to Linux.
• Worked with Infrastructure and Operation Database Engineering Team.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using DG Broker for RAC one Node Databases.
• Configured and installed RAC One Node Production Databases with Automatic Storage Management (ASM).
• Provided 24/7 on-call support for Oracle production/development databases to ensure maximum availability.
• Installed Automatic Storage Management (ASM) for stand-alone and RAC One Node databases and performed migration of databases from file systems to ASM.
• Configured and installed GoldenGate in unidirectional and Bi-directional replication for Oracle 11g Databases for High availability and reporting projects
• Configured RAC 11gR2 Data Guard Standby Databases using Data Guard Broker.
• Performed RMAN backup and also developed backup strategies using incremental and cumulative backup methods.
• Scheduling the backups for the database using EM 12C cloud control.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Configured and Implemented Oracle 11g Database Two node Real Application Cluster (RAC) using Automatic Storage Management (ASM) and responsible for High Availability.
• Extensively worked on 12C Oracle Enterprise Manager (OEM) grid control for monitoring needs.
• Performed various RMAN strategies like RMAN Backup, RMAN Restore and RMAN Recovery etc.
• Configured and Performed Hot and Cold Backups for Non-prod databases, and Cloning of Databases using RMAN methodologies for setting up UAT and DEV environments.
• Excellent experience of database Backups and Recovery strategies using RMAN, Export Import

Environment: Oracle 10g/11gR2 RAC, Windows 2008, Sun Solaris 10, Red Hat Enterprise Linux 5, ASM, RMAN, GoldenGate, FTP, putty, Data Guard, OEM11 &12C, TOAD, PL/SQL, SQL*Loader.

Confidential, Annapolis, MD

Oracle DBA

Responsibilities:

• Installation and creation of Oracle 9i databases on Production and Test Linux servers.
• Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Refresh test database from production using Recovery Manager (RMAN).
• Troubleshoot databases, provide reports on the database health check, follow up and recommendations.
• Great experience in using FTP utility program for copying files on UNIX and Windows systems.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Responsible for monitoring and estimating the size of the database & growth, and configuring the database accordingly.
• Responsible configuring listeners for network connectivity and security.
• Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
• Responsible for taking regular backups including cold / hot backups, Export / Import of database, using RMAN, and recovery in case of disasters.
• Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), move Archive Logs to different mount point when Archive Destination is full and Resync RMAN catalog. coded stored procedures, triggers, table creation and indexes in Sybase and MS-SQL servers
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.
• Creation and maintenance of stand by database by using oracle high availability method Oracle Data Guard.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: Oracle 9i / 10g, OEM, RMAN, DBCA, Data Guard, Putty, XML, FTP, TOAD, UNIX, Solaris, Windows XP

Confidential, Raleigh, NC

Oracle DBA

Responsibilities:

• Installed Oracle 10g database on Sun Solaris, Red Hat Linux.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
• Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Haveworked on backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Experience in handling GUI software and OS.
• Database Restore using RMAN, Cold Backup and Export.
• Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used impdp /expdp and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Optimize JDBC and java stored procedure code. Provide stress testing and scalable using thin vs OCI driver. Web Logic EJB performance tuning.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris, Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid Control, RMAN, DBCA, Data Guard, Putty, TOAD 8.1,UNIX, Linux 4.0.

Confidential

Oracle DBA

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Responsible for optimizing the queries and application tuning.
• Implement Hot, Cold and Logical backup plans.
• Designed backup and recovery procedures for OLTP system
• Use TOAD tool to access the database.
• Used PL/SQL developer to create PL/SQL Procedures.
• Refresh/Cloning of Database for development, testing.
• Monitoring and Management of database users.
• Testing PL/SQL procedures against the test cases.

Environment: Windows 98/NT / 2000, HP-UX, AIX, Oracle 9i, TOAD, Database Tools/Utilities, Oracle Enterprise Manager.

Confidential

Jr. Oracle DBA/Developer

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup Script creation and Standardization. Performed Database Installation and up gradation.
• Created materialized views, table partition for Tuned databases.
• Created indexes, rebuild indexes and maintained indexes.
• Involved in user creation and user access control. Involved in Schema creation and management.
• Implemented Oracle security features Applied and audit mechanisms for Fine grained access control.
• Maintained the RMAN repository and customized recovery catalog.
• Customized Data Guard as a tool for Disaster Planning and implementation.
• Created Logical and Physical standby Databases to ascertain high availability of database during system crashes.
• Performed database tuning for daily loads and slow response issues.
• Used Triggers for database activities, like delete, update triggers.
• Used STATSPACK, PERFSTAT, TKPROF utilities for Tuning and analysis.
• Involved in session management and monitored the critical wait events in the database.
• Involved In query optimization and using rule based optimizers and cost based optimizers.
• Used SQL* Loader for data import from remote databases
• Written the control files in SQL*Loader to load the files in database tables.

Environment: Oracle 9i, 10g, SQL, PL/SQL, Oracle Enterprise Manager Database Control, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux.