Database Architect

Job Description: The client is seeking an expert Database Architect to support the redesign and modernization of the Homeless Management Information System (HMIS) 2.0 project for OTDA. The ideal candidate will support database architecture, application modernization, business analysis, reporting, data governance, and system integration efforts while working within Microsoft and Oracle environments. The role includes SQL development, ETL monitoring, data quality management, reporting, system support, and collaboration with business users and technical teams.Key ResponsibilitiesDesign and maintain database architecture supporting HMIS modernizationExecute SQL and PL/SQL queries for reporting and analysisSupport data collection, validation, standardization, and governanceMonitor ETL processes and troubleshoot failuresSupport database backup, restoration, migration, and archiving activitiesAssist with access management and permissions administrationGenerate reports and dashboards using SSRS and related toolsAnalyze business processes and translate requirements into technical solutionsDesign and support ASP.NET, MVC.NET, Angular SPA applicationsMaintain system documentation and support audit readinessAdditional ResponsibilitiesSupport knowledge transfer and documentation throughout engagementParticipate in ITS security compliance and mandatory trainingCollaborate with analytics and operational teams for reliable datasetsRequired SkillsASP.NET / MVC.NET DevelopmentOracle, PL/SQL & SQL ProgrammingAngular SPA (v914), ReduxSQL Reporting Services (SSRS)WCF / Web ServicesBusiness Process AnalysisDatabase Design & ArchitectureJSON & Data IntegrationGovernment Eligibility Systems ExperienceObject-Oriented Design PrinciplesQualifications & CertificationsBachelors Degree required84 months experience designing n-tier ASP.NET web applications using VB.NET, Web Services, and WCF84 months experience analyzing business processes and working with non-technical users60 months experience with Oracle, PL/SQL, SQL programming, and JSON36 months experience in Web GUI design including accessibility compliance and Angular SPA (v914)24 months experience with government human services eligibility systems24 months experience designing applications using object-oriented principles36 months experience with SQL Reporting Services (SSRS)36 months experience with MVC.NET developmentProject Management Professional (PMP) Certification preferred/required as specified