EXPERIENCE SUMMARY

• 7+ years of extensive experience as an Oracle Applications DBA as well Oracle DBA in Production, Test and Development environments.
• Designing, modeling, administration, implementation, and troubleshooting, and quality management for several production/test systems on Oracle (8i, 9i, 10g, 11g) Databases. Involved system administrators groups in designing the logical and physical model of the databases.
• Installation, configuration and upgrade of Oracle 10g, 11g RAC.
• Pre - patch analysis for the patches and document preparation wif pre and post patch installation steps.
• Experience as Oracle DBA providing support to many Production, Development, Test, CRP instances comprising of some of the more complex and challenging environments from versions 9i to 11g releases.
• Installing and Upgrading Oracle Server 10g to 11i, 11g.
• Administering Oracle 10g, 11i, 11g Instances.
• Multiple upgrades of Oracle server older versions to newer versions.
• Performed Cross Platform migration of Oracle and Advanced Pl6anning and Scheduling from HP to AIX
• Configuring, Upgrading and installing Oracle Server 9i/10g/11i/11g.
• Troubleshooting and Administration of Oracle 9i/10g/11g Server.
• Oracle 11g Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories.
• Oracle 10g,11g RAC Database setup and administration using Dell/EMC SAN for storage and Oracle Recovery Manager (RMAN) for backups.
• Implementing High Availability solutions wif Oracle 11g RAC, Standby (Datagaurd)
• Installing, configuring and maintaining Oracle Grid Monitoring.
• Extensive noledge in working wif the tools like OEM, TOAD, QUEST, Export/ Import, Stats pack, SQL* Loader, SQL Analyze, TKPROF, Explain Plan, and Oracle Supplied DBMS PACKAGE.
• Configuring backup software like VERITAS Netback up, Legato Networker for oracle using RMAN tool for backup and recovery.
• Hot and cold Backup and recovery of Oracle 10g, 11g database using tools like RMAN.
• Scripting and scheduling of oracle database backup using RMAN.
• Good experience of Oracle PL/SQL, Procedures, Triggers, Cursors and Functions.
• Cloning of database for development teams, import and export of data.
• Good working Experience on Sun Solaris, Linux, HP-UX and AIX.
• Extensively used oracle tools like TOAD and SQL Developer.
• Experience in writing complex SQL Queries, created materialized views.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc.
• Proven ability to adapt to demanding schedules and changing priorities.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Involved and implemented wif analysts, developers, programmers and project managers in a project system development life cycle (SDLC) phases.
• Strong analytical problem solving and good communication skills wif ability to work wifin team environment and independently when needed.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g RAC

OS: Oracle Enterprise Linux 3/4/5, Red hat Linux 2.1/3.0/4.0/5.0, Sun Solaris 5.6/5.9/10, UNIX

Tools: TOAD, OEM, OAM, SQL*Plus, SQL*Net, SQL*Loader, RMAN

PROFESSIONAL EXPERIENCES:

Confidential, Sunnyvale, CA

Responsibilities

• Worked in 24x7 Production Oracle Databases environment.
• Involved in both managing and supporting all Production, Development and Test instances of Oracle Version and Oracle Applications.
• Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin.
• Maintaining the Oracle Applications Systems including Oracle databases, Middle tier IAS Applications.
• Working closely wif Functional/Developers and halping them in issues.
• Creating and sizing of database objects (tablespaces, tables, and indexes).
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures.
• Management of Users, Roles and Privileges.
• Scripts to monitor online Database objects and SGA.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning. Provided Assistance to application team, design various development activities, code Fixing & SQL tuning in application by using hints in queries & used utilities like STATSPACK, Explain Plan, TKPROF, 10046 Event Trace, SQL trace, ORADEBUG . Used packages like DBMS SCHEDULER to schedule tasks and used DBMS STATS to gather the statistics.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Experience in Installing, configuring and administrating database in RAC environment.
• Troubleshoot RAC database by verifying alert logs. Configured Rapid connect-time failover and Transparent Application Failover in RAC environment and working noledge in Maximum Available Architecture (MAA).
• Installed, configured and troubleshoot Oracle Clusterware Cluster Ready Service (CRS) for RAC. Used Oracle 11g specific features like Automatic Memory Management (AMM), Result Cache parameters.
• Adding a Disk group, removing a disk group, movement of data between disk groups in an ASM storage platform.
• Successfully implemented Data Guard on physical, logical standby databases.
• Replicating the tables, schemas and database using the replicating tool Golden gate.
• Managed Resumable Space Allocation using Resumable Time out parameter.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling wif utilities like OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Backed-up database and database objects using different techniques such as user-managed backup, RMAN backup wif or wifout catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup.
• Experienced in cloning database using RMAN Duplicate and cold & hot backups.
• Performed full database recovery as well as incomplete recovery using Tablespace Point in Time Recovery (TSPITR). Knowledge of cross platform migration of databases.
• Implemented Change Tracking File wif RMAN and reduced the backup time significantly.
• Hot and cold Backup and recovery of Oracle 11g database using tools like RMAN.
• Maintain database security, user roles and access profiles, Involved in taking cold and hot backups.
• Daily monitoring and checking the Background Dump File (alert SID Logs) and User Dump Files for errors.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical problem solving and good communication skills wif ability to work wifin team environment and independently when needed.

