Systems Developer Expert

6 days ago


Albany, United States PSI International Full time

HBITS-(phone number removed) - Systems Developer Expert – 50% REMOTE – Albany, NY

Agency Name: Information Technology Services (ITS)

Project/Program Name: CONNECTIONS

Provide a short description of the Position: This individual will provide expert database development support to the CONNECTIONS project during development and maintenance activities to maintain New York State's Automated Child Welfare Information System for OCFS, LDSS , and Voluntary Agencies.

Provide a complete list of the day-to-day tasks to be performed by the Selected Candidate: The following activities are indicative of the assignments/outcomes expected of this individual:

Participating in design sessions to help with database design

Serving as the internal Team DBA for CONNECTIONS application

Serving as lead database developer for CONNECTIONS, developing complex database packages and procedures to feed data to WCF Service Layer via ODP.NET

Serving as lead database developer for CONNECTIONS ancillary applications like AIMS, CCWIS DX, Dynamics CRM, FHARM, OCS, RFI

Serving as lead database developer to develop and maintain highly complex database packages for data exchange with applicable intra-agency and inter-agency legacy applications

Investigating and troubleshooting Production data issues and code appropriate data fixes

Creating and tracking ITSM requests coordinating with the central DBA Team for roll-out of Build-related database changes

Supporting parallel development and testing of multiple Application Builds by maintaining the integrity of corresponding development databases

Supporting CONNECTIONS Training databases liaising with CONNECTIONS Training Coordinator

Supporting CONNECTIONS Batch development and support team with database coding

Supporting CONNECTIONS nightly Audit process

Catering to CONNECTIONS Audit data requests from OCFS

Assisting Data Warehouse Team sharing relevant CONNECTIONS database changes having Data Warehouse impact

Mentoring developers in the effective use of performance-optimized SQLs

Performing reviews of other developers' database code to ensure CONNECTIONS database coding standards are adhered to

Assisting Testing Team with creating test data

Developing appropriate system documentation

Job Title: Systems Developer

Skill Level: Expert

Target Start Date: 2024-07-31

Engagement Length in Months: 24. 0 Months

Is this a Full or Part-Time Position: Full Time

What are the daily work hours: M-F 8:30am - 5:00pm

Where is the Home Base Region? 1

Where is the physical work office located: 40 North Pearl Street , Albany, NY , 12207

Is telecommuting allowed for this position: Yes

If YES, note if negotiable or list the percentage allowed/number of days allowed per week: 50%

What is the format of the Candidate interview: Webcasting

If Webcasting, is Candidate required to be on camera: Yes

What type of software is typically used by the Agency: Agency is a Microsoft and Oracle shop

What type of hardware is typically used by the Agency: Agency is a Microsoft shop

Position MANDATORY Qualification:

Position Job Title: Systems Developer

Position Job Title Description: Develops and implements applications and programs for the backend processing systems used in businesses and organizations.

Position Skill Level: Expert

Position Skill Level Description: 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

List all the Position REQUESTED Qualifications:

84 months of experience writing packages, SQL, PL/SQL, stored procedures, functions, triggers in minimum version of Oracle 11g or higher.

84 months of experience performing Oracle database administration activities in a production database environment containing on-line and batch environments - including performance tuning, maintaining the architecture, processes, and database objects of an Oracle database Server in minimum version of Oracle 11g or higher.

84 months of experience developing and maintaining applications in Oracle's Application Express (APEX).

84 months experience with Oracle Database Express Edition (XE) in-house database administration tasks like create schema, manage privileges, etc.

84 months experience working with project staff (both program and technical staff) providing database support in the development of n-tiered client-server/web applications based on defined technical designs.

84 months experience in performing knowledge transfers to coworkers of Oracle database developer techniques supporting the development of database structure for new application designs and/or enhancements to existing application designs.

84 months experience creating and maintaining PERL scripts.

24 months of experience writing Unix/Linux Shell Scripts.

24 months of experience using Microsoft SQL Server.

Are there additional security requirements for the Authorized User: Yes

