Database Architect

This is a fully remote position, open to applicants in Maryland.

📋 Description

• Lead the design and enhancement of the CTIS-M Azure SQL data architecture that supports Regulated Garbage workflows.

• Create conceptual, logical, and physical data models, ER diagrams, metadata structures, lineage rules, and retention policies.

• Ensure that data structures adhere to USDA, APHIS, PPQ, FEA, federal regulatory, audit, and reporting standards.

• Establish and uphold enterprise data modeling standards, naming conventions, and governance practices.

• Convert requirements from the APHIS Regulated Garbage Program Manual into automated data flows and scalable relational schemas.

• Facilitate electronic workflows for Compliance Agreements, inspections, monitoring checklists, direct observations, incidents, escalations, and enforcement records.

• Enable FOIA-ready audit trails and regulatory workflow data structures.

• Assist in data integration and exchange with external systems such as CBP Agricultural Workspace, APHIS ARM, IPHIS, FMD, eAuthentication, UMS, and Login.gov.

• Enhance T-SQL queries, indexing, performance tuning, partitioning, and cloud SQL configuration.

• Ensure compliance with Section 508 accessibility for system-generated content, forms, and documents.

• Support performance, load, and stress testing for data-layer components.

• Collaborate with developers on secure, compliant, and vulnerability-free data implementation.

• Engage in Agile ceremonies including backlog grooming, sprint planning, sprint review, and retrospectives.

• Create and maintain user stories, requirements, data requirements, process flows, and technical design documentation.

• Populate Azure DevOps/TFS artifacts including backlog items, documentation, code repositories, burn-down/velocity reports, and deployment artifacts.

• Contribute to architecture reviews and the CTIS-M modernization strategy.

• Provide technical guidance to developers implementing data-layer features.

• Collaborate with engineering, business, and federal stakeholder teams.

• Communicate complex data architecture concepts to both technical and non-technical audiences.

• Facilitate knowledge transfer and training during the CTIS-M deployment.

⛳️ Requirements

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field (or equivalent experience).

• Significant experience in enterprise data architecture, relational modeling, and designing data solutions for extensive, workflow-driven systems.

• Proficiency in Azure SQL, T-SQL, performance tuning, and cloud data engineering.

• Experience working in Agile Scrum environments with Azure DevOps/TFS.

• Familiarity with integration platforms such as MuleSoft or similar technologies.

• Proven experience developing T-SQL stored procedures, triggers, and functions.

• Experience in writing Python scripts utilizing Pandas.

• Extensive experience in enterprise data architecture and relational data modeling.

• Deep expertise in Azure SQL, T-SQL, indexing, and cloud-based data performance optimization.

• Experience supporting large-scale workflow, inspection, or compliance-driven systems.

• Familiarity with MuleSoft or comparable enterprise integration platforms.

• Experience delivering solutions within an Agile Scrum framework.

• Proficiency in utilizing Azure DevOps for work management and technical documentation.

• Strong analytical and problem-solving capabilities.

• Excellent communication skills for articulating complex data concepts to both technical and non-technical audiences.

• Ability to work collaboratively with cross-functional technical and business teams.

• High attention to detail and a strong commitment to accuracy.

• Ability to lead, mentor, and guide team members.

• Experience working with government clients.

• Must be eligible to obtain and maintain a Public Trust Clearance.

• Must meet all Federal suitability requirements.

🏝️ Benefits

• Medical, dental, and vision insurance.

• 401(k) retirement plan.

• Paid time off.

• Paid parental leave.

• Life and disability insurance.

• Flexible spending accounts.

• Commuter benefits.

• Tuition reimbursement.

• Flexible remote work arrangement.

• Equal employment opportunity benefits and accommodations.