SUMMARY

• Having 7+ years of experience in the IT Environment as an Oracle Database Administrator.
• Manage Oracle database administration assignments for diverse industry clients.
• Expertise in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, troubleshooting database design, Unix shell scripting, Perl scripting and documentation.
• Experience with Oracle 11g/10gRAC/9i/8i in manufacture, insurance, automobile, financial and banking industries in both Business Intelligence/Data warehouse Systems and OLTP Systems, Oracle E - business Suite.
• Installation and configuration of 10g/11g RAC on UNIX and Windows environment.
• Experience in GOLDENGATE and PEOPLESOFT for migrating the databases.
• Involved in Installation and Configuration of MS SQL Server 2000/2005/2008 Versions.
• Experience working on HP-UX, AIX, SUN SOLARIS, Linux and Windows environments.
• Involved in administrating multiple 24*7 Production Oracle 8i/9i/10g RAC Databases as well as UAT/Dev/Test databases.
• Experience in configuring and utilizing Oracle Streams, Shareplex for the replication of Data.
• Installation and Configuration of Oracle Data Guard.
• Having Experience with Data Guard Broker to perform switchover and switchback.
• Experience in migrating Oracle databases from 32 bit to TRU 64 bit and to Sun Hardware. Experience in migrating Oracle databases from Solaris to Linux.
• Experience with Oracle Data Center infrastructures use commodity servers, network storage and full virtualization.
• Experienced in database migration using Transportable Table spaces.
• Experience in developing Oracle PL/SQL based applications.
• Experience in Oracle Grid Control, Quest central and Quest Fog light for databases.
• Experience in AppWorx on Windows, LINUX, and AIX environments.
• Experience in Writing Perl Scripting, Shell Scripting, bash scripting and Partitioning.
• Experienced in Developing Oracle 9i/10g PL/SQL Packages, Dynamic SQL, Triggers, Stored Procedures, Functions, DDL, and DML.
• Experienced in administration setup, data migration and data dictionary reconciliation.
• Worked on application servers Web logic, Web sphere in combination to oracle DB Oracle 10g.
• Experience on installing and Administrating Oracle Enterprise Security Manager (ESM).
• Experience in Database Administration tools like OEM (Oracle Enterprise Manager) Grid Control and TOAD.
• Oracle Database capacity planning, space management and storage allocation.
• Strong in Concepts of Data Dictionary, Configuration of Oracle Enterprise Manager (OEM) tools for monitoring, Performance Enhancement and debugging.
• Utilized SQL* Loader and data pump import to load data in to tables.
• Extensive knowledge in PL/SQL Tuning.
• Supported for Oracle products running on VMware Virtualization environment.
• Strong Knowledge in Oracle Data ware house DBA skills relating to administration and management of VLDB environments, Oracle OLAP and Cognos.
• Extensive Knowledge in Business intelligence tools like Cognos and Informatica and Oracle EBS.
• Strong Knowledge in People soft applications and also involved in reviewing performance reports with People soft Application developers.
• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Worked on Data transferring with export/import utilities and Data pump.
• Highly experienced in performance monitoring/tuning/troubleshooting.
• Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
• Very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS

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

RDBMS: Oracle 11gRAC/10gRAC/10g/9i/8i, SQL Server 2000/2005/2008.

Languages: SQL, PL/SQL, Dynamic SQL, C, C++, UNIX Shell Scripting, Perl Script, XML

DB Management: TOAD, OEM 9.2

Tools: /Utilities/Products: RMAN, OEM Grid Control, Ignite, ESM, SQL Navigator, SQL* Loader, ASM, SQL Server, Export/Import, TOAD, Patch Management, Oracle Warehouse Builder, Oracle Retek, SQLNET, ETL, Cognos, ODBC, Oracle Streams, Shareplex, Data pump, Data Guard, VERITAS Net Backup, VMware MS Office, Oracle EBS 11i/R12.

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

Database Modeling: Erwin 4.0

PROFESSIONAL EXPERIENCE

Confidential, Memphis, Tennessee

Oracle DBA

Responsibilities:

