> Markdown version of [/jobs/ext/1970282-software-architect-expert-level](https://www.wearedevelopers.com/jobs/ext/1970282-software-architect-expert-level). 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).

---

# Software Architect (Expert Level)

- **Company:** NYS Department of Health
- **Location:** Albany, NY, United States (Remote available)
- **Contract:** Temporary contract
- **Skills:** Access Network, Adobe InDesign, Client Server Models, Databases, Information Engineering, Extract Transform Load (ETL), Data Migration, Relational Databases, Oracle (Applications), PowerBuilder, SQL Stored Procedures, SQL Databases, Data Processing, Freeform SQL
- **Published:** August 7, 2026
- **Apply:** https://www.dice.com/job-detail/02401eb7-494a-461d-835b-63630d0016d1

## About the Role

* Experience Level: Expert (84+ months of industry experience providing guidance to large teams).
 * PowerBuilder: 84+ months of experience coding client-server relational database applications.
 * Oracle & PL/SQL: 84+ months creating tables, stored procedures, triggers, views, and related objects.
 * Complex SQL & Data Engineering: 48+ months writing complex SQL queries (multiple JOINs, subqueries, conditional logic, window functions), data manipulation, data migration, and building ETL scripts.
 * Technical Leadership: 48+ months as a Lead Developer on projects involving multiple developers or teams of >4 developers.

Compliance & Security Requirements

 * ID Requirements: Government-issued Photo ID (Driver''s License / Non-Driver ID) for building access.
 * Clearance: DOH Confidentiality Agreement and Network Access approval required.
 * Mandatory Training: Completion of NYS GOER training (Security Awareness, Sexual Harassment Prevention, Workplace Violence Prevention) and agency-specific courses.

## Description

Role Overview The Software Architect will support application and database components for the Wadsworth ELAP program. The position involves participating in design reviews, evaluating existing data sets, and modifying/supporting legacy client-server systems while preparing them for transition to modern web-based versions.
Key Responsibilities

 * Implement requirements by designing, coding, and testing new application features.
 * Document code-based business rules and system design.
 * Create and optimize database objects, complex queries, and ETL scripts.
 * Prepare procedural documentation, process diagrams, and step-by-step guides for ongoing application support.
 * Conduct knowledge transfer and mentoring sessions for State staff and other consultants.


## Related Videos

- [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases)
- [Cyber Sleuth: Finding Hidden Connections in Cyber Data](https://www.wearedevelopers.com/videos/893-cyber-sleuth-finding-hidden-connections-in-cyber-data)
- [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)
- [40 Minutes to Build a Serverless COVID-19 REST and GraphQL APIs](https://www.wearedevelopers.com/videos/208-40-minutes-to-build-a-serverless-covid-19-rest-and-graphql-apis)
- [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)

## Related Articles

- [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)
- [Software Developer Salary in The Netherlands [2023]](https://www.wearedevelopers.com/magazine/217-software-developer-salary-in-the-netherlands-2023)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [Dev Digest 134 - Where pixels sing?](https://www.wearedevelopers.com/magazine/477-dev-digest-134-where-pixels-sing)
- [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)