SUMMARY:

• Around 18 years of experience in Database Administration, Database Modeling, Designing, Programming, Database Schema Design, SQL Optimization in Data Warehouse, Data Mart, Batch Processing, OLTP Systems.
• 2 years of experience in supporting Oracle E - Business Suite R12.1.x.
• Installation, Configuration and implementation of Oracle E-Business suite R12 and oracle11g.
• Patching security vulnerabilities as part of quarterly release, applying minipacks, maintenance pack, family pack and one-off patches.
• Cloning of Oracle application environment using Rapid clone and adconfig.
• Highly experienced with Oracle Application tools and ad utilities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
• 1 year and 9 months of experience in supporting Oracle Exadata database machine V1 with 11gR2 exadata storage server software.
• Expertise in installation, configuration, up-gradation, Backup & Recovery, application support, Resource Management, User & Security Management and cloning oracle homes.
• Installation, configuration and administration of 10g/11gR2 RAC on Linux/AIX.
• Adding and deleting a node from the RAC cluster.
• Converting the databases from single instance to RAC and vice versa.
• Moving the databases from one ASM disk group to another ASM disk group.
• Moving the databases from File system to ASM and vice versa.
• Renaming the databases and changing dbids using nid tool.
• Experience in configuration and administration of data guard for physical and logical standby databases.
• Experience in migrating the database from one platform (e.g., Sun Solaris) to another platform (e.g., AIX) using transportable database option.
• Experience in refreshing the lower environments with production database using rman active duplication or by restoring the production backups or by using duplicate technique using backup.
• Impact analysis of CPU/PSU patches to various versions of oracle homes.
• Performed switch over and failover tests for standby databases.
• Excellent experience in Database design, programming, optimization, tuning, SQL Optimization and Administration of Database and SQL scripts.
• Expertise in client server, Internet architecture applications development using Oracle 9i/8i/7.3.3, PL/SQL, SQL*Plus, SQL *Loader, Stored Procedures, Triggers, Functions and Packages.
• Upgraded Oracle Database using Export/Import utilities in a highly compressed time frame for smooth and successful migration.
• Involved in Data warehouse initiatives, establishing procedures and methodology for defining, analyzing, modeling and loading file in to the Data warehouse and Data marts.
• Implemented the database security in compliance with Sarbanes oxley rules.
• Strong skills in Oracle programming, Shell Scripting.
• Expertise in scheduling Production Jobs for very complex Batch System. Designed the Job Processes, Dependencies, and Passing Parameters. Monitored Production.
• Implementation and instructed Operation Group to hold and release jobs.
• Experience in Capacity Planning, Problem Resolution, System Monitoring, Disaster Recovery.
• Expert in using design and management tools like ERstudio, ERwin, DBArtisan and Toad
• Excellent in Database monitoring Tools like BMC Patrol.
• Implementation of a complete Hot/Cold Backup solution utilizing RMAN via a Recovery Catalog, strategy included development of daily, weekly and monthly strategy incorporating incremental backups.
• Implementation and use of the Oracle Enterprise Manager (OEM) as well as the Performance Tuning and Diagnostics Packs.
• Participated in data sourcing, extract data investigation process, worked with teams to develop PL/SQL, coded to extract, cleaned and sorted data for flat file generation, coded SQL*Loader control files to load data.
• Designed, coded and implemented database monitoring on Unix Platform using shell scripts.
• Worked with Oracle support on various SRs/TARs, those include lots of severity 1 SRs/TARs for production issues.
• Monitored Oracle Database using Quest Central and OEM, to minimize the performance problems.
• Oracle Database tuning for long running concurrent jobs using ASH, ADDM, AWR reports, TKPROF, etc.
• Good experience in tuning the SGA components, check point and redo tuning, and also PGA tuning.
• Extensive experience of Data analysis, user requirement analysis, infrastructure design and module specification.
• Excellent knowledge and experience in writing complex stored procedures, stored functions, database triggers and packages using PL/SQL.
• Effective analytical, organizational and communication skills.
• Installing Oracle Management Server (12c) and Oracle Management agents (12c). Monitoring the databases using Oracle Eneterprise Manager Cloud Control.s

