Jobs
>
Albany

    Database Architect/Developer - Albany, United States - Empire State

    Default job background
    Description

    Job Description

    Job 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. 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.



  • Empire State Albany, United States

    *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 Dat ...


  • PSI International Albany, United States

    HBITS Database Architect Expert 50% REMOTE Albany, NY · Agency Name: NYS Office of Mental Health · Project/Program Name: Aid to Localities Fiscal System (ALFS); Client Worker Payroll (CWP); Oracle Cost Reporting Application (OCRA); MHARS Enhancement and Transformation (MET) ...


  • PSI International Albany, United States

    HBITS Database Architect Expert – 100% ONSITE - Albany, NY · Agency Name: New York State Department of Health · Project/Program Name: Medicaid Enterprise Systems · Provide a short description of the Position: The position is to support Medicaid Enterprise Systems (MES). The Data ...

  • Princeton IT Services

    Database Architect

    1 week ago


    Princeton IT Services Albany, United States

    Job Description · Job DescriptionJob Title : Database Architect · Location : Albany, NY · Job Type : Contract · Job Summary: Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates curre ...


  • Mindlance Albany, United States

    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 th ...


  • Avenues International Albany, United States

    Job Description · Job 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 ...

  • Mindlance

    Database developer

    3 weeks ago


    Mindlance Albany, United States

    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. · ...

  • Avenues International, Inc.

    Database Developer

    2 weeks ago


    Avenues International, Inc. Albany, United States

    Position Name: Database Developer · Job ID: HBITS · Duration: 5+ Months · Location: Albany, NY, (Day 1 Onsite) · Primary Skills: · 60 Months Experience with relational database management systems. · 48 Months Experience with Oracle 10g or higher. · 48 Months Experience writing ...

  • Castletop Logistics LLC

    Database Architect

    1 week ago


    Castletop Logistics LLC Albany, United States

    Job Overview: · The requirements listed below are from the "**State of New York,**" and requires applicants to start on-site on **Day 1** · **Database Architect - Expert - HBITS ** · **Location : 44 Holland Ave, Albany NY 12229** · **Agency Name:NYS Office of Mental Health** · ** ...

  • Tekcogno

    Database Architect

    3 weeks ago


    Tekcogno Menands, United States

    **Role: Database Architect Expert** · **Location: Menands, NY % Remote** · **Job description**: · **Day-to-day tasks include, but are not limited to**: · 1. Working with large and complex Oracle data warehouses, data marts and OLTP databases. · 2. Overseeing the creation/modifica ...


  • Sligo Software Solutions Albany, United States

    Job Description · Job DescriptionDescription · The position is to support Medicaid Enterprise Systems (MES). The Data Architect position will support major architecture initiatives of New York State Medicaid Enterprise. · Duties · The Database Architect (expert) will have respons ...


  • Catholic Charities of the Dioscese of Albany Albany, United States

    Job Description · We are currently hiring a Development & Database Coordinator, to work in our Executive Office & Support Services. As the Development & Database Coordinator, you would be responsible for: · Manage incoming and outgoing fundraising correspondence · Perform and coo ...

  • Vichara

    Database Developer

    5 days ago


    Vichara Albany, United States

    Company Description · Vichara 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 Description · Day-to-Day tasks: · - The candidates will analyze, design/functi ...

  • Vichara

    Database Developer

    3 days ago


    Vichara Albany, United States

    Job Description · Job DescriptionCompany Description · Vichara 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 Description · Day-to-Day tasks: · - The candidate ...


  • Mindlance Menands, United States

    Provide a short description of the Position: On March 31, 2021, former Governor Andrew Cuomo signed the Marihuana Regulation & Taxation Act (MRTA). The legislation creates a new Office of Cannabis Management (OCM) governed by a Cannabis Control Board to oversee and implement the ...


  • Catholic Charities of the Dioscese of Albany Albany, United States

    Job Description · We are currently hiring a Development & Database Coordinator, to work in our Executive Office & Support Services. As the Development & Database Coordinator, you would be responsible for: · + Manage incoming and outgoing fundraising correspondence · + Perform ...


  • System Edge LLC Albany, United States

    Hello, · We are urgently hiring for the below contractual role with our Direct client NYS: · Job Title: Oracle Database Architect with Healthcare or Medicaid exp. · Client: State of New York · Agency: Office of Mental Health · Task ID: HBITS · Location: 44 Holland Ave, Albany N ...


  • GreyCell Labs, Inc Albany, United States

    Job Title: ON-SITE -Oracle Database Architect - HBITS · Location: Albany, NY,12229 · Duration: Long-term · Job Description: · 84 months experience ensuring the soundness of the architecture and security of Oracle databases for multiple applications in Production/Quality Assura ...


  • Princeton IT Services Albany, United States

    Job Description · Job DescriptionJob Title: Senior Java Developer and Technical Architect · Location: Albany, NY( Hybrid) · Job Type: Contract · Job Summary: · The candidate will Support the infrastructure with expertise in physical security, IT security architecture, infrastruct ...


  • GreyCell Labs, Inc Albany, United States

    Job Title: ON-SITE -Sr. Java Developer / Architect -HBITS · Location: Albany, NY, 12227 · Duration: Long-term · Job Description: · 72 months of experience with J2EE technologies including JDBC, JSP and XML. · 72 months of experience developing, building, and testing Java EE ap ...