NYS DOH Expert Software Architect

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

• 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

Pulled from the full job description

• Opportunities for advancement, * Competitive compensation
• Opportunity to support high-impact New York State public health initiatives
• Collaborative and experienced technical teams
• Professional growth and advancement opportunities
• Exposure to enterprise modernization projects
• Inclusive and supportive work environment

At DAS, we believe our people are our greatest strength. We foster innovation, collaboration, and continuous learning while delivering technology solutions that make a meaningful impact. You’ll have the opportunity to work alongside experienced professionals on mission-critical government projects that improve services for communities across New York State.