Charan Reddy

Job Description: Software Architect (Expert Level)

Posting ID: HBITS-08-14916
Agency: NYS Department of Health – Wadsworth Center (Environmental Laboratory Approval Program)
Location: Empire State Plaza, Corning Tower, Albany, NY (Region 1)
Telecommute: 50% Hybrid
Target Start Date: September 15, 2026
Engagement Duration: 30 Months
Schedule: Full-Time (8:30 AM – 5:00 PM, 40 hrs/week)

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.

Mandatory & Requested Qualifications

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.

PowerBuilder

Quick Overview

Job Description

Skills

Similar jobs

IBM MQ Admin (Containerization & EKS Migration)

Agentic AI + Java/Python - Only W2

Senior Exchange Administrator

Design Thinking Strategist IV

Lead Identity and Access Management (IAM) - SailPoint IIQ

Agile Coaching Technical Lead