SUMMARY:

• 8 years of experience as an Oracle DBA with administration & maintenance of Oracle 12c/11g/10g on operating systems such as Red Hat Linux, Sun Solaris, HP - UX, IBM-AIX and Windows.
• 24*7 production database support to developers & end-users.
• Worked on upgrading of oracle databases from 11g to 12c
• Worked on building and rolling out new 12c databases for test/dev/qa environments.
• Implemented oracle 12c active standby database for test database environment.
• Installed, Configured Oracle 12c Golden gate on Oracle 12c Database.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Worked with projects/operations/professional services team and coordinated multiple tasks at hand with expertise and solid plan.
• Contributed as an efficient/reliable team member for all business-critical releases and changes.
• Worked under high stress situations many times and handled the situation very effectively.
• Performed the code reviews for all the database code coming into the database and fine-tuned it before-hand.
• Implemented Oracle 11g Golden-gate for replication project.
• Handled Vendor applications and interacted with vendors regularly to understand and optimize the database operations.
• Actively participated on war room bridges during major releases and escalated to dba management as needed.
• Participated in database audits and following compliance rules and regulations always.
• Participated in requirements gathering meetings with customer while building out new db environments.
• Effectively communicating with PM'S while working on project related tasks.
• Always uploaded the common share point repository with all updated work related documents for sharing purpose.
• Experienced in Installation, configuration and tuning of high availability Real Application Clusters (RAC) applications.
• High experience in deployment and configuration of Fusion Middleware Applications such as OBIEE, Hyperion, ODI, Informatica and WebLogic administration.
• Experience in applying Critical Patch Updates (CPU Patches) and patch set updates (PSU patches) on Databases, Application Servers and Middle Tiers.
• Installation and Setup of Informatica and DAC.
• Experience in installing and configuring Golden Gate 11g/12c and using replication procedures to support data replication in the Oracle database environment.
• Experience in building Standby databases. Implementing FSFO (Fast start failover) on 11G databases and configuring disaster recovery site using Dataguard.
• Modeling and designing Data, OLAP, Logical and Physical Database Design of tables, tablespaces, Users, roles, privileges, creating storage structures or using ASM and Performance Tuning.
• Installing and maintenance of NoSQL Postgres and Cassandra Databases.
• Implemented efficient methods for Maintenance, Monitoring, Backup/Recovery, Growth Management, contention Resolution, block corruption and Defrag scenarios across diverse environments.
• Proficient use of advanced replication using Oracle Streams and experience in using utilities like TOAD, SQLDeveloper, SQL*Plus, SQL*Loader, data Migrations using export/import as well as traditional UNIX command that requires for Oracle DBA.
• Extensive experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM.
• Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.

TECHNICAL SKILLS:

Oracle Applications: Oracle Applications ERP R12, 11i

Operating Systems: HP-UX, Red-hat Linux 6, Windows 7/XP/2000/NT, IBM-AIX

Languages: C, C++, Unix Shell Scripting, PL/SQL

RDBMS: Oracle 9i,10g,11g,12CTools: Toad, SQL*PLUS, SQL*Loader, WSFTP, SQLDeveloper.

Development Tools: Developer 2000, XML Publisher, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i, OA Framework

Methodology: Oracle Application Implementation (AIM) Methodologies Oracle Unified Methodology (OUM)

Oracle Technologies: OBIEE11.1.1.7,Hyperion11g,Weblogic-server11g/12c,Informatica9i, EBS-APPSR12

Oracle: Supply Chain/Distribution Modules & Financial Modules: OrderManagement(OM), Inventory(INV), Purchasing(PO),Account Receivables(AR), Accounts Payables(AP), General Ledger(GL), HRMS.

Utilities: SRVCTL, CRS, DGMGRL, ASM, Opatch, Explain Plan, Dbca, Awr, OEM, R-Man, Tuning Advisor, TOAD, Oracle SQL developer, MS Office Tools, winscp, sftp, SQL*Loader, FTP, exp/imp, Datapump, SPM, SQLT,Data Guard, Golden Gate, RDA, Streams, ADDM,Adrci.

