PROFESSIONAL SUMMARY:

• 13+ years of experience as an Apps DBA consultant
• Worked on 8 end - to-end lifecycle ERP implementations in Oracle DB
• 11+ years of experience Oracle E-Business suite in its installation, administration and implementation on different platforms
• 3+ years of experience as an Oracle Core DBA for SAP.
• 5+ years of experience for Oracle Database RAC/Non RAC installations on different platforms like Redhat Linux, Oracle Linux, HP-Unix, Windows and Solaris
• 7+ 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, 12.2.2.
• Oracle Database 8i, 9i, 10g, 11g and 12c & RAC setup 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 Load Blncr.
• Customized payroll module setup and integration in Oracle E-Business suite
• Administration and management of Oracle E-Business suite which included patching using adpatch, rapid cloning using adpreclone.pl and adcfgclone.pl, schema password change using fndcpass, files version identification using adident, administration, compilation and re-linking application objects using adadmin etc.
• Oracle Discoverer 11g setup in Web logic, integrated in Oracle E-Business suite.
• 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 Upgradation 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 SQLDeveloper.
• Manipulating with Data using Export, Import, Data Pump or SQL Loader utilities
• Managing logical and physical storage structure e.g.(Datafiles, Tablespaces, Extents)
• 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.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. OracleAppsDBA

Responsibilities:

• Performed patch analysis, applied patches (one-off, mini packs, developer 6i patches) and checked the patch impact along with managing patch history.
• UpgradedOracleE-Business Suite to (R 12.2.2.4.0 ) from R12.1.3. Effectively resolved the issues encountered during the migration activity.
• InstalledOracleWeblogic and InstallBPEL,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.
• Performed the fixingissue regarding weblogic, OBIEE, BPEL,SOA,OTM 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,spacerequired 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 managingOracleActive 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.
• Provided hypercare support after successful Go-Live.
• 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 Discoverer and Few Custom Forms/Reports application 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, objectlevel maintenance,oracledatabase patching, database upgrade and installation.
• Experiencedin 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 onAppsschema, Performed jar file/forms generation as a post patch step, relinking theOracleappsprograms.
• Worked in 24x7DBAsupport environment providing off hours support, Scheduled job execution, planning and emergency maintenance handling
• Handling day to day requests, application & database security, System administration, code migration requests
• Database and application performance tuning including use of OBIEE Performance Pack. Well experienced in OEM/OMCC monitoring.
• Worked on automating repetitive tasks, documenting and maintaining knowledge repository for issues and best practices.
• Coordination with different teams (server, storage etc) to plan for big upgrade which involved server, storage,apps,DB upgrade etc.
• Managed over 20instances, which included bothoracleappsand other applications.
• Analyzing patches forOracleapplications andOracledatabases.
• ApplyingOracleAppsPatches in Development and Test Instances and keeping track of them so that they are applied in all future instances of that release till production
• Writingshell scripts for day to day work to automate activities.

Confidential: Omaha,NE

Sr.OracleAppsDBA

Environment: OracleDatabase10g,OracleDatabase 11g,OracleApplications 12.1.1, Toad, DBartisian, MobaXterm, ASM,OracleEnterprise Manager (OEM) GridControl, RMAN, Red Hat Linux ES6.

Responsibilities:

• Providing Support toOracleR12.1.3 E-business suite application.
• Worked on 10g, 11g databases,and R12.1.3E-business suite applications.
• Maintaining, Monitoring and Administering forOracleapplications environmenton RAC architecture
• Performed Multi Node installation ofOracleEBS R12.1.3
• Cloning theOracleApplications R12 environment from Production to UAT, QA, DEV boxes.
• Setup the RAC one node.
• Set up Printers,Workflow mailer and Wallet inOracleApplications R12.1.3 Prod, UAT,QA,DEV Environments
• Workedclosely with Functional/Developers and helping them in fixing issues
• Applying latest patches fromOracleSupport 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 updatess.
• Raising the Service Request and working withOracleTeam.
• Installed and configured 10g Discoverer onaOracleApplicationenvironment.
• 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 InOracleApplications Environment.
• Scheduled the Rman Backupscripts in a cron job.
• Applied Patches for Developers Bug fixes and ScheduledMaintenanceonOracleApplications
• Implemented DR setup on theOracleApplications R12 environment as per Client Standards.
• OracleApplications Parallel Concurrent Processing Administration & tuning for R12 applications.
• Created OMF managed Tablespaceson ASM environment.
• Done Full Exports and Imports of the database at schema as well as tablespace level for different customers.
• Performed the Restore ofOracle11g databases on a two node RAC environment.
• Install, configure and write scripts for RMAN
• DailyDBAactivities as Performance Monitoring, Instance Health Check etc
• Working with FNDCPASS to change Passwords of APPLSYS,APPLSYSPUB and SYSADMIN
• Provided 24*7Production supportinOracleProductionDatabasesas well asOracleApplicationsenvironments.
• Rapid Cloning R12 with hot Databases duplicate from Production to UAT, QA, DEV databases through rman.

Confidential, Illinois.

Sr. Oracle Apps DBA

Environment: Oracle E-Business Suite 12.1.3 upgradation over Sun Solaris

