Sign upLog in

Database Architect

Siritech Solutions Corp

Albany, NY

Apply
JOB DETAILS
JOB TYPE
Contractor
SKILLS
ASP.NET MVC, Administrative Management, Analysis Skills, Business Analysis, Business Processes, Data Collection, Data Management, Data Quality, Data Recovery, Data Sets, Database Administration, Database Architecture, Database Backup, Database Design, Database Extract Transform and Load (ETL), Documentation, Government, Graphical User Interface (GUI) Design, Homeless Services, Identify Issues, Internet Application, JSON, Knowledge Transfer, Management of Information Systems/Technology (MIS), Microsoft .NET, Microsoft ASP.NET (Active Server Page), Microsoft Product Family, Microsoft Visual Basic.NET, Model View Controller, Multi-tier Architecture, Object Oriented Design (OOD), Operational Audit, Oracle, Oracle PL-SQL, Process Analysis, Project Management Professional (PMP), Quality Management, Quality Monitoring, Reporting Dashboards, Reporting Skills, Requirements Management, SQL (Structured Query Language), SQL Server Reporting Services (SSRS), Security Compliance, Software Design, Support Documentation, System Integration (SI), Systems Administration/Management, Systems Maintenance, Web Design, Web Services, Windows Communication Foundation (WCF)
LOCATION
Albany, NY
POSTED
2 days ago

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 Responsibilities:

  • Design and maintain database architecture supporting HMIS modernization
  • Execute SQL and PL/SQL queries for reporting and analysis
  • Support data collection, validation, standardization, and governance
  • Monitor ETL processes and troubleshoot failures
  • Support database backup, restoration, migration, and archiving activities
  • Assist with access management and permissions administration
  • Generate reports and dashboards using SSRS and related tools
  • Analyze business processes and translate requirements into technical solutions
  • Design and support ASP.NET, MVC.NET, Angular SPA applications
  • Maintain system documentation and support audit readiness


Additional Responsibilities:

  • Support knowledge transfer and documentation throughout engagement
  • Participate in ITS security compliance and mandatory training
  • Collaborate with analytics and operational teams for reliable datasets


Required Skills:

  • ASP.NET / MVC.NET Development
  • Oracle, PL/SQL & SQL Programming
  • Angular SPA (v914), Redux
  • SQL Reporting Services (SSRS)
  • WCF / Web Services
  • Business Process Analysis
  • Database Design & Architecture
  • JSON & Data Integration
  • Government Eligibility Systems Experience
  • Object-Oriented Design Principles


Qualifications & Certifications:

  • Bachelors Degree required
  • 84 months experience designing n-tier ASP.NET web applications using VB.NET, Web Services, and WCF
  • 84 months experience analyzing business processes and working with non-technical users
  • 60 months experience with Oracle, PL/SQL, SQL programming, and JSON
  • 36 months experience in Web GUI design including accessibility compliance and Angular SPA (v914)
  • 24 months experience with government human services eligibility systems
  • 24 months experience designing applications using object-oriented principles
  • 36 months experience with SQL Reporting Services (SSRS)
  • 36 months experience with MVC.NET development
  • Project Management Professional (PMP) Certification preferred/required as specified


About the Company

S

Siritech Solutions Corp

Resume Resources

Free Resume TemplatesFree Resume Builder