Sr. Oracle Applications Dba Resume
BostoN
SUMMARY
- More than 10 years experience in Oracle APPS DBA, Oracle DBA and Fusion Middle - Tier which includes Oracle E-Biz Suite Implementation, Upgrade, Fusion Middle tier Implementation and Configuration, Oracle RDBMS Upgrade, Cross Platform Migration, Exadata Migration, RAC implementation, Operations management.
- Able to direct multiple tasks effectively and guide team operations and internal and external technology resources to realize on-time deliverables and production goals.
- Designed complex Architectures for Confidential - Europe, Stryker, IR BobCat(Doosan), Carlson, Ingersoll Rand, Dairy Gold - Ireland, Confidential, State Street
- Managing the DBA team for deployments of Coding, Cloning, Refreshing, Patching, Backups, restore etc.
- Strong record of success in managing and delivering IT projects on agreed time lines, to support development goals, policies, and operating procedures.
- Coordinated Configuration and Change Management with various teams
- Maintain team documentation including Standard Operational procedures, Run books, Knowledge Base
- Operations support on Managed Services model (24*7), encompassing onsite & offsite planning, requirement analysis
- Worked on implementing high-level release management strategies and system strategies
- Implemented ITIL V3 and ISO Policies and Processes
- Executed projects involving mission critical production systems, Product upgrades, Integrations, Datacenter and Platform migrations.
- A keen planner, strategist & implementer with expertise in managing global delivery frameworks and new technology implementation projects for streamlining related activities within time & cost parameters as per processes like Agile etc
- Efficient in mapping business requirements by interacting with business managers / vendors / multinational clients / consultants & other multiple stakeholders.
- An effective leader with distinguished abilities in recruiting, training & mentoring large multi-functional teams across different time zones to maintain deliverables as per SLA.
- Designed complex Architectures for State Street, Confidential, Confidential - Europe, Dairy Gold - Ireland, Stryker, IR BobCat (Doosan), Carlson, Ingersoll Rand etc.
- Experience on Oracle E-Business Suite upgrade from 11.5.10.2 > R12.2.4, 11.5.10.2 > 12.1.3, 11.0.3 > 11.5.9, 11.5.4 > 11.5.8, 11.5.8 > 11.5.9
- Installation and implementation of Oracle E-Business Suite 12.2.4, 12.2.3, 12.1.3, 12.1.2, 12.0.6, 11.5.10.2, 11.5.9 etc..
- Installation and upgrade of Oracle RDBMS upgrade from 10g to 11g, 9i to 10g, 8i to 9i, 8.0.3 to 8.0.6 etc.
- Installation and Configuration of n Oracle Fusion middleware like Weblogic 11g and 12c, SOA and integration with oracle E-Business Suite
- Cross platform migration from Solaris to Linux, HP-Unix to Linux and Confidential -AIX to Linux
- Knowledge of Server Tuning, Database Tuning, SQL Tuning, Application performance monitor
- Knowledge of UTF8 Character set migration using DMU and csmig tool and OATM migration
- Installation of Oracle Applications 11i/R12 through rapidwiz, ASM and Data Guard configuration and maintenance of Oracle 11i/R12 Applications, Cloning, Patching, Upgrade, Language installation.
- Worked as DBA on diverse platforms on Oracle Databases covering HP-UNIX, Confidential AIX, SUN Solaris, Linux etc
- Implemented high availability solutions, including Clustering, Active Data Guard, and Replication using Dell Shareplex and Oracle Streams etc.
- Familiarity with Oracle Advanced Supply Chain, Financials, Demantra, iSupplier/iProcurement, OBIEE, RMAN, SSO, OID, RAC, ASM, high availability setups for CMs, DB & Apps tier.
- Reorg of tables, indexes and tablespaces
- Very well versed in Oracle Applications Utilities like AD Administration, AD Controller, Autoconfig, AD Merge Patch, AD Relink, AD Splice, ADOP (AD online patching) etc.
- Knowledge in SSO and OID implementation and integration with Oracle E-Business Suite.
- Installation of Discoverer and integrating with Oracle application, upgrade from discover4i to 10g.
- Oracle E-Business Suite integration with Sabrix, HR Global, SOA/BPEL
- Setup of Oracle i-Expenses, i-Portal, i-Supplier and DMZ (SSL) using reverse proxy
- High Availability Configurations like Clustering and Hardware Load Balancers like Big IP
- Datacenter migration, life cycle of servers,
- Expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency.
- Managing backups of the apps instances & maintaining weekly cold backups of database of dev/test and involved in recovery of database.
- Well conversant with tools like Dell Shareplex, HP-Mercury (Kintana), Remedy etc.
TECHNICAL SKILLS
Operating System: Red Hat Linux, Solaris, Confidential AIX, HP Unix, Ms-Windows
Oracle E-Business Suite: 12.2.4,R12,11i, 11.0.3 etc.
Middle tier: Oracle Weblogic, SOA, OBIEE, OAM, IDM,JMS,JTS, Golden Gate etc.
RDBMS: Oracle 12c,11g,10g,9i,8i,8,7, Microsoft SQL Server
Big Data: - Hadoop, Exadata
No SQL DB: Cassandra
Languages: Sql, pl/sql, Java
Other Tools: Toad, X - Manager, OSWatcher, OEM, Kintana (HP-Mercury), APEX, Dell Shareplex etc.
Ticketing System: Remedy, JIRA, i-Service, DMS, ISM etc
PROFESSIONAL EXPERIENCE
Confidential, Boston
Lead Oracle Apps DBA/ Lead Oracle DBA
Responsibilities:
- Participate in the development and maintenance of an Enterprise Application Architecture as it relates to the Oracle Financials databases
- Designing complex Architectures for their R12 Migration and Upgrade project
- Taking care of Server, DB and application related performance and tuning the SQL queries
- Designing the complex build sheet for DB and application server
- Implementation of DMZ node for i-Supplier and i-Procurement
- Implementation and support of OTL, OBIEE, OAM,IDM, GRC etc
- Implementation and support of NDM and Kofax, Markview
Confidential, Boston
Principal Consultant
Responsibilities:
- Designed complex Architectures for their R12 Upgrade project
- Upgrade of Oracle RDBMS from 9.2.0.8 to 11.2.0.4
- Upgrade of E-Business Suite application from 11.5.10.2 to 12.2.4
- Tuned weblogic application memory and configured the DB parameter for better performance
- Documented AD online patching procedure for day to day operations support
- Implementation of TDE, OAM,IDM, OBIEE, Weblogic etc
Confidential, San Jose
Sr. Technical Architect
Responsibilities:
- Standardization of Infrastructure like Directory structure, OS user naming, DB naming standards, DB file naming, ASM naming standards, DB file size standards etc.
- Implementation of DB and application security setup using SOX, DB link Governance, RDAC as per Cisco standard
- Implementation and setup of Oracle DBaaS (Oracle Cloud) for Schema registration, ownership and capacity planning using eStore and DART tools as per Cisco
- Implementation of setup of HP Mercury (Kintana) for Code migration and deployment etc.
- Implementation DB and application backup procedure as per Organization standard using Oracle RMAN, OSSV backup using Veritas, EMC Snap backup etc.
- Migration of DB and application from Dell servers to Cisco UCS as per Organization standards
- SSL setup for i-Expenses and Verisign certificate implementation for data encryption using OWM tool.
Confidential, San Jose
Sr. Oracle Apps DBA
Responsibilities:
- Migration of Oracle RDBMS 10g (DB Size 10 TB) from Sun Solaris to Cisco UCS with zero downtime using Dell Shareplex.
- Migration data using XTTS method from Solaris and Cisco UCS and filesystem to ASM
- Setup and configuration RMAN, EMC VM backup, 12C OEM, Cisco EMAN, Splunk
- RDBMS upgrade from 10.2.0.5 to 11.2.0.3.
- Taken care of RDBMS Tuning parameters for better performance
- Implementation and support for Weblogic, SOA etc
Confidential
Sr. Oracle Apps DBA
Responsibilities:
- Migration of Oracle RDBMS 11g (DB Size 10 TB) from Dell Server to Oracle Exadata X3 Server with zero downtime using Data Guard.
- Setup and configuration RMAN, 12C OEM
- Completed patching on RDBMS,GRID, Exadata Cell using opatch and patchmgr tool etc
- Installation and Configuration Golden Gate for Data replication
Confidential, San Jose
Principal Consultant
Responsibilities:
- Installation and configuration 11.2.0.3 GRID, ASM
- Copy the data from RAW volumes to ASM using RMAN duplication
- Converting database from 2 nodes to 4 node RAC with MVDC architecture (High availability)
- Migration of application R12.1.3 code tree from 32 bit to 64 Bit on Cisco Linux
Confidential, San Jose
Principal Consultant
Responsibilities:
- DB upgrade from 9.2.0.8 to 11.2.0.3 and Cross platform migration from Solaris to Cisco UCS
- Installation and configuration of 11.2.0.3 GRID setup. OATM Migration, charter set migration
- Application(E-Business Suite) upgrade from 11.5.8 => 12.1.1 => 12.1.3.
- Setup and configuration of i-Supplier externalization, i-Store externalization.
- Installation and Configuration Golden Gate for Data replication
- OID and SSO implementation and integration with E-Biz suite application.
Confidential, San Jose
Consultant
Responsibilities:
- E-Business Suite upgrade from 12.0.6 to 12.1.1 => 12.1.3
- Setup and configuration of i-Supplier externalization.
- OID and SSO implementation and integration with E-Biz suite application.
- SSL setup for i-Expenses and Verisign certificate using oracle OWM tool
Confidential, San Jose
Consultant
Responsibilities:
- RDBMS upgrade from 10.2.0.4 to 11.2.0.2.
- Installed and configuration of 11.2.0.2 RAC and RDBMS code tree setup.
- Cross platform migration of DB from HP-Itanium to Linux using XTTS.
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Installed and configured R12 E-Business Suite (12.1.1) with RDBMS 11.1.0.7.
- Modules included HRMS, AP,AR,GL,INV,OR,PA etc.
- Upgrade total E-Business Suite from 12.1.1 to 12.1.2. on Confidential AIX
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Design the complex architect for E-Business Suite upgrade
- Upgrade of DB from 10.2.0.4 > 11.1.0.6 > 11.1..07 on Sun Solaris 2.8
- Upgrade of E-Business Suite from 11.5.10.2 to 12.1.1 on Sun Solaris
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Upgraded Project for Portal from 10.1.2.2.0 to 10.1.2.3.0.
- Installation and configuration of middle tier components like Weblogic, SOA, BPEL, OBIEE etc.
- Documentation of shutdown and startup process of of Web Portal
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Design and architect of environment setup
- Upgrade of DB from 10.2.0.4 > 11.1.0.6 > 11.1..07 on Confidential Aix
- Upgrade of E-Business Suite from 11.5.10.2 to 12.1.1 on Confidential Aix
Confidential
Architect
Responsibilities:
- Installed and Configured ASCP and ODP non-prod and PROD instances.
- Improved severe Oracle performance challenges, especially in the area of advanced supply chain planning and Oracle Demand Planning.
- Received major appreciations mails from CEO of the Customer and from project director of Confidential GBS, Europe
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Installation and Configuration of total E-Biz Suite Release 12.0.4
- Installation and Configuration of 10g DB with RAC on AIX
- Configuration of PCP, BIG IP for Apache load balance
- Installed and configured OID SSO on 10g RAC (two node) and integration with E-Business Suite
- Configuration of High Availability and load balance of OID and SSO
- Kintana Setup for automation of Clone and code migration
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Installation and configuration DB 10g RAC
- Installation and configuration middle tier components like OID and SSO
- Configuration of High Availability of OID and SSO
- Documentation of troubleshooting and registration and de-registration process of SSO and OID.
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Up gradation of DB from 9.2.0.4 to 10.2.0.4 and E-Biz Suite from 11.5.9 to 11.5.10.
- Completed DB cross platform migration from Solaris to AIX using XTTS
- Migrated E-Business Suite from Solaris to to AIX.
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Installation and Configuration E-Business Suite 12.0.4 on Confidential AIX
- Modules included AP,AR,GL,PA, FA, BOM,INV, MRP, TOL etc
- Configuration and setup of DMZ node
- Installation and configuration of Siemens PLM
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Installation and Configuration of total E-Biz Suite 11.5.10.2 with 10g RAC on AIX with GPFS
- Configured Parallel Concurrent Processing for concurrent Managers
- Big IP load balance setup in Apache and form level.
Confidential
Team Lead
Responsibilities:
- Handled a team 30 members in Managed services mode for operational support and delivery issues.
- Conducted regular/weekly meetings with vendors and coordinating with urgent and critical escalations to get a speedy resolution.
Confidential
Sr. Oracle Applications DBA
Responsibilities:
- Upgraded the E-Business Suite from 11.0.3 to 11.5.9 on Solaris.
- Completed their DB upgrade cycle wise from 8.0.5 to 9.2.0.5
Confidential
Sr. Technical Consultant
Responsibilities:
- Implemented the complete E-biz Suite 11.5.8 and 11.5.9
- Operational support to 1500 Oracle internal DB and application services
- Monitoring Performance and tuning of the Database, Applications and OS