JOSEPH ELIA

Oracle Exadata Architect / MS SQL Server Admin

HOME

** ***** ***** ******

Hilton, NY 14468

585-***-****

ac6afe@r.postjobfree.com

CAREER

SUMMARY Twenty years work experience in total. Career driven specialties involving troubleshooting database performance issues. Project based experience working with business application development, client/server networking, database administration, requirements management, technical presentation, and database modeling.

SOFTWARE

EXPERTISE Exadata 12c Oracle RAC Architect, designed and implemented 8 node cluster Extensive Experience Architecting Oracle Data Guard replication, database cloning, Rman backups, cluster administration, and support of large scale databases

Strong knowledge of Oracle database administration in Solaris/Linux/Unix/virtual environments.

SAP Basis Admin, Sapinst installation of SAP kernel, Java, Max DB, Central instance Brtools, R3trans, Transports, performance tuning

Subject Matter Expert (SME) For: Exadata Server Admin, Oracle RAC, Oracle ASM, OEM 12c, SQL Tuning, Linux and database upgrades / patching / monitoring.

MS SQL Server 2014 Database Administrator, server builds, Cluster configurations, High availability/Disaster recovery (Clustering, Log Shipping, Mirroring)

BUSINESS

EXPERTISE Requirements Management, (Customer requirements gathering and documentation.)

Performance Monitoring, (Troubleshooting logs files, examining system services)

Oracle Portal Management, (Provided catalog management to sales force, supported portal Oracle Internet Directory)

Server Consolidation, (Upgrading Solaris operating systems, scaling clustering servers to meet business needs)

EDUCATION Roberts Wesleyan College

Organizational Management, Graduated 2012 BS

Monroe Community College

Computer Science, 1992

Professional Career Training

Oracle Enterprise DBA (Backup And Recovery)

Oracle 12C Administration

MS SQL Server 2014 administration

Oracle Workflow Release

SAP Basis Administration

Tibco Business work Administration

Tibco Hawk Administration

Oracle Enterprise DBA Architecture and Administration

Oracle SQL and PL/SQL

Oracle Application System Administration

Oracle 9i Real Application Clustering R2 ED2

Windows NT 4.0 Core technologies

Sun Solaris 2x System Administration SA-235

Sun Perl Programming

Sun Solaris 2x System Administration

WORK

EXPERIENCE

Kodak Alaris Rochester, NY October 2017 – Present

Oracle/MS SQL Server DBA

Installed and configured Oracle Enterprise Manager Grid Control 13.

Developed purging process and collaborated with business partners and development team, to implement data retention policies.

Upgraded over 20 MS SQL Servers from MS SQL Server 2012 to 2016.

Upgraded Oracle databases from 11 to 12c.

Developed troubleshooting and performance tuning procedures for Oracle Database Appliance (ODA)

Provided Strong performance and tuning skills to resolve technical issues in a timely manner.

Implemented Disaster recover procedures utilizing Oracle Data Guard technologies.

Supported MS SQL Server All-ways on servers, in a SharePoint environment.

Provided 24x7 on-call support.

Assisted with deploying Oracle Partitioning to Increase performance, improve availability and Decreases costs.

Provided production Support for 2016 Always-On SQL server databases.

Provided support for 2016 SQL Server databases in Azure.

Sodexo Buffalo, NY Contractor March 2017 -October 2017

Oracle DBA

Maintained the organization's databases across multiple platforms and computing environments

Applied practical understanding of relational database concepts and query languages in order to design required summary of aggregation tables to support analyses.

Collaborated with technology/infrastructure staff to identify data relationships and functional requirements.

Analyzed and resolved issues related to information flow and content.

Maintained database support tools, OEM 13c Grid Control.

Planning, coordination, and administration of database systems, including the database definition, structure, documentation, requirements and disaster recovery.

Engineered Oracle RDBMS upgraded process from 11 to 12c.

Rich Products Corporation July -2009 – February -2017

Senior Oracle DBA

Performing a variety of technical and analytical functions necessary to ensure the availability, integrity, reliability, and serviceability of data for user business needs.

Subject Matter Expert for everything related to Exadata implementation.

Architected Exadata 4 node cluster

Provide comprehensive productive support of all Oracle databases and Exadata Server Administration

Subject Matter Expert for oracle 12c rman backups.

Subject matter expert oracle 12c Exadata grid control, cluster ware, asm and database performance

Upgraded SAP R/3 Oracle Databases from 10.2.0.4 to 11.Through the complete landscape to Production.

Tibco Administrator installed and configured Tibco service bus

Installed and configured MS SQL server 2012 and 2014 on 64 bit Platform.

Responsible for assigning work assignments for Oracle DBA contractors and vendors

Assisted in upgrading SAP BW 3.5 to BW 7.01 and Migrated from HP-UX to Linux ReadHat

Preformed Systems Monitoring and Scheduled backups on MS SQL Servers.

