Oracle Administrator Resume
Dallas, TX
SUMMARY
- An accomplished professional with around 8+ years of total industry experience in different technologies including Oracle products.
- Key responsibilities include installation, migration, upgrade and support of Oracle Fusion Middleware applications and Infrastructure.
- Experience in Oracle Fusion Middleware including (SOA, WebLogic, WebCenter) and Oracle Database administration.
- Extensive experience with Installation, Configuration, Administration and Performance tuning of OracleWebLogic Application Servers running for Oracle Service Bus/Business Activity Monitoring/Oracle SOA Suite in a clustered environment.
- Installed and Configured Oracle SOA Suite on Weblogic.
- Hands on experience with Installation, Configuration, Upgrades, Migrations, Administration, Backup and Recovery, Disaster Recovery and Patching of Oracle Weblogic 11g/12c, Oracle Identity and Access Management Suite (OAM and IDM Suite), Oracle SOA Suite, & Oracle WebTier using OHS and WebGate.
- PerformedWeblogicupgrades and patching as they come fromOraclewith the special procedures as required for security.
- Implemented backup procedures for different clients using Oracle fusion middleware
- Installed and Configured Oracle Business Intelligence Suite 11g
- Installed and Configure Oracle WebCenter Suite 11g.
- Responsible to provide the 24*7 support for Production Oracle Environment.
- Extensive experience in implementing Exalogic, Exadata & Exalytics.
- Setting up VServers for Exalogic. Involved in building environments for Oracle FMW stack on Exalogic.
- Planned and implemented Disaster Recovery (DR) & high availability solutions using Oracle Products.
- Experience in creating and managing user and groups, accounts, security, rights, privilege and permissions using OID, OAM, and LDAP.
- Experience in OEM 12cadministration, install, configuring agents, targets, setting up alerts, creating block out,security configuration &monitoringallmiddleware components.
- Customized EM12c monitoring for some specific client requirements including N/W monitoring using SNMP Traps, Custom Metric alerts, Custom Application Health - Check monitoring setup and Customized log file monitoring.
TECHNICAL SKILLS
Operating Systems: HP-UX, Sun Solaris 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. OEL Linux 5/6. Windows XP/2007/2010/UNIX/Mac.
Oracle Fusion Middleware Products 11g/12c: Oracle SOA Suite, OAM, WebCenter Suite, OBIEE, OID and Oracle WebTier 11g(OHS)
Programming Languages: SQL, PL/SQL, UNIX Shell
Scripting Tools: IDE, collaboration, UML Design and Testing: - Fusion Middleware Console, Enterprise Manager 11g/12c, OVD, JExplorer (AD), PuTTY, MobaXTerm, VNC, JRockit Mission Control
Database Utilities: SQL*Plus, Oracle Enterprise Manager, Oracle 8i/9i/10g/11g/12c Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import
PROFESSIONAL EXPERIENCE
Confidential - Dallas, TX
Oracle Administrator
Responsibilities:
- Oracle Fusion Middleware & Database Administration experience in variety of different environments like Windows (NT/2005 Server, and different flavors of Unix (IBM-AIX, Linux)
- Work involving Oracle FMW products (SOA Suite, OSB, ODI, Webcenter, and WebLogic).
- Install, upgrade and maintain Oracle 10g,11g,12C on Linux, Solaris and Windows.
- Write and modify UNIX shell scripts to manage Oracle environment
- Responsible for WebLogic HA architectural concepts.
- Administrating Oracle SOA suite in WebLogic clusters, OSB, BPEL administration, High availability / Disaster Recovery.
- Worked on server virtualization including Oracle VM & VMWARE.
- Configured JMS Components including Server, Module, Topics, queue and sub-deployments
- Inspect facilities and security equipment and ensure that it meets security standards
- Installed and configured EM13c with management packs including Exalogic and Exadata plugin’s, EXADATA (Infiniband monitoring, Exadata plug-in setup).
- Basic setup with oracle engineered systems (Exalogic & Exadata)
- Transition/Migration of middleware applications on Exalogic server.
- Initialization and testing of ExaBR for backup and recovery for Exalogic Hardware and Virtual Servers.
- Oracle Fusion Middleware product components as Exalogic Server Administrator to six environments on two Exalogic racks.
- Installed and configured Exalogic X2-2 for one of the clients.
- Capacity Planning sessions for Infrastructure Cloud on Exadata.
- Performance comparison statistics and reporting on engineered systems for various databases.
- Familiar with Software Development Life Cycle (SDLC)
- Working Exclusively on 11.1.0.7/11 gR2 RAC Environments.
- Installed and Configured Oracle SOA Suite on Weblogic and Oc4j Container.
- Installation & Configuration of Oracle SOA 11.1.1.9
Confidential, Salt Lake City, UT
Consultant
Responsibilities:
- Installing and ConfiguredSOA Suite, WebLogic10.3.x.x Servers,Webcenter Portal.
- Implemented Performance tuning for different Oracle middleware products including SOA Suite & WebLogic.
- Responsible for Installation and Configuration of Oracle Fusion Middleware 11g and 12c products on Red Hat Enterprise Linux.
- Managing/administrating Exalogic using OEM and managing Exalogic using CLI/Graphical user interfaces.
- Worked on WebLogic application servers including installation, Create WebLogic Domains and configurations.
- Responsible for testing/validating the setup of software/hardware
- Done Troubleshooting/Performance Tuning OracleEM12c, FMW and Fusion Apps production Deployments.
- Installed& Configured Oracle WebCenter Suite 11g on Linux environments.
- Work involving Oracle FMW products (SOA Suite, OSB, ODI, Web Center, and WebLogic).
- Exalogic Elastic cloud (Physical and Virtual) and Upgrading Exalogic components and ZFS.
- Implemented Performance tuning for different Oracle middleware products including SOA Suite &WebLogic.
- Did a POC for Exalogic with basic VM setups. Capacity Planning sessions for Infrastructure Cloud on Exalogic/Exadata.
- Upgraded Oracle SOA Suite from 11.1.1.5 to 11.1.1.7 for all environments.
- Assisted application teams with the design and troubleshooting of OAM and Authentication and Authorization related issues
- Created BAM Server for the client and implemented end to end monitoring using em12c.
- Performance Tuning of different Oracle products including Fusion middleware (SOA, WebCenter Portal & Content).
- Proficient in deployments on Weblogic, OSB, SOA Suite, OAG using out of box functionalities or scripts.
- Monitoring the environment using OEM and setting up alerts as and when required.
- ImplementedOracleOIM 11g performance tuning parameters.
- Installed WebLogic/SOA on Linux environment.
- Installed Weblogic/SOA cluster environment for RAC Databases
- Configure and migrate Operating System, Middleware Applications and Database. Installation & Configuration of Oracle SOA 11g
- Worked on Cluster configurationofOracleSOA 11g and OSB 11g for extending the domains
Confidential - Franklin, TN
Consultant
Responsibilities:
- Design Complex Infrastructure solutions for multiple clients using Oracle Product Stack (Linux/Solaris, Database, and Fusion Middleware).
- Administrator and Consultant for highly available Clustered solutions using Oracle Fusion Middleware products(Oracle SOA Suite, Oracle WebLogic Server, Oracle WebCenter Suite, Oracle ECM Suite, Oracle IDM Suite & Oracle WebTier, Coherence, Enterprise Manager 11g/12c).
- Experience with WebLogic Integration administrator and configuration using application integration platforms.
- Work involving Oracle FMW products (SOA Suite, OSB, ODI, Web Center, and WebLogic).
- Installed and configured different Oracle Fusion Middleware products.
- Implemented backup procedures for different clients using Oracle fusion middleware.
- Implemented Performance tuning for different Oracle middleware products including SOA Suite &Weblogic
- Configured software components for managed WebLogic services on Server Farms and Cloud Services.
- Worked on upgrading the environment from WebLogic 11g and 12c
- Install & Configure Oracle WebCenter Suite 11g on Linux environments.
- Upgraded OracleSOA Suite from 11.1.1.5 to 11.1.1.7 for all environments.
- Configure and migrate Operating System, Middleware Applications and Database. Installation & Configuration of Oracle SOA 11g.
- TroubleshootSOAcomposite applications by performing corrective actions such as fault recovery.
- Tuning and configuring OracleSOASuite 11g environment for high availability and load balance.
- Managing and monitoring service engines, and updating the state ofSOAcomposite applications.
- Experience with WebLogic Integration administrator and configuration using application integration platforms.
- Configured software components for managed WebLogic services on Server Farms and Cloud Services.
- Worked on upgrading the environment from WebLogic 11g and 12c.
- Installed and configured different Oracle Fusion Middleware products
- Implemented backup procedures for different clients using Oracle Fusion middleware.
- Configuring Clusters on WebLogic using the WebLogic Console
- Work involving Oracle FMW products (SOA Suite, OSB, ODI, Web Center, and WebLogic).
Confidential - Grand Rapids, MI
Oracle DBA
Responsibilities:
- Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
- Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
- Refreshing Dev and Test instances with data from Production on a regular basis.
- Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4) & 11g Release 2(11.2.0.2,11.2.0.3) install and upgrade on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11gR2 upgrades.
- Checking Backup and Restore validity periodically on databases about 12TB in size, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups
- Worked on USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
- Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
- Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp.
- Refreshed the databases from PROD to UAT, QA, and DEV using RMAN.
- Performed migration of databases from 9i and 10g to 11g on Linux.
- Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
- Decent usage of ADDM, AWR, ASSM, features of 10g/11gR2.
- Worked on resolving the gap between primary and standby
- Worked on setting up the flashback and restore point on the databases and also flashbacked the databases to restore point when required.
- Database Maintenance, Data warehousing, and Data Modeling using Erwin.
- Worked on installing CPU patches manually and also using enterprise manager grid control. Worked on installing the Rollover patches for RAC databases. Capacity planning: Allocate system storage and plan future storage requirements.
- Creating OEM alerts that provides notifications through emails.
- Monitoring rollback segment and temporary table space use.
- Performing housekeeping tasks like checking log and trace files.
Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
Confidential, Arlington, VA
Oracle DBA
Responsibilities:
- Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting Required privileges to users.
- Performing monthly and annual performance reports for trend analysis and capacity planning.
- Assist in SQL tuning and providing consultation such as creating Materialized views, adding Indices, dropping unnecessary indices, using hints wherever possible, amongst others.
- Worked on both VMS and UNIX environments.
- Troubleshooting of various database performances by proper diagnosis at all levels like SQL,
- PL/SQL, database design, database tables, indexes, Instance, memory, operating system and Java calls.
- Experience in writing UNIX/SHELL scripts for providing the reports.Installed and configured Oracle 11g database on a test server using Oracle standard
- Procedures and OFA, for performance testing and future 10g production implementation.
- Loading data from flat files to database using SQL*Loader, External Tables.
- Extensively used AWR, ADDM and explain plan for periodic performance tuning.
- Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-
- Organizing Databases/Schemas/Tables to improve the performance.
- Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL
- Trace & TKPROF, EXPLAIN PLAN.
- Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
- Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp.
- Refreshed the databases from PROD to UAT, QA, and DEV using RMAN.
- Performed migration of databases from 9i and 10g to 11g on Linux.
- Upgraded the databases from 9i and 10g to 11g and resolving the issues during upgrade.
- Worked on RMAN backup and recovery. Recovered the databases (full recovery) during database
- Upgrade and point in time recovery as per the user request using RMAN.
- Have used different tools like DB Artisan (8), EXPLAIN PLAN, TKPROF, and STATSPACK to solve the Performance issues. Successful in applying RDBMS patches, security patches for improving the Security and functionality of the databases.
- Achieved optimized performance for the databases by rebuilding indexes, on tables and Indexes.
- Automated the processes like moving files, managing alert log, efficient backup by developing UNIX Scripts.
- Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
- Used TOAD for database management.
- Made optimal use of Oracle Support in resolving the SRs.
- 24 X 7 Production & Development database support and administration.
Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* PlusSQL*Loader, OEM, TOAD 10.0.
Confidential, Plano TX
Network Administrator
Responsibilities:
- Part of the team which was responsible for the overall management of the LAN/WAN.
- Installed, configured and administered network devices such as routers, switches and Hubs and performed LAN/WAN routine maintenance and troubleshooting.
- Overall responsible for reliable and consistent LAN/WAN network performance and Services.
- Implemented and administered Virtual Local Area Networks.
- Administered Remote Access Server and defined its network security policies and User accounts.
- Backup and Recovery as per the defined backup Strategies.
- Managedthe planning and implementation of information systems security, anti-virus and data protection software.
- Designed desktop account security parameters on one workstation which served as template for all
- Terminals. Ensuredbusiness continuity with full responsibility for 100% uptime, full data backup,and recoveryand system redundancy.
- Monitoring of the system performance and corrective action for smooth functioning of system.
- Installation and configuration of Windows NT 4.0 and MS-Proxy Server.
- Responsible for troubleshootingnetwork performance issues.
- Responsible for the creation and maintenance of a disaster recovery plan.
- Install and perform minor repairs to hardware, software, or peripheral equipment, following design or installation specifications.
- Responsible for maintaining an accurate inventory of technology hardware, software, and resources.
- Modify existing software to correct errors, to adapt it to new hardware, or to upgrade interfaces and improve performance.
- Responsible for the setup, configuration, and supportofinternal and/or external networks