> Markdown version of [/jobs/ext/1337922-state-of-ny-expert-database-architect-hbits-08-14879-albany-ny-hybrid](https://www.wearedevelopers.com/jobs/ext/1337922-state-of-ny-expert-database-architect-hbits-08-14879-albany-ny-hybrid). 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). --- # State of NY - Expert Database Architect HBITS-08-14879 - Albany, NY - Hybrid - **Company:** GDR Defense - **Location:** Albany, NY, United States - **Experience:** Expert - **Contract:** Temporary to permanent - **Skills:** Amazon Web Services, Data Analysis, Application Integration Architecture, Health Informatics, Program Optimization, Computer Programming, Databases, Data Architecture, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Mart, Data Migration, Data Systems, Data Warehousing, Relational Databases, Database Design, Database Security, Microsoft Software, Oracle Business Intelligence Enterprise Edition, Oracle (Applications), Performance Tuning, Query Optimization, Release Management, Salesforce.Com, Data Streaming, Tableau (Software), System Availability, Database Performance, Information Technology, Data Analytics, Star Schema, Physical Data Models - **Published:** July 18, 2026 - **Apply:** https://www.careerjet.com/jobad/usfffa4a4f14f269c6ce9a6fd58f188e57 ## About the Role * Database Architect - Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems. * Expert- 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. * 84 Months Experience developing and maintaining logical and physical dimensional data models, including star schema, snowflake schema, and data migration strategies in enterprise data warehouse and business intelligence environments. * 84 Months Experience using data modeling tools (e.g., Erwin) for data model design, documentation, and review to ensure compliance with enterprise data standards and development best practices. * 84 Months Experience in relational data management, database design, and development using Oracle technologies, including advanced SQL programming for data analysis, optimization, and reporting in data warehouse environments. * 72 months of experience supporting healthcare analytics environments, including maintenance and troubleshooting of OBIEE reporting solutions and ETL processes to ensure data availability, accuracy, and business continuity. * 48 Months Experience in designing enterprise data integration architecture using Informatica, including implementing best practices and mentoring team members for data warehouse and reporting solutions. * 48 Months Experience participating in business analysis and requirements gathering sessions, including translating business requirements into data and reporting requirements. * 48 months of experience using business intelligence tools (e.g., OBIEE 11g) to support data analytics, reporting, and enterprise decision-support solutions. * 24 Months Experience designing and implementing enterprise OBIEE dashboards and reports, including repository (RPD) development, metadata modeling, and performance tuning for high-volume data mart environments. * 24 Months Experience establishing and enforcing enterprise data governance, lineage, and data quality frameworks to ensure data integrity, compliance, and reliable reporting across data marts and reporting environments. * Bachelor's degree in IT field ## Description Within this environment, the DataMart team is responsible for the design, development, and ongoing maintenance of the enterprise data warehouse and reporting layer supporting the NYWIC application. The team includes Business Analysts, Data Modelers, Informatica Developers, and OBIEE Developers who work collaboratively to deliver and sustain data solutions. The team continuously implements enhancements and updates to the DataMart as the core application evolves, ensuring accurate, reliable, and timely reporting for business users, program administrators, and regulatory stakeholders., * Perform data analysis of current and future WIC systems, including system comparison, to support ongoing and future data needs. * Collaborate with customers, vendors, and technical teams to gather requirements, perform gap analysis, and prioritize reporting needs. * Design and maintain enterprise data architecture, including conceptual, logical, and physical data models, while performing ongoing data modeling and schema design. * Define and enforce data standards, naming conventions, governance practices, and ensure data quality, integrity, and consistency across all environments. * Develop and maintain documentation of business processes, workflows, and data flows using modeling techniques and flowcharts. * Develop, review, and optimize ETL processes and mappings for data migration, improving performance and efficiency. * Design and support reporting solutions, including dashboards and prototypes, aligned with end-user requirements. * Develop and execute test plans, scripts, and validation scenarios to ensure data accuracy and compliance with business requirements. * Monitor and optimize database performance through query tuning, indexing, partitioning, and overall system optimization. * Implement and maintain database security, access controls, auditing, and compliance with organizational and state data privacy requirements. * Evaluate implementation strategies, identify risks and issues, and support resolution and mitigation planning. * Provide technical guidance, conduct design reviews, mentor team members, and support release planning and post-implementation reviews. * Facilitate and document meetings, support reporting development discussions, and ensure proper tracking of outcomes. * Perform administrative duties including attendance at meetings and completion of NYS LATS timecard and monthly timesheets. TVT is an Information Technology (IT) professional business leader providing IT services to the public sector. Our firm is founded on the values of high integrity, trust, honesty, and commitment. We take pride in providing exceptional value to our clients by supplying and delivering the best IT project-based and hourly talent across the nation. We are business partners with many technology solution providers such as IBM, AWS, Google, Microsoft, Oracle, Tableau, Salesforce, and others. Tech Valley Talent provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, This is a 30 month opportunity on the Hourly-Based IT Services (HBITS) Contract at the State of New York. (Possibility of extension). Required Experience: 84 Months Experience … + 3 days ago, Title : Database Architect - Expert Location : Menands, NY, 12204. Duration : 30 Months Client : Department of Health Requirements : 84 Months Experience developing and m… + 10 hours ago + Apply easily + ## Related Videos - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [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) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [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) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering)