Peter Viola Email & Phone Number

Alphen Aan Den Rijn, Nl

A SaaS-based product, UpToDate is a critical component of the clinical workflow when embedded in today’s electronic health record systems. In fact, 93% of clinicians surveyed say embedding UpToDate in their electronic health record systems is important to patient care, and 91% say it improves clinician satisfaction. As a mission-based organization committed to getting things right, we’re investing in cutting edge healthcare technology solutions to meet the strategic needs of our customers. * Administer, optimize, and support Install, patch and maintain all Oracle Software to help develop a Patch Management and Version Control process. * Perform Database backups and copy using RMAN. * Perform tasks using PL/SQL, Data Pump and SQLLOADER. * Implement and maintain database security (create and maintain users and roles, assign privileges). * Linux Shell Scripting.

Waltham, Ma, Us

Manage broad range of DBA tasks such as creating, tuning, patching, cloning, debugging, upgrading, and implementing recovery/backup (RMAN) strategies in Oracle E-Business Suite Linux environment. • Manage projects individually and as team lead; deliver projects on deadline with zero to limited impact on daily operations.• Partnered with financial stakeholders to devise a Disaster Recovery strategy plan for Oracle E-Business Suite.Representative Projects • Installed Oracle E-Business Suite 12.1.3 on RedHat Linux on 3 VMs; production environment comprised of Oracle database tier version 11.2.0.2, an application tier for E-Business (which runs forms / concurrent managers), and an OID tier for Single Sign On (SSO) and Apex financial reporting. • Installed Oracle 10.1.4 and implemented SSO by registering the E-Business application to leverage Rocket’s Active Directory; enables users to gain access to E-Business application and Apex via Network ID / password.• Oversaw migration from SHA1 certificates to SHA2 certificates; upgraded to latest OracleAS 10g.1.3.x patch set, JDK 7.0 Update, and OracleAS 10g Forms and Reports.• Served as sole Oracle Application DBA on eight-member team; installed / implemented Oracle E-Business Suite 12.1.3:o Project completed seamlessly; went live ahead of schedule.• Implemented the iExpense module by adding two additional external nodes located in a DMZ:o Innovation allows staff to use Oracle Fusion Expense Mobile app without having to VPN into the Rocket network.• Led five-member team in upgrading E-Business Suite’s Oracle database from version 11.2.0.2 to 12c while migrating to Cisco UCS blades running Oracle Linux 7 (which was connected to HDS SAN):o Project resulted in smooth upgrade to a more reliable platform; provided stable environment for future expansion.

Provo, Ut, Us

Ensured the day-to-day functionality and integrity of E-Business Suite and SQL databases, including upgrades, patching, cloning, monitoring, security, backup/restore, and space-related issues. Trained and mentored junior database administrators.• Partnered with project teams to implement any customizations such as modifying or creating stored procedures, database triggers and indexes. • Managed database and SQL tuning, security, and backup and recovery while troubleshooting the production, test, and development database servers.• Automated shell/perl scripts to backup, startup & shutdown, purged archive logs and alerts. • Worked closely with developer and users to troubleshoot issues on daily basis.• Monitored tablespace usage and overall health of database.Representative Projects• Installed Oracle E-Business Suite on SLES9 platform using RapidWiz installer; Shared File System/Application Architecture; Application Teckstack components and 9i Database RAC Clusterware installed in Multi-(5)node. • Conducted DBA tasks on CTP’s internal systems such as PeopleSoft HR, Billing, and Projects, Coda financials, Concur Expense, Evolve Staffing, and a custom-built time entry system. • Performed Oracle database migration from 7.3 to 9i for PeopleSoft Billing and Projects system; migrated database from 7.3 to 8i for PeopleSoft HR system.• Implemented application fixes and updates provided by PeopleSoft; configured PeopleSoft web server, application server and process scheduler.• Provided assistance in upgrading Coda financials, including upgrading Oracle databases from Oracle 7.16 to Oracle 7.3.

South Jordan, Ut, Us

Irvine, California, Us

Aberdeen, Scotland, Gb

Us

London, England, Gb