Overview
On Site
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Skills
Artificial Intelligence
Backup
Cloud Computing
Collaboration
Communication
Dashboard
Data Management
Data Modeling
Data Science
Data Warehouse
Database
Database Administration
Datastage
ERwin
Extract
Transform
Load
Google Cloud
Google Cloud Platform
IBM Cognos Analytics
IBM Cognos Report Studio
IBM DB2
IBM InfoSphere DataStage
IBM SmartCloud
IT Management
Linux
Machine Learning (ML)
Management
Meta-data Management
OLTP
Optimization
Oracle
Oracle Db
Performance Tuning
Recovery
Red Hat Linux
Reporting
Scripting
Security Management
Snow Flake Schema
Structural Engineering
Job Details
Role: Database Architect
Location: Albany, New York
Duration: 2.5 Years Contract
Job Description:
What our client is looking for?
Our client is seeking a highly experienced Database Architect with deep expertise in designing, implementing, and managing enterprise-level database systems. The ideal candidate will have strong experience across database platforms, Linux environments, data modeling tools, reporting tools, cloud data services, and ETL technologies.
Primary Responsibilities:
- Analyze business and application requirements to define database structures.
- Design logical and physical data models for OLTP and data warehouse systems.
- Install, configure, and administer databases on Linux environments.
- Perform performance tuning, backup/recovery, and security management.
- Develop and maintain ETL processes using DataStage or related tools.
- Support metadata management and governance using IBM Cloud Pak for Data.
- Develop and maintain dashboards/reports using IBM Cognos Analytics.
- Work with Snowflake, BigQuery, Oracle, and DB2 for data management and optimization.
- Collaborate with analysts, developers, and data science teams.
- Provide technical leadership and guidance.
Experience / Preferred Qualifications
- 7+ years of experience as a senior Database Architect.
- 6+ years of DB2, Oracle, and Google Cloud database administration.
- 7+ years of Red Hat Linux administration & scripting.
- 7+ years of data modeling using Erwin Data Modeler.
- 7+ years of IBM Cognos Analytics (Framework Manager, Data Modules, Report Studio).
- 5+ years of data warehousing on Oracle/DB2/BigQuery
- 5+ years of ETL development using IBM DataStage.
- 5+ years of IBM Cloud Pak for Data (Knowledge Catalog).
- 7+ years of Snowflake data warehouse experience.
- 7+ years of AI/ML experience (data prep, model deployment, monitoring).
- Strong communication and collaboration skills.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.