Oracle Dba Resume
Winston Salem, NC
SUMMARY
- Implementation of multiple EBS R12 systems Order Management, Supply Chain, Projects, Finance, and Incentive Compensation, HR.
- Upgraded multiple EBS environments - Oracle EBS Upgrades from 11.5.10.2 to 12.1.3 and 11.5.10.2 to 12.2.6 and database upgrades from 9i to 10g and 10g to 11g and 11g to 12c
- Platform Migrations for Oracle Database, EBS and FMW environments. Migrated several systems from 32BIT to 64BIT
- Implemented RAC, DR, High Availability and Load Balancing Solutions to multiple Oracle Environments
- Implemented ASM, RMAN and Backup Strategy for the organizational databases and applications.
- Proficiency in Performance Tuning. And expertise in memory level, system level, SQL level tuning and application side tuning
- Performance tuning of JVM heap size, garbage collections, java stack and Native thread & production performance of WebLogic and FMW Stack
- Installation, Configuration, Monitoring and performance Tuning on WebLogic Server 10gR3/11g and 12c Part of 24X7 production support team with on call rotation.
- Implementations of the Fusion Middleware stack with SOA suite 11g/12c, Oracle Service Bus 10g/11g/12c.
- Troubleshooting by using Thread Dump, Heap Dump and Garbage collection analysis for Web Logic Server issues
- Implementation, Upgrade and support for OBIEE and ODI and eco systems- 11g and 12c
- Implementation and support to OEG 11g with SSL for external facing applications
- Implementation and maintenance of DEMANTRA 11g and 12c, GRC 11g and 12c, Primavera P6 and Hyperion
- Implemented OEM 12c for enterprise wide database monitoring. And configured databases for primary monitoring
- IDM 10g & 11g & 12c - Single Sign-on Implementation
- EBS/FMW - IDM Integration: Integration of IDM with multiple Oracle EBS systems and FMW Systems
- Migrated Cisco acquired company’s ERP environment to Cisco Data center and providing SSO capability to them including user provisioning (Migrated WebEx Datacenters into Cisco)
- Data Centre Migration for Database, ERP, FMW and foundational components like IDM, TNS OID, OCM
- EBS, Database and FMW Refresh/Cloning/Patching/Autoconfig strategy and implementation
- Leading and supporting Weekly/Monthly/Quarterly releases
- Oracle EBS Platform migration from HP to Cisco UCS (RHEL Linux) and Solaris to OEL
- High Availability setup for EBS R12.1.3/R12.2, FMW 11g/12c (SOA and ADF), IDM 10g & 11g (MVDC Setup)
- DR setup for Oracle Databases, EBS R12.1.3 and R12.2, FMW 11g/12c, IDM 10g & 11g using Data Guard
- High Availability configuration for EBS R12, FMW 12c and WebLogic with High availability and DR setup
- Golden Gate Replication for EBS 12.2 and Evaluation of Oracle 12c new features
- EBS integration with IDM 11g, FMW Integration with IDM 11g and AD
- FMW (SOA, ADF, GRC, Primavera, BAM/BPM, Web center) SSO enablement
- Hardening of EBS and Identity Management technology stack and DMZ setup for external users
- Experience of leading team of 20 members with onsite and offshore model. And mentoring team members for team ramp up
- Managed a team of DBAs for supporting the life cycle of Oracle Databases, Oracle E-business Suite, IDM, FMW environments for production, release and various project support and data center migration.
- Experience in managing production systems efficiently. Automation, Documentation and proactive monitoring of the systems. And experience in cloud and implemented DBaaS, PaaS and IaaS
- Technology landscape includes Oracle Database 10g/11g/12c, ERP 11i/R12/R12.2 and Oracle Middleware Products (SOA, ADF, OBIEE/ODI, Demantra, OEG, OEM, IDM, GRC, Primavera, Web center, etc.)
- Capable of providing end-end solution for an enterprise IT starting from defining the architecture, design and implementation of Oracle eco system including Oracle Applications (11i, R12.1.3 and R12.2) and Databases, Oracle Identity Management, Oracle Fusion Middleware (SOA and ADF), and Oracle Golden Gate Data Replication.
- Expertise in Hadoop Administration and No SQL Database Administration. Implemented Cloudera Hadoop (CDH). Explored Open Source Apache Hadoop, Hortonworks Hadoop and No SQL Databases like Cassandra DB and MongoDB.
TECHNICAL SKILLS
Middleware Technologies: WebLogic 10g/11g/12c, Fusion Middleware 11g/12c, SOA 11g/12c, BAM/BPM 11g/12c, Web center (IPM, UCM) 11g/12c, GRC 11g/12c, Primavera P6 8.3/current, ADF 11g/12c, Oracle JRockit and Sun Hotspot JVMs, OTM 6.2, Agile PLM 9.3.2, Fusion Apps 11g/12c, IDM 10g/11g (OIM & OAM), LDAP (AD, ADAM and Open LDAP), Demantra 11g/12c, Vertex 12c, OEG 11g, OBIEE/ODI 11g/12c, APEX
ERP: Oracle Apps 11i/R12.1.3/R12.2, Discoverer 4i/10g/11g, Developer 6i/10g, JDK, JRE, JVM, J-Initiator
Databases: Oracle 9i/10g/11g/12c, PostgreSQL, MySQL, SQL Server, DB2, Exadata, Derby, Pointsec
Application Servers: WebLogic Server 9/10/11g/12c and Oracle 10g Application Server, GLASSFISH
Web Servers: Apache, Tomcat, OHS, Web Cache, Reverse Proxy
Replication Products: Golden Gate Replication and Shareplex Replication
Languages: SQL, PL/SQL, C, C++, PHP and Java & Shell Scripting, Perl, WLST and Python
Operating Systems: Linux, Solaris, HP-UX, AIX, Windows, Mac
Hardware: UCS 64 Bit/ 32 Bit, HP Blade Servers, Sun SPARC machines, Dell Servers
IT Process: SOX Compliance, ITIL V3, ISO 27000, Agile and Scrum Standard
Tools: OEM, TOAD, SQL Developer, App Dynamics, Remedy, JIRA, SNOW
Big Data Solutions: Apache Hadoop, Cloudera CDH, Hortonworks HDP, NO SQL Databases - MongoDB and Cassandra DB, PostgreSQL, My SQL, Maria DB and corresponding eco systems.
PROFESSIONAL EXPERIENCE
Confidential, Winston Salem, NC
Oracle DBA
Responsibilities:
- Provide shift and non-shift support for Oracle e-Business Suite; Oracle production, test and development instances; and Oracle Fusion Middleware tech stack and infrastructure (including: ADF based applications).
- Manage and architect the Oracle SOA Web Services tier.
- Meet service level agreements for production support response and resolution.
- Troubleshoot and tune Oracle e-Business and Non-ERP Oracle Databases and contribute to technical performance analyses and enhancements.
- Utilize Change Management controls to implement code changes in Production and non-Production instances.
- Apply core database skills to maintain key processes (e.g. archiving, monitoring, replication, integrity and security).
- Implement and test disaster recovery plans.
- Maintain health and compliance of primary production systems (conduct analysis and apply Security Patches periodically)
- Work on provisioning users and management of tools (e.g. Identity Management and Single Sign-On (SSO)).
- Adhere to standards related to documentation, software development methodology, version control testing, and migration.
- Contribute to a cooperative environment that fosters knowledge sharing.
- Perform other duties as assigned.
- Implementation and support of Oracle Fusion Middleware products like ADF, SOA, OSB, OHS and WebLogic
- Upgrade EBSO 11.5.10.2 to 12.2.4
- Implementation and support of OBIEE/ODI 11g/12c
- Implement and support of Golden Gate Replication, IDM and SSO, OEG 11g, OEM 12c, GRC 12c, Primavera P6, Demantra, Vertex, APEX and Hyperion
- Proactive Production systems monitoring using cron jobs, OEM Monitoring, Monitoring through App Dynamics for FMW Environments,
- Production support daily and weekly weekend maintenance and EOM support
- Managing schedules through SMA, deployments through custom deployment tools, incident management though SNOW
- Handling Sev1/Sev2 Issue over conference bridge and providing solutions and providing RCA for the issues
- Managing team of 10 members including regular and consultants
- Documentation, scripting, mentoring and trainings and took training on Oracle SQL Turning and Oracle cloud technologies and tuned oracle queries for better performance
- Implemented Hadoop and No SQL Solutions for big data problems
Confidential, San Jose, CA
Oracle DBA
Responsibilities:
- Integrated various EBS and FMW (SOA/ADF) environments with IDM for SSO
- Implemented and Integrated Demantra and Sabrix with R12.1.3
- MVDC Implementation for oracle Database and EBS12.1.3 with Active-Passive Database and Active-Active Applications
- Replication using Golden Gate and Shareplex technologies
- ASM Conversion and RMAN Implementation
- 8 Node RAC, RAC Services, 8 Node DR, Full DR, Snapshot DR Implementation for LSS Project
- Platform Migrations from 32BIT to 64BIT and implemented Direct NFS for IO performance
- WebLogic, SOA, ADF, OTM, Demantra, Vertex, Sabrix Administration and implementation
- EBSO Upgrade from 11.5.10.2 to R12.1.3 and POC completed for R12.2
- Implemented Localization for Brazil and enabled new languages Italy and FRC in EBS systems
- Load Balancing, High Availability and DR solutions for the integrated EBS systems
- Implemented Primavera P6 with High Availability and DR Setup
- Implemented GRC 11g and upgraded GRC to 12c
- Datacenter migration for cisco acquired company WEBEX. Migrated all WEBEX systems to Cisco Datacenter
- Worked with Cisco SMEs to implement and support Cisco Cloud Systems for DBaaS
- Transitioned all implemented projects to cisco production support team and supported the environments for the system stabilization
- Provide shift and non-shift support, weekend support, release support for oracle systems
- Documentation, scripting, mentoring and trainings
- Enabled SSL for FMW and EBS systems
- WebLogic Implementations for COVC LSS/CG1 Project