Remote Software Developer Jobs in Albany, NY (NOW HIRING)

Expert Software Architect – PowerBuilder, Oracle and PL/SQL

Important Employment and Submission Notice

W-2 EMPLOYMENT ONLY — NO CORP-TO-CORP, C2C, 1099, THIRD-PARTY VENDORS, SUBCONTRACTORS, OR EMPLOYER-SPONSORED CANDIDATES.

PLEASE DO NOT SUBMIT YOUR RÉSUMÉ UNLESS YOU MEET EVERY MANDATORY EXPERIENCE REQUIREMENT LISTED BELOW.

Applications that do not clearly demonstrate the required number of months will not be considered.

Position Summary

We are seeking an Expert Software Architect with advanced experience supporting legacy client-server applications and relational database environments. The selected candidate will support the application and database components of an enterprise laboratory accreditation program while contributing to its eventual replacement with a modern web-based solution.

This position requires expert-level experience with PowerBuilder, Oracle, PL/SQL, complex SQL development, data migration, ETL scripting, application maintenance, and technical leadership.

Key Responsibilities

• Support application and database components of an enterprise laboratory accreditation program.
• Participate in application and database design-review sessions with program stakeholders.
• Review, evaluate, and document existing applications, databases, data structures, and datasets.
• Maintain, modify, and support legacy applications until they are replaced with modern web-based solutions.
• Analyze business and technical requirements and translate them into application features.
• Design, code, test, debug, and implement new application functionality.
• Develop and maintain PowerBuilder client-server applications.
• Create and modify Oracle database tables, stored procedures, triggers, views, functions, packages, and other database objects.
• Write and optimize complex SQL queries involving multiple joins, subqueries, conditional logic, and window functions.
• Perform data manipulation, data conversion, data migration, validation, and reconciliation.
• Develop and maintain ETL scripts supporting application and database operations.
• Document source-code logic, application functionality, technical specifications, and code-based business rules.
• Troubleshoot production issues and implement appropriate corrections.
• Participate in code reviews, testing, release planning, deployment, and production support.
• Provide technical direction and guidance to developers and other project personnel.
• Lead development activities involving multiple developers working on shared applications and components.
• Promote application stability, code quality, maintainability, security, and data integrity.

Mandatory Qualifications

Candidates must meet every requirement below:

• At least 84 months of senior-level software development or software architecture experience.
• Demonstrated ability to provide guidance to large technical teams or extensive industry experience that places the candidate at the top of the field.
• At least 84 months of experience coding client-server relational database applications using PowerBuilder.
• At least 84 months of hands-on Oracle and PL/SQL experience.
• Demonstrated Oracle experience creating and maintaining tables, stored procedures, triggers, views, functions, packages, and other database objects.
• At least 48 months of experience writing complex SQL queries and reports involving multiple joins, subqueries, conditional logic, or window functions.
• At least 48 months of experience with data manipulation, data migration, and the creation of ETL scripts.
• At least 48 months of experience serving as a lead developer on projects involving multiple developers working on the same application or component, or teams containing more than four developers.
• Demonstrated experience designing, coding, testing, debugging, documenting, and implementing enterprise application features.
• Demonstrated experience supporting and modifying production applications and databases.

Required Application Information

Every submission must include:

• Full legal name
• Complete résumé
• • Dates must be listed as MM/YY–MM/YY for every engagement.
  • Every engagement must include its City and State.
  • Each mandatory skill must be connected to a specific employer, project, and date range.
  • Résumés containing only general summaries or unsupported skill lists will not be accepted.
• Current location: City and State
• Written confirmation of willingness to relocate or commute, unless the position is specifically designated as fully remote.
• Work-authorization status
• • Candidates must be United States citizens or lawful permanent residents—green card holders—as of March 2026.
  • Visa sponsorship and employment-based transfers are not available.
  • Work-authorization documentation may be required through a secure verification process at the appropriate stage.
• Education
• • Highest completed degree must be identified.
  • A copy of the diploma is preferred and may be required.
  • Copies of relevant technical certifications are preferred and may be required.
• Current telephone number
• Current email address
• Confirmation of acceptance of W-2 employment
• Confirmation of acceptance of the stated compensation range

Do not submit sensitive identity documents with the initial résumé unless specifically instructed to use an approved secure submission process.

Compensation

The anticipated W-2 hourly pay range is $65.00–$69.00 per hour.

Final compensation will be based on documented experience, technical expertise, education, training, certifications, geographic location, and the specific circumstances of the engagement.

Benefits

Eligibility may vary based on employment classification and assignment. Available benefits may include:

Candidates who do not satisfy every mandatory experience, work-authorization, résumé-formatting, employment-type, and submission requirement should not apply.