SUMMARY

• Over 6+ years of IT experience as an Oracle Database Administrator on a variety of Operating Systems (RHEL, Solaris, HP - UX, AIX, Windows NT 4.0/2000/2003 ) with Oracle ( 8i, 9i, 10g, 11g), RAC, standby, replication, installation, configuration, migration, sizing and space management, backup and recovery, performance tuning and troubleshooting.
• Experience in database administration for Oracle 8i, 9i and 10g, 11g, Configuring Single instance, Oracle Real Application Clusters (RAC) and Automatic Storage Management (ASM).
• Excellent experience of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Proficiency in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence, materialized views), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), UNIX Shell Scripting, scheduling jobs.
• Experience in migration techniques like export/import, datapump (expdp, impdp).
• Extensive knowledge on database backup/recovery strategy RMAN, cloning, Data guard.
• Experience in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Experience in maintaining Standby Databases using Data Guard and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, Normalization and its normal forms, tuning of SQL scripts using SQL Trace and TKProf.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases, Application Servers and Middle Tiers.
• Experience in using OEM, TOAD, SQL Developer and Data loading using SQL*LOADER, Logical and physical modeling using ERWIN.
• Experience in using Flashback, Log miner and Network Configuration using NetCA.
• Experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, Sun Solaris 9.0/10.0, and Windows NT/2000/2003/XP, HP-UX, IBM-AIX 5L, 6.

Rdbms: Oracle /11g/10g/9i/8.x, Oracle 10g Real Application Clusters (RAC).

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

Software / Utilities / Tools: Srvctl, Crsctl Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, ERWIN, Clusters, SQL Loader, FTP, TOAD 7.6/7.5, Oracle Enterprise Manager(OEM), Data pump, Data Guard, TKPROF, STATSPACK, AWR, ADDM.

Web Technologies: HTML, XML, JSP, Servlets

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Oracle DBA

Environment: Oracle 10g/11g RAC, RHEL 5.5, AIX 6.1, FTP, putty, OEM.

Responsibilities:

• Installation and configuration of Oracle 11g.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Installation of Oracle database 10g/11g software with RAC using Oracle Clusterware. Installation of Oracle 10g management agent and grid control.
• Administration of a 2 node RAC, configuring and monitoring daily backups, troubleshooting errors, to improve performance.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager / Grid Control to monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.
• Implemented the Oracle Physical Data Guard for production Databases in case of disaster recovery, maintained primary and standby databases.
• Performed upgrade of oracle database from 10g to Oracle 11g manually and with Oracle Database Upgrade Assistant (DBUA) also in development, test and production environment.
• Worked on database design, creation and configuration, space management and other database maintenance procedures in a multiple oracle production and development environments.
• Supported Automatic Storage Management (ASM) database and performed migration of normal database to ASM database using RMAN.
• Troubleshooting, Monitoring Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM), SQL Tuning Advisor, SQL Analyze, TKPROF, STATSPACK and tuning parameters for optimization of system performance.
• Performed patching on Oracle Database Server 10g and 11g using Opatch utility.
• Performed hot backup and cold backup using scripts and RMAN and also developed backup strategies using incremental and cumulative backup methods. Cloning of Production Databases to Test Environment using RMAN.
• Performed Data migrations from CSV/flat files using scripts and SQL Loader.
• Developed automated scripts for database creation and builds.
• Creating batch files and automating the tasks. Granting roles and privileges to end users.
• Scheduled various job using UNIX Crontab utility.
• Worked on import/export and Datapump utility.
• Configured and maintained Oracle Data Guard for Disaster Recovery environment using physical standby database.
• Responsible for database Backups and Recovery, maintain 24 hours uptime for the database.

Confidential, Chicago, IL

Oracle DBA

Environment: Oracle 10g and 11g, RHEL 5, Oracle Enterprise Manager (OEM), putty.

Responsibilities:

• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance.
• Monitoring System Resources, understanding and troubleshooting Database issues in Production Environment.
• Upgrading from Oracle 10g to 11g database.
• Setting up and configuration of database with 10g in RAC environment with Data guard and worked on ASM feature.
• Responsible for maintaining Oracle 10.1.0.2 using SRVCTL, Oracle Enterprise Manager, maintaining Oracle Clusterware using CRSCTL.
• Performed a proof-of-concept of Oracle10g and Oracle11g databases on single RAC Cluster 11g.
• Involved in Design and implementation of oracle 10g Data guard, both physical/logical standby databases.
• Utilized Grid Control, ASM and Flashback tools to administer multi-node RAC database; also managed redo and undo in the RAC environment.
• Handling large database environments and 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.
• Implemented backup/recover strategies using HOT backup, COLD backups, RMAN and Export/Import, Datapump utilities.
• Setting init.ora parameters, maintaining Data Files, Control Files, Redo Log Files, managing Tablespaces, segments, extents, indexes and managing Undo Data.
• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.
• Used Flashback feature to backup/recover objects and also Databases.
• Used Automatic Workload Repository (AWR) for analyzing the database performance.
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN Plans and monitor the database performance on daily basis.
• Monitoring of the queries with high response time and high disk reads per execution (Top SQL) and tuning the same using TKPROF, Auto trace.
• Involved in Capacity planning meetings & operations. Experience ensuring the high availability and integrity of databases.
• Automating the daily routine activities backups using the DBMS JOBS, DBMS SCHEDULER.
• Organizing Oracle Database operations, installation, creation, configuration, laying out database tables and database schema design, startup and shutdown of Databases
• Use TOAD to Optimize and test SQLs, PL-SQL statements developed by the Development Team.
• Maintenance and troubleshooting of oracle network files like listener, tnsnames.ora and sqlnet.ora. Also used NetCA for configuring listener and TNS.
• Creation of Materialized views and partitioned the oracle tables to improve reporting performance
• Perform User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database.
• Implemented Change Control for the Production Databases as and when required.

Confidential, Hartford, CT

Oracle DBA

Environment: Oracle 8.1/ 9.2.0/ 10.1/11 , SOLARIS 8/9, HP - UX, SQL, PL/SQL, Putty, TKPROF, Erwin Tools 4.5, TOAD 7.6.

Responsibilities:

• Creation of the Development, Test and Production Oracle 10g databases, Installation of patches
• Setting up and configuration of database with 10g in RAC environment with data guard and worked on ASM feature.
• Responsible for configuration and implementation of backup strategies using RMAN and Data Guard in RAC environment.
• Team member of Strategic planning team was responsible for Developing backup and recovery strategy, database tuning strategies, capacity planning etc.
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Database Administration & Planning including logical design, physical design, backup & recovery.
• Performed migration using transportable table space (TTS) to transport tablespaces across platforms.
• Part of Migration team from 8i/9i test databases to 10g and from 10g to 11g. Testing the migrated database in different scenarios with different loads, test different new features of 10g,11g and use of new features in 10g,11g.
• Managing Application user profiles and managing concurrent managers, concurrent processing, load balancing etc.
• Setting Oracle Streams for bi-directional replication between two databases.
• 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.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using UNIX Shell scripting
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc
• Used UNIX shell programs & CRON jobs for automating the process of refresh of data periodically.
• Involved in Business Analysis and Requirements collection. Documentation of Data Base Setup and administration of Server Environment.

Confidential

Oracle DBA

Environment: RHEL, Oracle 9i/10g/11g, PL/SQL, Oracle Enterprise Manager 9.2.0/10g, RMAN, IBM AIX 5.3.

Responsibilities:

• Responsible for installing, upgrade and configuring the Oracle 10g on RHEL, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Installed Oracle 10g RAC database on RHEL and applied all current patches.
• Responsible to schedule backups through RMAN. Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases
• Applied patches, keeping applications software bug free, and improving data integrity.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Partitioned large tables to increase the performance.
• Monitoring the Database storage and Day to Day activities. Configured scripts to monitor activity with database.
• Cloned Environments to create Patch Test, Development and QA Environments
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Used Flashback table to restore tables which is a new feature of Oracle 10g.
• Participated in Disaster Recovery Drills, documented database and application validation steps
• On-Call 24x7 DBA support for production databases. Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate

Confidential

Oracle DBA

Environment: Oracle 9i,10g, PL/SQL, Oracle Enterprise Manager (OEM), TOAD, Erwin Designer, Sun Solaris and Windows 2003,RHEL 4.2.

Responsibilities:

• Installation, Configuration and Upgrading of Oracle 9i/10g.
• Logical and Physical Data Modeling using Erwin.
• Created new Table Spaces, added Data Files and resolved Disk Contention Issues.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle and automated processes using UNIX scripting.
• Implemented Hot, Cold and Logical backup plans.
• Database backup with export and import.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Loaded data into Database using the SQL Loader, Export, UNIX shell script and managed system Events and Jobs using OEM. Monitoring the data loading jobs and tuning the Sql queries.
• Developed various PL/SQL Stored Procedures, Functions and Packages.
• Creation of Users and Controlling the User Privileges, Profiles, Roles, monitoring the Security Issues
• Assured Load balancing, monitored disk I/O statistics, Data file I/O statistics, read/write ratios and fixed problems.
• Configured scripts to monitor activity with database. Management of tablespace growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files,