Systems Architect III

Position Title: Systems Architect III — Database ArchitectLocation: Remote (U.S.-based)Clearance Requirements: Active Top Secret required; must be eligible for T5 federally adjudicated clearancePosition Status: ContractPay Rate: $60–65/hr depending on qualificationsPosition Description:Join a high-impact federal modernization program supporting mission-critical adjudication and risk decision systems for a U.S. government agency. As a Systems Architect III, you'll play a lead role in designing and architecting the enterprise data layer for a large-scale case management system modernization effort — replacing legacy infrastructure with a secure, scalable, cloud-enabled platform built for the future.This is a senior-level, hands-on architecture role where you'll define data standards, lead legacy-to-cloud migration initiatives, and collaborate across development, DevOps, and business teams to deliver high-availability, high-performance data solutions. If you thrive in complex federal environments and want ownership of enterprise-wide data architecture on a program that matters, this is the opportunity.Key Responsibilities:Design, develop, and implement enterprise-grade database management systems including relational architecture, metadata structures, and configuration managementDefine and enforce data architecture standards, controls, documentation, and operational proceduresArchitect and manage data environments across hybrid cloud platforms (AWS, Azure, GCP) and on-premises infrastructureLead legacy-to-cloud migration initiatives and develop modernization roadmapsDesign and optimize ETL/ELT pipelines, ingestion workflows, and data integration processesTune queries, indexes, and server configurations to ensure efficient, secure, and cost-effective data availabilityAdvise development teams and business stakeholders on DBMS capabilities, data-driven solutions, and performance optimizationDevelop enterprise-wide data architecture blueprints and capacity planning strategiesProvide technical leadership and mentorship to junior engineers and analystsPartner with DevOps, data engineers, and cross-functional teams to align architecture with mission objectivesRequired Qualifications:Deep expertise in enterprise DBMS platforms: SQL Server, PostgreSQL, Oracle, or equivalentAdvanced T-SQL/SQL skills: query design, optimization, stored procedures, indexing strategiesStrong data modeling background: ER modeling, normalization, schema design, data warehouse architectureHands-on hybrid cloud experience designing and managing data across on-premises and cloud environmentsETL/ELT proficiency: SSIS, Informatica, Azure Data Factory, AWS Glue, or equivalentNoSQL experience: architecting, creating, and managing NoSQL data solutionsSecurity and governance knowledge: access controls, encryption, compliance, and auditabilityPerformance engineering: query tuning, resource optimization, workload analysisIntegration expertise: secure data movement between legacy systems and modern cloud repositoriesU.S. Citizenship requiredActive Top Secret clearance required; must be eligible for T5 federally adjudicated clearanceEducation and experience: minimum 8 years with BS/BA; 6 years with MS/MA; 3 years with PhDStrong analytical, troubleshooting, and communication skillsAbout Seneca ResourcesAt Seneca Resources, we are more than just a staffing and consulting firm — we are a trusted career partner. With offices across the U.S. and clients ranging from Fortune 500 companies to government organizations, we provide opportunities that help professionals grow their careers while making an impact.When you work with Seneca, you're choosing a company that invests in your success, celebrates your achievements, and connects you to meaningful work with leading organizations nationwide. We take the time to understand your goals and match you with roles that align with your skills and career path. Our consultants and contractors enjoy competitive pay, comprehensive health, dental, and vision coverage, 401(k) retirement plans, and the support of a dedicated team who will advocate for you every step of the way.Seneca Resources is proud to be an Equal Opportunity Employer, committed to fostering a diverse and inclusive workplace where all qualified individuals are encouraged to apply.