Version Control: Git, SVN, CVS, VSS (Visual Source Safe)

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DBA

• Extensive Knowledge in AWS Cloud
• Configured Storage Gateway setting to migrate the instance from Oracle to cloud service.
• Worked with AWS (Amazon Web Services) for linux cloud deployments using EC2(Elastic Cloud Compute) for RedHat/CentOs/Ubuntu with MarketPlace and Custom AMI’s.Worked with Instance store-backed and EBS (Elastic Block Storage) for setting up the EC2 instances.
• RMAN Backups and Clones using scripts.
• Production Assessment Tests and maintained to the global standards
• Planning and Administration of backup and recovery strategies.
• Creating and Managing Primary Objects like Custom tables, Procedures, Cursors, Packages, Triggers, Alerts & Functions, Views, Materialized Views, Indexes, user accounts, roles, grants and performing day-to-day operations.
• Rebuilding Database indexes and tables.
• Monitoring tablespace usages.
• Using TKPROF, EXPLAIN PLAN and AWR for the Better performance.
• Transferring files by using SCP, SFTP, FTP and PSCP.
• Partitioning strategies for very large tables.
• Diagnose and troubleshoot Database problems and failures
• Creating and refreshing materialized views.
• Performing SQL*Loader jobs for data loading.
• Monitoring of database for growth and performance.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Involved in Database sizing, Capacity Planning.
• Performed Space Management & Troubleshooting the database issues.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Database cloning/exp/imp tables to setup identical databases in the production and development environments.
• Performed Cloning/Refresh to setup Test and Development database.
• Create and maintain users, roles and privileges & Auditing Triggers.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Transformed logical database designs into physical databases.
• Build and implemented test, quality assurance, production databases and environments.
• Coordinated strategies to move data between databases.
• Ensured data is being maintained effectively by monitoring data maintenance.
• Performed version upgrades and patch installs.
• Automate Logical Backups using export/import, data pump on applications through grid control.
• Implemented and maintained database security (created and maintained users and roles, assign privileges).
• Documenting and maintaining the process related to oracle database installations, patching, migrations and upgrading.
• Worked with oracle global support/metalink team for various oracle database issues and software version bugs.
• Followed the oracle metalink standard documents and procedures for various database related deployments and changes.
• Worked with application support teams to gather requirements and document them properly

Environment: AWS Cloud services, Oracle10g/11g, Sun Solaris10, Oracle Enterprise Linux, RHEL, OEM, SQL*plus, SQL Loader, Toad

Confidential

Sr. Oracle apps DBA

• Monitoring the Oracle applications and provided 24x7 On-call support
• Managing the patches and dealing with Oracle Support for many production and test/development Instances.
• Cloning of Oracle Applications 11i RAC to RAC and RAC to Non RAC.
• Upgraded Oracle Applications from 11.5.10.2 to R12
• Upgraded 9i database to 11g (11.1.0.7) database
• Post go-live support of Oracle Applications R12
• Maintenance of 10g databases and other non-ERP Databases
• Implemented parallel concurrent processing in R12
• Configured ASM on one of the Prod OLTP instance.
• Cloning DEV and UAT instances from Production for testing.
• Installed SOA suite and trouble shoot issues.
• Implementing and troubleshooting of forms server, report server, Discoverer server, Web Server.
• Administer middle tier Oracle SOA, Oracle HTTP server
• Golden Gate DDL replication using Golden Gate
• Maintenance of Concurrent managers and Parallel Concurrent Process (PCP) and troubleshoot issues.
• Worked on Oracle 11g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listeners running, disk space availability, checking for errors in alert logs etc.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Worked on Application System Administration. Activities like user setup, defining responsibilities, value sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs
• Implemented Data guard (Physical Standby database set up in production)
• Successfully implemented 3-node RAC setup and made the environment stable
• Configured load balancing on Apache and Forms Servers
• Applied the patch sets, one off patches, opatch to the Development and production servers
• Monitoring of databases using 11g OEM grid control
• Implemented the Oracle E-business suite Application Management Pack on OEM
• Implemented Shared APPL TOP
• Troubleshooting the issues raised by oracle ERP from both user community and development
• Taking care of the performance issues both at the database level and applications level
• Scheduled the backups using RMAN and disk backups
• Recovering the databases at critical situations
• Worked with Oracle Support on resolution of SRs
• 24x7 on call support for Oracle ERP applications and production databases