TECHNICAL SKILLS

• Windows 95/98
• Windows NT
• MS-DOS
• UNIX (sun solaris 2.6/2.8/5.10
• AIX 5.3/6.1
• SUSE Linux 10
• HP UX 11/11i)
• SQL
• PL/SQL
• Java
• shell scripting
• awk
• Oracle 7.3/8/8i/9i/10g/11g
• E-Business Suite R12
• DBArtisan
• TOAD
• OEM
• RMAN
• LogMiner
• Tkprof
• Svrmgr
• data pump
• Export/Import
• SQL Loader
• SQL*PLUS
• ERStudio 7.1/7.5
• Erwin3.5/4.1.2
• Developer 2000
• (Forms 4.5
• Reports 2.5)
• Procedure Builder
• Designer 2000
• JDK
• Visual Source Safe
• PVCS
• Clear Case
• BMC Software
• Oracle Applications
• Compaq
• HP PCs
• DELL laptop
• Sun Fire 6800
• web sphere
• tibco.

PROFESSIONAL EXPERIENCE

Confidential, Reston VA

Senior Oracle DBA Consultant

Responsibilities:

• Applying PSU/CPU patches to the oracle homes of standalone databases, databases with data guard configuration and also for RAC databases.
• Raising Service Requests (SRs) with oracle for the encountered bugs or to get conflict one-off patches for the PSU patches.
• Resolving performance issues of database.
• Creating databases, tablespaces and adding space to the same.
• Enabling the audit for the users in the databases.
• Restoring the databases.
• Taking hot and cold backups of the database using rman.
• Used SPM (SQL Plan Management), sql profiles
• Moving the databases from file system to ASM and vice versa.
• Tuning the sqls in exadata environment.
• Configuring, maintaining dataguard setup.
• Installing Oracle Management Server(12c) and Oracle Management agents(12c). Monitoring the databases using Oracle Eneterprise Manager Cloud Control.
• Upgrading the O/s, exadata storage server software, Oracle software and databases to latest versions.
• Replacing the disks whose status is critical or preventive failure and creating the grid disks and add those grid disks to the existing asm disk groups.

Environment:, Exadata, Linux, Oracle 11gR2, OEM, SQL Developer, Toad.

Senior Oracle DBA Consultant

Responsibilities:

• Upgrading the O/s, exadata storage server software, Oracle software and databases to latest versions.
• Replacing the disks whose status is critical or preventive failure and creating the grid disks and add those grid disks to the existing asm disk groups.
• Changing the ip addresses of ntp servers using ipconf on exadata servers.
• Reimaging the cell
• Installing and administering the 10g/11gR2 RAC on Linux
• Applying PSU/CPU patches to the oracle homes of standalone databases, databases with data guard configuration and also for RAC databases.
• Raising Service Requests (SRs) with oracle for the encountered bugs or to get conflict one-off patches for the PSU patches.
• Resolving performance issues of database.
• Creating databases, tablespaces and adding space to the same.
• Enabling the audit for the users in the databases.
• Restoring the databases.
• Taking hot and cold backups of the database using rman.
• Refreshing the lower environment databases using rman active duplication or rman duplication technique with backup..
• Used SPM (SQL Plan Management), sql profiles and outlines
• Converting the single instance databases into RAC enbled databases.
• Moving the databases from file system to ASM and vice versa.
• Moving the databases from one ASM disk group to another ASM disk group.
• Renaming the database and changing the dbid using nid tool.
• Compressing the tables using hybrid columnar compression.
• Tuning the sqls in exadata environment.
• Conducted POC to move the database from Exadata to AWS.

Environment: Exadata, Linux, Oracle 11g, OEM, SQL Developer, Toad, cellcli, dcli.

Senior Oracle DBA Consultant

Responsibilities:

