Software Developer Senior - Albany, United States - PSI International

    PSI International
    PSI International Albany, United States

    3 weeks ago

    Default job background
    Description

    HBITS
    Software Developer Senior


    REMOTE NEGOTIABLE
    Albany, NY


    Agency Name:
    Office of the New York State Comptroller (OSC)


    Project/Program Name:
    [No data provided]

    Provide a short description of the Position:


    Consultant to act as a Software Developer for the APEX Team in the OSC Division of the Chief Information Officer (CIO).

    Provide a complete list of the day-to-day tasks to be performed by the

    Selected Candidate:
    Work under the guidance of the APEX Team Manager and Supervisor.

    Help OSC management develop APEX Roadmap and Strategy.

    Contribute to the development and establishement of the APEX Operating Model.

    Assess OSC APEX methodologies, practices, and activities and advise APEX Team on how they can be improved.

    Evaluate business functions, analyze business requirements, and assess feasibility, impact, and/or implications of using APEX.

    Guide development of APEX designs that are scalable and meet business requirements.


    Help the APEX team to establish a robust APEX Security Model, including integration with Active Directory for authentication and authorization.

    Assist APEX developers with building of shared components.

    Develop custom APEX applications.

    Prepare documentation associated with the development and implementation of new APEX applications.

    Perform quality assurance checks and post-implementation reviews.

    Collaborate and/or share knowledge with other staff in troubleshooting tasks.

    Keep management, APEX Team, and stakeholders fully informed on the status of work.

    Follow APEX industry best practices throughout the process.

    Hold Knowledge Transfer sessions with OSC Staff.



    Job Title:

    Software Developer



    Skill Level:

    Senior

    Target Start Date:

    5/24/2024

    Engagement Length in Months:

    12

    Is this a Full or Part-

    Time Position:
    Full-Time

    What are the daily work hours:

    Negotiable; between 8:00a and 5:00p

    Where is the physical work office located:

    110 State Street Albany, NY 12236

    Is telecommuting allowed for this position:

    Yes

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

    Negotiable - OSC's preference is for the selected candidate to work onsite for the first week

    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:

    Windows, Microsoft Office (Outlook, Teams, etc.), Microsoft Suite (Word, PowerPoint, Excel, Project), Git + GitLab, ServiceNow, Oracle, APEX, SQL, PL/SQL

    What type of hardware is typically used by the Agency:

    Laptop, monitor(s)


    Position MANDATORY Qualification:
    Software Developer

    Position

    Job Title:

    Software Developer


    Position Job Title Description:


    Is involved with all facets of the software development process, including the research, design, programming, testing and implementation of computer software.

    Position

    Skill Level:

    Senior


    Position Skill Level Description:

    months:
    Candidate is able to work independently, without assistance and provides guidance to others. May have an advanced education.

    List all the Position REQUESTED Qualifications:

    60 Months of Experience with using Oracle APEX software, with experience in Oracle APEX 17.x-21.x and Oracle Database 11g-21c.

    60 Months of Experience with with Oracle APEX security, authentication, and authorization schemes.


    60 Months of Experience with Oracle APEX analysis, design, development, testing, implementation, and maintenance of forms, interactive reports, interactive grids, collections, graphs, dashboards, and generating reports.

    48 Months of Experience with JavaScript, JSON, Web Services, XML, HTML, and UI/UX.


    60 Months of Experience with designing, developing, testing, and documenting new applications and supporting/enhancing existing applications on the Oracle APEX platform.

    60 Months of Experience with creation of dynamic reports in Oracle APEX environment using reporting tools (e.g. BI Publisher).

    60 Months of Experience with SQL and query performance tuning.


    60 Months of Experience with PL/SQL (procedures, functions, packages), cursors, triggers, collections, transactional modeling, database normalization, indexing methods, constraints, performance tuning, security, auditing, metadata management.

    12 Months of Experience with migration of legacy applications to Oracle APEX.

    Are there additional security requirements for the

    Authorized User:
    No

    Will additional training potentially be required during the Engagement:

    No

    What type and/or manner, of knowledge transfer is requested during the Engagement:


    Consultant will be required to document any established procedures, processes, standards, checklists, how-to guides and required artifacts established as output of developing APEX applications.


    Consultant will be required to document any applications they work on, including business requirements, technical specifications, system design documents, and security models.


    Consultant will be required to conduct working sessions and provide guidance to the OSC APEX Developers and APEX Administrators on tasks pertaining to APEX applications design and development.

    Consultant will be required to conduct code walk throughs and documentation reviews with the OSC APEX Developers and Business Users.

    Is travel anticipated during the Engagement:

    No

    #J-18808-Ljbffr