Resume

Sign in

Oracle apps DBA

Location:
Greenbelt, Maryland, United States
Posted:
December 17, 2018

Contact this candidate

Resume:

Juan C Navas

ac7zvz@r.postjobfree.com

708-***-****

Professional Summary:

Oracle Certified Professional (OCP) with over 15+ years of experience: responsible for the design, architecture and setup of databases including documentation, optimization and tuning. Experience installing, upgrading, configuring, and supporting: Oracle RAC/Grid Control/ASM/Data Guard/OBIEE 11.1.1.7/Oracle WebLogic Server 11g-12c/OEM Grid Control. 15 + years of E-Business Suite Application (Versions 10.6 through 12.1.3): Concurrent manager setup/optimization, performance tuning, minor/major/version upgrades, application patching, and HA Setup.

Key Strengths Include:

Leadership skills: Manage, mentor and lead offshore/onshore DBAs in order to complete Projects, Clones, Non-production, and production queues. Ensure deadlines are met and group maintains a world class IT Service. A self-motivated, responsible, and reliable team leader with a set of very strong technical, project management, and people skills.

Auditing: Audit compliance, and monitor data security with strict adherence to change management, release management, industry standards and best practices.

Project management: Managed upgrade of E-Business Applications from 11.5.2. to 11.5.9 and from 11.5.9 to 11.5.10.2 at Panduit. At USG managed 12.1.2 EBS upgrade to 12.1.3. Lead the project to upgrade of all databases from 10g to 11.2.0.4. Responsible for Analyze, Design, Build, Test and Production stages of the implementations.

Process Improvements and Tuning: Excellent tuning experience using explain plan, SQL Trace, AWR, ADDM, SGA tuning, SQL Tuning Advisor, Compression, SQL Plan, and Tuning of initialization parameters.

Backup and Recovery: Designed, tested, and extensively documented Hot, Cold backups, Duplicate Clones, Restore and Recovery procedures using scripts (crontab), RMAN, OMNIBACK, Data Protector, and Seagate Backup Exec for Oracle database versions 7 through 12c.

Experience:

Real Estate Investing/Semi-Retired 3/17 to present

Purchase properties in the Maryland area for remodeling and rental potential

DELOITTE LLC

Specialist Senior 1/16 to 2/17

Data Warehouse, Senior E-Business Applications DBA, Subject Matter Expert (OEM, E-Biz Application, and Core DBA 12c-10g)

Cloned development databases on a regular basis using Export/Import datapump, and RMAN.

Upgraded 11g to 12c databases, patched CPU, and critical patches on Sun Solaris

Daily 24/7 on-call critical production DBA support

Performance tuning ETL jobs in order to improve overall batch times by over 3 hours for EOY jobs

Utilized parallel hints, memory keep area, partitions, SQL tuning, index creation, Oracle provided tools(AWR, ASH, ADDM, OEM 11g) in order to improve OLTP and batch job response time.

USG Corp

Senior Oracle Database Administrator 02/10 to 10/2015

Senior E-Business Applications DBA, Release Lead DBA, Offshore Lead DBA, Subject Matter Expert (OEM, E-Biz Application, and SSO/Discoverer, Core DBA 12c-10g)

