Database Administrator Resume
Dallas, TX
SUMMARY:
- 11+ Years of experience in Oracle Fusion Middleware, SOA, WebLogic and Oracle Database administration.
- Extensive experience with Installation, Configuration, Administration and Performance tuning of Oracle WebLogic Application Servers running for Oracle Service Bus/Business Activity Monitoring/Oracle SOA Suite Suite in a clustered environment.
- Expertise in Infrastructure designing and setups especially with Oracle Fusion Middleware Products (Oracle SOA Suite, Oracle WebLogic Server & Oracle Web - Tier).
- Installed and configured different engineered systems(Exalogic/Exadata/Exalytics)
- Installed and configured Oracle Enterprise Manager 12c for many customers including some big financial firms.
- Configured various management packs including WebLogic management pack EE, Exalogic Elastic Cloud Management Pack, Exadata Management Pack, Coherence management Pack and many other monitoring management packs.
- 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.
- Monitored all these targets using em12c (Databases, Middle-Tier, App-Tier & Web-Tier).
- Installed and Configured Oracle SOA Suite on Web logic.
- Installation & Configuration of Oracle SOA 11g.
- JVM Tuning for different WebLogic containers.
- Patching and troubleshooting on SOA/BPEL.
- Implemented WebLogic clustering
- Responsible to provide the 24*7 support for Production Databases.
TECHNICAL SKILLS:
Operating Systems: -Unix/Linux (HP, Sun, Oracle, IBM),WIN9x/me/xp/2k/2k3 serverDatabases:- Oracle 8i/9i/10g/11g
App Server: - Oracle WebLogic Server
Oracle Fusion Middleware Products: - Oracle SOA Suite 10g/11g (SOA, BPM, AQUALOGIC, BAM, OSB, BPEL)Oracle WebTier 11g (OHS)
Web Server: - OHS, IIS, Apache, Tomcat
Tools: - IDE, collaboration, UML Design and Testing: - Fusion Middleware Console, Enterprise Manager 11g/12c, SQL*Plus, OEM/OAM, RMAN, Toad, AD tools, Putty, X-windows, JDeveloper, JRockit Mission Control, TOAD,AWR and ADDM
Networking/Protocols: - TCP/IP, SSH/SFTP, SDP, t3
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
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) .
- Upgrade databases from 9i to 10gR2 and also from 10gR2 to 11gR2.
- Actively involved in Performance tuning covering all major areas SQL-Tuning, OS Tuning, AWR, ADDM’s and Stats-Pack.
- Working Exclusively on 11.1.0.7/11 gR2 RAC Environments.
- Handling and maintaining Grid Control for all the databases
- Installed and implemented Oracle 9i/10G/11G databases on UNIX and Linux platform.
- Installed and Configured Oracle SOA Suite on Web logic and Oc4j Container.
- Installed and configured Exalogic X2-2 for one of the clients.
- Did a POC for first version of Exadata with HP hardware.
- Capacity Planning sessions for Infrastructure Cloud on Exadata.
- Performance comparison statistics and reporting on engineered systems for various databases.
- Installation & Configuration of Oracle SOA 10.1.3.4
- Patching and troubleshooting on SOA/BPEL.
- Implementation of EM12c installation for multiple data centers
- Troubleshooting/Performance Tuning Oracle EM12c, FMW and Fusion Apps production Deployments.
- Done Oracle SOA 10.1.3.4 Server clustering on Weblogic 9.2.
- Configured BPEL & ESB Clustering for Weblogic9.2 and Oc4j both.
- Configuring Web Services Inspection Language Configuration Assistant and Oracle Process Management and Notification for SOA.
- Daily support and faced a lot of challenges on SOA Suite(base - 10.1.3.1, patch-10.1.3.4)
- Implemented database security and worked on masking project for masking the various critical columns of the table.
- Developed strategies for implementation of database consolidations to streamline efficiencies as needed throughout the company, and participated in planning and execution of future upgrades and technology enhancements
- Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
- Benchmark response times between unencrypted and encrypted columns
- Used SQL-LOADER regularly to load excels files to database.
- Done migration from sql-server database to Oracle databases.
- Implemented multiplexing of control files and redo-logs for disaster recovery.
- Developed shell scripts, PL/SQL procedures to monitor the databases and scheduled UNIX cron jobs and Oracle DBMS SCHEDULER.
Environment: OBIEE 10.x / 11.1.5, Exalytics, Exadata, Exalogic, Weblogic, BI Apps, DAC, Noetix, RCU Repository Creation utility for various installers Oracle Fusion Middleware applications, SOA/BPEL/BPM, WebCenter, ECM & IDM stack.
Confidential
Responsibilities:
- Installed and configured Oracle Fusion Middleware with management packs including Exalogic and Exadata Management Pack.
- Configured EM12c monitoring for some specific client requirements.
- Monitored all these targets
- Database 11g/10g(Customized DB Alerts)
- Fusion Middleware (Admin Servers, Managed Servers, CPU Utilization on Compute Nodes, JVM Memory Utilization per managed server, OTD (Oracle Traffic Director) & JMS queues).
- EXADATA (Infiniband monitoring, Exadata plug-in setup) and EXALOGIC.
- Extensive experience in handling Production SOA Fusion middleware and Troubleshooting.
- Support Oracle SOA and SOA composite services, spring framework
- Deploying, configuring and validating SOA composite applications
- Install and administer clustered H/A middleware environments.
- Experience with implementation and maintenance of Oracle Service Bus (OSB), Oracle BAM & BAM.
- Experience configuring JMS and data-sources.
- Administering the SOA middleware environments.
- Configuring and monitoring the SOA environments.
- Performance tuning SOA Environments.
- Handling Fiserv. Branding
- Basic fusion middleware administration.
- Migration of Projects from various environments as per SDLC.
- Database Refreshes.
Confidential
Database Administrator
Responsibilities:
- Experience with configuration of firewalls, DNS and other network topology constructs.
- Worked with Oracle disaster recovery configurations and approach
- WebLogic/SOA Tuning
- Node manager concepts
- SOA Purging.
- AD integration with WebLogic
- Deployments automation
- Troubleshooting of issues.
- Experience installing Oracle SOA10/11g on OC4J &WebLogic.
- Gathered user requirements and translated them into software customization requirement
- Documented with flow charts and diagrams current reporting processes
- Liaison with third party vendor to implement web based package
- Developed relationships between business users and development team to implement and customize cloud platforms
- Post Refresh Activities and Hand off to End User
- Reconfiguring of Appserver domains, PRCS domains, report nodes, web domain
- Creation of Users, Grant of necessary Roles/Privileges and allocation of tablespaces.
- Applying Tax Updates.
- Applying database patches.
Confidential, Cleveland, OH
Oracle Database Administrator
Responsibilities:
- Monitored database growth, created objects, administered users and tuned expensive SQL statements using EXPLAIN PLAN and SQL TUNING ADVISOR.
- Implemented database migration and Integration from 10g to 11g using Golden Gate
- Installed and Setup Golden gate between Oracle DB and Sqlserver DB
- Setup switchover, data guard broker, and all scripts to monitor failover on Exadata V2
Confidential
Jr. SQL Server Database Administrator
Responsibilities:
- Install, upgrade and maintain Oracle 9i, 10gi on Sun Solaris and Windows 2003, Redhat4.
- Installation, setup and configuration of DATA GUARD.
- Implementing Database Security, Management of role-based security
- Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database
- Write and modify UNIX shell scripts to manage Oracle environment
- Performed Data Migration as a part of enterprise data warehouse project
- Extensive Performance Tuning, Memory (SGA) Tuning, Net backup
- Cloning databases using scripts as well as RMAN
- Established database backup/recovery strategy for different databases
- Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure
- Management of table space growth, monitoring data files additions, extent growth
- Constantly monitor the performance of the Databases and viewing Alert log files & Trace files
- Logical and Physical data modeling using Erwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling
- Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store
- Performed scheduling Control-m for scheduling jobs
Environment: Oracle 9i and 10g, Sun Solaris, Red Hat Linux, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, AIX, TOAD, Erwin, STATSPACK