Ray Gill Email & Phone Number

Portland, Or, Us

Translating business requirements into technical specifications, including data streams, integrations, transformations, databases, and data warehouses.Defining the data architecture framework, standards, and principles, including modeling, metadata and security.Defining reference architecture, which is a pattern others can follow to create and improve data systems.Defining data flows, i.e., which parts of the organization generate data, which require data to function, how data flows are managed, and how data changes in transition.Collaborating and coordinating with multiple departments, stakeholders, partners, and external vendors.Build proof of concept solutions using the latest in data and database technologies.

Chicago, Il, Us

Responsible for the vision that underlies the solution and the execution of that vision into the solution from the backend that represents the business information systems. By driving collaboration, transparency, and productivity throughout the entire software delivery and incident management lifecycle. Dedicated to continuous improvement, the delivery of reliable services, and focused on the true value behind a DevOps culture. Adopt and migrate to Adobe Experience Platform to leverage Unified Profile Matching for customers through our in-house built Customer Data Platform (CDP)- Successfully developed a pipeline of continuous delivery and releases through the use of Docker containers to allow our product development teams to accurately test their development efforts. This included building up Oracle, MySQL and MongoDB instances within the containers and being deployed on AWS.- Worked with clients and the business to transform data from Oracle to Adobe’s proprietary database technology and Sales Force’s proprietary database technology through the use of developing a new data model. - Worked with Adobe on Experience Platform and successfully developed a proof of concept to showcase Unified Profile Matching Algorithms- Worked with Account Managers and Business Units to help transform data requirements into data solutions through thorough data analysis and gathering.- Managed and coordinated all database releases along with managing all database environments for the full development lifecycle.

Chicago, Il, Us

We define ourselves by a better caliber of technology, insights and services that help our clients get to ‘YES’ sooner with their customers. We boast a complete portfolio of multi channel marketing solutions and tools, including interactive marketing applications, data management, data intelligence, lead generation, and best practices consulting.- Managed efforts for ITIL implementation with best practices in mind. Designed workflow lanes which assisted the implementation team in correctly designing the ITIL process for Yesmail. Frameworks included- ITIL Service Strategy: Understands organizational objectives and customer needs. - ITIL Service Design: Turns the service strategy into a plan for delivering the business objectives. - ITIL Service Transition: Develops and improves capabilities for introducing new services into supported environments. - ITIL Service Operation: Manages services in supported environments. - ITIL Continual Service Improvement: Achieves services incremental and large-scale improvements. - Designed first Enterprise System Map Topology which outlines the current platform and all the components it communicates with.- Led Business Impact Analysis for Premium clients.

Chicago, Il, Us

Supported Oracle 11g, SQL Server 2005, and 2008 databases. Troubleshot several database issues ranging from performance to space utilization and server issues. Partnered with business units to resolve daily issues regarding SQL tuning, performance bench marking. Forged relationships with different groups to enhance customer relations and ensure operational duties are delivered and met with accordance to service level agreements. Coordinated and led efforts for ITIL tool implementation. Designed workflow lanes which assisted the implementation team in correctly designing the ITIL process for Yesmail. Assisted with Business Impact Analysis for Premium clients

Bangalore, Karnataka, In

Leading a team a team of 15 Oracle DBA's and 7 MS SQL DBA's for Operational Support of our Client Nike Inc.

Open to new contract and full-time opportunities with a great and reputable organization. With my consulting background mixed with Oracle database administration experiences for the past 10 years, I am the ideal candidate for your team.

Oakville, Ontario, Ca

• Successfully managed several projects and delivered on time and on budget.• Managed DBA’s time and projects through internal time tracking system. Managed time vs. budget to accurately predict if we could meet our project timelines.• Built relationships with internal customers and external customers as well as vendors. With this open relationship we managed successfully to implement several key changes into the production systems without downtime to the business as well as implement new business requirements without hesitation.• Coached and mentored DBA’s and delegated roles and responsibilities on a daily basis.• Administered and managed Oracle databases ranging in versions for Production, Development and Test environments. Databases releases included:• Oracle 9iR2, 10gR1, 11gR1 & 11gR2, 12c for Oracle Enterprise Manager, SQLServer 2005, 2008 & 2012• Supported platforms included: Solaris 9 & Solaris 10, RHEL 5Major Projects included:• Active Batch migration from AutoSys: Migrated from AutoSys, a UNIX based application to schedule various user-defined jobs and batches to a Integrated Enterprise Scheduler. Jobs included RMAN backup jobs, Stats gathering jobs, monitoring jobs as well Application Batch jobs.• Data Center Migration: Upgraded from Solaris 9, 2 Node RAC to Solaris 10 4 node RAC using Solaris Zones. Migrated from Raleigh, NC datacenter and Lynchburg, VA datacenter to Blythewood, SC datacenter• Database Upgrades: Upgrades were performed on databases running versions 9iR2 and 10gR2 to 11gR2. Upgraded Oracle Enterprise Manager from OEM 10g to OEM 12c• Implementation of GoldenGate for Oracle: Implemented GoldenGate for Oracle on our primary Production Oracle Database to replicate real time data to our new datacenter. Replication was setup from Oracle 9iR2 to Oracle 11gR2.• Setup monitoring daily to ensure data movement was successful and data was replication was accurate

