Database Architect/Developer

2 weeks ago


Albany, United States Empire State Full time
*Applicants MUST submit a cover letter with resume to be considered.

*Position expected to work onsite and hybrid consistent with New York State.

BASIC FUNCTION:

For the Database of Economic Incentive’s: Develop, test, and maintain new and existing Microsoft SQL Server Databases in support of ESD’s business requirements. Applicant must possess a proficient knowledge of current / programming languages and be able to work both independently and in a team environment. Duties will include application programming, system installation/maintenance, diagnostics/performance monitoring, end user support, system disaster recovery, application testing and documentation as well as to provide technical assistance in any other area of IT as directed by department managers.

WORK PERFORMED:
  • Develop and support ESD’s Database of Economic Incentives (DOEI) database and business applications, taking on an active role in all stages of the application development life cycle
  • Make changes to the DOEI database as needed including but not limited to new program and existing field mapping, etc
  • Develop, maintain, and make any necessary changes to SSIS packages & Stored procedures used to populate the Database
  • Establish new and maintain existing connections to external databases
  • Establish and maintain proper security roles for the DOEI and associated databases
  • Work closely with Database of Economic Incentives Program Team, BA/PM, UT Developer, ESD Data Warehouse Architect, external contractors as well as other key IT Teams in support of the DOEI and associated platforms
  • Support, create and enhance new workflows, reports and customizations
  • Provide Data Analysis and Ad Hoc reporting as required by application users and ESD Management
  • Troubleshoot application performance bottlenecks to ensure fast efficient workflow and data processing
  • Develop “Test and Debug” strategies to ensure System reliability and data integrity
  • Assist with creating and maintaining documentation of DOEI workflow, user guides and data dictionaries
  • Research new technologies to improve professional knowledge and maintain an industry current skillset
  • Assist ESD’s development team with supporting other critical projects and platforms as time permits
  • Assist with IT Disaster Recovery efforts, testing and documentation
  • Perform other related duties as directed by IT Management

MINIMUM REQUIREMENTS:

Education Level required: BA in an IT related discipline with minimum of 3 years’ experience in related field; Or a 2-year degree with a minimum of 5 years’ experience; Or any equivalent combination of experience and/or education from which comparable knowledge, skills and abilities have been achieved.

Relevant experience required: Extensive experience in an Application Development role

