Software Architect in Albany, NY

Client: Wadsworth Environmental Laboratory Approval Program (ELAP) | Information Technology Services (ITS) | Program for: HBITS (NY) Visa: Valid work authorization required (Driver’s License/Green Card/Visa/Passport) Note: Selected candidate needed to fill out the checklist. Required Documentation R sum Copy of Candidate Identification as listed above under Candidate Information Section (i.e., Driver’s License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.), * Define architectural vision, standards, and guidelines for complex applications.

• Lead and mentor development teams through multi-developer project lifecycles.
• Design, optimize, and maintain Oracle database structures, objects, and ETL scripts.
• Develop and support client-server relational applications using PowerBuilder.
• Write complex SQL logic and facilitate seamless data migration and integration

• Level: Expert (84+ months of experience providing guidance to large teams, demonstrating extensive industry experience, and operating at the top of the field).
• High-level architectural design experience, setting technical and coding standards, and defining component interactions for large-scale enterprise systems.

Requested Skills & Qualifications

• PowerBuilder: 84 months of experience coding client-server relational database applications using PowerBuilder.
• Oracle & PL/SQL: 84 months of experience with Oracle and PL/SQL, including creating tables, stored procedures, triggers, views, and other database objects.
• Advanced SQL & Data Operations: 48 months of experience writing complex SQL queries and reports (multiple JOINs, subqueries, conditional logic, window functions) alongside data manipulation, data migration, and ETL script creation.
• Technical Leadership: 48 months of experience as a lead developer on projects involving multiple developers or teams of more than four developers.