Environment: Oracle Applications 11i (11.5.10.2), R12, Oracle 10g, Sun Solaris10, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, Boston, MA

Oracle Apps DBA

• Created and monitored the concurrent managers.
• Allocating system storage and planning future storage requirements.
• Cloning of Database and Applications as per functional requirements.
• Oracle Applications upgrades, patches using various AD utilities
• Troubleshooting and on-call support (7x24)
• Resolving system errors, disk space problems, huge file sizes errors
• Monitoring Oracle Applications users
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches etc.)
• Developing UNIX and sql scripts for the smooth functioning of database and applications related issues
• Tuned the database and applications using EXPLAIN PLAN, Auto Trace, SQL Trace, TKPROF STATSPACK (advanced version of UTLBSTAT and UTLESTAT)
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command.
• Monitored the Applications and database using OAM.
• Rebuild the indexes and dropped unused indexes.
• Setting up the printers in Application environment.
• Upgraded JDK 1.1 to 1.3.1
• Troubleshooting throughout the project phases and TAR Management
• Effective use of Oracle Web cache with multiple applications.
• Capacity Planning/Management (space/machine load/network)
• Moved the objects from one instance to other using FNDLOAD.
• Performed Application admin tasks using ADADMIN utility
• Cloning of Database and Applications
• Prepare and implement system management and maintenance procedures
• Analyzing the requirements and creating the database as per the requirements and the connectivity of clients to the server
• Cloning of Oracle APPS 11.5.10 Instance on HP-UX 11.0 platform
• Upgraded Oracle Applications 11.5.10 to Oracle Applications 11.5.10.1 on HP-UX 11.0 platform
• To tune and configure Oracle 9i Database for optimum performance.
• Provided production support.
• System Administration of 11i
• Applied the patches using ADPATCH
• Setting up of printers
• Developed backup scripts for EBS Applications 11.5.10.

Environment: Oracle 9i/11g Oracle Applications 11i (11.5.10.2), Oracle 9i, HP UNIX TRU 64, Precise, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer, JDK 1.2/1.3.1

Confidential, Newyork City, NY

Oracle Apps DBA

• Installation, Configuration, Upgrade, patching of Oracle RDBMS in development, test and production environments on Various OS Platforms like Linux, AIX and HP-UX.
• Refresh/Cloning of Database and applications for as and when needed.
• ADOP Patching of all the 5 phases and complete understanding of Run file system and Patch file system.
• Involved in developing PL/SQL functions, procedures, packages, and triggers. Involved in creating tables, views etc.
• Monitoring and tuning using different Oracle utilities like AWR, SQL trace, TKPROF, Explain plan
• Implementing User management strategies: schemas, Objects, user profiles roles and privilege management etc. As per application requirements.
• Preparation of Monthly Metrics of tickets and activities using the Nimsoft Infrastructure Management.
• Preparing the Documents: Installation/Upgrades/Patching/cloning/Issues /New activities are documented for the User and shared along with the team.
• Doing the Dashboards/Reporting Setups.
• Played the major role in upgrading DB 9i to 11g with Character set conversion to AL32UTF8 and OBIEE applications from 10G to 11G of two non-prod and one PROD instance
• Applying Patch set update and critical patch updates
• Removing OLAP ( Online Analytical Processing) and RAT (Real Application cluster)
• Experience in code migration, database change management and data management

Environment: Red Hat Linux5, Windows2008/2012, Oracle 9i/11g/12C, EBS R12 Applications, weblogic11g/12c.

Confidential

Oracle Apps DBA

Responsibilities:

