KFintech is the largest registrar and a market leader in the investor servicing industry. With over 100 million investor accounts, they have reached out to over 3500+ issuers including banks, PSUs and mutual funds. Being an ISO 9001:2015 certified company on data security in the Registrar and Transfer agency space, their real-time data replication capability ensures zero impact in case of exigencies. KFin is a one of its kind digital platform excelling in hyperscale transaction management, big data solutioning, transformative platforming, pureplay financial and technical services built on proven tech expertise in the asset management industry.
KFinTech was looking for hosting there IQ BOT applications on AWS. All the BOT applications need to run on windows platform with MS-SQL as a Backend DB. Customer focus was on HA for the MS-SQL database and was also having pain with Infra scaling issues causing poor performance during load on server with their existing service provider. Windows Workload. KFinTech wanted to work with a strong Cloud Consulting Partner like Workmates to help them host their windows workload on AWS, manage Infra and applications 24*7 and then build Cloud capabilities so that KFin can concentrate on application development.
- The initial Infrastructure would consist of Bot Servers, Control Room Server, and MSSQL Server running on EC2 on Windows. All Server Sizing was initially taken based on the current sizing and its utilization shared by the customer. Based on the utilization reports in CloudWatch Servers were scaled up or down.
- Since the DC was on Mumbai Region so we will create the Direct Connect link was created between the AWS VPC and Mumbai DC.
- Workmates team will create all the required infra in Kfin Tech existing AWS a/c. To facilitate secure connectivity, we will provision two separate network segments namely public and private and Network Access Control Lists(NACLs) are used to control traffic at the subnet level. And NAT gateway is used for in stances in private network to have access to internet.
- All the servers be placed in private subnet and ELB ( Elastic Load Balancer ) will be on internet facing , with ALB you will get the SSL certificate and it will protect and manage the external threat our internal IP’s will not be exposed to internet. ALB would be used as per the application team’s requirement.
- We will enable the auto recovery feature to ensure the maximum uptime of the infra
- The public facing network (public subnet) will contain one NAT gateway for upgrades patches and occasional system updates to the hosted machine
- The Application and Database server will be hosted on the non internet network i e private subnet) with a network route configured to the NAT gateway and the VPN subnet.
- To protect unwanted access to backups we will also create, and AWS managed KMS encrypted S3 bucket.
- The servers will be configured with the latest update of Windows Server OS with one additional SSD volume
- We shall provision a scheduled task that will take a backup of the primary data store on the MSSQL DB to S3
- Users will link their client applications to their respective client machines via the local IP of the VM instance via the VPN tunnel
- Our approach towards data backups and AMI snapshots will ensure complete data availability
- The license for Microsoft SQL Server has been considered.
- All the logs will be sent to AWS Guard Duty for threat detection and identifying malicious activities in the account.
- AWS Config will be enabled, and all the AWS recommended config rules will be created.
- Periodic patching of the servers will done via AWS SSM Patch Manager.
EC2, EBS, ALB, Route53, S3, CloudFormation, CloudWatch, CloudTrail, IAM, Config, Guard Duty, Systems Manager, NAT gateway.
- MS SQL Server Database
- Standard on Windows Server to run BOTS and process customer data.
- Using IAM we restricted users and group to access specific AWS resources only as per the requirement.
- AWS Multi-Factor Authentication for privileged accounts, including options for hardware/Software based authenticators is enabled.
- Quarterly Patch Management and Patch Automations is carried out using AWS SSM. During patch all the security patches, OS critical patches will be applied.
- Deep visibility into API calls through AWS Cloud Trail, including who, what, and from where calls were made. All user related activity are tracked and logged.
- For any Administrative task Remote user will use VPN client to connect the servers.
- All the SSH port will be bind with OpenVPN server, also default ports will be changed to the custom port.
- DB is accessible only through the Application containers and through the VPN. All servers will be hosted on the private subnet.
- For Configuration Management and Policy as a Code, AWS Config will be used, which will help us detect any configurations drift within the AWS Account.
- All the Data on Rest will be encrypted using AWS KMS. EBS volumes of EC2 to be encrypted, all S3 buckets to be encrypted.
- Trusted Advisor Checks will be carried out every week ensure the all the security checks are used.
- AWS Secrets Manager are being used to store the DB credentials encrypted using KMS.
- AWS WAF has been implemented to help protect web applications and APIs against common web exploits and bots that may affect availability, compromise security, or consume excessive resources.
Cloudworkmates finished the project on-time and under-budget delivering a scalable and highly available infrastructure with no single point of failure. KFin was happy with the deliverables and the executed timeframe. Should the need arise to extend or modify their infrastructure further, CloudWorkmates is available to continue the relationship.
KFin is now able to process more customers data faster than they could by using their in-house solution. Also, on AWS, they can quickly scale their production stack as dynamically as their workloads scale. For example, KFin are now easily increase their storage footprint and compute footprint utilizing AWS’s highly scalable features. Finally KFin was able to realize the full potential of running Microsoft Workloads on AWS with the required high availability, reliability , performance & scalability