• Installing and administering the 10g/11gR2 RAC on Linux/AIX
• Migrating the databases from Solaris to Linux using data pump option.
• Migrating the databases from source to target using ISR solution( provided by data link and Q-logic)
• Installing oracle software of various versions (10.2.0.4, 11.1.0.7 11.2.0.1 and 11.2.0.2).
• Applying PSU/CPU patches to the oracle homes of standalone databases, databases with data guard configuration and also for RAC databases.
• Raising Service Requests (SRs) with oracle for the encountered bugs or to get conflict one-off patches for the PSU patches.
• Resolving performance issues of database.
• Creating databases, tablespaces and adding space to the same.
• Enabling the audit for the users in the databases.
• Cloning oracle homes.
• Restoring the databases.
• Migrating/Upgrading the databases from 10.2.0.4 to 11.1.0.7 or 11.2.0.2.
• Taking hot and cold backups of the database using rman.
• Installing the Management Agents on the host and adding the host/database to OEM repository.
• Refreshing the lower environment databases using rman active duplication or rman duplication technique with backup..
• Used SPM (SQL Plan Management), sql profiles and outlines
• Converting the single instance databases into RAC enbled databases.
• Moving the databases from file system to ASM and vice versa.
• Converting the table definitions from BYTE semantics to CHAR semantics.
• Moving the databases from one ASM disk group to another ASM disk group.
• Renaming the database and changing the dbid using nid tool.

Environment: AIX 5.3/6.1, Linux, Oracle 10g/11g, OEM, SQL Developer, Toad.

Senior Oracle DBA Consultant

Responsibilities:

• Installing and administering the 10g/11gR2 RAC on Linux/AIX
• Migrating the databases from Solaris to AIX using transportable database option.
• Installing oracle software of various versions (10.2.0.4, 11.1.0.7 11.2.0.1 and 11.2.0.2).
• Applying PSU/CPU patches to the oracle homes of standalone databases, databases with data guard configuration and also for RAC databases.
• Raising Service Requests (SRs) with oracle for the encountered bugs or to get conflict one-off patches for the PSU patches.
• Resolving performance issues of database.
• Creating databases, tablespaces and adding space to the same.
• Enabling the audit for the users in the databases.
• Cloning oracle homes.
• Restoring the databases.
• Migrating/Upgrading the databases from 10.2.0.4 to 11.1.0.7 or 11.2.0.2.
• Taking hot and cold backups of the database using rman.
• Installing the Management Agents on the host and adding the host/database to OEM repository.
• Worked on implementing ILM strategy.
• Worked on Transparent Data Encryption for tablespaces.
• Scheduling the automated tasks using Control-M.
• Used SPM (SQL Plan Management) and outlines

Environment: Sun Solaris 5.8/5,10, AIX 5.3, Linux, Oracle 9i/10g/11g, OEM, Control M, CVS, Toad.

Senior DBA Consultant

Responsibilities:

