Customer is a leading Encryption solution provider.
They provide solutions for encryption, authentication and are world leading SIM cards manufacturer.
Customer requested for the integration of their key management solution with PostgreSQL to implement Column encryption in PostgreSQL DB.
Developed the PostgreSQL Transparent data encryption (TDE) solution to perform Column encryption
This solution involved development of an Extension handler code that gets called when the DDL ( Alter Table) or DML ( Insert, Update, Select, Delete) queries are fired performing the column data encryption and decryption using the Table key encrypted by the Key management Master key.
Scenarios such as key rotation, data archival were implemented as well