SUMMARY

• 7+ years of experience as an Oracle APPS DBA which includes Oracle APPSDBA/Oracle DBA on different platforms Linux, AIX, Solaris, HP and windows platforms - work includes in Installation, Management, Administration, Backup and Recovery, Maintaining and Tuning of Oracle Applications and Oracle RDBMS.
• Oracle Applications RDBMS Database Administration / Application Design and Development Design, Administration, Disaster recovery, Performance Tuning, Cloning, extent/space management, 24X7 On-Calls. Extensive custom development / data quality analysis; Legacy data processing, stored procedures, Triggers, indexing strategies.
• Has experience in giving support to Oracle databases 9i/10g/11g in variety of different environments like HPUX, Sun Solaris, AIX, Red Hat Linux and Windows.
• Installation, Cloning and patching (version 11.5.8 to 11.5.10.2, 12.1.1 to 12.1.3).
• Oracle Database Infrastructure experience on Single node, multi-node and RAC
• Creating maintaining, Tuning Standby databases, Disaster recovery using data guard Broker.
• Expertise in dealing with Concurrent Manager Setup and trouble shooting.
• Expertise in Oracle Applications Sys admin activities too.
• Easily can handle the 11.5.x technology stack: forms server, reports server, forms metrics server, Apache web server, load balancing, Apps listener, concurrent manager configuration.
• Worked very extensively with utilities like - adadmin, adctrl, adpatch, admrgpch, adclone.pl, adconfig.sh, adident, f60gen, FNDCPASS, FNDLOAD, and CONCSUB etc.
• Strong knowledge of Oracle Enterprise Manager and Oracle Applications Manager, Auto Config.
• Expertise with all the knowledge regarding GUI development using Oracle Forms and Reports Developer 2000.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Have strong programming skills in writing / maintaining SQL and PL/SQL Oracle database backend programming.
• Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables, Indexes etc,
• Responsible for memory and Application, performance tuning of the databases using Oracle utilities like OEM, SQL Trace, TK Prof and Explain Plan.
• Worked on Partitioning of large tables for fine tuning performance.
• Worked in situations involving crash recovery strategies, and Hot, Cold and Logical backup plans- successfully made a necessary steps to make it out of disaster.
• Worked in environments where periodic Backup of the Database and the software using Recovery Manager and VERITAS is done.
• Generated regular Stats-Pack/AWR/ADDM reports for the performance tuning of the databases in all most all the client sites.
• Experience with DBUA/Export and Import to migrate the database.
• Excellent team player, have very good relationships with the various Application teams and the Infrastructure teams.
• Have been successful in mentoring the Client Side Data Base Administrators.
• Managing Table spaces, Creating profiles and roles assigning the same to users.
• Working on 24*7 production day to day and on call support and maintenance
• Changing databases from No-Archive log to Archive log mode, and setting multiple
• Reorganizing tables and database to reduce fragmentation
• Implemented RAC and ASM Based Database instances. Applied RDBMS patches using OUI and Opatch
• Analysis of database and fine-tuning to improve performance of database.
• Suggesting backup and recovery strategies. Proactive measures before event specific activities.
• Maintaining Physical and logical backups. Tuning Sort operations.
• Expertise in Data Base maintenance, its security and also its auditing too.
• Experience in Data Migrations, Benchmarking.
• Planning the Disaster recovery in the event of database crash to recover without any loss Of data.

TECHNICAL SKILLS

Applications: Oracle EBS 11i, R12, Oracle Application Server 10gAS, 9iAS

Databases: Oracle 8i, 9i, 10g RAC, 11g, MySQL 5.1

Operating Systems: Windows NT/2000/2003/XP, RHEL, Sun Solaris, AIX, HP-UX

Languages: Confidential ++, PHP, PERL, SQL, Shell Scripting.

Performance Tools: TKPROF, STATSPACK, Explain Plan.

Others: AD Utilities, SQL * Loader, TOAD, XML/BI Publisher, Workflow Builder, SQL

PROFESSIONAL EXPERIENCE

Confidential, Keene, NH

Senior Oracle Applications DBA, Oracle DBA

Responsibilities:

