PROFILE:

• 8 Years of Oracle DBA Experience
• Strong Experience with Installation, Patching, Cloning Upgradations
• Strong Experience with RHEL, RAC, ASM, RMAN
• Strong Experience in Performance tuning
• Oracle Certified Associate OCA

Technical Skills:

• Oracle Application Administration and OCA certified Oracle Database Administration in below competencies
• Installations: Experienced with Installation/Maintenance of Oracle Databases 8i, 9i, 10g, 11g 12c on Linux, UNIX and windows platforms
• Patching: Experienced in database patching OPatch, o/s patching using RPM -UVH application patching ADPATCH and its troubleshooting has good experience performance tuning of patch during application point release upgrade. Has good experience with patch analysis
• Cloning: Experienced in database and application cloning using Manual and Rapid Clone technology and troubleshooting. Has done multi to single node cloning too as well as software cloning
• Upgrades: Has done manual automatic database up gradation from 9.2.0.7 to 10.2.0.1, 10.2.0.4 to 11.1.0.6 10.2.0.3 to 11gR2. Has done applications upgrade
• Migrations: Migration of database from sun-OS to Linux code migrations using FNDLOAD utility Data Migrations using SQL LOADER utility
• Data Guard: Maintenance of physical standby and knowledge in logical Standby
• Monitoring: Participating as part of a team ensuring daily system operations are smooth, this may include following daily checklists, participating in status meetings as well as being on-call. Monitor error log s , database and log space, user activity and resource utilization of production environment. Has hands-on experience in using many monitoring tools and good at proactive monitoring using tkpoof, OEM, explain Plans, AWR, ADDM stats pack.
• Securities: Experienced in creating profiles, roles and responsibilities, setting the permissions and changing the ownerships, DMZ configuration. Strong knowledge of creating database administration processes and controls to meet security and compliance audit requirements for SOX, PCI DSS, FISMA, GLBA, SOX, HIPAA, ISO 27001..
• Troubleshooting: Good hands-on experience in troubleshooting applications and database checking into the log files alert logs and configuration files
• Networking: Experienced in setting up the network using NETCA and NET MGR utilities establishing network between nodes, configuring ssh, exposure in using neat and netconfig. Coordination with data center, network teams and Oracle support, monitoring and fixing server related problems.
• Backup Recovery: Set-up, testing, and implementation of backup/recovery strategies using Oracles Recovery Manager RMAN . Good experience in EXP/IMP tools and DATAPUMP. Has knowledge in taking hot and cold backup using VERITAS tool
• Training and documentation: Providing Oracle Apps/Database support services, documenting resolutions or best practices and performing training/Transfer of Information where required.
• Provide expert assistance in setting up instances, tablespaces, tables, indexes and views. In conjunction with programmer/analysts, define new objects or modifications to existing objects.
• ASM, RAC CRS: Installed and provided maintenance and support of Oracle RAC/ASM with SCAN as well as VIP. Key generation, ASM Disc management, ASM instance setup, ASM disc group creation, Migration of non ASM database to ASM database and Monitoring RAC using CRSSTAT
• Performance Tuning: System Tuning, Tuning Log switches, PGA-Aggregate Target, Tuning Advisors, Load balancing, PCP configuration, Pinning Packages in Memory, Statspack, SQL Tuning, Rebuilding Indexes, Oracle Optimizer, Explain Plan, TKPROOF, Hints, Stored Outlines scheduling purge and gather schema stats system administrator
• Advanced Technologies: Knowledge on the advanced technologies like R12.2, Oracle AS 10g/ Weblogic , Exalogic, Exadata, Golden gate, Oracle Streams, Oracle Internet Directory OID ,Oracle Access Manager OAM , SSO, OBIEE , Fusion Middleware, SOA, Strong knowledge of OEM / Oracle Grid for 11g and 12c

TECHNICAL SKILLS :

Work Experiences

Confidential

Lead Oracle DBA

Responsibilities:

• Database upgrades from 10.2.0.4, 11.2.0.2 to 11.2.0.3
• Oracle 12c implementation
• Support for the upgraded instances
• Applying E-Business Suite and Database Patches
• MetaLink Service Requests support for new bug fixes and development support
• Cloning databases and applications for use in development environment and deployment of post clone activities
• Code deployment of scripts made by development team
• Troubleshooting performance and concurrent managers issues
• Creation of custom top for the application customization
• Managing backups of the database
• Cloning of database and application
• Proactive monitoring of the Space and server issues
• Alert Management
• Attending weekly status calls and business calls
• TMS tracking tool

Environment: Oracle10g, 11g, 12c, Oracle EBS 11.5.10, R12, Linux AS 4.0, 5.0 RHEL

Confidential

Role: Lead Oracle DBA

Responsibilities:

• Upgrade of Database from 8.1.6 to 8.1.7, 8.1.7 to 9.2.0.8, 9.2.0.6 to 9.2.0.8, 9.2.0.8 to 11.2.0.3
• Upgrade of oracle Applications/EBS from 11.0.3 to 11.0.4 and 11.0.4 to 11.5.10.2
• Bubble support for the upgraded instances
• Applying E-Business Suite and Database Patches
• MetaLink support for new bug fixes and development support
• Cloning databases and applications for use in development environment and deployment of post clone activities
• Code deployment of scripts made by development team
• Troubleshooting performance and concurrent managers issues
• Creation of custom top for the application customization
• Managing backups of the database
• Cloning of database and application
• Proactive monitoring of the Space and server issues
• Alert Management
• Attending weekly status calls and business calls
• Remedy tool tracking

