High-Performance MS SQL CLR FPE UDF
Budget: $250 – $750 USD
This project centers on a brand-new MS SQL Server CLR-based User Defined Function that performs format-preserving encryption (tokenization) of Personal Identifiable Information. From cryptographic core to batch-oriented wrappers, every line will be written from scratch and staged in our Development environment.
Scope
• Implement FF1 and FF3-1 per NIST SP 800-38G in C#.
• Wrap the algorithms in a MS SQL-Server-compatible CLR assembly exposed as a scalar UDF.
• Engineer bulk-load logic so that inserting and tokenizing 1 million rows across three columns finishes in under 40 seconds on commodity hardware.
• Provide unit tests and a demo script that tokenizes sample PII and then reverses it to verify correctness.
Acceptance criteria
1. Deterministic, reversible ciphertext that preserves the original character set and length.
2. End-to-end benchmark (insert + tokenize) ≤ 40 s for 1 M × 3 columns.
3. Source code, deployment script, and README delivered within one month.
Feel free to employ any performant cryptographic primitives or parallelization techniques, provided they remain fully managed and safe for SQL CLR deployment.
Scope
• Implement FF1 and FF3-1 per NIST SP 800-38G in C#.
• Wrap the algorithms in a MS SQL-Server-compatible CLR assembly exposed as a scalar UDF.
• Engineer bulk-load logic so that inserting and tokenizing 1 million rows across three columns finishes in under 40 seconds on commodity hardware.
• Provide unit tests and a demo script that tokenizes sample PII and then reverses it to verify correctness.
Acceptance criteria
1. Deterministic, reversible ciphertext that preserves the original character set and length.
2. End-to-end benchmark (insert + tokenize) ≤ 40 s for 1 M × 3 columns.
3. Source code, deployment script, and README delivered within one month.
Feel free to employ any performant cryptographic primitives or parallelization techniques, provided they remain fully managed and safe for SQL CLR deployment.