Job Description
Database Architect
Location Onsite / Hybrid (Des Moines, Iowa)
Engagement Contract W2 or 1099 (no C2C)
Experience 13-15+ years
About the Role
Design and govern the programs database and data architecture modeling, platform standards, performance, security and migration for state agency systems.
Key Responsibilities
Design conceptual, logical and physical data models for transactional and analytical systems.
Define database platform standards (SQL Server, Oracle, PostgreSQL, Azure SQL) including HA / DR.
Lead database and data migrations, including to cloud platforms.
Optimize performance, indexing and capacity; review DBA and developer designs.
Apply data security controls: encryption, masking, access management for PII /PHI.
Partner with data governance on metadata, lineage and data quality.
Must-Have Skills
5+ years in database architecture or senior data modeling
Strong SQL Server and / or Oracle; data modeling tools (Erwin, ER/Studio)
Database migration and HA / DR design
Data security for PII / PHI
Nice-to-Have Skills
Azure SQL / AWS RDS / cloud data platforms
State or public-sector data systems
Data warehousing (Kimball)
Preferred Certifications
Azure Database Administrator Associate (DP-300) AWS Database Specialty CDMP