We provide IT Staff Augmentation Services!

Database Administrator Resume

0/5 (Submit Your Rating)

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

We'd love your feedback!