Sr. Oracle Apps Dba & Big Data Engineer Resume
Dallas, TexaS
SUMMARY:
- I am a certified Sr. Oracle DBA/Apps DBA with almost 17 years of vigorous and robust ERP experience including various implementations, upgrades, migrations, integrations, advance configurations and techno - functional support on different projects in the Government and Private Sector companies of various businesses.
- 15 years of experience as an E-Business Architect and Apps DBA expertise.
- Worked on end-to-end lifecycle ERP implementations. Knowledge of OAF, AOL and BC4J Components AM, VO, EO and VL etc.
- 2 year of ORMB/ORMBA implementation and administration experience.
- 13 years of experience Oracle E-Business suite in its installation, administration and implementation on different platforms
- 2 years of experience as an Oracle Core DBA for SAP with sap basis admin.
- 14+ years of experience for Oracle Database RAC/Non RAC installations on different platforms like Redhat Linux, Oracle Linux, HP-Unix, Windows and Solaris
- 10+ years of experience in Oracle Discoverer and Developer Reporting.
- 1+ year of experience in Oracle OLAP Express Server and Sales Analyzer
- Experience in Oracle E-Business Suite 11.5.8, 11.5.9, 11.5.10, R12.0.6, R12.1.1, 12.1.3 and latest in 12.2.5, 12.2.6.
- Oracle Database 8i, 9i, 10g, 11gand 12c&RACsetup on Windows, Redhat Enterprise Linux AS 4/5/6/7 and HP-Unix PARISC 11.3. Solaris, IBM-Z
- Installation and configuration of Oracle E-Business suite with RAC DB and F5 Load Balancer.
- Big Data Hadoop, kafka administration and integrations experience with IBM IIDR CDC.
- Administration and management of Oracle E-Business suite which included patching using adpatch, adop, rapid cloning using adconfig, adpreclone.pl and adcfgclone.pl, schema password change using fndcpass, afpasswd. Using weblogic related txk scripts txkManageDBConnectionPool.pl, txkUpdateEBSDomain.pl etc. strings/adident for versions check. Application objects compilation and re-linking using adadmin etc.
- Weblogic with Oracle Discoverer 11gand also in Oracle E-Business suite 12.2.
- Regular monitoring and performance tuning for application& concurrent processes.
- Importing data into Oracle E-Business suite using application interfaces.
- Configuring Shared Storage Location and Raw Storage Devices and ASM.
- Installation and Configuration of Database and Enterprise Manager Grid Control(OEM 11g) and Enterprise Manager Cloud Control (EMCC) 12c.
- Configuration of Oracle Data Guard(including active and logical) for data replication on standby database
- Oracle Secure Backup for Tape Drive Backup Management
- Database Upgrade using DBUA and upgrade scripts. DB Modeling using ERwin
- Oracle Goldengate, OBIEE BI Publisher Installations and configurations.
- Managing migration from one operating system to another and non-oracle database to Oracle Database with the help of SQL Developer.
- Manipulating with Data using Export, Import, DataPump or SQL Loader utilities
- Non Oracle Databases experience e.g. MS SQL Server, Mongo DB, MySQL and DB2.
- Configuration of Oracle Database Vault and Audit Trail and audit on DDL, DML etc.
- Installation of RAC Database with OCFS, OCR and ASM
- Configured Oracle Internet Directory (OID) and using Single Sign on (SSO) feature.
- Performance Tuning using SQL Tuning Advisor, Statspack, ADDM and AWR report
- Adjust Initialization Parameters at Optimum level and gain maximum Hit Ratio
- Automating scheduled jobs like gather statistics, also at OS level like cron jobs
- Design and Implement of comprehensive Backup policy
- Configuration of Oracle database archiving policy using Oracle ILM.
- Configuration and usage of RMAN for complete and incremental backups
- Make Recovery Procedures for all scenarios
- Configure Oracle Gateway services to execute oracle queries on non-Oracle database
- Manage complete or partial recovery test through RMAN and SQL commands
- OLAP Express Server 6.3.4, Sales Analyzer 6.4.0 configuration/administration.
- I have expert level experience in Oracle E-Business suite implementation, installation, configuration, ad cloning, upgrade (11i to R12 and R12.1 to R12.2) and patching including 12.2 adop cycle and related issues. Started career from 11.5.8 release with more vast role than ever performed which includes complete Techno-Functional work with system and database admiration. Functional work included 3C, Chart of Account Definition, Currency and Calendar definitions to setup new set of books, Master configurations of complete financial mainly for GL, AP, AR, FA module and then CE bank statements BAI2 and other formats integrations and reconciliations and to the extent to bring final FSGs for balance sheets and profit and loss statements at end of year and period closing. Role was so diversified because of my IT and commerce educational combined backgrounds that the learning I did in my very first career experience is still beneficial to me. In technical work not only done complete Application and Database admiration but also handled all related matters like backup and recoveries, integrations. Also done Development in same role using mostly Oracle Developer for Customized Forms/Reports extensively. Besides Financial also provided expertise for order management, manufacturing and partially for HR modules.
- Excelled my 15+ years career mainly in E-Business and Oracle Databases with some other Oracle technologies. I had also served more than an years SAP Basis too which was mixed role with Oracle Database administration. Therefore I have versatile experience to work for 2 major ERP giant software solutions. I have extensive knowledge of CCM (including PCP), Conc. Programs, Conc. Requests, Workflows and Notification Mailer and related business events which has become one of my major expertise interest due to business knowledge. Even in recent project I highlighted events to Functional leads which were reported by business for false notification triggering to suppliers. Functional team was unable to catch triggering event until I caught its process.
- Facilitated with my expert level administration of Oracle Database and E-Business including advance configs: and security testing, DMZ configurations and port mappings for firewall exceptions and F5 Setups. Automated Clone and minimized switchover activities timing. Setup 12.2 DR which is different setup on Apps side than previous versions. Just helped EST team for comprehensive application security scanning specially for DMZ hosting using 3rd party tools Qualys with OS authentication. Besides this I have vast experience on Performance tuning with help of trace/tkprofs, SQL performance Analyzer, SQL Monitoring, SQL Tuning Advisor (EMCC) and Toad. Similarly expert level of experience in RMAN for over 15 years and for every type of scenario. Recently done Point in time Recoveries using RMan for special clone requirements and using DDBoost tape library channels. Linux, Unix, Solaris and Windows I have supported throughout my career. Most experience is on Linux and can do advance system admin tasks as well. On database side worked for every version include 12c CDBs, PDBs setups.
- Achieved target multiple times for advance configurations setup like for SOA, BPEL etc. Also done SOA suite setup and integration through dbc files as standalone application. Done setups for OBIEE and Hyperion. OBIEE over 7 years specially supporting for ETL data extraction from E-Business and configurations side. Used active standby to run batched ETLs. I am also working on Weblogic platform from at least last 5 years. Supported Discoverer, ODI and even custom forms/reports deployment and support over weblogic. It is now part of R12.2.
- I Also have vast experience on RAC environment setup and usage including ASM, managing ASM disk volumes and addition of space to ASM disk groups and knowledge of balancing operation. Latest used Infinity Band in Exadata RAC cluster with ExaLogic App deployment for interconnect communication to minimize GC RAC wait events and using cell smart scan cache. Also have chance to work on Golden data for replication.
- Experience in Hadoop Big Data integrations. I have unique skills in problem understanding and have an edge due to understanding of business operation and financial background and excellent understanding of financial double entry system. Also good in service enhancements and user friendly environment creation. I have good skills in writing and facts description and presentation. Similarly having excellent oral communication in a team and managing them to lead from front for delivery on time. It’s very important to communicate in team appropriately and timely.
- Apart of this I am very good in all office tools specially in excel. All credit to my Techno-Functional experience in which I used excel sheets for master data filtration and even for capturing configuration setup templates based on some macros and lookups. Used word and power point for documentation and presentations.
- I am usually good in every computer application which is in my use. Also I am a very good learner.
- A quick example is Oracle Express Server for OLAP with Oracle Sales and Financial Analyzers which uses OBIEE concept and is based on data cubes. I learned and supported these old technologies for Confidential ME on very short notice which they still use as MDWRAT system for their critical production quality related reports. I can learn and manage specially oracle based technology very quickly.
EXPERTISE IN:
Oracle Cloud
Oracle E - Business Suite 11i, R12.1, 12.2
Oracle DB 8i, 9i, 10g, 11g, and 12c, 18c
Big Data Hadoop, kafka eRwin and DDBMS
DB2, Mongo DB, SQL Server, MySQL Experience
10g,11g, 12c
Enterprise Manager
10g, 11g (EMGC), 12c and 13.2c (EMCC)
10g, 11g, 12c
Financials
Inventory and purchasing.
Oracle Express Server 6.3.4
Oracle Sales/Financial Analyzer 6.4.0
Redhat Linux AS
Oracle Linux
HP-Unix
Windows Server
AIX/Solaris
CHRONOLOGICAL SUMMARY OF EXPERIENCE:
Confidential, Dallas, Texas
Sr. Oracle Apps DBA & Big Data Engineer
Technology/Platform: Oracle ORMB/ORMBA 2.6.0.1.0, RHEL 7.3, OEM 12c, RDBMS 12c, OBIEE 12.2, ODI 12.1
Responsibilities:
- Achieved goal for setup/configuration of complete ORMB/ORMBA apps including Oracle Grid Infrastructure 12.2, Oracle RAC databases 12.2 for ORMB and 12.1 for ORMBA, Oracle Golden Gate 12.3, Oracle Data Integrator, Oracle Fusion Middleware, Oracle ORMB OUFA (Framework and app), ORMBA App and OBIEE for dashboard.
- Setup DB, ETL and Web components for application to work
- Generated and Deployed Golden Gate Groups from ETL app scripts.
- Setup and integrated Hadoop Big Data kafka integrations using IBM change data capture (CDC).
- Achieved goal to setup High Availability Architecture (HAA) with VIP for Golden Gate to failover to available node in RAC using X Agent (agctl) along with its monitoring mechanism.
- Achieved goal to setup latest Golden Gate 12.3 Management Pack for EMCC13cR2 to integrate monitoring plug-in for golden gate with help of JAgent and PMSRVR processes.
- Performed cloning of GoldConfig environment to UAT and then for Prod. GoldCfg was kept up to date with base common configs and with latest patchset and release updates from oracle. Ran post clone dmbs lock and inittran setup scripts on cloned schema.
- Monitoring and Tuning Application functional specially for custom objects and queries. Scheduled Gather stats on different oracle app schemas.
- Used ORMBA Admin gui to setup GG Replication Parameters and Initialization settings for initial load.
- Used ODI Studio for running initial load and monitoring load processes.
Confidential, Cleveland, Ohio
Sr. Oracle Apps DBA
Technology/Platform: Oracle E-Biz R12.1, 12.2, RHEL 6.7, OEM 12c, RDBMS 12c, OBIEE, SOA 12c, ExaData X3-X4/ExaLogic
Responsibilities:
- Achieved targets for MMS and SLM projects related to stores supply chain (order management) and regionally consolidated supplier hub (iSupplier) implementation.
- Worked on Oracle SAAS, PAAS cloud infrastructure support.
- Upgraded Oracle E-Business Suite to (R12.2.6) from R12.1.3 for trial runs. Planned 4 Regional upgrades including 9 languages support. 2 of regions e.g. Asia and Europe were upgraded to 12.2.5.
- Successfully architected solutions for MMS and SLM projects for various tasks. E.g. for MMS, old mainframe 40 years historical data was converted and loaded into E-Business suite and for SLM project supplier hub data flow integrated sync mechanism was developed.
- Performed patch analysis and checked the patch impact along with managing patch history. Applied patches (one-off, mini packs and psu) using adpatch in 12.1 and adop in 12.2.
- Configured Oracle Weblogic and Install SOA configurations integration with ERP.
- Perform Cloning of OBIEE BI Publisher and OTM from old environment to new environment. Also created a new schema in EBS with a new ETL layer batch jobs to fetch financial data from E-Business suite.
- Monitoring and Tuning Application functional mainly custom code from enterprise cloud control grid and specially after Mar17 on latest version 13.2.2.0 EMCC using sql tuning advisors and sql monitoring.
- Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, in memory database etc.
- 11g Database Upgrade/Support to 12c including CDB and PDBs for non-ebz customer databases.
- Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack, STATSPACK and E-Business management pack. Used latest 13C EMCC for this purpose.
- Gathered requirements for storage, kernel parameters, backup policies, space required for backup and performed capacity planning for building new application and database.
- Implemented performance tuning recommendations of all components in Exadata database machine.
- Oracle Fusion Middleware 11.1.1.9 management for domain and node cluster configuration and Few Custom Forms/Reports application deployment and Oracle Access Manager integration for SSO.
- Provided knowledge and experience in handling RAC databases using ASM issues and troubleshooting.
- Handling day to day requests, application & database security, helping application security scans using Qualys app, system administration, code migration requests etc.
- Coordination with different teams (server, storage etc) to plan for big upgrade which involved server, storage, apps, DB upgrade etc.
- Analyzing patches for Oracle applications and Oracle databases using patch analysis wizard from OAM.
- Applying Oracle Apps adop patches in development, SIT and QA instances and keeping track of them so that they are applied in all future instances of that release till production
- Deployed successfully configuration of Reverse proxy on external Tier with SOA integration and Server+Responsibility hierarchy management for iSupplier Portal module and related custom responsibilities.
Confidential, Milwaukee, Wisconsin
Sr. Oracle DBA
Technology/Platform: Oracle RDBMS 12c, HPUX, RHEL 6, OEM 12c
Responsibilities:
- Performed patch analysis, applied patches (one-off, bundle PSU patches) and checked the patch impact along with managing patch history.
- Installed Oracle Weblogic and Install BPEL, SOA Application configurations integration with ERP.
- Performed the fixing issue regarding weblogic BPEL, SOA etc.
- 11g Database Upgrade/Support to 12c.
- Worked for plugable databases in 12c for reducing maintenance and operation overhead.
- Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
- Scheduling RMAN backup of database using catalog DB and TDPO tape backup.
- Performed Data Centre Migration of Application and Databases.
- Gathered requirements for storage, kernel parameters, backup policies, space required for backup and performed capacity planning for building new application and database.
- Preparing status updates and regularly tracking project milestones and updating share point folders with project related documents.
- Configuring and managing Oracle Active Data Guard and logical standby for DSS.
- Building Pre-prod instances using Flashback Database Concept so that we can revert back to a past point-in time and delivered Pre-prod instances to client for testing purpose.
- Proactive monitoring of databases for table space sizes, monitoring database growth, setting system and object privileges, user logins and passwords.
- Oracle Fusion Middleware upgrade from 10g to 11.1.1.7 to be used by Few Custom applications and Oracle Access Manager for SSO.
- Have knowledge and experience in handling RAC databases using ASM and troubleshooting.
- Involved in backup and recovery using RMAN.
- Knowledge of regular database admin tasks like tablespace management, object level maintenance, oracle database patching, database upgrade and installation.
- Experienced in applying patches in R12 environment.
- Have expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency.
- Validating & Creating grants & synonyms on Application schemas, Performed jar file/forms generation as a post patch step, relinking the Oracle executables.
- Handling day to day requests, application & database security, System administration, code migration requests
- Database and application performance tuning.
- Coordination with different teams (server, storage etc) to plan for big upgrade which involved server, storage, apps, DB upgrade etc.
- Achieved target for aggressive pro-active maintenance for over 20 instances including oracle apps and core dbs.
- Analyzing patches for Oracle applications and Oracle databases.
- Applying Oracle Apps Patches in Development and Test Instances and keeping track of them so that they are applied in all future instances of that release till production
- Writing shell scripts for day to day work to automate activities.
Confidential, Omaha, NE
Sr.Oracle Apps DBA
Technology/Platform: Oracle Database10g, Oracle Database 11g,Oracle Applications 12.1.1, Toad, ASM, Oracle Enterprise Manager (OEM) Grid Control, RMAN, Red Hat Linux ES6., ExaData/ExaLogic
Responsibilities:
- Providing Support to Oracle R12.1.3E-business suite application.
- Worked on 10g, 11g databases, and R12.1.3 E-business suite applications.
- Maintaining, Monitoring and Administering for Oracle applications environment on RAC architecture
- Performed Multi Node installation of Oracle EBS R12.1.3
- Cloning the Oracle Applications R12 environment from Production to UAT, QA, DEV boxes.
- Handling database performance issues over Exadata/Exalogic.
- Set up Printers, Workflow mailer and Wallet in Oracle Applications R12.1.3 Prod, UAT,QA,DEV Environments
- Worked closely with Functional/Developers and helping them in fixing issues
- Applying latest patches from Oracle Support to the Test and Production Instances for resolving issues or Enhancing features.
- Cloning R12 ERP Instances from Production to Test, Development Instances and coordinate with Testing and Development Teams.
- Backups- Logical and Physical for Multiple Instances.
- Controlling and Monitoring of User Access to the Database including Granting and revoking of Privileges and Roles and Tablespace Quotas.
- Experience in Upgrading 11gR1 to 11gR2 and applied PSU including for security quarterly updates.
- Raising the Service Request and working with Oracle Team.
- Installed and configured 10g Discoverer on a Oracle Application environment.
- Installed Web ADI on the user’s desktops and fixed the Application Problems.
- Oracle Discoverer deployment with latest Fusion Middleware 11.1.1.7
- Created users, responsibilities, Menus, Functions and migrated them to remaining environments through FNDLOAD In Oracle Applications Environment.
- Scheduled the Rman Backup scripts in a cron job.
- Applied Patches for Developers Bug fixes and Scheduled Maintenance on Oracle Applications
- Implemented DR setup on the Oracle Applications R12 environment as per Client Standards.
- Oracle Applications Parallel Concurrent Processing Administration & tuning for R12 applications.
- Created Tablespaces with Oracle-Managed-Files (OMF)in ASM environment.
- Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
- Daily DBA activities as Performance Monitoring, Instance Health Check etc
- Working with FNDCPASS to change Passwords of APPLSYS,APPLSYSPUB and SYSADMIN
- Provided 24*7 Production support in Oracle Production Databases as well as Oracle Applications environments.
- Rapid Cloning R12 with hot Databases duplicate from Production to UAT, QA, DEV databases through rman.
Confidential, Chicago, Illinois
Sr. Oracle Apps DBA
Technology/Platform: Oracle E-Business Suite 12.1.3 up-gradation over Sun Solaris
Responsibilities:
- Upgrade of E-Business suite from 11.5.10 to 12.1.3 with all interfaces and with all latest patch sets in 76 hours.
- Administration, configuration and cloning of Oracle E-Business suite 12.1.3 with Oracle Database 11GR2 over Oracle Sun Solaris.
- Architect solution of integration for new departmental applications from FM-CHIPS Project and migrate old integrations to new hardware with upgrade of E-Business suite.
- Configured physical standby active dataguard in maximum performance read only mode for R12 DB for replication through archived log application at DR site.
- Configured re-sync with 20 minutes delay for application server replication at DR site.
- SSO integration in R12.1.3 E-Business suite to comply with logon standard and create ease for end users.
- Cloning of production environment on Sapphire, Jade, Ruby and Emerald staging servers for R12. Each server having 4 nodes each. 1 DB and 3 Apps clustered nodes with PCP.
- OBIEE BI Publisher 11.2 Installation and configuration.
- Patching of oracle application using “adadmin” and “adpatch” and database using OPatch. Applying One-Off and Security patches. Merging patches from Patch wizard using OAM and then applying them.
- Tuning and optimizing oracle application database parameters for maximum users load capacity and configuring hardware load balancing for application.
- Write shell scripts and setup database/application backup and some scheduled activities.
- Oracle E-business application system administration activities using FND utilities like FNDCPASS, FNLOAD etc especially before and after cloning activity.
- Upgrade of Enterprise Manager Grid Control (OEM) to 11.1 and registering all DB and Fusion Middleware targets using central agent deployment and pushing new agents to all servers.
Confidential, Northfield, Illinois
Sr. Oracle Apps DBA
Technology/Platform: Oracle E-Business Suite 12.1.3 over OVM, Extracts based Up-gradation from 11i, Discoverer and XML Publisher setups.
Responsibilities:
- Administration, configuration and cloning of Oracle E-Business suite 12.1.3 with Oracle Database 11GR2 over Oracle virtual machine (OVM) and OCFS with Oracle Linux on blade servers.
- Extraction of data from legacy 11i environment and create its change in change management system Serina to deploy across all system landscape environments and moving to Production environment with approval of authorizing stake holders.
- RMAN configuration and its testing and integration with Comvalut library for new environment tape backups.
- Configured physical standby dataguard in maximum performance mode for R12 DB for replication through archived log application at DR site.
- Configured re-sync with 20 minutes delay for application server replication at DR site.
- Cloning of production environment on Dev, Sup, TST and UAT servers for R12. Each server having 4 nodes each. 1 DB and 3 Apps node with 1 CCM and 2 WEB Tiers.
- Patching of oracle application using “adadmin” and “adpatch” and database using OPatch. Applying One-Off and Security patches. Merging patches from Patch wizard using OAM and then applying them.
- Tuning and optimizing oracle application database parameters for maximum users load capacity and configuring OC4J and Forms load balancing at application level for WEB Tiers.
- Write shell scripts and setup database/application backup and some scheduled activities.
- Installation and configuration of Oracle Goldengate 11.2.1.0.20 for real time fast replication
- Oracle E-business application system administration activities using FND utilities like FNDCPASS, FNLOAD etc especially before and after cloning activity.
- Installation of Enterprise Manager Grid Control (OEM) 11.1 and registering all DB and Middleware targets using agents
- Oracle Fusion Middleware hosting support for Discoverer and SSO.
- Incorporating Master data and legacy system data in database through populating interface tables in application and importing them.
- Activating audit trail and making triggers specific triggers on objects for tracking specially for DDLs.
- Configuration of Database vault and controlling user roles to respective authorizations for security.
- Scheduling DBA admin jobs from system admin responsibility e.g. (Purge alerts and logs, purge concurrent requests and logs, Gather schema statistics etc)
- Configuration of XML Publisher component/module and used license manager to add advance collections.
- Configuration of Oracle Discoverer and defining its EUL layer for integration with E-Business suite to get flexible real time reports.
- Defining https (Hyper Text Transfer Protocol Secure) in context of E-Business Application server with SSL terminator for secured access.
- Defining workflow setup and using workflow builder to configure specific roles assignment for attributes of workflows for authorizing them to fire on particular events under specific role.
Confidential, Aliso Viejo, CA
Sr. Oracle DBA/Apps DBA
Technology/Platform: Oracle E-Business Suite 12.1.1 installation over RAC and migration of data, Discoverer and XML Publisher setups.
Responsibilities:
- Installation and administration of Oracle E-Business suite 12.1.1 with Oracle Database 11G RAC using Oracle Clusterware File System (OCFS) and Oracle Cluster Ready (OCR) with Automatic Storage Management (ASM) on new servers environment.
- Extraction of balances from chart of accounts of old release 11i (11.5.8) running on old servers.
- Import and data load into new environment and posting that data to verify accounts for testing.
- Cutoff and reimport of data again in between test run and cutoff date to make new environment up to date for go live.
- Comprehensive Backup policy with RMAN configuration and its testing with data protector library integration for new environment.
- Configured DataGuard for R12 physical standby server replication through archived log application at DR site.
- Configured re-sync for application server replication at DR site.
- Cloning of production environment on Dev and QA servers for R12.
- Oracle Single Sign On SSO upgrade and Integration in E-Business suite 12.1.1.
- Patching and cloning of the oracle application and database.
- Tuning and optimizing oracle application database parameters for users load.
- Write shell scripts and setup database/application backup.
- Oracle E-business application system administration activities using FND utilities like FNDCPASS, FNLOAD etc.
- Installation of Enterprise Manager Grid Control (OEM) 10.2.0.5 and registering targets after installation of agents
- Incorporating Master data and legacy system data in database through populating interface tables in application and importing them
- Activating audit trail and making triggers for tracking record for specific DDL statements for reports supporting annual audit queries.
- Configuration of Database vault and restricting roles for security
- Scheduling DBA admin jobs from system admin responsibility e.g. (Purge alerts and logs, purge concurrent requests and logs, Gather schema statistics etc)
- Patching application using “adadmin” and “adpatch” and fixing XLA accounting issue. Also applied upgrade patchset for XLA
- Configuration of XML Publisher component/module and using license manager to use it in XML based reports.
- Configuration of Oracle Discoverer and defining its EUL layer for integration with E-Business suite to get flexible real time reports.
- Defining https (Hyper Text Transfer Protocol Secure) in context of E-Business Application server with SSL terminator for secured access
- Provide 24/7 support for successful business running
Confidential, Atlanta, GA
Sr. Oracle DBA/Apps DBA
Technology/Platform: Oracle E-Business Suite Upgrade to 12.0.4 over RAC with Application cluster
Responsibilities:
- Provided DBA support for Upgrade of Oracle Financials, Human Resources and Payroll
- Provide maintenance, patching and general DBA functions for the production, development and testing instances: Patching, Cloning, Tuning, Backup & Recovery.
- SYSADMIN activities for Upgrade of E-Business Suite releases from 11.5.10 to R12.0.4 on HP UX 11.2.
- Configuration of E-Business with F5 Big-IP type load balanced application servers.
- Troubleshoot and execute solutions to database issues & middle tier issues.
- OBIEE BI Publisher configuration and creating ETL layer to run fetch data from E-Business suite at night.
- Plan and conduct unit, system, acceptance, integration, and performance testing.
- Lead cross functional teams in resolution of performance problems and tuned database for best performance.
- Using AD utilities like admrgpch to merge the patches and apply them.
- Configured Dot-Matrix Printers with Oracle Applications.
- Proactively monitored the applications and database through shell script alerts.
- Cloned Instances from Production whenever required for testing or development.
- Used FNDLOAD for responsibility, menu, value sets and profile migration.
- Write scripts for assigning users with new responsibilities and change profile values.
- Upgraded the E-Business suite database from 10.2.0.2 to 10.2.0.4.
- UAT and successful changeover to upgraded database.
- Used DBV (DB verify) utility to check corruption in database data files before upgrade.
- Space Management - Re organized and restructured tablespaces and data files across SAN to divide IO.
- Managing and Monitoring Concurrent Jobs, Concurrent Managers and Application Users.
- Creating heterogeneous database link in Oracle database to integrate it with other applications.
- Configure and use Oracle Gateway for running non-Oracle queries in our database to comply requirements of other applications.
- Installation and configuration of Oracle Goldengate 11.1.1 for real time replication of large database streams.
- Involved in disaster recovery planning and implemented database backups and disaster recovery strategies using RMAN and data guard.
- Configure RMAN for integration with differential incremental backup policy. Also to check block corruption.
- Configure backup retention time in RMAN and checking periodically obsolete and expired backups to delete.
- Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
- Install Oracle enterprise manager (OEM) with its repository using emctl utility.
- Encrypting stored data for privacy and security which is crucial for media companies.
- Implementing network and domain security by customizing sqlnet.ora and allowing specific domain and IPs only for connectivity.
- Successfully implemented physical standby database using OracleData Guard feature for High availability configuration.
- Troubleshoot Database performance issues using Automated WorkloadRepository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
- UNIX Shell scripting for backup and monitoring of databases.
- Worked as 24x7 production support DBA and supported on holidays, weekends and beyond regular hours
- Implemented DataGuard for DR site and Oracle Gateway for integration of ERP database with other applications
Confidential, NYC, NY
Sr. Oracle DBA
Technology/Platform: Oracle Database Server Upgrade with Load Balanced Application
Responsibilities:
- Device a strategy for Database upgrade and make a replicated environment before upgrade.
- Used DBV (DB verify) utility to check corruption in database data files before upgrade.
- Step by step patch set upgrade of Oracle Database from 9i to 10g then to 11g on Redhat Linux AS5 with OS clusters using DBUA.
- Run pre upgrade checking and post upgrade scripts for this process.
- New DB deployment after database modeling and design using Erwin.
- Restructuring large number of extents objects and their size and partitioned them horizontally according to data accessibility requirement.
- Integration of database with F5 Big-IP type load balanced application servers.
- Backup policy management and Oracle secure backup configuration for tape backups.
- Taking logical backups by datapump and replicating in DEV environment for quick replication of Database.
- Install Oracle enterprise manager (OEM) with its repository using emctl utility.
- Configure RMAN for integration with differential incremental backup policy. Also to check block corruption.
- Configure backup retention time in RMAN and checking periodically obsolete and expired backups to delete.
- UAT and successful changeover to new platform and upgraded database.
- Encrypting stored data for privacy and security which is crucial for media companies.
- Implementing network and domain security by customizing sqlnet.ora and allowing specific domain and IPs only for connectivity.
- Performance tuning using SQL Tuning Advisor, modified execution plan, SQL/PLSQL joins modifications and using hints to use custom indexes.
- Creating heterogeneous database link in Oracle database to integrate it with other applications.
- Configure and use Oracle Gateway for running Oracle queries in our application to get data from non Oracle database.
Confidential
E-Business suite Implementation and Level 1 Support
Technology/Platform: Oracle E-Business Suite R11.5.10.2 over Oracle database 10gR2 RAC
Responsibilities:
- Oracle E-Business suite administration and post implementation complete support including Level1 support
- Administration of Oracle database 10gR2 RAC over Redhat Linux clusters
- Managing Oracle cluster ready service CRS for RAC (e.g. init.crs start/stop etc)
- Using srvctl utility for clustered database services management
- Changed backup policy and introduced incremental level1 backup due to 24*7 operation and high capacity 1.4 TB database
- Configuration of Oracle internet directory services (OID) and Single Sign On (SSO) feature for all supported Oracle products. Also integrated the oracle support in it.
- Dataguard physical standby configuration with dataguard broker for controlling switchover for Disaster recovery server at DR site. User dgmgrl utility for controlling broker
- Common APPL TOP shared on SAN for
- Cloning of production RAC database on test without RAC
- Patching ERP application which was divided on different application servers in term of shared application tops and RAC based database
- Performance Tuning specifically of data warehousing queries used by Oracle BI integration with E-Business suite
Confidential
Sr. Oracle Techno Functional Engineer
Technology/Platform: Oracle E-Business Suite R11 over Redhat Linux AS
Responsibilities:
- Upgrade of Oracle database and Oracle E-Business suite from 11.5.9 to R11.5.10
- Tuning of their Oracle database which was around 1 TB. Also configured Oracle Data Guard solution for them. I have also done configuration for HP tape library (data protector) to Integrate with Oracle database for online rman backup on tapes
- Handling with Oracle support and fixing issues
- Mapping of 11.5.9 release structure to 11.5.10 for Discrete Manufacturing merger process with OPM manufacturing. ( Here I would like to highlight one thing that after we have done this process successfully Oracle told us that this was the first major project for new R12 manufacturing merger scenario in all over the world )
- Support for Oracle Financials (AP, AR, GL, CE and FA), Purchasing & Inventory and Human Resource.
- Oracle Developer 6i for custom reports and forms development and did integrations into ERP.
- Set of Books deployment including Chart of Account, Currency and Calendar setups.
- Master data management in Subledgers and opening balances into GL. Matching balances before go live.
- Did interfacing of other apps with ERP interfaces to import data into ERP and post their financial accounts.
- Did different types of AP and AR invoices, payments and receipts support including adjustments and prepayments and miscellaneous receipts.
- Created FSGs for PnL, Balance sheet and other COA based reports. Also did Intercompany accounts balancing/transfers.
- Create customized Financial and inventory repots and used HR module to maintain employees data and generate monthly payroll out of it.
- Customizations of Forms/Libraries/Report using Oracle Application Development Framework ADF.
- Did XML publisher based reports, ADI (application desktop integrator) usage and Discoverer reports also.
- Achieved goal of system admin and application developer responsibilities within E-Business suite.
- Setup configurations for Budgeting in GL and used that to control expenses in various domains.
- Financial accounting engine XLA performance and abnormal growth issues resolution
- Cut off old system and change over to new platform and E-Business application
Confidential
Sr. Oracle DBA/Apps DBA
Technology/Platform: Oracle OLAP and Oracle Database, Express Server, Window Server, OSA,OFA
Responsibilities:
- Oracle database9i/10g installation and cloning
- Installation of OLAP and other Oracle products e.g. Oracle Developer based customized application, Oracle Database, Oracle Express Server and Oracle Sales Analyzer
- Restructuring/Redesigning using star modeling technique for new MDWRAT database using Erwin.
- Modification, debugging and upgrade of their custom MDWRAT application (Manufacturing Data mart Warehousing) which they have been using for business intelligence reporting and production planning and control system
- For its support i have visited at various sites like Dubai, Jordan, Saudi Arabia and Egypt and Lebanon are in queue
- Upgrade of this custom application to Oracle Developer 10g and Oracle Database 10g and make it web enabled centrally deployed and used for all bottlers in the region