Toronto, Ontario, Ca

• Supported Oracle 10g, 11g, SQL Server 2005, 2008 databases• Managed backups for Oracle databases. Backup methods included Cold, Hot and RMAN• Led the efforts to design a new backup and recovery strategy using Oracle’s Point In Time Recovery Methodology with RMAN• Developed several PL/SQL scripts along with Windows scripts to monitor database metrics, performance and space utilization• Worked with Business Units to resolve day to day issues with respect to security, SQL tuning and performance bench marking• Managed all environments through Oracle’s OEM GRID control

Boston, Ma, Us

• Supported different flavors of databases in Production, Development and Test environments. Databases Included: Oracle versions ranging from 8i to 10gR2 (32bit and 64 bit), Beta Tested 11gR1. Databases were running on Sun SPARC 64 bit and IBM AIX 32 bit & 64 bit. IBM DB2 and DB2 UDB versions ranging from 8 to 9 and Control Center, Windows bases.• Projects included: Architecting Data Marts and OLTP environments, Performance and Tuning from Oracle server side and front end SQL, Building Parallelization for application support.• Member of the Advisory Committee for Information Technologies where analysis of business requirements were performed and recommend possible scenario’s to achieve to the end user and deliver a sound solution• Recommended to the team new technologies within Oracle that could help minimize overall execution time in there processes.• Introduced the team to Oracle’s Data Pump over traditional Import/Export. Results saved them an overall 6 hours of time.• Developed several PL/SQL scripts along with Unix Shell scripts to monitor database metrics, performance and space utilization• Managed backups for Oracle databases. Backup methods included Cold, Hot and RMAN• Supported SIEBEL ERP Application by Oracle (Version 8i with migration set for Q2 to 10gR2)• Day to day activities included: Database monitoring which included responding to alerts and notices and reviewing database health’s every morning, Executed Change Management activities which end users submitted through IBM’s CQIM Change Management Tool and troubleshooted several spectrum of database issues ranging from performance to space utilization as well as server issues.

Houston, Tx, Us

• Developed Project Plans for team members to execute• Oversee milestones and ensure all goal are met in a timely manner• Understand my teams goals and objectives and try to achieve them any way possible• Executed Performance Evaluation reviews• Worked extensively with the sales team to define and develop specialized service offerings in Oracle and Business Intelligence / Capacity Planning moving the practice beyond the database only realm. Resulted in a practice growth from 4 consultants to 12• Leveraged our knowledge, volume and relationships to assist clients in saving millions in infrastructure costs, which lead to increased sales with existing and new clients due to strong performance and excellent references• Consulted with client management team on implementing best practices for data management, backup and recovery, database security and capacity planning / forecasting• Helped Develop Service Delivery Management Framework which enabled us to develop a "Charge Back" Model. Provided robust delivery channels utilizing existing tools and capabilitiesModeled, benchmarked, tested and published SLA’s and OLA’s to Executive Management before making it operational

Houston, Tx, Us

Engagement Highlights while employed with Sungard Global Services:ELM Resources - http://www.elmresources.com – Oracle RAC Migration to 11g Project• Managed and Lead a team of 2 Oracle SME’s and 1 System Administrator• Managed and Organized day to day tasks and approved all work through time and material• Approved all Service Requests from ticketing system and managed teams time• Provided upper management with weekly statuses reports and overall health of the project• Reduced the overall project time line by 15% to delivered a solution 3 weeks ahead of schedule• Implemented Oracle OEM GRID Control and educated client on best “How-To” practices when engaging with tool• Architected and designed Oracle 10g RAC (3 Node) Environment to 11g Oracle 2 Node RAC Environment with Active DataGaurd, RMAN solution as well as one design without Active DataGaurd. Overall size of environment was 6 TB’s• Followed Oracle’s Maximum High Availability Methodology• Client opted to go without Active DataGaurd, thus resulting in a savings of $25,000• Developed Design and Implementation document (300 pages) for our client which illustrated the current environment and future proposed environments and architecture with complete install guidelines and setup instructions. Document was eventually published as a companywide standard document for Oracle RAC implementations on AIX systems

Houston, Tx, Us

Engagement Highlights while employed with Sungard Global Services:KAISER PERMANENTE - http://www.kp.org - Analytical Center of Excellence Project• Managed and Lead a team of 1 Oracle SME’s and 1 System Administrator• Managed Teams priorities with the latest technical issues as well as new client requests• Prepared weekly status reports based upon teams daily status report which were due to me at the close of business every working day.• Team Member of the Enterprise Capacity Planning Team and helped architect a solution called “Analytical Center of Excellence”. This was a Data Warehouse and Capacity Planning solution for our client with full Capacity Management and Performance Monitoring Capabilities with OLAP design built with TeamQuest• Successfully worked with Technical & Business Project Managers in defining System Level Metrics and mapping them to Business Level Metrics for Oracle, Business Objects, Cognos and SAS. • Provided input from an Oracle expertise to help define and construct System Level Agreements (SLA’s) and Operational Level Agreements (OLA’s). • Established and implemented monitoring and KPI requirements required for production environments and verified that they were are achieved adequately

