SUMMARY

• Over 6 years of experience as Sr Oracle DBA in various domains. Worked extensively on oracle 11g, 10g and 9i versions involving Database Administration, Production Support, Installation, Configuration, Upgrades, Performance Monitoring and Tuning, Backup and Recovery, Migration, Patches, Cloning, RAC, Data Guard, Grid Control, Goldengate, Space Management, Database security, Troubleshooting database issues.
• Expert in Installation, Configuration, Cloning, Trouble shooting and Performance tuning of Oracle 11g/10g/9i databases on AIX, LINUX, WINDOWS and UNIX platforms.
• Experienced in providing 24/7 on - call support for Oracle production databases to ensure maximum availability.
• Extensive Experience in Oracle Exadata.
• Worked on basic administration of SQL Server.
• Worked on supporting and managing very large oracle databases up to 2 TB (OLTP) and up to 24 TB (Data-warehouse databases).
• Involved in Installation, Configuration and Implementation of Oracle database and Real Application Clusters (RAC) on different nodes configuration (2-node, 3-node and 4-node) with Automatic Storage Management (ASM).
• Installation and Configuration of Oracle 11gR2 RAC with ASM on multi node systems.
• Installed SQL server 2007 on windows server 2003 and migrated SQL server database to Oracle Systems using SQL*Loader.
• Experienced in setting up Oracle 10g, 11g, 2, 3 and 4 Node RAC implementations & administration using CRSCTL, SRVCTL command utilities in LINUX and AIX environments.
• Experience in administrating ASM disk group using ASMCMD command line utility.
• Implementation of High Availability Solutions using Oracle 11gR1, 11gR2 RAC, 10g RAC, and Dataguard with physical standby/logical standby.
• Experienced in setting up active Dataguard.
• Experienced in setting up unidirectional and bi-directional replication using Goldengate 11.1 for high availability and reporting projects.
• Experienced in Goldengate upgrades from V10.4 to 11.1 for oracle 11g databases.
• Experienced with working on various UNIX platforms (Solaris (10), HP-UX (RISC and Itanium 11.31, AIX (6.1), Linux), Windows server 2000/2003 with Oracle (9i, 10g, 11g), 10g RAC, 11gRAC, Data Guard and RMAN.
• Experienced in day-to-day DBA activities including schema management and database security(creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Excellent support in providing DBA support for People-soft, CRM applications also provided support during new code releases and application upgrades.
• Very good experience in doing cross platform migrations using RMAN and Transportable tablespaces.
• Upgraded several databases from oracle 9i, 10g to 11gR2 using both DBUA and also manual methods.
• Hands on experience of database Backups and Recovery strategies using RMAN, Export Import.
• Monitoring and optimizing the Database Performances through Database Tuning, System Tuning, and Application/SQL Tuning.
• Well versed in Loading external data into the database using SQL*Loader, External Tables, etc. and moving data from one database to other using Data Pump and Export/Import.
• Experienced in setting up and configuring 10g OEM grid control and also OEM agent deployments in multiple servers.
• Configured database alerts and reports using OEM grid control for monitoring needs.
• Excellent experience in various migration techniques like export/import, Data pump, backup restore, data guard and cloning.
• Experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM and ASH reports, and tuning of SQL’s using EXPLAIN PLAN, Auto Trace and TKProf utilities.
• Good Experience in setting up Hot and Cold Backups for Non-prod databases and cloning of Databases using RMAN methodologies for setting up UAT and DEV environments.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes and TOAD Data modeling utilities, Logical and Physical database design.
• Experience in administering Oracle Database using tools like Oracle Enterprise Manager, Toad, and PL/SQL Developer.
• Experienced in setting up jobs to automate many DBA tasks using CRON and dbms scheduler.
• Good experience in applying one off patches, Critical Patch Update (CPU Patches) and quarterly PSU’s to facilitate security and bug fixes.
• Experience in understanding business requirements for analysis, detailed design, database design and development of applications. Worked with various projects in large enterprise projects.
• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.
• Excellent ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Database: Oracle 11g, Oracle 10g, Oracle 9i

Languages: SQL, PL/SQL, Unix Shell scripting.

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

Operating Systems: Windows 2000, XP, 2003, Red Hat Enterprise Linux (RHEL) 4.x, 5.xSun Solaris 5.8/5.9/5.10 , AIX 5.2/5.3/6.1

Tool: and Utilities: Oracle Grid, OEM, TOAD, Putty, Erwin, SQL loader, Export / Import Expdp / Impdp, AWR, ADDR, STATSPACK, RMAN, VMware, Win SCP, TKPROF, Log Miner

PROFESSIONAL EXPERIENCE

Confidential, Des Plaines, IL

Oracle DBA

Responsibilities:

• Responsible for Oracle11g logical and physical databases design, implementation and maintenance on UNIX.
• Installing, Configuring, Patching and Managing Oracle 10g/11g RAC and Single instance Databases with 100 GB to 8 TB sizes.
• Working on 2 and 3 node RAC performance issues related to RAC Cluster and ASM.
• Provide on-call production database support. Moved database Schema changes to stage or production.
• Expertise in installing of Oracle11g 2-Nodes RAC with Clusterware and ASM.
• Migrated stand alone data base to Exadata X2 half RAC.
• Proficient in administrating Exadata Sell Server using Sellcli command line utility.
• Experience in maintaining ASM Disk group by adding new disk to existing disk groups or creating one.
• Experience in installation and configuration of Oracle Goldengate for replication and reporting purpose.
• Performing Schema as well as Table level replication using Oracle Goldengate.
• Implementing disaster recovery solution using ORACLE Dataguard for critical applications.
• Proficient in using DGMGRL (Dataguard Broker) utility to administer Dataguard configuration.
• Experience in using 11g, 10g features Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, ASH, EXPLAIN PLAN, TKProf and Recycle Bin.
• Configure ASM disk groups to store Data files, redo log files, and control files.
• Expertise with different Backup and Recovery strategies, Cloning (using Recovery Manager - RMAN), creating RMAN scripts, VERITAS Net Backup, Export / Import, DataPump, TTS, and Hot and Cold back-ups.
• Performing periodical Backup and Restoration and recovery using RMAN (full and incremental) and RMAN incrementally updated backups.
• Analyzing and monitoring wait events on production databases to implement improvements for buffer busy waits/sequential and scattered read contentions.
• Experience in Bulk Loading of data from flat files using SQL*Loader.
• Extensively experienced in Oracle Database monitoring and tuning using Oracle Enterprise Manager (OEM) monitoring.
• Create partitions and indexes for tables in database to improve query performance.
• Develop shell scripts, SQL and PL/SQL scripts in support of database operations.
• Implement database refresh with the hot backup using DUPLICATE or full export. Used EXPDP/IMPDP to do table level, Schema and full database refresh.
• Expertise in creating Users, Roles, Profiles and Privilege management with role-based security.
• Apply relevant quarterly security patches for multiple oracle databases.
• Perform database tuning using Explain Plan, Hints, Toad, AWR, ADDM, ASH, TKProf and Enterprise Manager.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc
• Provide advanced technical troubleshooting for applications and database systems with emphasis on root cause analysis.
• Monitor the performance of UNIX Servers using TOP,VMSTAT, IOSTAT,NETSTAT and SAR.

Environment: UNIX AIX, Oracle 11g, Golden Gate, Exadata OEM, Erwin 4.0, RAC, Data Guard, PL/SQL, Export/Import, SQL*Loader, RMAN, Linux 5.0, VMware.

Confidential, Radnor, PA

Oracle DBA

Responsibilities:

• Installed and implemented 2-node RAC on RHEL/UNIX and worked on ASM features of Oracle.
• Worked as a team member to provide 24x7 on call production database support.
• Worked in backup team and was responsible for configuration and implementation of backup strategies using RMAN and Data Guard in RAC environment.
• Installed and configured Golden gate 10.4 for 10g databases for high availability.
• Team member of strategic planning team was responsible for developing backup and recovery strategy, database tuning strategies, capacity planning etc.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Cloned production database to the test environment using Recovery Manager (RMAN).
• Extracted data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting.
• Performed daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, managing user groups, Database security and OS space monitoring etc.
• Monitored database Performance using AWR, ADDM, SQL Tuning Advisor, SQL Analyze, TKPROF, STATSPACK and tuning parameters for optimization of system performance.
• Supported Automatic Storage Management (ASM) database and performed migration of normal database to ASM database using RMAN.
• Export and Import of database objects to copy from one database to another database as well as copy the export dump file to tape that can act as a backup.
• Worked on conventional import/export and Data pump utility.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.
• Used UNIX shell programs & CRON jobs for automating the process of refresh of data periodically.
• Documented Data Base Setup and administration of Server Environment.
• Installed, upgraded and maintained database software, included creating user accounts, cloning database systems, ensuring nightly backups are performed, applying software patches.
• Performed data loading from CSV/flat files using scripts and SQL Loader
• Developed automated scripts for database creation and builds.
• Upgraded databases applying patches, patch sets and critical patch updates.
• Designed and implemented Backup and Recovery strategies (both cold and hot backups) and performed periodical backup, restoration and recovery using RMAN(full and incremental)
• Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Handled large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Granted roles and privileges to end users as per the requirement.
• Installed and Configured Oracle 10g, 11gR1 databases on Linux and also Upgraded Oracle databases from 9i to 10g version.
• Scheduled various job using UNIX Crontab utility.
• Managed Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.
• Performed cloning of the database using the RMAN utility.

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

Confidential, Columbus, OH

ORACLE DBA

Responsibilities:

• Installed and configured Oracle 10g databases on Linux and also upgraded Oracle databases from 9i to 10g version.
• Implemented Oracle Database 10g 2-node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Provided production support for the 24x7 Oracle database availability.
• Configured Oracle Data guard for Disaster recovery solutions.
• Achieved high availability, data protection and maximum performance by maintaining physical standby databases.
• Restored and recovered 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.
• Implementation and configuration of Oracle Goldengate.
• Extensive use of Oracle Data pump, 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.
• Performed Schema as well as Table level Replication using Oracle Streams. Also migrated data from Oracle to SQL SERVER, Sybase, etc., for testing, reporting and analysis requirements.
• 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.
• 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.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced 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.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Experienced in performing Point in time recovery using RMAN.
• Estimated growth of database size by detail analysis of the company’s future policies and generated reports for the management to act in advance.

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

Confidential, Rhode Island

Oracle DBA

Responsibilities:

• Involved in 24x7 supports for both production and development databases with on-call.
• Installed 9i and 10g databases for Testing and Development
• Upgradaded Database from 9.2.0.6 to 10.2.0.2 and patching.
• High availability 24/7, Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.
• Performed database Cloning to setup test and development database.
• Applied patches using OPATCH and applying patch sets using OUI.
• Implemented and maintained read only snapshots and snapshot logs.
• Implemented database security by setting up auditing, roles and privileges.
• Created database schemas, tables, indexes, tablespaces, data objects, packages, procedures and functions.
• Well versed with the usage of Oracle export and import utilities.
• Developed RMAN scripts for database backup and recovery.
• Planned and scheduled Backups, taking Logical Backups (with Export/Import Data pump utilities)
• Tuned the SGA components like buffer cache, shared pool to avoid paging & swapping hence reducing I/O bottle-necks in 9i, 10g environment.
• Did the regular activities like monitoring the alert logs, redolog status, listener, v$session and checking the space for normal segments, rollback segments.
• Provided support to development teams for the conversion like creating database objects, Schemas creation, tables, indexes, constraints etc.
• Tuned SQL Queries using the Tools such as TKPROF and EXPLAIN PLAN
• Experienced with the UNIX operating system and command set as well as competence with shell scripting.
• Conducted sizing and capacity planning for Oracle databases.
• Monitored Growth of tables and undertaking necessary re-organization of database as and when required.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.

Environment: Oracle 10g, 9i and 8i, Linux 5.0, Sun Solaris 9, IBM AIX, TKprof, OEM, NET8.

Confidential

Jr. Oracle Developer/ Database Administrator

Responsibilities:

• Planned, Installed and Configured Oracle Database on the Server.
• Made changes to the parameter file as requested by the customer and ensured a clean database startup for the changes to take effect.
• Coordinated Backup and Recovery operations over all databases, ensuring 100% recoverability.
• Performed Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.
• Wrote Stored Procedures for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Created Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Created of Users and Granting them privileges and roles.
• Used extensive Sub Queries, PL/SQL procedure, DDL functions, database triggers and packages.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Responsible for physical and logical backups of database.
• Wrote PL/SQL procedures and functions. Writing shell scripts to automate the data loading.
• Performed Database Tuning. Performed Database Security and Integrity.
• Monitored the data loading jobs and tuning the SQL queries.

Environment: Oracle 8i, UNIX (Sun Solaris), SQL*PLUS, Quest software tools, Export/Import.