Database Architect
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Database Architect in Albany, NY, for 24 months, paying $45.00 - $80.00 per hour. Requires 84+ months of experience in data migration, OLTP data models, SQL Server/Oracle, and data governance.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
640
-
🗓️ - Date discovered
August 19, 2025
🕒 - Project duration
More than 6 months
-
🏝️ - Location type
On-site
-
📄 - Contract type
Unknown
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
Albany, NY 12207
-
🧠 - Skills detailed
#SQL Queries #Data Migration #Data Governance #Business Analysis #Requirements Gathering #Compliance #Documentation #"ETL (Extract #Transform #Load)" #RDBMS (Relational Database Management System) #BI (Business Intelligence) #SQL (Structured Query Language) #Oracle #Migration #SQL Server #Agile
Role description
Location: Albany, NY (50% onsite)Duration: 24 monthsTarget Start: September 17, 2025Application Due: August 20, 2025
Key Responsibilities
Design, develop, and optimize data models (conceptual, logical, physical) for OLTP systems.
Lead end-to-end data migration projects (planning, ETL design, validation, go-live).
Write and optimize complex SQL queries, stored procedures, and functions.
Develop dashboards and reports for KPIs, BI, and analytics.
Ensure data governance compliance (quality, lineage, asset management).
Collaborate with cross-functional teams (developers, DBAs, business analysts).
Mentor junior staff and provide knowledge transfer.
Support major DEC initiatives:
Pesticide Reporting Law (Outsystems DMND0004464)
Environmental Bond Act Information System – Phase 3 (DMND0004405)
Special Licenses System Modernization (DMND0004452)
Laboratory Information Management System RFP (DMND0004541)
Required Expertise (84+ Months)
Leading data migration projects using multiple integration patterns & technologies.
Designing & implementing OLTP data models.
Strong background in SQL Server / Oracle RDBMS.
Advanced SQL for analytics, reporting, and performance optimization.
Familiarity with Agile, Waterfall, Iterative SDLCs.
Experience with systems analysis (requirements gathering, modeling, design).
Proven work with data governance principles.
Required Documentation
Resume
Candidate Identification (Driver’s license, passport, visa if applicable)
Supporting documentation (degrees, certifications, etc.)
Apply today!Be part of projects that impact New York State’s environmental and public programs.
Please note that CCST cannot issue Visas, so all applicants must be US Citizens or have a valid Green Card.
Job Type: Contract
Pay: $45.00 - $80.00 per hour
Work Location: In person
Location: Albany, NY (50% onsite)Duration: 24 monthsTarget Start: September 17, 2025Application Due: August 20, 2025
Key Responsibilities
Design, develop, and optimize data models (conceptual, logical, physical) for OLTP systems.
Lead end-to-end data migration projects (planning, ETL design, validation, go-live).
Write and optimize complex SQL queries, stored procedures, and functions.
Develop dashboards and reports for KPIs, BI, and analytics.
Ensure data governance compliance (quality, lineage, asset management).
Collaborate with cross-functional teams (developers, DBAs, business analysts).
Mentor junior staff and provide knowledge transfer.
Support major DEC initiatives:
Pesticide Reporting Law (Outsystems DMND0004464)
Environmental Bond Act Information System – Phase 3 (DMND0004405)
Special Licenses System Modernization (DMND0004452)
Laboratory Information Management System RFP (DMND0004541)
Required Expertise (84+ Months)
Leading data migration projects using multiple integration patterns & technologies.
Designing & implementing OLTP data models.
Strong background in SQL Server / Oracle RDBMS.
Advanced SQL for analytics, reporting, and performance optimization.
Familiarity with Agile, Waterfall, Iterative SDLCs.
Experience with systems analysis (requirements gathering, modeling, design).
Proven work with data governance principles.
Required Documentation
Resume
Candidate Identification (Driver’s license, passport, visa if applicable)
Supporting documentation (degrees, certifications, etc.)
Apply today!Be part of projects that impact New York State’s environmental and public programs.
Please note that CCST cannot issue Visas, so all applicants must be US Citizens or have a valid Green Card.
Job Type: Contract
Pay: $45.00 - $80.00 per hour
Work Location: In person