• Monitoring and Installing Oracle Application EBS R12.2.4, EBS R12.2.5, EBS R12.2.6 and 12c Database
• Patching and Cloning
• Apply patches using ADOP utility in R12.2.6
• Cloning Oracle application R12.2.6 on QA/DEV/Test instance
• Creation of application users.
• Upgradation oracle database from 11g to 12c
• Upgradation oracle Application ERP from R12.2.0 to R12.2.4, R12.2.6
• Handling ERP login page problems
• Troubleshooting the daily production instance problems
• Production support for database and Application activities
• Apply patches on Fusion middleware, WebLogic server
• Daily Health Checkup of database
• Carrying out all System Administrator functions like creating & removing users;
• Taking cold and hot backups of the database and application tiers through scripts, manually.
• Applying Patches Using AD patch utility as per requirement.
• Change Apps password, SYSADMIN user password for security.
• Cloning Oracle Application on test instance.
• Space management.
• Checking alert log file.
• Add datafiles or resize datafiles in to tablespace as per requirement.
• Reporting to Team Leader for Oracle database health reports on daily, weekly and monthly basis
• Handling ERP login page problems.
• Checking of CPU utilization, memory utilization, application services.
• Starting & shutting down the production/ test instance on request.

Environment: Oracle Applications 11i (11.5.10.2), R12, Oracle 10g, Sun Solaris10, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer

Confidential

Oracle Apps DBA

Responsibilities:

• Support and maintenance of Oracle Databases and EBS. Applications on a 24*7 basis.
• I Installed, upgraded and configure all components of OBIEE 11.1.1.7
• I Created repository schema objects or metadata for running BI Applications as expected.
• Supported 24x7 mission critical applications which include different versions Oracle 11gR1/11gR2/12c, OBIEE11g.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
• Created Tablespaces as per the requirement of BI Applications -
• I have deployed/created managed servers: bi server1 and bi server2 on top of weblogic11g.
• Oracle BI and Weblogic11g administration.
• Creating security roles, group policy, user authentication and authorization for Active Directory setup in Weblogic11g.
• I have performed perfect patch analysis and documented the installing instructions for upgrade from OBIEE 11.1.1.9.160119
• Performed OBIEE upgrade from 11.1.1.7 to 11.1.1.9.160119 by applying patch 2239388 using Opatch utility.
• Setting up online daily application backup scheduled using Linux scripting.
• Performed Configuring connection for Datawarehouse Administration Console (DAC11g).
• Setting up disk space free up script for maintaining file system space.
• Executed DAC Migration from windows to AIX machines successfully.
• Performed DAC Email Notification Setup using DAC server management>DAC server setup.
• Performed table compression for wedw schema.
• Disabled Real application testing and datavault in 11.2.0.4 database using chopt utility to reduce cost of unused components that inadvertently comes up with Oracle installation.
• Upgradation of WebLogic servers in development, testing and production environment, applying patch and service packs.
• Performed Weblogic Server and managed server: Performance Tuning using Thread/Core Dump Analysis, after reviewing logs when Server crashed unevenly to find the root cause and identified the bottle necks due to JVM memory sizing and improved it with effective measures.
• Tuning JVM heap size to maximize the number of clients accessing the applications.
• Analyzing the Log Files, Thread Dumps, JVM Dumps, Exception Stack Traces.
• Extensive knowledge with Informatica 9.1.0 hot fix 2 used for extraction, transformation and loading from source definition to target definition into datawarehouse.
• Experience with Informatica 9.1.0 hotfix 2 of maintaining/recreating repository services for power center repository for the migration.
• Informatica9 Power Center Repository and Power Center Integration upgrade installing informatica 9.1.0 hotfix2.
• Enabling Archive log mode for 11g Db’s and maintaining the archive log files.
• Maintaining Monthly Metric reports of closed/opened and pending tickets/tasks and reviewing to maintain SLA.
• Upgraded Oracle test/QA and Production from 11.2.0.4 to 12.1.0.2

Environment: Oracle 9i/10g, OBIEE 11g OEM, SQL*plus, Imp/Exp, RMAN, SQL, PL/SQL, SQL*loader, tkprof, HP-UX 11.0, Windows 2000