> Markdown version of [/jobs/ext/640482-database-architect-expert](https://www.wearedevelopers.com/jobs/ext/640482-database-architect-expert). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Database Architect (Expert) - **Company:** Brandon Consulting Associates, Inc. - **Location:** Albany, NY, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Databases, Data Dictionary, Data Integrity, Extract Transform Load (ETL), Database Queries, Health Information Management, JSON, Oracle Databases, Oracle (Applications), SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Data Management - **Published:** June 25, 2026 - **Apply:** https://www.dice.com/job-detail/871bf9ab-d848-4ee1-a55e-402069402025 ## About the Role 1 A Bachelor's Degree 2 84 months experience in designing logical and physical database models. 3 84 months experience designing oracle databases including triggers and packages 4 84 months experience in performing Extract, Transform, and Load (ETL) techniques and flagging any failures. 5 60 months experience with SSIS design and development 6 60 months experience using SQL Reporting Services (SSRS) 7 60 months experience in in SQL programming including writing complex queries utilizing JSON in Oracle. 8 36 months experience with participating in meetings to understand data needs and communicate updates on data status. Maintaining detailed logs of data management activities and issues. Required Documentation * Résumé * Copy of Candidate Identification (i.e., Driver's License//Visa and Passport if applicable) * Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) ## Description Short description of the Position: This project involves the upgrading and combining of various aging systems into one comprehensive Homeless Information Management System (HMIS). In this role, they will be responsible for designing, implementing, maintaining, and securing our organization's databases to ensure optimal performance, reliability, and data integrity. They will collaborate closely with developers, analysts, and IT teams to support business operations and strategic initiatives. Generate and distribute standard & complex reports and dashboards. Maintain detailed logs of data management activities and issues. list of the day-to-day tasks : "The candidate of this position will be responsible for, but not limited to: · Participate in meetings to understand data needs and communicate updates on data status. · Maintain detailed logs of data management activities and issues. · Stay updated on company data policies, compliance requirements, and best practices. · Learn new data management tools and technologies as required. · Complete all assigned tasks. · Assist in documenting data sources, definitions, and lineage (data dictionaries, metadata). · Execute complex queries (using SQL or similar) to extract data for reports or analysis as requested. . Ensures that project goals/objectives are met. ## Related Videos - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [How building an industry DBMS differs from building a research one](https://www.wearedevelopers.com/videos/768-how-building-an-industry-dbms-differs-from-building-a-research-one) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [TiDB, One Layer at a Time: How Distributed SQL Became an Agentic AI Backbone](https://www.wearedevelopers.com/videos/100117-tidb-one-layer-at-a-time-how-distributed-sql-became-an-agentic-ai-backbone) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Quick guide: How to write a Software Developer CV](https://www.wearedevelopers.com/magazine/37-quick-guide-how-to-write-a-software-developer-cv) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Starter Kit For Job Applications For Developers](https://www.wearedevelopers.com/magazine/7-starter-kit-for-job-applications-for-developers)