Sr Oracle Dba Resume
4.00/5 (Submit Your Rating)
Washington, DC
PROFESSIONAL SUMMARY:
- Over 15 years of Oracle DBA Experience and over 20 years of IT experiences in various domains.
- Expert in Oracle Real Application clusters (RAC), Automatic Storage Management (ASM), Oracle Data Guard and Oracle Enterprise Manager (OEM)
- Recent multiple Upgrade/Migration of FMW WebLogic 11g to 12c on Linux platform
- Installed and configured OEM 13c Cloud Control Center, configured Agents, setup metrics and thresholds for Oracle Databases and hosts/targets
- Developed skills to troubleshoot, roll patches, upgrade and add nodes to Oracle 11g Real Application Cluster (RAC) database instances
- Expert with migrating and upgrading Oracle databases from 11g to 12c
- Expert in installing, configuring, managing and maintaining WebLogic, Oracle Identity Management Pack (Oracle Identity Management, Oracle Access Management, Oracle Identity Federation, etc)
- Expert in charge of setting and configuring RMAN backup and recovery using recovery catalogs, and setting up backup policies and archive log and full backup scripts in communicating with the Veritas NetBackup in different environments.
- Involved with Database and Applications performance tuning, tuning SQL code, tuning database parameters
- Involved in setting up database security and auditing scripts
- Worked as Team Lead for a data warehouse group where my strong Unix administration skills and DBA skills were utilized
- Worked independently to research Oracle CPU patches for Oracle Databases, Oracle AS10g and Infrastructure environments, applying them, coordinating for after patch testing and develop documentation specific to the environments.
TECHNICAL SKILLS:
- Oracle 10g, 11g, and 12c
- WebLogic 11g and 12c, FMW Configuration and setup
- Oracle Enterprise Manager 12c, 13c, OEM 13c Cloud Control Center
- Oracle 11g Real Application Cluster (RAC), Data Guard and Standby Database configuration
- Oracle 11g Identity Management Pack (Oracle Identity Manager, Oracle Access Manager, Oracle Identity Federation, OVD, OID, OIF, etc)
- Oracle Fusion Middleware/WebLogic/SOA
- Amazon Web Service (AWS)
- Cloudera Hadoop
- Oracle 10g Grid Control (OEM), Quest Central, Big - IP (Load Balancer), Blade Logic
- Oracle 11i, J2EE Containers, Web Tier and Mid-Tier Apps DBA, Sql Developer, Toad
- Solaris 10, Linux, HP-UX, Compaq True 64 UNIX
- SQL, Java, .NET, VB Script, T-SQL
- SOA, OBIEE, BPEL, TIBCO, Crystal Management Console, Crystal Enterprise, PeopleSoft 7.5, Crystal Report 8.5
PROFESSIONAL EXPERIENCE:
Sr Oracle DBA/ Fusion Middleware Engineer
Confidential, Washington, DC
Responsibilities:
- Installed and configured WebLogic 12c Admin and Managed Servers in Cluster setting
- Expert in Database Administration and migration from 11g R2 to 12c
- Designed and brainstormed Database upgrade from 11g to 12c in Single Instance to Multi-Tenancy
- Installed and configured Oracle 12c Multi-Tenant Container Database and Pluggable Database format
- Arranged meeting with the customers and Application teams to discuss customizable requirements
- Detailed understanding of pros and cons of RAC, RAC One Node, Single Tenancy and Multi-Tenancy
- Provided full support as Oracle DBA and Fusion Middleware Engineer to Application Developers in their Migration/Upgrade
- Configured Data Source for connection to Customized Oracle 11g and 12c Databases
- Installed OEM 13c Repository database to point to Oracle 12c database on Linux platform
- Installed and configure Remote Host/Target Agent from the Cloud Center
- Configured Oracle database metric, thresholds, customizing email notification in OEM 12c and 13c
- Completed OEM 13c Requirement Document and Deployment Guide in Federal Agency format
- Applied Quarterly Oracle patches on WebLogic Admin and Managed Server to be security compliant
- Participated in the meetings with the Application Teams to discuss the detailed requirements
- Completed WebLogic 12c Requirement Document in Federal Agency required format
- Completed WebLogic 12c Installation and Deployment Guide in Federal Agency format
Senior Oracle DBA
Confidential, Kansas City, MO
Responsibilities:- Expert in Database Administration and migration from 11g R2 to 12c
- Oracle RAC experience with strong knowledge of Oracle ASM
- Responsible for installing, upgrading, and supporting Oracle Applications software and the associated Oracle technology stack in a multi-tier environment: database server, applications server, web server, concurrent processing, reports, forms, and admin server
- Experience with Oracle Database 11g / 12c product versions in a RedHat (RHEL) Linux environment
- Hands-on experience with Oracle Database including patching, upgrades, migrations and management console
- Responsible and expertise in Oracle Database Administration experience with configuration, load balancing, backup/recovery, sizing and space management, RAC, PL/SQL tuning, and diagnostics
- Proficient with the use of Oracle's Enterprise Manager tool
- Work with Opening, managing, and resolving Oracle SR's experience when necessary
- Production database support of a 24x7 environment and on-call support
- Knowledge of the underlying Oracle Applications database architecture - schemas/products, database objects, file system structure, tables, views, packages, procedures, functions, triggers, sequences, indexes, and constraints
- Oracle Software Installs, Upgrades in version 11g and 12c
- Implement Backup and Recovery using RMAN along with NetBackup
- Performance tuning of the Database both at the application level (SQL) as well as instance.
- Expert knowledge with Oracle Enterprise Manager/Grid Control and AWR and other tools
- Hands on experience on RedHat Linux (RHEL), and Shell Scripting
Senior Oracle DBA
Confidential, Arlington, VA
Responsibilities:- Latest project involved in migrating and upgrading from Oracle 10g to 11g, and Oracle 11g databases to Oracle 12c in numerous database instances
- Oracle 11g Real Application Cluster (RAC) database instances: troubleshooting, rolling patching, upgrading in conjunction with Automatic Storage Management (ASM) in testing and development phases
- Expert in installing, configuring, managing and maintaining different single sign-on enabled environments involving Oracle 10g and 11g databases with Oracle Application Servers, web logic and Oracle Infrastructure Components in Unix, Linux and Windows environments
- Expert in charge of setting and configuring RMAN backup and recovery using recovery catalogs, and setting up backup policies and archive log and full backup scripts in communicating with the Veritas NetBackup in different environments.
- Oracle Single Sign On (SSO) / Oracle Internet Directory (OID) controlled multi-tier structure and supports multi-environments
- Install, Manage and maintain Oracle 10g and 11g in Sun Solaris platform
- Setup, configure, and maintain Oracle Grid Infrastructure on Unix and Windows
- Database refresh and cloning using RMAN backup
- Database Performance tuning using Grid OEM Console, analyze AWR, ADDM, ASH reports, run prstat and vmstat to verify the cpu load and memory utilization, etc
- Setup standby databases for the primary database on both ITE and Production environment
- Apply and install Oracle CPU patches quarterly along with major java upgrades
- Upgrade and install j2ee and 11i application deployment in full cycle
- Deploy and troubleshoot 11i application with Concurrent Manager
- Setup and maintain RMAN backup policy to disk and to tapes
- Maintain Oracle 10g Grid Control, install grid agent, apply patches
- Troubleshoot web-tiers and application tiers to resolve solutions
- Manage, monitor, maintain Oracle large databases with Terra Byte Sizes
Senior Oracle DBA
Confidential, Reston, VA
Responsibilities:- Oracle Core and Applications DBA for Production, ITE (Integrated Testing Environment), Pre-ITE and Development environments involving over 25 Unix Solaris Database Servers, 50+ Oracle As10g application servers and 20+ windows servers.
- Install, Manage and maintain Oracle 9i, 10g and 11g in Sun Solaris platform
- Setup standby databases for the primary database on both ITE and Production environment
- Apply and install Oracle CPU patches quarterly along with major java upgrades
- Application DBA for major application deployment in testing and production environment
- Deploy and troubleshoot 11i application with Concurrent Manager
- Setup and maintain RMAN backup policy to disk and to tapes
- Maintain Oracle 10g Grid Control, install grid agent, apply patches
- Troubleshoot web-tiers and application tiers to resolve solutions
- Manage and maintain Crystal Management Console
- Manage, monitor, maintain Oracle large databases with Terra Byte Sizes
Operations Director
Confidential, Englewood, CO
Responsibilities:- In charge of business operations and the financial management
- Oversee the employee management
- Manage TAJIMA/PULSE SW upgrade and file manager
- Clients’ accounts payable and accounts receivable
Architect / DBA
Confidential, La Mirada, CA
Responsibilities:- ERP system analysis, management and support
- Manage and maintain RDBMS (Informix) and UNIX system
- User management, schema management, content management
- On-site, email and phone support to End-users
- Update and upgrade patches for ERP systems
- Conduct end-user training for new features of ERP systems
Oracle DBA/Systems Administrator -
Confidential, San Antonio, TX
Responsibilities:- Oracle 9i installation and configuration
- Oracle SQL and PL/SQL performance tuning using tools as Analyze and Explain Table
- Managed database datafiles space management, user management, and role and profile management
- Performed backup and recovery using Recovery Manager (RMAN)
- Lead developer of the Data Warehouse Project to convert the Legacy database with the PeopleSoft HRMS and FINANCIAL tables to generate Personnel, Payroll, Finance and Accounting reports using Crystal Reports via Crystal Enterprise web-based to campus-wide departmental administrators.
- Some of the daily responsibilities include: PL/SQL scripting, Oracle User management, Oracle security, schema and object creation, backup and recovery, and performance tuning, complex Crystal Report development and troubleshooting.
- Developed databases using T-SQL commands and administered SQL Server 2000.
- Internal Oracle and Applications trainer for programmers, administrators and departmental end-users.
- Managed, maintained, supported and troubleshoot multi-faceted platform: UNIX, Windows 2000/NT/98/95 and VMS servers.
- System installation and upgrade along with disk configuration and maintenance.
Oracle DBA/UNIX Systems Administrator
Confidential, San Antonio, TX
Responsibilities:- Oracle 8x installation, configuration, space management, user management
- Maintained Oracle database security and configured OS security patches
- Remote and on-site installation to Air Force Bases around the world
- Maintained, managed and administered forty-five HP-UX Super-Mini computers supporting CIVMOD Functional Process Improvement (FPI) servers.