• Oracle Apps DBA Production Support in 4 in 24X7 Production environments.
• Responsible for 5 Production and 80+ Development, Test and UAT instances with maximum database size of 2TB
• Oracle R12 experience includes, installing and upgrading to 12.1.2 version with Forms Web Server, Reports and Concurrent Mangers on Linux, Unix node.
• Worked on E business suite
• Responsible for support, upgrade and maintenance of Oracle Applications 11.5.10.2
• Provide regular status reports and support/maintain project plans.
• Cloning Oracle Apps instances (11.5.10.2) multiple times using Rapid Clone utility.
• Applying patches (family packs, mini-packs), install new products.
• Migrated database objects to the new table spaces under OATM concepts post upgrade to 11.5.10 versions.
• Installed and upgraded Oracle Applications 11i e-business suite version 11.5.10.2 to R12 (12.1.1).
• Upgraded application tier upgrade from 11i (11.5.10.2) to R12 (12.1.1).
• Provided support to many Production, Development, Test, CRP instances from versions 11.5.10 and versions 12.0.4, 12.0.6, 12.1.1, 12.1.2, 12.1.3.
• Extensively used Oracle AD utilities on a day-to-day basis.
• Enabling auto- config for Oracle Apps Instances.
• Managing forms server, forms metrics server, Apache web server.
• Provided on-call support for production applications.
• Administration, maintenance, and tuning of concurrent managers, monitor operations, schedule and purge requests.
• Worked on different modules and have a good technical knowledge about and have in depth knowledge of the tables involved in these modules AR, AP, GL.
• Troubleshooting & Diagnosis of Sysadmin activities (including User management, Concurrent Manager Admin, APPL TOP Management, Schema Analyze, Report/forms server management).
• Responsible for research and installation of Critical patch updates every quarter.
• Investigation of Instance level technical issues, Oracle TAR Support.
• Use FNDCPASS to change APPS, APPLSYS and other application schema passwords.
• Migrating objects from Test to UAT and UAT to Production, representing changes as necessary in Change Management.
• Responsible for creating automated scripts and setting up jobs in Autosys and crontabs.
• Strong understanding of the Oracle technology stack and architecture for Oracle Applications.
• Perform instance monitoring, analysis, debugging, and tuning.
• Design procedures for business continuation planning (daily backup and recovery as well as backup integrity checks) as required by system-availability agreements for each application.
• Strong technical expertise on data issues and independently performs analysis, design, testing, and monitoring of databases across multiple platforms, technologies, and computing environments.
• Supported Sarbanes-Oxley audit of all Oracle databases.
• Responsible for system administration functions: setup executables, users, responsibilities, concurrent programs, backup, tuning, monitoring, patching, cloning, and upgrades.
• Performance tuning of the Application and Database.
• Oracle Database Administration activities including monitoring, schema management, space management, performance tuning, SQL tuning, database backup and recovery, disaster recovery.
• Use of Oracle export and import utilities to get objects from Production to Test and UAT environments.

Confidential, Phoenix, AZ

Senior Oracle Apps DBA

Responsibilities:

• Upgraded Oracle Applications from 11.5.9 to 11.5.10.2
• Installation of Oracle 10g
• Database migration from Oracle 9i to 10g
• Copy/Clone of Oracle application environment using Rapid clone
• Database Refresh
• Worked on E business suite
• Installed, configured and tested 10G RAC.
• Configuration of Workflow Notification Mailer, OAM, OEM 10g and tuned concurrent managers using Oracle Enterprise Manager (OEM).
• Installing, configuring and maintaining Oracle Grid Control (10g grid).
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc.
• Worked on different modules and have a good technical knowledge about and have in depth knowledge of the tables involved in these modules HRMS.
• Applied RDBMS patches using Opatch
• Created a number of database instances for development, testing and production.
• Created and managed the Database objects and schemas
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Application user creation / responsibilities assignment
• Analyze design and data model solutions for business needs in cooperation with various levels of business and systems personnel.
• Perform database analysis, design, coding, testing and implementation of database structures.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
• Review database access code and recommend tuning opportunities.
• Advise less experienced team members in all phases of the assignments and assist in the coordination of team activities.
• Write code to access database.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.
• Install, test, evaluate, implement and maintain DBMS related system software and tools.
• Design and implement database backup and recovery procedures (RMAN).
• Monitor and tune database performance including SQL tuning.
• Implement effective database security practices and procedures.
• Implement complex enterprise changes as they pertain to the database environment.
• Develop, document and enforce database standards and procedures.
• Maintain and improve high availability and disaster recovery.
• Strong skill in PL/SQL procedures, packages, triggers and replication.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Clear communication and documentation of technical specifications.
• Load and extract formatted data in and out of database (ETL).
• Migrate data to other databases.
• Recover lost databases.
• Database storage management.
• Finest granularity approach to Oracle implementation and defragmentation.
• I/O distribution analysis.
• Capacity planning, capacity monitoring and management.
• Perform transaction-sizing measurements.
• Managed day-to-day production databases.
• Possess a thorough understanding of Oracle fundamentals, concepts, utilities and applications.
• Seasoned experience with Unix and a strong ability with Unix shell scripting.
• Experience working in large database environments.
• Calculate disk space requirements.
• Oracle’s Enterprise Manager(OEM), Statspack Reports, Explain Plans, SQL Trace and TKPROF.
• Data guard, upgrades, patches, partitions, RAID arrays, etc.
• Oracle SQL*Net Network Configuration.

