FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Database Architect
Koniag Government Services. Guide the design and optimization of the CTIS-M Azure SQL data architecture supporting Regulated Garbage workflows .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in Azure SQL, T-SQL, and enterprise data architecture, with a strong focus on compliance-driven systems and Agile methodologies. Capable of translating complex regulatory requirements into scalable data solutions while ensuring data integrity and accessibility.
Highest-signal resume keywords
Azure SQL ExpertiseT-SQL Performance TuningEnterprise Data ArchitectureAgile Scrum ExperiencePublic Trust Clearance
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data ModelingT-SQL Stored ProceduresPython ScriptingRelational Data ModelingData IntegrationPerformance TuningCloud Data EngineeringMetadata StructuresData GovernanceCompliance Requirements
Soft Skills
Analytical AbilitiesProblem-Solving SkillsCommunication SkillsCollaborationAttention to Detail
Tools & Technologies
Azure DevOpsMuleSoftAgile MethodologiesTFSER Diagrams
Industry Keywords
Federal Regulatory ComplianceUSDAAPHISPPQFOIAInspection SystemsWorkflow AutomationAudit TrailsData AccessibilityGovernment Clients
Tech Stack
Tools & technologiesAzureCloudPandasPythonSQLTFS
About the role
Key responsibilities & impact- Guide the design and optimization of the CTIS-M Azure SQL data architecture supporting Regulated Garbage workflows
- Develop conceptual, logical, and physical data models, ER diagrams, metadata structures, lineage rules, and retention policies
- Ensure data structures comply with USDA, APHIS, PPQ, FEA, federal regulatory, audit, and reporting requirements
- Define and enforce enterprise data modeling standards, naming conventions, and governance practices
- Translate APHIS Regulated Garbage Program Manual requirements into automated data flows and scalable relational schemas
- Support 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
- Support data integration and exchange with external systems including CBP Agricultural Workspace, APHIS ARM, IPHIS, FMD, eAuthentication, UMS, and Login.gov
- Optimize T-SQL queries, indexing, performance tuning, partitioning, and cloud SQL configuration
- Ensure Section 508 accessibility compliance for system-generated content, forms, and documents
- Support performance, load, and stress testing for data-layer components
- Collaborate with developers on secure, compliant, vulnerability-free data implementation
- Participate 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 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 technical and non-technical audiences
- Support knowledge transfer and training during CTIS-M deployment
Requirements
What you’ll need- Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience)
- Extensive experience in enterprise data architecture, relational modeling, and designing data solutions for large, workflow-driven systems
- Expertise in Azure SQL, T-SQL, performance tuning, and cloud data engineering
- Experience working in Agile Scrum environments with Azure DevOps/TFS
- Experience with integration platforms (MuleSoft or similar)
- Experience developing T-SQL stored procedures, triggers, and functions
- Experience writing Python scripts using Pandas
- Extensive experience in enterprise data architecture and relational data modeling
- Deep expertise in Azure SQL, T-SQL, indexing, and cloud-based data performance tuning
- 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 environment
- Proficiency in using Azure DevOps for work management and technical documentation
- Strong analytical and problem-solving abilities
- Excellent communication skills for presenting complex data concepts to technical and non-technical audiences
- Ability to collaborate effectively with cross-functional technical and business teams
- High attention to detail and commitment to accuracy
- Ability to lead, mentor, and guide team members
- Experience working with government clients
- Must be able to obtain and maintain a Public Trust Clearance
- Must meet all Federal suitability requirements
Benefits
Comp & perks- 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