Our customer case studies fully demonstrate our practical experience in solving complex customer problems and delivering workable and cost-effective solutions to our clients.

• A Large Manufacturing Company

  A large IW U.S. 500 manufacturing company has established a long-term relationship with EDO Solutions for their remote DBA needs since 2006. EDO Solutions helped this company to implement Enterprise Resource Planning (ERP) solutions using Oracle database 10g as a back-end. Since this company uses this critical production application to keep track of inventories, bill of materials, sales orders, material requirements planning (MRP), jobs scheduling, purchasing, GL, accounts receivable/payable & etc., the database performance and availability is very important. In addition to proactively monitoring and managing the database, we have helped implementing and managing Oracle Data Guard in a remote site as a disaster recovery solution. EDO Solutions also kept the Oracle database up-to-date by proactively applying patches and upgrades. In 2010, EDO Solutions successfully upgraded the production Oracle database from 10g to 11g with minimum downtime. By using EDO Solutions’ remote DBA services, this company achieved high production performance and availability with significantly reduced operating costs.

• A Regional Hospital

  This is a third-party vendor application that is driven by Microsoft SQL Server 2008 with active/passive cluster architecture running on VMware ESXi virtualization platform. EDO Solutions worked with the vendor to review the database and private cloud implementation from server hardware and OS performance, ESXi server implementation, SQL Server configuration, database configuration, index maintenance, SQL Server jobs to SQL profiler and long running queries analysis. EDO Solutions quickly identified issues and presented key findings and recommendations to the third party software vendor. After implementing the database performance tuning fixes that EDO Solutions recommended, the application performance had been dramatically improved. Since then, this hospital has been engaged with EDO Solutions to provide remote DBA services for all its Microsoft SQL Server and Oracle production and non-production databases for the entire hospital.

• A Global Wholesale Trading Company

  EDO Solutions has been partnering with an online wholesale trading company for more than a decade. EDO Solutions helped this company implement and manage the online trading database system using Oracle 8 via our remote DBA services. With the growth of the business, the demands of OLTP type of transactions had been getting higher every day. EDO Solutions constantly tuned and managed the database to keep up with the fast growing demands. In 2005 this company decided to move to open source technologies. EDO Solutions helped this company migrate from Oracle 8 to MySQL 4.1, and also implemented MySQL replication as a disaster recovery solution. Since 2005, EDO Solutions has helped this company to manage the MySQL production trading database with high performance and minimum downtime. EDO Solutions has also been keeping the database up-to-date via periodically patching and upgrades. In 2015, EDO Solutions helped this company to move all its IT operations from its own data center to Amazon Web Services (AWS). Under EDO Solutions’ remote DBA and cloud computing services, this company has experienced fast growth and huge success from its beginnings as a startup company to a global social network for wholesale trading, with over 42,000 B2B wholesalers from 79 countries today. This company will continue to partner with EDO Solutions and overcome tomorrow’s challenges.

• A Mid-Sized Manufacturing Company

  EDO Solutions provided remote DBA services to a mid-sized manufacturing company starting more than a decade ago. EDO Solutions helped this company design and implement a complex in-house manufacturing application using Oracle 8 and Oracle Forms and Reports 6i. To meet the needs of changing business requirements and emerging technologies, EDO Solutions has been proactively recommending new solutions and supporting the implementation of new business processes via new technologies over these years. While keeping production up-time is a top priority, EDO Solutions has successfully upgraded the production database from Oracle 8 to 10g, 11g, and then to 12c. In 2009, EDO Solutions helped this company implement a private cloud infrastructure using VMware, which significantly reduced hardware and on-going maintenance cost. In 2014, EDO Solutions helped this company implement Oracle Application Express (APEX) architecture and upgraded the legacy Oracle Forms and Reports 6i applications to the robust APEX platform. This company will continue to utilize EDO Solutions’ remote DBA and cloud computing consulting services to meet their changing business needs.

• An International Manufacturing Company

  In 2013, a global shoe manufacturing company engaged EDO Solutions to design and implement a web-based manufacturing business intelligent system to provide international collaboration on data collection, reporting and analytic. This system covers areas of workforce management and environment control management. The workforce management model includes functional areas of work hours, wage, benefits, injuries, and accidents. The environment control management model includes functional areas of energy use, water use and waste water discharge, waste and hazardous waste, chemical use and air emissions. Backed by our unrivaled industry knowledge and technology expertise, EDO Solutions completed the architecture design and software development based on the business requirements in time on budget. EDO Solutions will continue to partner with this company to improve this enterprise management solution which will truly transform the way that this company conducts the global manufacturing analytical practice.