If YES, include the additional security requirements: Mandatory ITS Security Agreements and Fingerprint-based Background Check.

Will additional training potentially be required during the Engagement: No

If YES, provide description of anticipated training:

What type and/or manner, of knowledge transfer is requested during the Engagement: Documentation will be up-to-date at all times in Team Foundation Server (TFS) and SharePoint. A weekly review will be a means of knowledge transfer. The individual may be asked to provide training, knowledge transfer to client staff on best practices, programming techniques, SQL queries & validations, etc. supporting the development of n-tiered client-server/web applications.

Is travel anticipated during the Engagement: No



  • Albany, United States Castletop Logistics LLC Full time

    Job Summary: We are seeking a Expert Systems Developer HBITS-05-13370 **Responsibilities**: - Execute full software development life cycle (SDLC) - Use Microsoft Visual Studio 2017 or higher and write code using MVC Architecture,.Net, JavaScript, Angular, Ajax, HTML, XML and WCF. - Prepare scripts to create and modify existing Oracle tables, create...


  • Albany, United States Avenues International Full time

    Job DescriptionJob DescriptionHello Associates,Hope you are doing great!!I am David from Avenues International Inc. We are a well-established, US based, IT Staffing & Consulting firm, providing services since 1994, for clients across USA. We are a prime vendor to the New York State and work on their HBITS: Hourly-Based IT Services (New York State-wide)...


  • Albany, United States Castletop Logistics LLC Full time

    Job Summary: **Duties**: - Work in coordination with a team of developers to expand the current system. - Work with Business Analyst on analysis and logical design. - Perform unit testing and correct all identified bugs. - Perform complex VB.Net/C# coding in a CSLA and MVC environment. - Assist with responding to Juvenile Justice data requests. - The...


  • Albany, United States Cedar Park Group Full time

    Cedar Park Group is looking for an Expert Systems Developer. 50% Remote. Full-time. 8AM-5PM. 11 month contract. Duties: Develops and implements applications and programs for the backend processing systems used in businesses and organizations. Work in coordination with a team of developers to write the new Facility Application Management system in ASP.net...

  • Systems Developer

    2 weeks ago


    Albany, United States Vichara Full time

    Job DescriptionJob DescriptionCompany DescriptionVichara is a Financial Services focused products and services firm headquartered in NY and building systems for some of the largest i-banks and hedge funds in the world.Job Description1. Work with client on analysis and requirement gathering. 2. Perform complex .Net coding. 3. Perform unit testing and correct...

  • Systems Developer

    4 weeks ago


    Albany, United States Mindlance Full time

    Provide a short description of the Position: Design and implement solutions for .NET project initiative using C#, Core .Net, MVC, PL/SQL, and various other programming tools. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Daily Tasks will include but are not limited to the following: 1. Execute full software development...


  • Albany, United States Spruce Technology Full time

    NYS Information Technology Services (ITS) is seeking a Business Analyst Expert The consultant will be responsible for working with ITS technical staff and business subject matter experts to document transactions, workflows, user roles, etc. of legacy (PeopleSoft HCM) human resource systems and to develop test artifacts necessary to perform QA and UAT of...

  • Systems Architect

    3 weeks ago


    Albany, United States Avenues International Full time

    Job DescriptionJob DescriptionHello Associates,Hope you are doing great!!I am David from Avenues International Inc. We are a well-established, US based, IT Staffing & Consulting firm, providing services since 1994, for clients across USA. We are a prime vendor to the New York State and work on their HBITS: Hourly-Based IT Services (New York State-wide)...


  • Albany, United States Avenues International Full time

    Job DescriptionJob DescriptionHello Associates,Hope you are doing great!!I am David from Avenues International Inc. We are a well-established, US based, IT Staffing & Consulting firm, providing services since 1994, for clients across USA. We are a prime vendor to the New York State and work on their HBITS: Hourly-Based IT Services (New York State-wide)...


  • Albany, United States Avenues International Full time

    Job DescriptionJob DescriptionHello Associates,Hope you are doing great!!I am David from Avenues International Inc. We are a well-established, US based, IT Staffing & Consulting firm, providing services since 1994, for clients across USA. We are a prime vendor to the New York State and work on their HBITS: Hourly-Based IT Services (New York State-wide)...


  • Albany, United States Castletop Logistics LLC Full time

    Job Summary: **We have an opening for an Expert Software Developer HBITS-05-13372. **The APD project is designed to deliver an integrated health care data warehouse and analytic platform to provide policymakers, researchers, and consumers with a comprehensive repository of health care information. The NY APD will be used for quality measurement, population...


  • Albany, United States Amazon DSP Full time

    Overview: We are seeking a talented HBITS-05-13425 Required to work on site starting day 1 **DURATION**:30 Months **LOCATION**: Albany, NY - _Onsite_ The New York State Department of Motor Vehicles (DMV) will move its public website (dmv.ny.gov) and intranet site from Drupal 7 CMS to Drupal 8/9. Along with these migrations, DMV would like to make some...

  • Systems Developer

    2 weeks ago


    Albany, United States Princeton IT Services Full time

    Job DescriptionJob DescriptionJob Description:Job Title: System Developer Expert (. Net Developer)Location: Albany, NYDuration: long-termJob type: ContractSummary:Systems DeveloperDevelops and implements applications and programs for the backend processing systems used in businesses and organizations.Expert84+ Months: Candidate is able to provide guidance to...


  • Albany, United States Avenues International Full time

    Job DescriptionJob DescriptionHello Associates,Hope you are doing great!!I am David from Avenues International Inc. We are a well-established, US based, IT Staffing & Consulting firm, providing services since 1994, for clients across USA. We are a prime vendor to the New York State and work on their HBITS: Hourly-Based IT Services (New York State-wide)...


  • Albany, United States Spruce Technology Full time

    NYS Department of Labor (DOL) is seeking a Systems Architect Expert Day to Day task include: Performance Testing: planning, coordinating, and executing performance, load, and stress testing of SOA applications. This includes monitoring AIX, Linux and Windows environments, analyzing performance results, and scripting tests using Rational Performance Tester...


  • Albany, United States Spruce Technology Full time

    NYS Department of Labor (DOL) is seeking a Systems Architect ExpertDay to Day task include: Performance Testing: planning, coordinating, and executing performance, load, and stress testing of SOA applications. This includes monitoring AIX, Linux and Windows environments, analyzing performance results, and scripting tests using Rational Performance Tester...

  • Systems Developer

    1 month ago


    Albany, United States GENESYS Consulting Services Full time

    This is a 24 month opportunity on the Hourly-Based IT Services (HBITS) Contract at the State of New York. (Possibility of extension). Required Experience: 60 months of experience in designing and developing complex reports using SSRS. 60 months experience working with agency/business subject matter experts (SME) to understand business needs/requirements,...

  • Systems Developer

    2 weeks ago


    Albany, New York, United States GENESYS Consulting Services Full time

    This is a 24 month opportunity on the Hourly-Based IT Services (HBITS) Contract at the State of New York. (Possibility of extension). Required Experience: 60 months of experience in designing and developing complex reports using SSRS. 60 months experience working with agency/business subject matter experts (SME) to understand business needs/requirements,...

  • Systems Developer

    2 weeks ago


    Albany, New York, United States Vichara Full time

    Day-to-Day tasks:Work with client on analysis and requirement gathering.Perform complex .Net coding.Perform unit testing and correct all identified bugs.Respond to client inquiry and data requests.The individual in this position will work under the direction of a Project Manager.Perform writing of complex stored procedures/triggers in an Oracle database...

  • IT Specialist Expert

    2 weeks ago


    Albany, New York, United States PSI International Full time

    HBITS-(phone number removed) – IT Specialist Expert – 50% REMOTE – Albany, NYAgency Name: NYS Office of Mental HealthProject/Program Name: DLMS (Distributed List Management System). PCS (Patient Characteristics Survey) - a system that all OMH funded local providers must use every 2 years to update information about the patients they serve. Plus other...