SUMMARY:

• Having 7+ years of experience in the IT Environment as an Oracle Database Administrator.anage Oracle database administration assignments for diverse industry clients.
  xpertise 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.
  xperience 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

Educational Qualification:

• Bachelor of Engineering in Computer Science from Confidential,University.

Technical Certification:

• Oracle 10g Certified Associate.

PROFESSIONAL EXPERIENCE: Confidential,Tennessee Jan’ 12 – Present Position: Oracle DBA Description: FedEx known as FDX Corporation, is one of the leading companies, based in the United States with headquarters in Memphis, Tennessee, which provides strategic direction and consolidated financial reporting for the operating companies and customers worldwide with a broad portfolio of transportation, e-commerce and business. 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, TOAD,
Sql-navigator 2000 & 2005, SQL*Loader, Oracle Warehouse Builder, ODBC, Oracle EBS, PL/SQL, OEM Grid, RMAN.

Confidential,Columbus, Ohio Feb’11 – Jan’ 12 Position: Oracle DBA Description: Nationwide is one of the largest and strongest diversified insurance and financial services organizations in the U.S.

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 modeling.
• 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, TOAD,
Sql-navigator 2000 & 2005, SQL*Loader, Oracle Warehouse Builder, Oracle EBS, ODBC, ASM, PL/SQL, XML, OEM Grid, Ignite, RMAN.

Confidential,CA Apr’10 - Jan’11 Position: Oracle DBA Description: Core Logic is a leading provider of financial, property and consumer information services and maintains the most comprehensive business database in the U.S.

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 Jan’09 - Mar’10 Position: Oracle DBA Description: “NJDOT” an acronym for New Jersey Department of transportation is the agency responsible for transportation issues and policy in New Jersey. NJDOT is the first State transportation agency in the United States. It has been responsible for maintaining and operating the State\'s highway and public road system, planning and developing transportation policy and assisting with rail, freight and intermodal transportation issues.

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