Worked on the hapifhir/hapi-fhir repository to improve the reliability of SQL Server database migrations by addressing an issue with dropping multipart primary keys. Refined the DropPrimaryKeyTask in Java to correctly identify multipart primary keys using SQL and T-SQL, ensuring compatibility with SQL Server schema information. Added an integration test, implemented in Java and YAML, to verify the correct behavior when dropping and re-adding multipart primary keys during migrations. This work enhanced data integrity and reduced upgrade risks for SQL Server deployments, demonstrating skills in database migration, integration testing, and Java development while focusing on robust schema change management.