Project Portfolio

A multi-platform organization had grown its database infrastructure without consistent standards, documentation, or security controls. There was no authoritative inventory of what databases existed, where they ran, or how they were configured. Administrative credentials were unsecured, naming conventions were inconsistent across environments, and there were no documented standards for anyone to follow.

Foundation Software Technology performed a complete audit of the database fleet across all locations, documenting hardware, software versions, platform configurations, and database inventory from scratch. All administrative credentials were secured into a credential vault. Naming and configuration standards were established and enforced across the entire fleet. The engagement transformed an undocumented, at-risk infrastructure into a managed, auditable environment with a clear baseline for ongoing operations.

A healthcare market research organization needed to consolidate data from multiple disparate sources — an Oracle production database, an ad management platform, and a web analytics platform — into a unified analytical environment. The data arrived on different schedules in different formats, and each source had previously been handled in isolation with no shared infrastructure or common processing approach.

Foundation Software Technology designed and built a Data Lake on AWS Athena and Glue, integrating all three sources through S3-triggered Lambda and Glue ETL pipelines. Each pipeline ingested, transformed, and deposited source data into a unified structure queryable through Athena. The result gave the organization a single analytical environment across all data sources, with automated ingestion replacing the manual processes previously used for each feed.

An organization running a production Oracle database on-premises needed to migrate to AWS RDS PostgreSQL, a platform change that required more than a straightforward data migration. On-premises processes and integrations were tightly coupled to Oracle-specific features and the local environment, and could not simply be lifted and shifted to the new platform.

Foundation Software Technology managed the full migration engagement: schema conversion, data migration using AWS DMS and custom-built utilities, and re-engineering of on-premises processes to run natively in AWS. Oracle-specific PL/SQL logic was converted to PostgreSQL-compatible equivalents, and dependent processes were rebuilt to operate within the AWS environment. The migration was executed with no loss of data and no unplanned production outage.

A large organization with databases spread across multiple platforms and environments had no centralized view of its database fleet. Information about database sizing, software versions, cluster topology, user accounts, and application access patterns was scattered across individual systems and known only to the DBAs managing each one. Operational and management reporting required significant manual effort to produce.

Foundation Software Technology designed and built a fleet intelligence repository: an internal administration tool that collects database metadata from all systems across the organization into a centralized store. The tool captures hardware and software inventory, cluster topology, user account information at both the database and application level, and sizing data. A reporting front end built on AWS QuickSight provides targeted operational and management dashboards, giving both the DBA team and organizational leadership a live view of the database fleet without manual data gathering.