Ray Gill

Ray Gill Email and Phone Number

Lead Enterprise Data Architect @ Jama Software
135 SW Taylor St. #200 Portland, Oregon 97204
Ray Gill's Location
Portland, Oregon, United States, United States
Ray Gill's Contact Details
About Ray Gill

Having been exposed to such great and innovative organizations from the start, I have been able to educate myself with different industry best practices. After contributing to the growth and success of five different organizations in the past 15 years, I am seeking new challenges. Challenges and opportunities that can really excite me and allow me to provide effective leadership to a team and organization. My experiences encompasses project management, strategic planning, resource utilization, revenue growth, and cost reduction. My ability to analyze needs and create unique solutions designed to yield a successful outcome has proven to be one of my greatest assets. With my consulting background, I have been responsible for teams as large as 23. Delivering on milestones and being results-driven are key components when leading a team and delivering a solution. Managing ones time and responsibilities can prove to be overwhelming, however as a mentor and coach, I have successfully been able to deliver on all my projects and implementations on time and on budget. Managing several key projects at once with my team proved to be awarding and fulfilling. Building relationships with internal and external customers is a skill I derived from my consulting background. As a Enterprise Data and Database Architect, I have been privileged to work with many various technologies including Oracle, GoldenGate, ArangoDB MySQL to name a few. Successfully delivered on several key projects including data center migrations, data center upgrades and database upgrades.I know that my proven leadership skills, strong commitment to high ethical and professional standards, and flexibility in devising proactive responses to evolving customers and vendors would allow me to make a significant contribution to any team.

Ray Gill's Current Company Details
Jama Software

Jama Software

View
Lead Enterprise Data Architect
135 SW Taylor St. #200 Portland, Oregon 97204
Website:
jamasoftware.com
Ray Gill Work Experience Details
  • Jama Software
    Enterprise Data Architect
    Jama Software Nov 2019 - Present
    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.
  • Yes Marketing
    Lead Database Architect, Manager, Devops
    Yes Marketing Jan 2017 - Oct 2019
    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.
  • Yes Marketing
    Manager, It Operations, Enterprise Reliablity
    Yes Marketing May 2015 - Jan 2017
    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.
  • Yes Marketing
    Senior Database Administrator
    Yes Marketing Dec 2013 - May 2015
    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
  • Infosys
    Team Manager, Platform Dba Team
    Infosys Jan 2013 - Dec 2013
    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.
  • Precise Data Management Consulting Services
    Principal Oracle Architect & Dba
    Precise Data Management Consulting Services Sep 2010 - Dec 2013
    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.
  • Genworth Financial Canada
    Senior Lead Oracle Dba
    Genworth Financial Canada Aug 2010 - Sep 2012
    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
  • Ontario Teachers' Pension Plan
    Senior Database Administrator
    Ontario Teachers' Pension Plan Feb 2010 - Aug 2010
    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
  • John Hancock Life Insurance Company (U.S.A.)
    Oracle Solutions Architect Consultant And Senior Database Administrator
    John Hancock Life Insurance Company (U.S.A.) Sep 2009 - Feb 2010
    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.
  • Sungard Global Services
    Team Lead - Oracle Solutions Architect Consultant And Senior Database Administrator
    Sungard Global Services Aug 2008 - Sep 2009
    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
  • Sungard Global Services
    Team Lead - Oracle Solutions Architect Consultant And Senior Database Administrator
    Sungard Global Services Aug 2008 - Sep 2009
    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
  • Sungard Global Services
    Team Lead - Oracle Solutions Architect Consultant And Senior Database Administrator
    Sungard Global Services Aug 2008 - Sep 2009
    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
  • Sungard Global Services
    Team Lead - Oracle Solutions Architect Consultant And Senior Database Administrator
    Sungard Global Services Aug 2008 - Sep 2009
    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
  • Sungard Financial Systems
    Lead Senior Oracle Senior Database Administrator / Oracle Solutions Architect Consultant
    Sungard Financial Systems Feb 2007 - Apr 2008
    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
  • Csc
    Oracle Dba For Nortel Networks
    Csc 2005 - 2007
    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.
  • General Dynamics Land Systems
    Oracle Database Administrator, Project Team Lead
    General Dynamics Land Systems Apr 2002 - Nov 2005
    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

Ray Gill Skills

Sql Oracle Rac Database Administration Consulting Goldengate Activebatch Solaris 8/9/10 Unix Unix Shell Scripting Linux Oracle Sql Oracle Enterprise Manager Leadership Technical Leadership Team Leadership Data Center Data Migration Oracle Data Warehousing Disaster Recovery Solaris Pl/sql Red Hat Linux Performance Tuning Erwin Shell Scripting Sql Tuning High Availability Rman Cluster Databases Aix Microsoft Sql Server Data Guard Toad Replication Hp Ux Xml Business Intelligence Integration Data Modeling Db2 Requirements Analysis

Ray Gill Education Details

  • Sheridan College
    Sheridan College
    Data Modeling/Warehousing And Database Administration

Frequently Asked Questions about Ray Gill

What company does Ray Gill work for?

Ray Gill works for Jama Software

What is Ray Gill's role at the current company?

Ray Gill's current role is Lead Enterprise Data Architect.

What is Ray Gill's email address?

Ray Gill's email address is ra****@****ail.com

What is Ray Gill's direct phone number?

Ray Gill's direct phone number is +150341*****

What schools did Ray Gill attend?

Ray Gill attended Sheridan College.

What skills is Ray Gill known for?

Ray Gill has skills like Sql, Oracle Rac, Database Administration, Consulting, Goldengate, Activebatch, Solaris 8/9/10, Unix, Unix Shell Scripting, Linux, Oracle Sql, Oracle Enterprise Manager.

Who are Ray Gill's colleagues?

Ray Gill's colleagues are Cooper Graham, Katie H., Cooper Morrow, Piush Jamra, Clemens Ruf, Nick Mchale, Matt Mickle.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.