Backfill / Database architect

Greycell Labs Inc; Town of Cobleskill (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

Greycell Labs Inc in Albany, NY is seeking a Backfill / Database Architect to upgrade and consolidate aged systems into a single HMIS. You will design, implement, maintain, and secure databases to ensure performance, reliability, and data integrity, collaborating with developers, analysts, and IT teams.

The role involves generating and distributing standard and complex reports and dashboards, maintaining detailed logs of data management activities, and aligning data operations with business

Qualifications

• Bachelor’s degree in a related field.
• 7 years of experience designing logical and physical database models.
• 7 years experience designing Oracle databases including triggers and packages.
• 7 years experience in ETL techniques and flagging any failures.
• 5 years experience with SSIS design and development.
• 5 years experience using SQL Reporting Services (SSRS).
• 5 years experience in SQL programming including writing complex queries utilizing JSON in Oracle.
• 3 years experience participating in meetings to understand data needs and maintain detailed logs of data management activities and issues.

Responsibilities

• Upgrade and consolidate aging systems into one comprehensive HMIS.
• Design, implement, maintain, and secure organization databases for performance, reliability, and data integrity.
• Collaborate with developers, analysts, and IT teams to support business operations and strategic initiatives.
• Generate and distribute standard and complex reports and dashboards.
• Maintain detailed logs of data management activities and issues.

Skills

Database modeling

SQL proficiency

Data integrity

Team collaboration

ETL design

Education

Bachelor's Degree

Tools

Oracle databases

SSIS

SSRS

SQL

JSON in Oracle

ETL

Job description

Job Title: Backfill / Database Architect

Location: Albany, NY 12043

Duration: 30 Months

Job Description

• A Bachelor's Degree
• 84 months experience in designing logical and physical database models.
• 84 months experience designing oracle databases including triggers and packages
• 84 months experience in performing Extract, Transform, and Load (ETL) techniques and flagging any failures.
• 60 months experience with SSIS design and development
• 60 months experience using SQL Reporting Services (SSRS)
• 60 months experience in in SQL programming including writing complex queries utilizing JSON in Oracle.
• 36 months experience with participating in meetings to understand data needs and communicate updates on data status. Maintaining detailed logs of data management activities and issues.

____________________________________

Detailed Job Description: This project involves the upgrading and combining of various aging systems into one comprehensive Homeless Information Management System (HMIS). In this role, they will be responsible for designing, implementing, maintaining, and securing our organization’s databases to ensure optimal performance, reliability, and data integrity. They will collaborate closely with developers, analysts, and IT teams to support business operations and strategic initiatives. Generate and distribute standard & complex reports and dashboards. Maintain detailed logs of data management activities and issues

Note: Sorry we do not Sponsor Visa