Responsibilities:

• Upgradation of E-Business suite from 11. .1.3 with all interfaces and with all latest patchsets in 76 hours.
• Administration, configuration and cloning of Oracle E-Business suite 12.1.3 with Oracle Database 11GR2 over Oracle Sun Solaris.
• 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.
• Upgradation 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

Environment: 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

Environment: 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 Upgradation 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.
• Periodically testing Recovery procedures.
• 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

Sr. Oracle DBA/Apps DBA

Environment: Oracle E-Business Suite Upgradation to 12.0.4 over RAC and Install & Configure Application cluster

Responsibilities:

• Provided DBA support for Upgradation 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 Upgradation of E-Business Suite releases from 11. .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.
• Configured the system to view the invoices in a PDF Format.
• Oracle Application Development Framework ADF support.
• 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 Oracle Data Guard feature for High availability configuration.
• Troubleshoot Database performance issues using Automated Workload Repository (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

Sr. Oracle DBA

Environment: Oracle Database Server Upgradation 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 upgradation 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.
• Archived old data and maintained its history for .
• 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.
• Granting sysdba and dba role and controlling dba accessibility for management.
• 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

Sr. Oracle DBA/Apps DBA

Environment: 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
• Upgradation of Oracle database and patching application
• Upgradation of 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)
• Customizations of Forms/Libraries/Report using Oracle Application Development Framework ADF.
• 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

Environment: Oracle OLAP and Oracle Database over Window Server across different GCC and African Countries

Responsibilities:

• Oracle database 9i/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 upgradation 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
• Upgradation 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
• Oracle E-Business Suite Upgrade and Patching
• Oracle Database Administration
• New backup policy implementation which includes configuration of RMan and daily Incremental backup restoration for “Day End” Standby server”
• New configuration for Oracle E-Business Suite for Data Guard and making a physical standby server
• Performance Tuning their existing Core Oracle Database for their main custom application
• Installation and Configuration of Oracle Enterprise Manager Grid Control (OEM) and administering All Oracle Servers (apps + Oracle database) though it. Not only oracle servers but also exchange and sql server machines management with special management add-in packs
• Provided implementation and post implementation support on various Oracle Products

Confidential

Sr. Oracle DBA/Apps DBA

Environment: Oracle Database 10gR1 RAC over HP-Unix Service Guard clusters with Raqmiyat Custom built ERP application called GEMS

Responsibilities:

• Recovery of Oracle database after it was crashed due to corruption
• Major restructuring and performance tuning of Oracle database due to huge volume of billing every month
• Backup policy configuration
• Upgradation of Oracle database from 9i to 10g
• Reinstallation of E-Business suite with Oracle Database 10gR1 over HP Unix clusters
• Besides this restructuring of logical tablespaces to distribute data evenly across the storage areas was also part of my job
• Installation of E-Business suite with Oracle Database 10gR1 over HP Unix clusters
• Configured application server to be used with load balancing environment
• Configured enterprise manager for database management (OEM)
• Made a comprehensive backup policy and automated their backup
• I also provided to their technical team about Oracle database concepts and specially for administering oracle database over HP-Unix environment
• Providing maintenance and Level 1 support to client on call basis

Confidential

Sr. Oracle DBA/Apps DBA and Network Support

Environment: Oracle Database 10g RAC on HP-Unix Itanium architecture for ERP Implementation in SAP

Responsibilities:

• Service Guard clusters installation and configuration on HP-Unix environment
• Oracle Database 10g RAC installation over service guard
• Oracle Data Guard configuration
• BRTool configuration and usage
• SAP Basis Database administration role (tcode DB13 etc).
• Migration of database from SQL Server to Oracle using SQL Developer for Billing and Customer Care BnCC application database.
• Integration of BnCC into MySAP ERP suite in FICO (receivable subledger) with and scheduled batch jobs to post real time transactional effect of all receiables.
• Migration of almost 3000 customized procedures and packages of Billing and Customer Care BnCC application from sql server to oracle mainly using sql developer and then changing lot of procedures/packages for final changes to make it operational.
• Maintaining integrity and functionality of application while keep it running to get revenue source active
• Migrating/changing of native SQL server functions into oracle standards. Some time recoding required source
• HP-Unix Operating System administration responsible for administration of Oracle database (Oracle 10g) which includes scheduled online and offline backups dump and alert log monitoring, tuning for maximum Oracle database performance.

Confidential

Sr. Oracle DBA/Apps DBA and ERP Application Admin

Environment: ERP Oracle E-Business suite 11.5.8 implementation and upgraded to 11.5.9 on Redhat Linux AS 4

Responsibilities:

• Oracle Database 9i R2 administration.
• Oracle E-Business Suite 11.5.8 installation, configuration and administration.
• Upgraded E-Business suite to 11.5.9.
• Functional Expertise in Oracle Financials, Purchasing & Inventory and Order Management and Human Resource.
• Oracle Developer 6i for custom reports and forms development.
• Tape backup configuration and scheduling it in cron job.
• Oracle Discoverer configuration for dynamic reporting requirement from management.
• Patching application.
• Red Hat Linux Advance Server administration.