Offshore DBA supervisor (Staff of 4 Senior Oracle DBA's in India) responsible for Production support ticketing administrator, and Non-Production Requests. Duties include: Daily to-do list, Project management, cloning scheduling with other groups, and resource allocation.

Manage USG Mexico E-Business Support making sure that any issues are addressed and resolve. Meeting and communication done in Spanish.

Production Senior Apps DBA responsible for all aspects of mission Critical Multi-Terabyte-24x7 RAC Oracle E-Business Suites (12.1.3/11R2) with over 3000 concurrent users, in a Multi-node HA environment. Capacity Planning, Database Security, CPU Patch Maintenance, HA, RDMS Upgrades, SSL setup, NLS (Languages) support, Performance Tuning and Monitoring.

Upgraded mission critical 11.5.9 multi-language E-Business Suite to version 12.1.2 E-Business as part of a multi-year project, and upgrade from version 12.1.2 to 12.1.3 upgrade, post-upgrade patches, HA setup, and server standardization.

In charge of Major and Minor Releases as Lead Release DBA. Duties include: scheduling, patch analysis, Project Planning, DBA resource allocation planning and interacting with all departments.

Upgrade Application Server 10g from 1.2.2 to 1.4.3. Upgrade involved SSO/OID for the Infrastructure and Discoverer in the Middle-Tier. Setup SSO for E-Business and Demantra databases.

Setup and implemented HA setup using Load balancer for both multi-node applications and Multi-node databases.

Created users, assigning appropriate roles, privileges to users depending on the user activity and auditing of database.

Involved in Disaster recovery testing to ensure 100% data recovery in the event of failures.

Designed and implemented Maximum Availability Solutions using: Data Guard Fast-Start Failover, and Flashback for several mission critical databases. Created over 10 Physical Standby databases.

Installed and configured Informatica, Get PAID, Demantra, Oracle APEX, and Vertex O Series Tax module.

Saved over 500 Gigs of space using online, offline re-org, table compression and table partition.

Panduit Corp

Senior Database Administrator and Senior Apps Dba 1998 to 2010

Senior Apps DBA for Oracle E-business Suite, Oracle 9i-10g, Application Server, and Microsoft SQL Server

Production Senior Apps DBA responsible for all aspects of mission Critical a 3 Terabyte-24x7 Oracle E-Business Suites (11.5.10.2/10.2.0.4). Capacity Planning, Database Security, CPU Patch Maintenance, Concurrent Managers setup, rdbms Upgrades, SSL Setup, NLS (Languages) support, Performance Tuning and Monitoring.

As Lead DBA: Upgraded E-Business Applications from 11.5.2. To 11.5.9 and from 11.5.9 to 11.5.10.2. Learned in a short time new database parameters, modules, products, and applications. Oracle is constantly adding new functionality to all its products which necessitates the installation of new releases and constant upgrades.

Shown over twelve years the ability to work with the DBAs and applications groups until any critical issue has been resolved by working with Oracle support, applying emergency patches and doing in-depth research to solve Severity 1 issues. During my tenure Panduit, the dba group never missed a project deadline or delay of any Applications group rollout implementation.

Troubleshooting expertise for all tiers (Apache, Forms, Concurrent, Admin, JInitiator and database). Upgraded the JDK Java virtual Machine from 1.3.1 to 1.4.2 to 1.5, JRE/JInitiator (1.3.1.21), forms Patchset 18 and all application teckstack components.

Configured APPWORX for DBA jobs, lock notification/resolution, running-out of space alerts, runaway tasks, and event driven scripting (sh&ksh).

Main DBA for Panduit's 10g mission critical Website database (Hot cloning, backups, security, standby database, performance monitoring and capacity planning).

MS SQL Server Administrator (7-2005) for mission critical: SharePoint, MS Project, VMI software, and Website. Designed and implemented High Availability solutions for SQL Server such as Log Shipping and Database Mirroring.

As E-Business system administrator configured: workflow mailer, Site profiles, weekly purge jobs, installed printers, created users, setup tracing, created multiple JVM's, setup Concurrent Manager queues, and gather schema statistics jobs in order to improve performance.

Setup and installed Oracle Applications server for EDI and proxy SSL.

Maintained, upgraded and optimized several Production Oracle 8I, 9I Linux/ NT databases, Oracle Middle Tier (iAS), and key SQL Server 7.0 databases (Panduit's 24/7 On-line Catalog, and Web Site) Created the database, tables, tablespaces, data objects, setting privileges, indexes, user login, passwords (security).

Applied thousands of patches, minipacks and family packs to the 11i production application and to cloned development instances. Some of the patch issues include: Payroll Quarterly patches, monthly Quantum, AP, AR, FA, GL, FORMS, Critical Patch Upgrades (security) and other 11i modules. Patch application has taken place over the weekend, holidays, and during weekdays at every hour of the day and night.

Installed, upgraded and maintained mission critical high visibility CRM (11.5.10.2/9.2.0.8), and Demand Planning (11.5.10.2/9.2.0.8) specific 11i E-Business Suites Instances.

Technology Skills:

Platforms: Sun Solaris, UNIX HP 11.x, Red Hat Linux, NT, Windows 2000-2003, and XP: OMNIBACK II, Glance, SAM, KORN SHELL, AWK, VI editor, PICO, DOS, and nedit.

Oracle: Database 12c, 11g, 10g, 9i, 8i, and 7.3.4, Statpack, Discoverer Viewer (Install, Upgrade), Oracle Streams, Transportable tablespaces, ASM, RAC, SQLPLUS, Export/Import Data Pump, SQL Developer, SQLOADER, TKPROF, RMAN, MWA Server setup, and Oracle Enterprise Manager.

Capacity Planning, Disaster Recovery, Performance Tuning and E-Business Suites (11.5.9/11.5.5/11.5.10.2/12.1.3) as Senior Oracle Applications and Core DBA.

APPWORX scheduling job software for DB monitoring and running.

QUEST: TOAD, Spotlight, and Space Manager.

NT 4.0, WINDOWS 2000: Master level Excel, Macros, SQL Editor, MS Access, Paradox, Internet, Desktop management, Networks, Extensive DASD management, Oracle Services, Register maintenance, NOTEPAD Programming.

Oracle VM: Oracle Linux Installations and setup.

SQL Server 7.0/2000/2005: Enterprise manager, Maintenance plans, cloning, backup and recovery.

Merant Version Manager (PVC) and Management Center (HPPM) for File, and script version management.

Exceptional Documentation skills. Written over 100 handbooks, release documentation, and upgrade to ensure that standards are followed.

Extensive use of Crontab in UNIX environment for scheduling routine tasks. Excellent Shell scripting, database monitoring and alerting; data reporting.

Education:

University of Miami Coral Gables, Florida

Master Degree in Business Administration Dec 1997

Major in Finance and International Business

Florida International University Miami, Florida

Bachelor's degree in Business Administration Dec 1992

Major in Finance and International Business

Oracle University Chicago, Illinois

Oracle Database Administrator Courses 1999-2016

Oracle Database 12c: New Features for Administrators, Data Integration and ETL with Oracle Warehouse Builder, RAC Administration, Backup and Recovery, Net Service, Managing Oracle on Linux, Oracle 9i Database: New Features for Administrators, 11g Grid Control

Training, Certifications, and Awards:

Oracle Certified Professional (OCP)

USG 2014 VIP Award winner

Languages: Spanish



Contact this candidate