Confidential MI

Responsibilities:

• Installed, Configured and deployed SOA on single node and cluster node.
• Created and Configured Data Servers, Physical Schemas, Logical Schemas, Models, Interfaces for source and target Data Mapping and Packages.
• Tested different Journalizing Knowledge Modules to ensure better performance.
• Good noledge of data warehouse architectures, concepts and technologies.
• Conceptual data modeling; logical and physical data modeling.
• Cloning and Patching.
• Good understanding in data modeling, entity-relationship modeling.
• Implemented cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Export and Import of Oracle Internet Directory Single Sign On Users wif ldap utility.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and AWR.
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views (replication).
• Configuration of OEM11g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one offs Patches etc).
• Expert noledge of oracle data-dictionary & configuration of Oracle Enterprise Manager (OEM): DB Control, Grid Control 9i/10g/11g.
• Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g.
• Oracle 11g RAC Database setup and administration using Oracle Recovery Manager (RMAN) for backups.
• Oracle 11g Application Server Enterprise load balanced setup and configuration using multiple Oracle RAC databases for metadata repositories.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, and Responsibilities for the user.

Confidential, Deerfield, IL

DataGuard.

Responsibilities

• SOA/BPEL Installation single Node & on RAC.
• Implementation, Maintenance of DR site.
• Architecting PCP in 4 RAC nodes.
• Controlling User access: Creating Users, User system Privileges, Granting system privileges, Creating Role, Creating & granting Privileges to a Role, Changing user password, Granting Object Privileges.
• Cloning RAC to RAC, RAC to Non RAC and Non RAC to RAC.
• Designing reporting Architecture.
• Designing backup strategy.
• Monitoring and configuring OEM.
• Backing up system using RMAN backup.
• Creating monitoring alerts in OEM 10g Grid.
• Setting new threshold values based on the alert history and business requirements.
• Tuning applications.
• Schema, Table, Database refreshes on demand for development teams.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Installation of Oracle clusterware, ASM, Configuring public and private network & VIP. Used SRVCTL utility for managing multiple instances & nodes, Managed & multiplex Voting Disk and OCR file for maximum RAC availability.
• Experience in job scheduling for Windows, UNIX (crontab).
• Working experience wif Very-Large databases (VLDB) up to 4 terabytes, data migration, against Oracle & other databases such as SQL Server, MYSQL etc.
• Shell scripting for the database and application monitoring.
• Capacity planning - space management, ongoing maintenance of production and development environments.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Creating & Maintaining Tablespaces.
• Choosing different types of data storages (Locally Managed Tablespaces, IOT and partition tables) and indexes in order to have good performance for SQL and DML.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Resolving datagaurd DR site sync issues.
• UNIX Shell scripting to simplify the day to day activities.

Confidential, CT

Software

Responsibilities