Houston, Tx, Us

Engagement Highlights while employed with Sungard Global Services:KAISER PERMANENTE - http://www.kp.org - TeraData to Oracle Migration Project• Managed and Lead a team of 2 Oracle SME’s, 1 System Administrator, 1 Network Consultant, 1 Disaster Recovery Consultant• Track Lead for all Non-Business ETL and Business Intelligence migrations. Reviewed and delivered all ETL processes with respect to Informatica and AbInitio and mapped them to Business Processes.• Prepared weekly status reports based upon teams daily status report which were due to me at the close of business every working day.• Assisted my team in identifying the problem at the root of several technical issues • Architected Oracle Database Migration from TeraData database systems to Oracle 10gR2 RAC (4 Node). Size of Pilot was 1.5TB’s. Overall migration was 300TB’s

Wayne, Pa, Us

• Managed and Lead a team of 4 Oracle SME’s for our new development efforts• Conducted several technical and non-technical interviews for potential candidates to be hired by SunGard iWORKS• Executed teams Performance Evaluation reviews and submitted them to my director and Human Resources Manager• Engaged with client & internal executives to understand business requirements and help translate them into technical results• Provided quarterly database health Metrics which outlined the health of the database to executive management• Coordinated the successful implementation of several key projects involving the release of the Frontier & GBAS (iWORKS) Product to clients with a new Oracle Infrastructure Engagement Highlights:GBAS - http://www.sungard.com/iworksgbas/ - Oracle Migration Project from Legacy Application• Managed and Lead a team of 1 Oracle SME’s, 1 Developer • Assisting in deploying Oracle database solutions to Sungard’s Insurance clients with the Frontier & GBAS (iWORKS) Application. Versions of Oracle were 8i to 10gR2• Completed migration tasks on Frontier & GBAS (iWORKS) application which was originally built using Progress OpenEdge Database while most clients were using Oracle• Successfully launched the following program in Test and Dev Environment. Oracle 11g on Enterprise Linux for Oracle was being tested for deployment using new version of the Frontier & GBAS (iWORKS) Application (iWorks Studio) for the US market. Looking to launch into Production Q4 of 2008 pending upon Oracle certifying the support• Managed production rollout for our Houston, TX Division where we have 4 early-adopters ready to use our new application that has been reconfigured from a database/schema level for which I led the team and effort

Global, Us

• Responsible for administering 32 Oracle databases ranging from Oracle 7.3.4 to 9.2.0.7 on SunOS, HP-UX and Linux and backed up 19 Oracle databases ranging from Oracle 8.1.7.4 to 9.2.0.7.• Provided quarterly database health Metrics which outlined the health of the database to executive management• Supported 11 Oracle production instances that were 24 x 7 and SOX Compliant. Ensured all security measures were in place for developers not to use production systems• Member of the Oracle 10g implementation Team. 10g Upgrades started Jan. 2007 • Documented all database changes before implementing into UAT or Test Environment and then into Production • Supported Developers with application code debugging, SQL tuning, data modeling, schema management, snapshot replication and materialized views• Tuned SQL queries for Application Development Team and Applied Oracle Security Patches to all databases that were in scope• Performed database recoveries due to hardware media loss, instance failure, user error and statement failure.

Us

• Managed and Lead a team of 1 Oracle SME’s, 3 Database Developers, 1 Reports designer and 1 Junior Oracle DBA • Engaged with Department of Defense (D.O.D. & internal executives to understand business requirements and help translate them into technical results• Developed Initial Project Plan for my development team to execute and follow through• Provided quarterly database health Metrics which outlined the health of the database to executive management• Installed Oracle 9i Release 2 on HP-UX and Sun Solaris and applied Oracle Security Patches regularly• Tested and implemented various RMAN and user-managed backup & recovery methods to best suit 24x7 operations. Created shell scripts on HP-UX with the assistance of the Unix Administrator and Senior DBA from vendor side• Developed Oracle Label Security strategy with legacy applications that involved different nationalities and organizations • Worked with the Oracle E-Business production DBA’s to solve performance issues with legacy application • Interfaced with ILAP Army applications in the Pentagon to send XML data for integration• Consultant to TACOM (Tank and Command Center for Pentagon) for General Dynamics Land Systems representing the DMIS Application• Designed and developed DMIS (Data Management Information System) database in Oracle and MS Access to track the maintenance of military defense products. DMIS is currently used by the several militaries around the world• Created Data Models and Data Architectural designs for Oracle using Erwin Data Modeler and Embarcadero ER/Studio• Performed Backup and Recovery solutions for Oracle Development Server• Project Highlights: Redesigned DMIS 3.1 into DMIS 4.0 to meet Database standards recognized by the business using Waterfall Methodology. Integrated many legacy Database systems into DMIS both internal and external. Designed and analyzed current processes & procedures to create a Gap Analysis for increasing productivity