Confidential, Atlanta, GA

Senior Oracle Database Administrator

Responsibilities:

• Performed Oracle 10g Release 2 and Oracle 9i release 2 installation and 9i database up gradation (from 9.2.0.1 to 9.2.0.4)
• Managing Table spaces growth by adding data files or resizing the size of the data files
• Responsible for backups (export/import) and restoration
• Strong understanding of the Oracle technology stack and architecture for Oracle Applications 11.5.5/11.5.9
• Performed database upgrades from 8174 to 9205.
• Upgrading of Oracle application from 11.5.5 to 11.5.9.
• Configuration of Oracle HTTP server load balancing.
• Planning and designing the database design based on the requirement provided by end user.
• Controlling and Maintaining User access in the DB using synonym creation and granting privilege
• Monitor databases for performance and tune the query, parameters accordingly
• Support the developers in the development life cycle and worked with change management team in the time of testing
• Logical Data modeling using Oracle Developer Suit (Oracle Designer)
• Written shell scripts to automate the daily jobs like backup the database using EXP utility, gathering statistics in STATSPACK.
• Recover lost databases.
• Database storage management.
• Finest granularity approach to Oracle implementation and defragmentation.
• I/O distribution analysis.
• Capacity planning, capacity monitoring and management.
• Perform transaction-sizing measurements.
• Managed day-to-day production databases.
• Possess a thorough understanding of Oracle fundamentals, concepts, utilities and applications.
• Seasoned experience with Unix and a strong ability with Unix shell scripting.

Confidential

Oracle APPS DBA

Responsibilities:

• Installing Oracle and recommending kernel parameters.
• Developed complex packages, stored procedures and functions to implement business logic
• Installed, configured and upgraded three-node Oracle 10g RAC release databases on LINUX and SUN Solaris Operating System.
• Work shifts, Printers, Print Styles and Drivers
• Creation of Request Group, Data group, value sets and Flex Field setups.
• Creation of Concurrent Mangers, Programs, and Request sets.
• Troubleshooting of Concurrent Requests and Request sets.
• Create table spaces, tables, and users for custom applications.
• Assist Programmers and Developers with Oracle problems.
• Resolved various application failures due to data entry errors or system errors.
• Configured Grid Control agents to collect database and instance level metrics and specific metrics to monitor RAC configurations
• Created database objects like tables, views, indexes, partitions.
• Maintained separate RAC database for testing and cloned production database
• Configured new RAC 9i,10g nodes using dbca and via manual method for existing RAC clusters on Linux Itanium servers
• Installation of RAC from scratch using OCFS2
• Creating users and Creating Roles, and assigning roles, privileges and profiles to users.
• Wrote Shell Script to create DB objects for Products, Automate backup and monitoring and testing scripts.
• Monitoring of data guard in the production environment
• Worked with AIX environment
• Monitoring the alert logs and trace files regularly. Administering the Client’s Oracle 10g Database.
• Monitoring the Table space Usage and Indexes usage regularly.
• Gathering Statistics by using Stats pack.
• Storage management, sizing the database objects, monitoring Disk usage.
• Monitoring the Backup Status. (Exports, Cold Backup, Hot Backup )
• Debugging the bugs in SQL using toad and troubleshooting end users problems.
• Monitoring RMAN jobs and events by using OEM.
• Compared schemas, databases, TNSNAMES.ora file and Table spaces for better understanding of databases between test and production environment.
• Import/Export, Data Pump, SQL* Loader