• Installed and Monitored the Oracle database on 10g and 11gR2 in RHEL 5.
• Created and configured 10g database using Oracle Database Configuration Assistant (DBCA).
• Upgrade and Migration of Database from 10g to 11g and applying patches whenever required.
• Daily Health Check Up of the Database using statspack, AWR, ADDM.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.
• Implemented and Managed Oracle Data Guard on Oracle 10g.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Involved in maintaining of instances of around 3 TB with 5000 Users and around 60 Production and Development instances.
• Performed SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility an AUTOTRACE utility.
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator and monitoring the Oracle EBS applications with the team.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• 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.
• Interacting with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: Oracle 11gRAC/10gRAC/10g, SQL Server 2008, Oracle Streams, Data Guard, TOADSql-navigator 2000 & 2005, SQL*Loader, Oracle Warehouse Builder, ODBC, Oracle EBS, PL/SQL, OEM Grid, RMAN.

Confidential, Columbus, Ohio

Oracle DBA

Responsibilities:

• Installed and Monitored the Oracle database on 10g and 11gR2 in RHEL 5
• Installed Oracle 11gR2 in PeopleSoft environment.
• Installation and maintenance of Oracle 11g in Test and in Production Environment.
• Implemented Oracle Streams for the replication of data in Development to Production.
• Experience in Data modelling.
• Upgrade and Migration of Database in 11g and applying patches whenever required.
• Apply Critical Patch Update released by Oracle Support to fix Security Flaws
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Administration of Oracle networking using Sqlnet, Tcp/Ip and Listener setup for oracle databases.
• Created Heterogeneous services for accessing the database links from an Oracle database to SQL server database.
• Taking Periodic Backup of the databases and the software using RMAN.
• Optimizing Oracle RMAN and ASM environment.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database and User Managed when ever required.
• Checking System Performances using and Implement POA ad hoc
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Daily Health Checkup of the database using STATSPACK, AWR, ADDM.
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator and monitoring the Oracle EBS applications with the team.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Environment: Oracle 11gRAC/10gRAC/10g/9i, SQL Server 2008, Oracle Streams, Data Guard, TOADSql-navigator 2000 & 2005, SQL*Loader, Oracle Warehouse Builder, Oracle EBS, ODBC, ASM, PL/SQL, XML, OEM Grid, Ignite, RMAN.

Confidential, San Jose, CA

Oracle DBA

Responsibilities:

• Installed and Monitored the Oracle database on 11g RAC in RHEL.
• Involved in performing migration from Oracle 10g to Oracle 11gRAC database.
• Upgraded oracle RAC 11.1.0 to 11.2.2 using Oracle Golden Gate and in PeopleSoft environment.
• Supported Remote DBA Support for Oracle 9i/10g and 11g.
• Installation and maintenance of Oracle 11g 24*7 Production Environment.
• Implemented Oracle Streams for the replication of data in Development to Production.
• Experience in Data modeling.
• Upgrade and Migration of Database from 10g to 11g and applying patches whenever required.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Administration of Oracle networking using Sqlnet, Tcp/Ip and Listener setup for oracle databases.
• Created Heterogeneous services for accessing the database links from an Oracle database to SQL server database.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Daily Health Checkup of the database using STATSPACK, AWR, ADDM.
• Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Optimizing Oracle RMAN and ASM environment.
• Taking Periodic Backup of the databases and the software using RMAN.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator and monitoring the Oracle EBS applications with the team.
• Worked with the business analysts throughout the development cycle, and provided post-implementation support, for data and report issues identified by customers.

Environment: Oracle 11gRAC/10gRAC/10g/9i, SQL Server 2008, Oracle Streams, Data Guard, TOAD, Sql-navigator 2000 & 2005, SQL*Loader, Oracle Warehouse Builder, Oracle EBS, ODBC, ASM, PL/SQL, XML, OEM Grid, RMAN.

Confidential, NJ

Oracle DBA

Responsibilities:

• Installed and Monitored the Oracle database on 10g RAC in Solaris Servers using ASM and also with Oracle EBS applications.
• Involved in performing migration from Oracle 10g to Oracle 11g database.
• Supported Remote DBA Support for Oracle 9i/10g and 11g.
• Monitored and Tuned database to optimize the performance of Oracle EBS applications.
• Installation and maintenance of Oracle 10g Data Guard 24*7 Production Environment.
• Implemented Oracle Streams for the replication of data in Development to Production.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Maintained instances of around 750GB with 500 Users and around 20 Production and Development instances.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM).
• Monitoring experience includes Oracle Enterprise Manager Grid Control and Quest Fog light.
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Used ERWIN for logical and Physical database modeling.
• Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Administration of Oracle networking using Sqlnet, Tcp/Ip and Listener setup for oracle databases.
• Created Heterogeneous services for accessing the database links from an Oracle database to SQL server database.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Daily Health Checkup of the database using STATSPACK, AWR, ADDM.
• Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Optimizing Oracle RMAN and ASM environment.
• Taking Periodic Backup of the databases and the software using RMAN.
• Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator and monitoring the Oracle EBS applications with the team.
• Worked with the business analysts throughout the development cycle, and provided post-implementation support, for data and report issues identified by customers.

