PROFESSIONAL EXPERIENCE

• Having 7+ years of experience as an Oracle Application Database Administrator.
• Oracle Certified 11g Database Administrator (OCA).
• EBS Cloning and Upgrade, Installation, Apply Patches/Patch analysis and Administration. Also in tuning of various components of E - Business Suite 11i/R12. Unix Shell scripting (ksh/bash).
• Installed, configured and administered Oracle Application 11i/12i database in a Multi-tier architecture.
• Application upgrade from 11.5.10.2 to 12.1.3.8 EBS suite.
• Applying patches on both Applications and Database TechStack tiers.
• Comfortable wif applying bug fixes and ADOP ( AD Online Patching).
• Hands on experience on handling and maintain Oracle Applications 12.2.3
• Configuration & Supported Oracle Databases 9i/10g/11g/ 12c, Oracle Apps, on call Support, Performance Tuning & Trouble shooting etc.
• Maintained and supported production, development, test, and training databases supporting over many applications corresponding to 13 instances and more than 2 terabytes of database.
• Oracle Application DBA support, applying patches, mini-packs, family-packs and maintenance packs, upgrades, multi-tier installations, automatic routines DBA task, periodic refreshes, oracle support dealing wif functional, developers and end users.
• Designed, developed, and implemented custom Web Application for on-going DBA support.
• Experience in supporting mission critical databases in 24/7 365 days environment
• Good Knowledge on Oracle Architecture and in Installation of Oracle 10g/11g binaries using silent mode and Graphical User Interface (GUI).
• Supporting several change migration processes and Involved in various code deployments.
• Database upgrades from 11 to 12c.
• Hands on experience wif patching applications in 12.2 versions.
• Performing schema and database refresh activities using data pump utilities like Expdp and Impdp.
• Managing Oracle Users, Roles and Privileges and creating database objects.
• Created and Managed Physical Standby databases using Data guard for PROD and QA Environments.
• Knowledge in Backup and Recovery strategies like User management backups and RMAN Backups.
• Generating AWR, ADDM reports.
• Planned and implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard, 11g and 10g databases.
• Worked on Exadata migrations and had a sound noledge on setting up different type of RACs.
• Great Knowledge on Oracle Data Guard Setup.
• Managed and cloned full-sized development and testing environments from Production.
• Perform 2-tier clones of Oracle Applications 11i instances and R12 instances.
• Strong troubleshooting skills in teh Windows environment including noledge of Active Directory, networking and security.
• Ability to coordinate various resources to effectively perform problem analysis and resolution.
• Committed to excellence, self-motivator, quick-learner, diligent, team-player, and a prudent developer wif strong problem-solving skills and communication skills.
• Strong “people-skills” working in high pressure technical situations.
• Provided 24x7 on-call supports to clients on a rotation basis.

TECHNICAL SKILLS:

Operating System: Red hat Enterprise Linux, Oracle Enterprise Linux and windows

Database: Oracle 9i, 10g and 11g.

Tools: Grid control (OEM), SQL *Plus, SQL *Loader, Toad, UNIX Shells Korn, Bourne, C), Forms 6i, Reports 6i, Oracle Workflow, data and: Visio and Shell Scripting, SCP, WINSCP:

Backup Utilities: RMAN, Import and Export, Data Pumps (Expdp, Impdp)

Languages: SQL, PLSQL, HTML, Basic in Java, Servlets, JSP, XML

Applications: Oracle 11i E-Business Suite Versions 11.5.10 and R12 Version12.1.1

PROFESSIONAL EXPERIENCE

Confidential, LA

Oracle Application DBA

Responsibilities:

• Managed and cloned full-sized development, testing, QA and Patch environments.
• Perform 2-tier clones of Oracle Applications 11i instances.
• Perform clones of Oracle Applications R12 wif both Hot Backup and Cold Backup.
• Application upgrade from 12.1.3 to 12.2.4 EBS.
• Installed and configured Oracle 11g and 12c databases on Linux servers.
• Upgraded oracle database version 11.2.0.3.0 to 12.1.0.1.0 using database upgrade assistant.
• Patched, configured, and maintained production, development, and testing instances.
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload teh running of huge reports.
• Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for teh file system and CPU issues.
• Handling various application issues/problems related to Apache, Concurrent manager, Forms server.
• Periodically refreshed Oracle Database and Oracle Apps by Cloning - of Databases and Applications.
• Configured and managed database listeners.
• Custom top creation as per teh requirement.
• Changing teh passwords using FNDCPASS.
• Worked wif Oracle Support to solve open Service Requests.
• Handled sysadmin tasks like creating and managing users, their responsibilities. Monitoring concurrent manager status.
• Executed teh scripts as on when asked by teh developers and provided them teh log files of teh executed scripts.
• Managing Oracle physical standby using data guard.
• Minimized code migration script using Unix shell scripting.
• Managed Data files, Parameter files, Control files, Online Redo logs and Archive logs.
• Configured RMAN and performing backups regularly using RMAN tool.
• Managing Tablespaces, user profiles, indexes, storage parameters.

Confidential

Oracle DBA/ Oracle Applications DBA

Responsibilities:

• Support and maintain Oracle Applications 11i instances including production.
• Configured, and maintained production, development, and testing instances.
• Applying database and applications patches (Maintenance, mini-packs, bugs, technology and security patches) and cloning teh databases.
• Administrating teh Oracle Applications instances, User administration and patch management
• Create Database Objects for custom applications.
• Analyzed performance for DML and DDL Commands.
• Create and maintain custom responsibilities as per teh client request.
• Backing up System & User databases by using different Backup strategies, scheduling teh Backups. Restoring them whenever necessary.
• Configuring load balancing on client and server side and Monitoring RAC database on load tests and performance monitoring and generating reports for analyze and giving suggests to application teams and creating required Indexes for better performance.
• Performed database cloning using RMAN utility.
• Applied patches on 12c databases using Opatch utility.
• Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for teh file system and CPU issues.
• Managing Responsibilities and adding custom responsibilities to users.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Worked wif Oracle Support to solve open Service Requests.
• Creating database links, Materialized views as per teh requirement.
• Performing daily and weekly health checks of various Databases. Installing and implementing new oracle apps modules and Products.
• Installation, Creation and Configuration of database.
• Upgrading and Migrating Oracle E-Business suites.
• Configure custom scripts for application and database backups and built DR rsync process for logs/out files.
• Configuring Workflow Notification Mailer.
• Creating temporary tablespace groups and assigning to users.
• User management, roles and Profile creation.
• Checking free space in data files.
• Tablespace management, Adding and resizing data files in tablespaces.

Confidential

Oracle DBA/ Database Analyst

Responsibilities:

• Involved in Systems study, database analysis. Involved in Development which includes creating and validating forms and reports having good user interface, writing database triggers, functions, procedures, packages.
• Application & database performance tuning, debugging. Developing pl/sql codes, triggers, functions, packages, Optimizing Sql statements, and Enrolling database users. Using utilities like TKPROF, Explain plan, statistics, tracing etc.
• Involved in software development lifecycle of teh project i.e. Requirement gathering, analysis, Development and testing, UAT and Production environments. Promoting teh modules developed from Development to UAT tan UAT to Production once end user requirements are met.
• Involved in SQL performance tuning and optimization.
• Backup and recovery strategies, Export, Import etc.
• Provide 7x24 supports when required.
• Interacted wif teh users for their further requirements.