NYS Information Technology Services (ITS) is seeking a Programmer Expert

Specific tasks will include:

• Guide agile development teams working on complex DOL systems.
• Guide a team of developers in the analysis, design, and development of integrated solutions for the project.
• Assist the project development team to establish and document standards and patterns for 'best practices' of integration technologies.
• Mentor state staff developers in advanced programming techniques and skills.
• Create and review sequence and activity diagrams.
• Develop business process models.
• Analyze, design, and develop services and business processes from business requirements using a SOA approach.
• Develop complex relational database queries using ANSI standard SQL and PLS/SQL to be used with Oracle and DB2 databases giving special consideration to transaction management.
• Perform database transaction management analysis, implementation, and troubleshooting.
• Perform unit and integration testing and resolve defects.
• Create and review technical documents for all aspects of the software development life cycle.
• Provide new technology evaluations resulting from research, proof of concept (POC), and proof of technology (POT) work.
  
  

Requested Qualifications:

• 60 months of experience in Dynamics Solution Design and Architecture. Design and implement complex solutions within the Dynamics 365 platform. This includes developing system architecture that integrates Dynamics 365 with other enterprise systems.
• 84 months of experience in Customization and Development of systems utilizing Dynamics technologies. Create custom plugins, workflows, and scripts to extend Dynamics 365 functionality. Develop and maintain custom applications using Power Platform tools like Power Apps and Power Automate.
• 84 months experience in Data Management. Oversee data migration, integration, and synchronization between Dynamics 365 and other systems. Ensure data integrity and implement best practices for data governance.
• 60 months experience in Performance Optimization. Identify and resolve performance bottlenecks in Dynamics 365 applications. Optimize system configurations and customizations for scalability and efficiency.
• 24 months experience with Collaboration and Leadership: act as a subject matter expert, guiding junior developers and collaborating with cross-functional teams. Provide technical leadership in project planning and execution.
• 12 months experience Testing and Quality Assurance: conduct thorough testing of customizations and integrations to ensure reliability and compliance with requirements. Implement automated testing frameworks where applicable.
• 60 months experience in Documentation and Training: document technical designs, processes, and solutions for future reference. Train end-users and team members on new features and functionalities.
  
  

Work hours and location:

• Full time role with engagement length of 30 months
• Daily work hours: 7:00 am to 6:00 pm (Negotiable)
• Physical office location: 1200 Washington Ave Bldg 12 , ALBANY, NY , 12226
• Telecommuting options: 50%
  
  

Spruce Technology, Inc. is a mid-size, award-winning (Inc 5000, SmartCEO, Entrepreneur of the Year) technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing.

Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process.

All full-time employees are eligible for the following benefits:

Medical, dental, vision health benefits

Life Insurance and AD&D (paid by company)

401k, Flexible and Dependent Care Spending Account plans.

Paid-time Off or Paid Sick Leave (amount dependent on position level and if required by state).