Expert Software Architect

Company: Diverse Agile Solutions (DAS)
Job Type: Full-Time / Contract
Location: Albany, NY (Hybrid/Onsite as required by client)
Experience Level: Senior / Expert (7+ Years)
Industry: Information Technology | Government | Public Health

About Diverse Agile Solutions

Diverse Agile Solutions (DAS) is a certified Minority Business Enterprise (MBE) specializing in IT Staff Augmentation, Agile Transformation, Cloud Solutions, Cybersecurity, Software Development, Artificial Intelligence, and Enterprise IT Modernization. We partner with federal, state, and commercial organizations to deliver innovative technology solutions that improve operational efficiency and drive digital transformation.

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.

Position Overview

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.

Key Responsibilities

• 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.

Required Qualifications

• 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
  • Packages
  • 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

What We Offer

• 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

Why Join Diverse Agile Solutions?

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.

Equal Opportunity Employer

Diverse Agile Solutions is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

Suggested Keywords for BreezyHR

PowerBuilder, Oracle, PL/SQL, SQL, Software Architect, Technical Lead, Enterprise Architecture, Client-Server Applications, Oracle Database, ETL, Data Migration, Legacy Modernization, SDLC, Database Design, Stored Procedures, Triggers, Views, Government IT, Public Health, Agile, Software Development, Lead Developer.