- SG: +65 64383504
- IN: 022 25771219
- IN: 022 25792714
- IN: +91 9987536436
The Philippine Stock Exchange (PSE) is the only stock exchange in the Philippines. It is one of the oldest stock exchanges in Asia, having operated continuously since the establishment of the Manila Stock Exchange in 1927. It currently maintains two trading floors — one at the PSE Centre (Tektite), Ortigas Center in Pasig City, and one at its principal office at the Ayala Tower One in Makati City’s Central Business District. The PSE is composed of a 15‐person Board of Directors. Trading in the PSE is a continuous session from 9:30 am to 3:30 pm daily.
The PSE selected NASDAQ as its new service provider for the Exchange’s trading engine in July 2014. NASDAQ deployed its X-Stream Trading System (XTS) to the PSE to replace the NSC trading system provided by NYSE Euronext Technologies SAS. The new trading system, called the PSETrade XTS, is being developed with enhanced trading capacity and increased risk management parameters in line with PSE’s overall strategy of introducing more products and services to the market. The backend RDBMS for PSETrade XTS was PostgreSQL, which was relatively new for PSE. With this situation, it was imperative for PSE to get their team trained on the new trading platform to make ensure efficient handling of daily chores for the production server.
Also, the client sought a trusted solution provider for its PostgreSQL support and implementation with optimal settings. Ashnik, a Master Partner to EnterpriseDB in the South East Asia region, extends its solutions, services and training services on Postgres and other EnterpriseDB products to its customers through local partners – IT Group being the preferred partner in Philippines. Ashnik has extensive consulting experience with certified PostgreSQL professionals, as well as experience in hosting numerous public and corporate batch trainings for PostgreSQL. Additionally, IT Group’s local presence in Philippines, made Ashnik the right choice of solution support and training provider for PSE. PSE thus chose to procure EnterpriseDB supported PostgreSQL subscription and engage with IT Group and Ashnik for implementation and training of PostgreSQL.
After thoroughly examining PSE’s business situation and requirement, Ashnik and ITG teams commenced implementation with a solution approach. The teams closely studied the application’s design architecture and accordingly architected PostgreSQL database to optimally power and support the application.
Key contributions to the PostgreSQL setup for NASDAQ’s X-stream Trading System Platform:
Ashnik developed a robust, resilient and highly available solution using EnterpriseDB’s Failover Manager and Backup Recovery Tool. Some of the key areas addressed were:
Post-implementation Training and Support :
After the initial consulting and contributions in PostgreSQL setup for NASDAQ X-stream Trading System Platform, Ashnik ramped up the PSE team by providing the required PostgreSQL training.
With first-hand understanding of the PostgreSQL setup and environment, our trainer helped the PSE team learn Postgres with a training program customized for its environment. PSE team, having a good knowledge and understanding of other databases like Oracle and SQL Server was very efficient in picking up the new concepts and handling operational tasks as a part of the training program. Upon completing training, the PSE team was ready to handle their PostgreSQL setup and operations that would host the database for its core system.