> Markdown version of [/jobs/ext/1920173-nys-doh-expert-software-architect](https://www.wearedevelopers.com/jobs/ext/1920173-nys-doh-expert-software-architect). 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). --- # NYS DOH Expert Software Architect - **Company:** Diverse Agile Solutions - **Location:** Albany, NY, United States - **Experience:** Expert - **Salary:** $104,000.0 - $114,400.0 - **Contract:** Permanent contract - **Skills:** Applications Architecture, Client Server Models, Databases, Extract Transform Load (ETL), Data Transformation, Data Migration, Data Structures, Relational Databases, Database Design, Database Schema, Oracle Databases, Performance Tuning, PowerBuilder, Software Architecture, Systems Development Life Cycle, Standard Sql, Software Engineering, Software Systems, SQL Stored Procedures, PL-SQL, SQL Databases, Freeform SQL, Enterprise Software Applications, Sql Optimization, Software Version Control - **Published:** August 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=f189eef04699bb3e ## About the Role * 84+ months (7+ years) of professional software development experience. * Recognized as a technical leader capable of providing architectural guidance to development teams. * Extensive experience designing enterprise-level software solutions. * Strong analytical, problem-solving, and communication skills. * Experience working throughout the Software Development Life Cycle (SDLC). Preferred Qualifications * 84 months of experience developing client-server relational database applications using PowerBuilder. * 84 months of Oracle database development experience. * Extensive experience using PL/SQL, including: + Stored Procedures + Triggers + Views ## Description We are seeking an Expert Software Architect to support a mission-critical New York State public health initiative. This position will play a key role in maintaining and modernizing legacy applications supporting the Wadsworth ELAP (Environmental Laboratory Approval Program) while helping transition the platform toward a modern web-based architecture., The Expert Software Architect will serve as the technical leader responsible for supporting, enhancing, and modernizing existing client-server applications and Oracle databases. This individual will collaborate with business stakeholders, analyze existing systems, design technical solutions, and implement enhancements while ensuring system stability during the modernization effort. This role requires extensive expertise in PowerBuilder development, Oracle databases, PL/SQL, SQL optimization, and enterprise software architecture., * Support application and database components of the Wadsworth ELAP program. * Participate in application architecture and design review sessions with business stakeholders. * Analyze existing applications, databases, and legacy data structures. * Design technical solutions to support evolving business requirements. * Modify, maintain, and enhance existing applications until replacement with a modern web-based solution. * Design, develop, test, and deploy new software features. * Create and maintain technical documentation, including code-based business rules. * Develop and optimize Oracle database objects including: + Tables + Stored Procedures + Views + Triggers + Packages * Write and optimize complex SQL queries and reports. * Perform data migration and ETL development activities. * Lead technical discussions and mentor development teams. * Ensure adherence to software architecture standards and best practices. * Collaborate with developers, database administrators, business analysts, and project managers throughout the software development lifecycle., + Database objects * 48 months of experience writing complex SQL queries involving: + Multiple JOINs + Subqueries + Window Functions + Conditional Logic + Performance optimization * Experience with: + Data migration + ETL development + Data transformation * 48 months serving as a Lead Developer on projects involving: + Multiple developers + Large enterprise applications + Cross-functional technical teams Technical Skills Required * PowerBuilder * Oracle Database * PL/SQL * SQL * Client-Server Architecture * Database Design * Software Architecture * SDLC * ETL Development * Data Migration Preferred * Legacy System Modernization * Enterprise Application Development * Technical Leadership * Performance Tuning * Version Control Systems * Agile/Scrum Methodologies ## Related Videos - [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) - [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) - [Crypto-secure Data Management with In-Database Blockchain](https://www.wearedevelopers.com/videos/632-crypto-secure-data-management-with-in-database-blockchain) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) ## Related Articles - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [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) - [The Best X (Twitter) Accounts for Developers](https://www.wearedevelopers.com/magazine/294-the-best-x-twitter-accounts-for-developers) - [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)