Pat N Sally Consulting Inc
Database Architect
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Database Architect with a contract length of over 6 months, offering $80.00 - $90.00 per hour. Key skills include DB2, Oracle, Google Cloud database administration, Red Hat Linux, data modeling, IBM Cognos Analytics, and Snowflake.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
720
-
🗓️ - Date
November 27, 2025
🕒 - Duration
More than 6 months
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Albany, NY 12240
-
🧠 - Skills detailed
#ERWin #IBM Cognos Analytics #Data Warehouse #Metadata #BigQuery #Deployment #Monitoring #Data Management #Business Analysis #Data Integration #Databases #"ETL (Extract #Transform #Load)" #Data Modeling #AI (Artificial Intelligence) #Data Lineage #Model Deployment #Scripting #Data Governance #DataStage #Database Administration #Snowflake #Data Science #Linux #Cloud #Oracle #ML (Machine Learning) #Security
Role description
DB2, Oracle, Google Cloud Database Administration: experience in administering databases on bare metal Linux environments, including installation, configuration, performance tuning, backup/recovery, and security management
Red Hat Linux Proficiency: experience in Red Hat Linux operating systems, including command-line administration, scripting, and system troubleshooting.
Data Modeling Experience: experience with data modeling techniques and tools, specifically Erwin Data Modeler, for designing and maintaining OLTP systems.
IBM Cognos Analytics Skills: Experience in developing, deploying, and maintaining reports and dashboards using IBM Cognos Analytics. This includes knowledge of Cognos Framework Manager, Data Modules, Report Studio, and related components.
Oracle Data Warehousing Knowledge: experience in data warehousing concepts on Oracle, DB2, or BigQuery platforms.
Data Integration Expertise: Experience with data integration tools and techniques, particularly IBM DataStage, for designing, developing, and executing ETL processes.
IBM Cloud Pak for Data / Knowledge Catalog Experience: Experience implementing, managing, and utilizing IBM Cloud Pak for Data, specifically the Knowledge Catalog, for metadata management, data governance, and data lineage.
Snowflake Data Warehouse Experience: Experience with Snowflake Data Warehouse, including data loading, performance optimization, and query development.
AI/ML experience in Artificial Intelligence (AI) and Machine Learning (ML) concepts, data preparation, model deployment, and model monitoring.
Communication and Collaboration experience collaborate with business analysts, developers, data scientists, and other stakeholders.
Job Types: Full-time, Contract
Pay: $80.00 - $90.00 per hour
Experience:
DB2, Oracle, Google Cloud Database Administration: 5 years (Required)
Red Hat Linux : 5 years (Required)
Data Modeling, OLTP systems: 3 years (Required)
IBM Cognos Analytics, Cognos Framework Manager: 3 years (Required)
Oracle Data Warehousing, Oracle, DB2: 3 years (Required)
Data Integration, IBM DataStage, ETL : 3 years (Required)
IBM Cloud Pak: 3 years (Required)
Snowflake Data Warehouse: 1 year (Required)
AI/ML: 1 year (Required)
Work Location: In person
DB2, Oracle, Google Cloud Database Administration: experience in administering databases on bare metal Linux environments, including installation, configuration, performance tuning, backup/recovery, and security management
Red Hat Linux Proficiency: experience in Red Hat Linux operating systems, including command-line administration, scripting, and system troubleshooting.
Data Modeling Experience: experience with data modeling techniques and tools, specifically Erwin Data Modeler, for designing and maintaining OLTP systems.
IBM Cognos Analytics Skills: Experience in developing, deploying, and maintaining reports and dashboards using IBM Cognos Analytics. This includes knowledge of Cognos Framework Manager, Data Modules, Report Studio, and related components.
Oracle Data Warehousing Knowledge: experience in data warehousing concepts on Oracle, DB2, or BigQuery platforms.
Data Integration Expertise: Experience with data integration tools and techniques, particularly IBM DataStage, for designing, developing, and executing ETL processes.
IBM Cloud Pak for Data / Knowledge Catalog Experience: Experience implementing, managing, and utilizing IBM Cloud Pak for Data, specifically the Knowledge Catalog, for metadata management, data governance, and data lineage.
Snowflake Data Warehouse Experience: Experience with Snowflake Data Warehouse, including data loading, performance optimization, and query development.
AI/ML experience in Artificial Intelligence (AI) and Machine Learning (ML) concepts, data preparation, model deployment, and model monitoring.
Communication and Collaboration experience collaborate with business analysts, developers, data scientists, and other stakeholders.
Job Types: Full-time, Contract
Pay: $80.00 - $90.00 per hour
Experience:
DB2, Oracle, Google Cloud Database Administration: 5 years (Required)
Red Hat Linux : 5 years (Required)
Data Modeling, OLTP systems: 3 years (Required)
IBM Cognos Analytics, Cognos Framework Manager: 3 years (Required)
Oracle Data Warehousing, Oracle, DB2: 3 years (Required)
Data Integration, IBM DataStage, ETL : 3 years (Required)
IBM Cloud Pak: 3 years (Required)
Snowflake Data Warehouse: 1 year (Required)
AI/ML: 1 year (Required)
Work Location: In person