• Installation, Configuration and implementation of Oracle E-Business suite R12 and oracle11g
• Patching security vulnerabilities as part of quarterly release, applying minipacks, maintenance pack, family pack and one-off patches.
• Cloning of Oracle application environment using Rapid clone and adconfig.
• Refreshing lower environment databases with production databases using rman active duplication or by restoring production backups.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Troubleshooting Apps components like Forms, Apache and Concurrent Managers.
• Highly experienced with Oracle Application tools and ad utilities like adpatch, adadmin, adconfig, adctrl etc. for the management and maintenance of Applications.
• Upgraded some of our databases from 11gR1 to 11gR2. Worked with Oracle support to resolve the bugs related to 11gR2.
• Configured AUTOCONFIG for handling customizations and Security issues.
• Highly experienced in Investigating performance issues for Oracle Applications(Concurrent Program/Reports)
• Identifying the best plans using sql tuning advisor and migrating the sql profiles from one database to another database using ‘dbms sqltune package’.
• Experienced in supporting high volume production runs like processing 20M batch size.
• Worked with oracle support to improve performance of Create accounting and update sub ledger balances program.
• Monitoring and troubleshooting top cpu/memory consuming processes, Identifying top sqls/sessions and tuning.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Experience in setting up E-Business Suite for Oracle Financials Accounting Hub Integration Pack for PeopleSoft General Ledger.
• Worked on QUEST STAT tool for deploying the code migrations
• Configured SSL for all the lower and higher environments.
• Troubleshooting clone issues related to Apache, autoconfig, Concurrent Managers and AD utility.
• Implemented SOX guidelines from technical perspective and followed change management to deploy codes.
• Migrating the databases from Solaris to AIX using transportable database option.
• Installing and administering the 10gR2 RAC on Linux.
• Installing oracle software of various versions (10.2.0.4, 11.1.0.7 11.2.0.1 and 11.2.0.2) including oracle examples.
• Applying PSU/CPU patches to the oracle homes of standalone databases, databases with data guard configuration and RAC databases.
• Raising Service Requests (SRs) with oracle for the encountered bugs or to get conflict one-off patches for the PSU patches.
• Creating autosys jobs to fulfill database monitoring and on demand backups.
• Resolving performance issues of database.
• Running character set scanner to find out data loss in the existing database.
• Creating databases, tablespaces and adding space to the same.
• Configuring/Building/Maintaining data guard for physical and logical standby databases.
• Performing switchover and failover tests for standby databases.
• Performing VCS failover tests.
• Migrating OLAP Analytic Workspaces from production to lower environment.
• Renaming the data files on the primary and standby databases.
• Enabling the audit for the users in the databases.
• Cloning oracle homes.
• VCS configuration.
• Restoring the databases.
• Installing Management Agents to monitor the databases on the hosts.
• Migrating the system tablespace from dictionary management to local management.
• Native compilation of pl/sql objects.
• Recreating the redo log files on the file system with 512K block size.
• Removing the databases and their corresponding oracle homes.
• Changing the dbid and dbname of the databases using nid tool.
• Performing POC for Real Application Testing which involves backing up the database, capturing the work load and replaying the work load.
• Migrating/Upgrading the databases from 10.2.0.4 to 11.1.0.7 or 11.2.0.2.
• Taking hot and cold backups of the database using rman.
• Building the environment for Exadata POC which involves full export of the database using data pump, database creation and full import of the database and configuring the database tier for E-Business Suite database.
• Supporting Business Resumption Test (Switching over the roles of the databases from primary to standby and standby to primary )
• Dropping the database links which can’t be dropped after changing the global name.
• Creating directory objects and setting up the acls on the file system.
• Cloning lower environment E-Business Suite databases from production database and configuring the database tier.
• Installing the Management Agents on the host and adding the host/database to OEM repository.
• Used SPM (SQL Plan Management) and outlines

Environment:Sun Solaris 5.8/5,10, AIX 5.3, Suse Linux 10, Oracle 8i/9i/10g/11g, OEM, autosys, E-Business Suite R12, VCS, Veritas Net Backup, Clear Case, ERwin.

DBA

Responsibilities:

• Migrating the database from 8.1.6.3 to 9.2.0.4
• Implementing the Sarbanes Oxley rules.
• Performance monitoring and Tuning the sql statements
• Applying patches for security alerts.
• Cloning the database for development/Test purposes using Rman production backup.
• Deploying WAR files
• Building the TIBCO server.
• Applying the promotion packages.
• Supporting UAT and performance Testing of the Application.
• Database creation.
• Developer support.
• Took cold backup, complete/cumulative and incremental exports as a backup strategy.
• Resolved the ora-600/ora-7445 on consultation with Oracle Support services.
• Worked closely with the development team to resolve complex application problems.
• Checked IO, CPU or memory bottlenecks and suggest appropriate measures.
• Re-sized/cleaned the existing database for unwanted users, space, etc. (as documented and approved by the client), tune SGA and initialization parameters for better performance.

Environment:HP-UX 11/11i, Sun Solaris 5.8, Oracle 8i/9i, Toad, TIBCO, Web Sphere 4.x.

DBA

Responsibilities:

