AWS migration of investment portfolio management solution

AWS migration of investment portfolio management solution

We created an AWS migration strategy, suggested the tech stack, and performed the solution’s switchover, helping deliver a more independent, easy-to-use, and easy-to-maintain system.

Table of contents

Challenge

TradeSmith provides technologically advanced trading, risk management, and portfolio analysis tools for individual investors and fintech news publishers that help users manage $30+ billion in investments. Their products offer hedge fund-level insights and proven investment strategies to maximize profits and minimize risk. The customer also creates custom crypto algorithms and research tools for crypto asset investing. Additionally, TradeSmith provides publisher services to financial newsletter publishers, including portfolio tracking, custom charts, and widgets.

The customer’s investment portfolio management system used an infrastructure built when the customer began their business journey as a startup. Since then, Itransition has become a trusted advisor of TradeSmith, gradually migrating parts of its infrastructure to AWS. However, due to the business growth, TradeSmith needed to expand its infrastructure capacity to support 15+ products, serve thousands of end clients, and process large amounts of data. To achieve that goal, the customer decided to migrate their whole infrastructure to AWS.

Since Itransition has already been a reliable partner to TradeSmith for 10+ years and has proven expertise in AWS consulting, as well as the AWS Advanced Consulting Partner status, the customer chose Itransition as the sole vendor performing the full migration to AWS.

Solution

Itransition assessed the cost of creating a secure, reliable, and scalable AWS Cloud infrastructure and suggested the most fitting migration tech stack. We also drafted the migration roadmap and risk mitigation plan, providing two options for data rollback.

After preparing the cloud infrastructure, creating and configuring EC2 virtual servers for apps, AWS Directory Service for Active Directory (AD DS), Redis, AWS Relational Database Service (RDS), and Jenkins, Itransition’s team analyzed the business continuity and performance impact of migrating services, apps, sites, data flows, and critical system parts interdependencies. The selected migration strategy allowed Itransition to streamline and facilitate processes while the client enjoyed business continuity.

Based on system interdependencies, we divided all components into two groups, non-critical and critical. Since the existing infrastructure was spread across different systems and used various technologies, we decided to migrate non-critical system parts that could be moved painlessly as a lift and shift migration, a step-by-step migration of live systems using the AWS toolset without major custom development and performed gradually.

For critical and complex database- and latency-dependent apps and sites, our team wrote custom scripts. This allowed us to avoid disrupting app development, QA, and deployment while keeping the apps up to date on the AWS servers. We also created custom scripts to automate the migration and avoid manual errors while maintaining existing app functionality.

The architecture of investment portfolio management solution

During the final migration phase, we used a big band migration approach for the database and database-dependent apps,  transitioning all resources simultaneously. The reason for moving the database and the database-dependent API was to avoid performance issues that could result from a gradual move.

Itransition ensured that dozens of TradeSmith’s database-dependent apps using their own connection strings were part of the proper inventory and were listed and included in migration scripts. Itransition’s team also used proper backups and switched connection strings to new ones.

After creating the website/app switchover roadmap and checklist, Itransition conducted the full switchover, ensuring data consistency during the final stage of the migration. Then the DevOps team performed a database migration of 40+ apps and sites, relying on monitoring tools to timely detect and resolve errors or process disruptions. The remaining apps were migrated by packing app files into a separate archive, transferring them to a new server, importing them into IIS, and running them in the IIS console.

After successful data and app migration, the team ensured DNS records were updated to match the new app network configuration in AWS, including records for all sites and databases. We used low TTLs before the migration to update DNS records quickly and test DNS updates.

Currently, Itransition’s dedicated support team upgrades and extends TradeSmith’s solution, ensuring system scalability, uninterrupted operation, high security, and 24/7 performance.

Results

The successful migration of the investment portfolio management solution resulted in expanded infrastructure capacity to support new products, a more independent and easy-to-use system, and simplified maintenance for both Itransition’s and TradeSmith’s teams.