Upgraded SAP BW Oracle Databases from 9i to 10g.

Provided 24/7 on call support for SAP Oracle Databases and SAP logons

Scheduled and ran backups using EMC Networker backup software.

Upgraded Oracle Client software on SAP application servers.

Upgraded SAP BRTOOLS from 6 to 7

Used Brtools to administrate SAP Oracle Database

Preformed many systems copies of Oracle Database from one host to another.

Provided Support for Disaster Recover testing at remote Data center.

Bureau Veritas September- 2008 – July- 2009

Oracle DBA – Contractor

Supported and configured Oracle Advanced Replication

Designed and implemented, Oracle RAC 10gR2 on Red Hat four node clusters

Installed Enterprise Manager 10g Grid Control Release 4 (10.2.0.4). Configured Alarms, RMAN backups, system performance.

Installed ocfs2 on Linux servers

Install and configured Oracle Cluster ware

Configured Oracle ASM on SAN storage

Monitor RMAN backups, Oracle Exports and DBMS Jobs.

Supported Microsoft SQL server

Supported Mysql server

Performed duties of Unix/ Linux Server Administrator

Configured Cisco Load balancing switches.

Scheduled Oracle CPU patches

Xerox Corporation- Contractor September- 2007 – September 2008

Oracle RAC DBA Contractor

Designed and implemented, four Oracle RAC 10gR2 on Red Hat 5 six node clusters.

Configured four terabytes of Storage using Oracle ASM from EMC Storage

Installed Enterprise Manager 10g Grid Control Release 4 (10.2.0.4). Configured Alarms, RMAN backups, system performance

Monitoring for over 50 Production Databases. Installed 10gR4 agents on 50 + UNIX and Red Hat servers.

Providing 24X7 support for production and test systems.

Successfully Upgraded Oracle RDBMS from 9.2.0.1 to 10gr2 on over twenty-production system.

Implemented Disaster and recovery process. For over 10 terabytes of data between three different DR sites.

Provided Outside Customer support for over 50 Million Documents

Using RMAN Repository/ EMC Legato to back over twenty Databases and managing the retention periods.

Homeland Security Buffalo, NY-Contractor October- 2006 – September 2007

Senior Oracle Database Administrator\ Linux Administrator

Installed and Maintained Oracle 10g R2 on over 20 Linux Servers

Provided Technical Support for Homeland Security Enterprise Servers

Evaluated reusability of current data for additional analyses

Conducts data cleaning to rid the system of old, unused, or duplicate data

Performed 24X7 System Monitoring or Oracle Database and Unix Servers

Implemented tape Backup Strategy for Servers and Database

24x7 On-Call production support for over a 20 Databases.

Oracle Competency Center December- 2000 - October -2006

Database Administrator @ Xerox, Rochester NY

Maintain Oracle databases in production and non-production environments.

Participated in a rotational 24x7 On-Call production support for over a terabyte of data

Installed Oracle 9iAS, 9.2 and 8.17 on Sun Solaris and successfully upgraded Oracle 8i databases to Oracle 9i

Supported and administered various advance replication configuration across multiple platforms

Installed & configured Oracle9iAS with OID for centralizing DB access authentication & authorization

Implemented corporate security strategy and business needs through database auditing

Support Oracle Portal/Oracle Internet Directory installations.

Responsible for performance tuning for over 25 Oracle Databases

Helped create an effective Disaster Recovery methodology and automated backup processes

Collaborated with Oracle Support to identify and resolve glitches and errors in Oracle Software

Used TKPROF & STATSPACK to troubleshoot & resolve system wide performance

Oracle Applications (GL, Payable, Receivable, Manufacturing, financials, order management, iStore/iPayment, Purchasing and Supply)

Architected and implemented Cisco Load balancing switches across 20 + Middle tier Sun Servers

2000 – 2004 Provided Solaris UNIX System Administration support for development and test server. For Oracle DBA and Development staff.

Xerox Data Center 1996 – 2000

Unix System Administrator @ Xerox, Rochester NY

Maintained over 50 Sun servers running Sun Solaris (5.6, 5.7,5.8)

Maintained over 25 Intel servers running Microsoft Windows server and Linux

Provided 24x7 support.

Strong knowledge of TCP/IP, NFS, SAMBA and DNS.

Successfully moved over 50 servers from one data center location to another.

Maintained and Supported Server network connectivity in Entire Data center.

Monitored and Preformed Nightly Backups using VERITAS NetBackup.

Architected and Implemented and supported several Compaq multi node cluster servers for Global supply chain.

Configured over 100 plus printers using ldadmin

Worked with Xerox print driver engineers. To develop network spool printing on UNIX and Microsoft servers.

West Group 1994 – 1995

NT Administrator @ West Group, Rochester NY

Helpdesk Support

Provided OS and Oracle Application support for more then one thousand users

REFERENCES Available upon request.

Contact this candidate