• Provided the support for the GEIS global data warehouse development, test and production database environments.
• Performance monitoring and tuning.
• Data replication.
• Database creation.
• Disaster recovery.
• Developer support.
• Taking necessary action on BMC alerts generated.
• Providing support for weekly Production release process.
• Database up gradation.
• Character set migration.
• Refreshed the test databases with production data.
• JVM installation on oracle databases to make use of java features in oracle.
• Re-organized the tables to gain the disk space back.
• Created testing environment for the tools like precise and FirstLogic.
• Took cold backup, complete/cumulative and incremental exports as a backup strategy.
• Resolved the ora-600/ora-7445 on consultation with Oracle Support services.
• Enabled the audit in the database.
• Involved in capacity planning exercises and implemented backup/recovery procedures.
• Worked closely with the architects and came up with detailed logical and physical schema design. Leads medium sized infrastructure projects.
• Designed, planned and implemented large and complex DB systems.
• Follow-up projects work with crisp documentation.
• Worked closely with the development team to resolve complex application problems.
• Checked IO, CPU or memory bottlenecks and suggest appropriate measures.
• Tested/verified exports on the database.
• Re-sized/cleaned the existing database for unwanted users, space, etc. (as documented and approved by the client), tune SGA and initialization parameters for better performance.
• Used oracle tools (sql*loader) and write procedures to migrate data from legacy systems.
• Verified daily loads and monthly loads.
• Managed indexes, partitioned tables and materialized views.
• Performance tuning on databases for Clients.

Environment:Sun Solaris 5.8, Oracle 8i/9i, DBArtisan, Toad, BMC Patrol, Precise, Erwin 3.5.

DBA/Data warehousing consultant

Responsibilities:

• Installation of Oracle Software.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and backend Procedures, functions, DB triggers and all schema objects in Oracle.
• Data migrations between Databases using Oracle SQL Loader, IMPORT and EXPORT utilities.
• Monitoring, Tuning and Trouble shooting the Databases.

Environment:Sun Solaris 5.8, Oracle 9i, Erwin 3.5, in house ETL tool kit

DBA

Responsibilities:

• Preparing Requirement Confirmation Document.
• Preparing Design Document.
• Designed and implemented both a logical and physical Oracle 8 database model.
• Designed, implemented & tested enterprise-level backup and recovery methodologies, performed complete and incomplete recovery operation on production and test Databases.
• Network Administration, configure and test an Oracle NET8 configuration, Oracle net8 troubleshooting.
• Wrote many SQL Scripts to identify the free space in Table space, identifying Max extents.
• Used export/import utilities.
• Monitored database using OEM’ s Instance manager, Security manager, and Scheme manager.
• Performance tuning through Application or SQL tuning, Memory tuning, I/O tuning, Disk and Latch contention tuning using various monitoring and diagnostic tools like SQL TRACE, TKPROF, UTLBSTAT and UTLESTAT and also various V$ Views.
• Writing Test Cases.
• Writing scripts for data migration.
• Preparing QC environment.
• Testing the components.
• Preparing the Test Notebook.

Environment:WindowsNT, Windows95, UNIX, Oracle 8, IE4, IIS

DBA/Developer

Responsibilities:

• Managed security and roles, functions included managing object and system privileges, granting, revoking and displaying privileges. Created (non) default roles and enabling/disabling roles.
• Wrote many SQL Scripts to identify the free space in Table space, identifying Max extents.
• Administered database backup and recovery operations.
• Used Windows NT Administrative tools for performing Backup and recovery.
• Tuned performance parameters like system status, memory utilization, and CPU performance.
• Monitored database performance.
• Extensively tuned databases and increased the HIT RATIO drastically.
• Monitored database using OEM’s Instance manager, Security manager, and Scheme manager.
• Preparation of Low Level Design.
• Module Generation through Application Design Wizard Utility.
• Additions/Modifications in Module Data Diagrammer, bearing in mind the capabilities of Forms Generator.
• Forms Generation through Forms Generator utility.
• Enhancing User Interface and Functionality in Developer 2000 to forms generated using Designer.
• Development of forms using Developer2000 (Forms 4.5)
• Development of Reports using Developer2000 (Reports2.5)
• Wrote Database Triggers and Stored Program Units
• Preparation of Unit Test Specifications.

Environment:Windows NT, Windows95, Oracle 7.3/8, Designer2000, Developer/2000 Forms4.5, Reports 2.5, Procedure Builder, TOAD, VSS