Knowledge required: Strong proficiency, Microsoft SQL Server TSQL, Integration services (SSIS), working knowledge of principles of Data modeling, especially OLAP design. Microsoft Visual Studio 2015+, Microsoft SQL Server 2016+, Microsoft Office applications and Microsoft Operating Systems. Ability to work with a diverse group of people at both a functional and technical level and communicate at a level appropriate to audience; Ability to work both independently and as part of a team; Strong written and verbal communication skills.

  • Albany, United States Empire State Full time

    Job DescriptionJob Description*Applicants MUST submit a cover letter with resume to be considered.*Position expected to work onsite and hybrid consistent with New York State.BASIC FUNCTION: For the Database of Economic Incentive’s: Develop, test, and maintain new and existing Microsoft SQL Server Databases in support of ESD’s business requirements....

  • Database Architect

    6 days ago


    Albany, United States Princeton IT Services Full time

    Job DescriptionJob DescriptionJob Title : Database ArchitectLocation : Albany, NYJob Type : ContractJob Summary: Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and...


  • Albany, United States PSI International Full time

    HBITS-05-13421 - Database Architect Expert – 100% ONSITE - Albany, NY Agency Name: New York State Department of HealthProject/Program Name: Medicaid Enterprise SystemsProvide a short description of the Position: The position is to support Medicaid Enterprise Systems (MES). The Data Architect position will support major architecture initiatives of New York...


  • Albany, United States Avenues International Full time

    Job DescriptionJob DescriptionHello Associates,Hope you are doing great!!I am Ujjwal 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 Sligo Software Solutions Full time

    Job DescriptionJob DescriptionDescriptionThe position is to support Medicaid Enterprise Systems (MES). The Data Architect position will support major architecture initiatives of New York State Medicaid Enterprise.DutiesThe Database Architect (expert) will have responsibility for the Data Architecture for the Medicaid Enterprise at the MDW. The Database...


  • Albany, United States Sligo Software Solutions Full time

    Job DescriptionJob DescriptionDescriptionThe position is to support Medicaid Enterprise Systems (MES). The Data Architect position will support major architecture initiatives of New York State Medicaid Enterprise.DutiesThe Database Architect (expert) will have responsibility for the Data Architecture for the Medicaid Enterprise at the MDW. The Database...


  • Albany, United States Mindlance Full time

    Provide a short description of the Position: Act as Expert Database Architect working for NYS Information Technology Services on behalf of the NYS Department of Transportation to fulfill the duties as described below. Provide a list of the day-to-day tasks to be performed by the Selected Candidate: Interact with Agency/business subject matter experts to...

  • Database developer

    2 weeks ago


    Albany, United States Mindlance Full time

    Job Title: Database developer Job Type: lbany, New York (Hybrid) Duration: 30 Months Required Skills: • 84 month's experience developing and supporting Microsoft Access databases / applications. • 84 Month's experience developing and supporting Oracle Databases. • 84 month's experience developing and supporting Microsoft SQL Databases. • 84 month's...


  • Albany, United States Castletop Logistics LLC Full time

    Job Summary: The requirements listed below are from the "**State of New York,**" and requires applicants to start on-site on **Day 1** **Database Administrator - Expert - **HBITS-05-13387 **Agency Name: Information Technology Services (ITS)** **Location : 99 Washington Ave, Albany, NY, 12207** **Duration : 24. 0 Months** **Project/Program Name**: Grants &...

  • Database Architect

    4 days ago


    Albany, United States Edward Daniels Group Full time

    This is a corp-to-corp (C2C) opportunity with long term potential of up to 24 months. This project involves an upgrade of the current ACS application and functionality. Looking for a technology solution to reduce template maintenance, simplify application distribution, improve access to ACS data, enhance reporting and user security updates. - 84 months...

  • Software Architect

    2 weeks ago


    Albany, United States Five Cubes, Inc. Full time

    Job Title: Software Architect - 13184 Location: Albany, NY Duration: 30 Months Direct ClientJob Description: Daily Tasks include but not limited to the following: Evaluate existing and emerging technology, business requirements for the purpose of architecting efficient, portable and scalable solutions. Analysis, modeling, design, coding, testing and...

  • Java Architect

    2 weeks ago


    Albany, United States Bits & Bytes Technology Solutions Full time

    Java ArchitectDuration: 30 monthsLocation: Albany, NY (2-3 days remote every week)Client: State of New YorkJob Description:1.84 months experience in developing applications that are implemented with JAVA Development Kit (JDK 1.8 or higher).2.84 months experience with web development using JSF/JSP, HTML, CSS, and JavaScript.3.84 months experience in...


  • Albany, United States PSI International Full time

    HBITS-(phone number removed) - Software Architect Senior – 40% REMOTE (after 4 months) – Albany, NY Agency Name: Information Technology Services (ITS) Project/Program Name: DTF Modernization Program/RPS Modernization Project Provide a short description of the Position: This position will be in support of the NYS Tax Modernization Program. This program...


  • Albany, United States Princeton IT Services Full time

    Job DescriptionJob DescriptionJob Title: Senior Java Developer and Technical ArchitectLocation: Albany, NY( Hybrid)Job Type: ContractJob Summary:The candidate will Support the infrastructure with expertise in physical security, IT security architecture, infrastructure platforms, application security, monitoring, tool administration/management and related...

  • Systems Developer

    3 weeks 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,...

  • Java Architect

    7 days ago


    Albany, United States Indsafri Full time

    Job Description:Title: Java ArchitectLocation: Albany, NY (Hybrid)Position Type: W2/C2C ContractContract Duration: 19 Months with possible extensionRate: $60/hr on W2 or $65/hr on C2CMust Have Requirements:72 months of experience with J2EE technologies including JDBC, JSP and XML.72 months of experience developing, building, and testing Java EE applications...

  • Java Architect

    1 week ago


    Albany, United States Indsafri Full time

    Job Description:Title: Java ArchitectLocation: Albany, NY (Hybrid)Position Type: W2/C2C ContractContract Duration: 19 Months with possible extensionRate: $60/hr on W2 or $65/hr on C2CMust Have Requirements:72 months of experience with J2EE technologies including JDBC, JSP and XML.72 months of experience developing, building, and testing Java EE applications...

  • Java Architect

    6 days ago


    Albany, United States Indsafri Full time

    Job Description:Title: Java ArchitectLocation: Albany, NY (Hybrid)Position Type: W2/C2C ContractContract Duration: 19 Months with possible extensionRate: $60/hr on W2 or $65/hr on C2CMust Have Requirements:72 months of experience with J2EE technologies including JDBC, JSP and XML.72 months of experience developing, building, and testing Java EE applications...

  • Java Architect

    1 week ago


    Albany, United States Indsafri Full time

    Job Description:Title: Java ArchitectLocation: Albany, NY (Hybrid)Position Type: W2/C2C ContractContract Duration: 19 Months with possible extensionRate: $60/hr on W2 or $65/hr on C2CMust Have Requirements:72 months of experience with J2EE technologies including JDBC, JSP and XML.72 months of experience developing, building, and testing Java EE applications...

  • Java / JEE Architect

    1 month ago


    Albany, United States Trigyn Technologies Full time

    Job Description: Trigyn's direct government client has an immediate need for a Java / JEE Architect in Albany, NY. Description: The consultant will design and assist with the implementation of both small and large-scale software systems. The Software Architect will design, develop, implement, support, and enhance, custom applications written in...