• 24x7 Production Oracle Administrations.
• Maintaining production, development & test databases and applications.
• Upgraded Oracle server Database Version 8.1.7.4 to 10g (10.2.0.4) on Solaris.
• Upgraded Oracle Database 9.2.0.8 to 10g.
• Upgraded database from Oracle 9i to Oracle 10g RAC on Windows.
• Installation and configuration of 9iAS/10gAS and performance tuning of Oracle RAC.
• Applied patches using ADPATCH, ADCTRL utilities.
• Performed database and application cloning of Production database on TEST environment to provide users the live data for testing purposes.
• Was involved in developing a disaster recovery (DR) plan.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Supported installation and configuration of Oracle WebDB, Oracle OAS and Oracle 9i.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Experience in using Flash-Back Recovery, AWR, ASM, ASH and ADDM.
• Involved in SQL tuning and refreshing statistics of database objects. Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Used Export/Import and Datapump utilities for full/partial backup.
• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for the same.
• Performed backup validations using RMAN, Database monitoring, troubleshoot and resolve the issues.
• Implementing Range, List Partitions, Hash Sub Partitions, Creating and refreshing materialized views.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one of Patches etc).
• Oracle Systems Administration. RMAN used in recovery, hot and cold backup of Oracle10G database.
• Planning and Administration of backup and recovery strategies.
• Involved in SQL tuning and refreshing statistics of database objects. Other duties included performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Creating Application Users, Profiles, Responsibilities, Roles, Functions for the user.
• Raising TAR and interact wif Oracle support to solve problems.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.
• Experience in testing and validating backups using Recovery Manager.

Confidential

Responsibilities

• Applying patches for enhancement and fixing bugs using Adpatch, Opatch.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Designing the logical and physical database structure.
• Management of schemas, objects partitioning the tables & indexes.
• Monitoring the CPU usage, IO statistics, and CPU time to identify any OS level Performance killers.
• Experience wif OEM Grid Control to monitor and manage the oracle databases.
• Automating jobs by using crontab.
• Database Re-organization (database, Tablespaces, tables etc.). Re-org is done from time to time for the primary storage objects like tables, indexes.
• Working closely wif Functional/Developers and halping them in issues
• Production Assessment Tests and maintained to the global standards.
• Stress test worked wif Test Engineer and evaluated the performance.
• Tuned the slow running concurrent requests.
• Creating the Customized Roles, Responsibilities, groups, Request sets and Application Users as part of sysadmin.
• Installation of Multi Node wif Shared File System and Cloning.
• Registering the new Forms, Reports, pl/sql scripts as concurrent programs as part of technical.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions, Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Database Upgrade from 8.1.7 to 9.2.0.6 and 10g.
• On Call (in rotation) for Production databases.
• Developed and maintained database designs, Meta data and data dictionaries.
• Rebuilding Database indexes.
• Monitoring table space usages.
• Configuring SQL*Net through tnsnames.ora and listener.ora.
• Upgrading JDK versions from 1.4.2 to 1.5 and 1.6

Confidential

Responsibilities:

• Creating and sizing of database objects (tablespaces, tables, and indexes).
• Database Backup and crash/Recovery both local and remote.
• Documented the Backup and Recovery procedures.
• Management of Users, Roles and Privileges.
• Database performance tuning, table sizing and administration.
• Scripts to monitor online Database objects and SGA.
• Diagnose the bottlenecks and problems causing poor performance.
• Database reorganization to minimize fragmentation.
• Rebuilding indexes for faster access and to reduce disk I/O.
• Clone the database for debugging application bugs.
• Data extraction and Loading using Export/Import and SQL*Loader.
• In depth noledge and experience wif RapidInstall, RapidClone, adpatch, adadmin, adsplice andadctrl utilities for Oracle Applications.
• Pre-patch analysis for the patches and document preparation wif pre and post patch installation steps.
• Experience in web development using HTML, JavaScript, and XML.
• Worked on SQL*loader to load data into database.
• Range Based Partitioning for Large Tables.
• Responsible for security on production database like creating roles and provide access to application schemas to users and maintain separate table spaces for data, indexes and temporary applications.
• Created different synonyms & views as per business needs. Created materialized views and snapshots for high end application usage.
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers and monitoring of the concurrent managers.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.
• Created new application messages and tan generated message file for application.
• Created new concurrent managers, Purged concurrent requests table.
• Provided application support to users and created a log of all the problems wif solutions for future reference.
• Good Knowledge of Oracle SQL & PL/SQL.
• Experience in implementing hot, cold and RMAN backups and performance tuning of SQL statements