Database Infrastructure

Focus areas

Schema design for survey, registry, and program datasets (clean keys, naming standards, and long-term maintainability).

Views and stored procedures for repeatable analytics and consistent definitions.

Performance tuning: indexing strategy, query optimization, and partitioning when appropriate.

Data governance: controlled vocabularies, phrase tables, and audit-friendly workflows.

Database development

Build-out of new databases from requirements through production deployment.

Ingestion pipelines from spreadsheets/APIs/flat files into normalized schemas.

Role-based access and safe editing workflows (e.g., CRUD interfaces for reference tables).

Integration with R Shiny / reporting pipelines.