JOSEPH ELIA
Oracle Exadata Architect / MS SQL Server Admin
HOME
Hilton, NY 14468
*******@*****.***
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.