Senior Database Administrator Resume
5.00/5 (Submit Your Rating)
Los, AngeleS
SUMMARY:
- Senior Database administrator with extensive experience designing, testing, upgrading and supporting next - generation database solutions in Oracle enterprise and Oracle E-Business applications environments.
- Proficient in an assortment of technologies, including Oracle 12c, 11g, 10g, EBS 11i, 12i - 12.1 through 12.2.4 and MS SQL Server 2014.
TECHNICAL SKILLS:
- Oracle Core Database Administration in Install, clone and apply patches for multi node production and development - L3 Support Oracle Applications R12, 11.5.X and Oracle
- Performance Tuning, Storage Management database installations
- CPU, PSU patching, SOX compliance Upgrades from 11.5.X to 12.2.1 and 12.2.4
- Demonstrated ability to identify root causes of Oracle Databases performance analysis, problems, and providing long and short-term monitoring and tuning. impact of proposed solutions Implement and maintain optimal database
- OnCall 24x7 schedule rotation support of backup and recovery, disaster recovery managed database installations procedures
PROFESSIONAL EXPERIENCE:
Senior Database Administrator
Confidential, LOS ANGELES
Responsibilities:
- Consolidate multiple non - shared core database instances and upgrade to 12c Multi-tenant architecture.
- Established RMAN backup and recovery procedures and documented business continuity plans for the rganization.
- Installed and administered SQL Server 2014 engine for SharePoint Search application.
Confidential, Mason,OH
Responsibilities:
- Installed, administered Oracle Application Suite with RAC & SAFS (Shared Application File System) for
- High Availability manufacturing applications.
- Provided cost efficient service delivery providing Oracle EBS and RDBMS installation, configuration, cloning, patching, backup/recovery, license optimizations, hardware consolidation services for multiple business applications.
- Managed Disaster Recovery site for the production environments and perform compliance testing to meet Recovery Time Object (RTO) and Recovery Point Objective (RPO) of E - business suite and various supporting applications.
- Implemented upgrades from 11.5. 10 to 12 .1 and 12.2.4 Oracle Applications.
- Coordinated critical incidents as an IT escalation point for the Business stakeholder under ITIL framework and provided root cause analysis and problem management.
- Shoulder on-call duties to ensure 24x7 availability. Assist team members troubleshoot instance locking sessions, database wait events, batch job failures, space shortage, memory fragmentation, and slow performing queries.
Confidential, Irving, TX
Responsibilities:
- Transitioned as part of Motorola Networks division divestiture, and spearheaded transformation and transition activities of existing database environment to the new company.
- Performed daily activities of configuration and operation of Oracle Applications and Databases that include user security, concurrent requests monitoring, refreshes, clones and export/import jobs and proactive monitoring.
- Supported major incidents involving runaway jobs, database performance issues/deadlocks, annual
- SOX audit requirements and business continuity plans in high availability ERP environment.
- Actively participated in architecture, installation, configuration, quarterly critical patch updates, monitoring, maintenance and version upgrades under Soliaris, Linux with RAC/ASM.
- Implemented parallel concurrent processing, tracing and debugging, defining concurrent managers and concurrent programs, managing database and applications security.
Confidential, Schaumburg, IL
Responsibilities:
- Supported Order Management ERP 12i system, performed installations/clones/refreshes of production, development and test environments.
- Performed feasibility analysis of infrastructure during data center moves that involved hardware and
- OS and database release upgrades.
- Installed and supported daily production operations of three node data warehouse application under
- RAC/Linux platform to support supply chain application.
- Setup OEM monitoring, agents and OMS installation, RMAN backups and Tivoli Alerts for new database installations.
- Created standby databases, and supported daily BCV refresh of production systems for reporting purposes.
Confidential, Phoenix, AZ
Responsibilities:
- Supported all production applications that are part of factory automation software for 7/24 manufacturing environment.
- Successfully integrated database support of another plant that was acquired, with cost savings in licensing and resource utilization.
- Implemented infrastructure for Oracle Advance Queuing and data transformation and extracts between several databases on multiple hardware platforms.
Confidential, Sunnyvale, CA
Responsibilities:
- Actively involved in the Upgrade of Oracle Applications projects (11.0.3 to 11i and 11i version upgrades, RDBMS upgrades under apps) and supported post - upgrade environments.
- Collaborated with developers and end-users in activities such as daily performance monitoring, completing cloning/refresh requests and proactive research of latest patches and follow up of TAR requests with Oracle and subsequent patching as necessary.
Confidential, Phoenix, AZ
Responsibilities:
- Involved in setup of Oracle ERP environment infrastructure, including installation, multiple refreshes and clones of Release 11i Financials, under 8.1.6 and 8.0.6 on Sun Solaris Hardware under 3 - Tier architecture.
- Participated in full implementation of Oracle Financials Suite with over 800 active users and multiple interfaces.
- Managed I2 supply chain database application, involved in creation databases under 8i, for test and production environments and was responsible for data migration and monitoring.