Environment: Linux AS 4.0, 5.0 RHEL, Oracle Apps 11.0.4, 11.5.10.2, R12 Oracle RDBMS 8.1.7, 9.2.0.8, 10gR2 11g R1, R2

Confidential

Role: SSE Oracle DB Administrator

Responsibilities:

• Installs, upgrades, and maintains the database server and tools and the E-Business Suite
• Applying E-Business Suite and Database patches
• Monitors for new patches and ensures patches are applied at both the database and PC level
• Code deployment of scripts made by development team
• Troubleshooting performance and concurrent managers issues
• Implementation and upgrade of 12.0.4 to 12.1.1 and 12.1.1 to 12.1.3
• Controls and monitors the E-Business Suite and custom user access to the database objects
• Creates and maintain primary database storage structures and objects
• Creation of custom top for the application customization
• Implementing regular and frequent E-Business Suite and database backups required to recover and/or restore the E-Business Suite code and output files along with the appropriate db objects
• Monitoring the size and content of archived redo log files and storage destinations.
• Defining E-Business Suite users, including their security levels and responsibilities
• Tracking size and performance of Workflow and other large E-Business Suite tables to determine potential need for partitioning these tables as they grow
• Controlling E-Business Suite system security
• Controlling report output and Concurrent Manager log destinations and purges outdated reports according to business requirements
• Create and Manage Service Requests related to the environment
• Defining E-Business Suite users, including their security levels and responsibilities
• Manage and monitor Concurrent Manager performance and functionality issues, including cleanup of jobs in background processes

Environment: Oracle10g, 11g R2, Oracle EBS 11.5.10, R12, Linux AS 4.0, 5.0 RHEL

Confidential

Sr.DBA Consultant

Responsibilities:

• Daily Reports to the client
• Maintaining 2 node RAC application
• RAC Failover Test High Availability testing
• Refreshing Database
• Maintain Physical Standby
• Application and Database Patching
• Taking zero level RMAN backups daily
• Taking Cold Backup weekly
• Troubleshooting concurrent managers and database
• Monitoring Alert Log file for space as well as Lock issues
• Troubleshooting Performance Issues
• Maintain and scheduling shell scripts for maintenance
• Scheduling Concurrent requests
• Proactive Maintenance
• Maintaining Hosting Servers for the clients Trainings

Environment: Oracle10g, 11g R2, Oracle EBS 11.5.10, R12, Linux AS 4.0, 5.0 RHEL

Confidential

Sr.DBA Consultant

Responsibilities:

• Creating and Maintaining Databases and Database devices,
• Server activity, maintaining batch and real-time scheduled tasks
• Setting up and maintaining security
• Creating and altering tables
• Troubleshooting various server and stored procedure related problems
• Taking Backups and Restoring Database
• Writing Triggers and Customizing end user adhoc Reports
• Analysis and Apply patches
• Database Cloning
• Creating users and assigning the Responsibilities
• Data Migration from Oracle to SQL Server Database
• Hot and cold Backup configuration
• Creating RDC
• Creating Forms
• Writing stored procedures and triggers

Environment: Oracle 91,10g, ORACLE CLINICALS 4.5.1, SQL Server 2008

Confidential

Role: Software Executive Oracle Apps DBA

Responsibilities:

• Making Daily Reports for multiple clients.
• Monitoring RMON tool
• Backup and Recovery Cold and Hot backup
• Monitoring Health checks
• Fixing Space issues
• Raising Service Request to Oracle
• Attending status calls
• Installing Change Controls
• Daily Databases and Application Health check
• Hot and cold Backup configuration
• Weekly Refreshes
• Database and Application Patching
• Maintaining Database Objects like Validating and compiling objects, recreating grants synonyms
• Analysis and Apply patches using adpatch utility.
• Creating users and assigning the Responsibilities using System Administration module of Oracle Applications.
• Maintaining availability of Concurrent Managers using system administration module scheduling.
• Clone Oracle Applications 11i environments for test purpose.
• Troubleshoot problems related to Oracle database and Oracle Applications.
• Single and multi-node installations.
• Configuring changes in Oracle Applications environment.
• AD ADMIN tasks.
• Upgrading 8.1.7 to 10.2.0.2
• Upgrading 9.2.0.8 to 10g
• Configuring OEM

Environment: Oracle10g, 11g R2, Oracle EBS 11.5.10, R12, Linux AS 4.0, 5.0 RHEL, Sun OS, HP-UX

Confidential

Oracle DBA

Responsibilities:

• Oracle DBA shadowing
• DBA health checks reporting
• Alerts Monitoring
• Patch analysis
• Patching
• DBA sizing and security
• User Management
• Documentation of installations and monitoring processes
• Jobs scheduling
• Change managements

Environment: Oracle10g, 11g R2, Oracle EBS 11.5.10, R12, Linux AS 4.0, 5.0 RHEL