Environment: Sun Solaris 9.0/10.0, IBM-AIX, Oracle 10gRAC/10g/9i, SQL Server 2008, Oracle Streams, Data Guard, Toad, Sql-navigator 2000 & 2005, SQL*Loader, Oracle Warehouse Builder, Oracle EBS, ODBC, ASM, PL/SQL, XML, OEM Grid, RMAN, Erwin

Confidential, San Jose, CA

Oracle Database Administrator

Responsibilities:

• Installed Oracle 10gRAC database on Redhat Linux using ASM.
• Installed Oracle 9i and 10g database on HP-UX 11.0, Redhat4.
• Migrated data from 9i to 10g using Transportable Table spaces and Export / Import utilities.
• Migrated Databases from 9.2.0.3 on Linux to 10.2.0.3 on HP-UX.
• Monitored and Tuned database to optimize the performance and satisfy the availability and Oracle EBS applications.
• Performance Tuning by using Oracle utilities like EXPLAIN PLAN, STATSPACK, and TKPROF for addressing performance bottlenecks is performed.
• Logical and Physical data modeling using Erwin, Dimensional/OLAP data modeling.
• Taken Backup & Recovery by using RMAN.
• Analyzed and monitored that data got by ADDM performed logical database using Export utility.
• Adopted general DBA tasks like Indexes, Partitioning and Flashback Recovery.
• Used Oracle Retek Space Optimization for optimal space and allocation recommendations.
• Used Snapshots for Replication and synchronization data with other branches.
• Used Snap Mirror for creating duplication of production databases.
• Implemented Oracle Data Guard for maintained oracle disaster recovery
• Used Storage Management using SAN.
• 24*7 remote support and on call for Production database supporting developers & end-users.
• Provided all kinds of DBA support to development teams as well as production support to various tasks.
• Manage Enterprise databases, users and roles by Oracle Enterprise Grid Control.
• Developed Dynamic SQL, PL/SQL Scripts, Packages and views.
• Created Data Modeling and Data definition Language (DDL) to support development efforts.
• Created and maintained different database entities included table spaces, data files; redo log files, rollback segments and renaming/relocating of data files on servers.
• Created PARTIONING of its types like Range, List & Hash by the specific use.
• Supported development effort by providing SQL statement tuning and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Trouble shooting and resolving any database and/or application issues or errors that occurred.
• Developing shell scripts and using various tools monitored the various database activities.
• Utilizing OEM SQL Analyze, OEM Grid Control, STATSPACK, SQL Trace, and TKPROF etc.
• Experience in writing PERL Scripting for day - day activities for monitoring the database.
• Established database backup/recovery strategy for different databases.
• Implemented Oracle Streams for Replication.
• Modified database structures including table spaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Performed daily alert log files, trace files check, and general data consistency & data integrity check.
• Developed scripts to monitor the storage usage, object status for daily job.
• Involved in Unit testing and Integration testing of forms and reports.
• Oracle support and Meta Link are utilized to troubleshoot the problems and issues.
• On-call support regarding production - related database problems is performed.

Environment: Oracle 10g/9i, Sql-Server 2005, HP-UX 11.0, Redhat4 Linux, Tru64bit, Retek Space Optimization, Shareplex, Data Guard, OEM Grid Control, RMAN, Oracle EBS, Erwin, ESM, Explain Plan, SQL Trace, TKPROF, STATSPACK, Shell Scripting.

Confidential

Jr. Oracle Developer/ Database Administrator

Responsibilities:

• Oracle Configuration, Oracle Tuning.
• Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability
• Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Planning, Installation and Configuration of Oracle Database on the Server.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creation of Users and Granting them privileges and roles.
• Development databases, which includes hot backup, cold backup, and export backup.
• Performed Database Tuning, Performed Database Security and Integrity.
• Applying upgrade patches, maintenance and interim patches on databases.
• Develops and executes a backup / disaster recovery plan for all databases and performance tuning of the database as and when required.
• 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 db using SQL.
• Designing, creating schema objects like db tables, indexes, views, synonyms, and all schema objects in Oracle.

Environment: Oracle 8i/9i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.