JSM Consulting Inc. · 1 week ago
Database Architect
Albany, NY
Contract
Onsite
Senior Level
7+ years expJSM Consulting Inc. is a consulting firm specializing in technology solutions, and they are seeking a Database Architect to manage and optimize database environments. The role involves database administration, data modeling, and collaboration with various stakeholders to ensure efficient data management and analytics.
Business DevelopmentConsultingInformation TechnologyProject ManagementTechnical Support
Responsibilities
Experience in administering databases on bare metal Linux environments, including installation, configuration, performance tuning, backup/recovery, and security management
Experience in Red Hat Linux operating systems, including command-line administration, scripting, and system troubleshooting
Experience with data modeling techniques and tools, specifically Erwin Data Modeler, for designing and maintaining OLTP systems
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
Experience in data warehousing concepts on Oracle, DB2, or BigQuery platforms
Experience with data integration tools and techniques, particularly IBM DataStage, for designing, developing, and executing ETL processes
Experience implementing, managing, and utilizing IBM Cloud Pak for Data, specifically the Knowledge Catalog, for metadata management, data governance, and data lineage
Experience with Snowflake Data Warehouse, including data loading, performance optimization, and query development
Experience in Artificial Intelligence (AI) and Machine Learning (ML) concepts, data preparation, model deployment, and model monitoring
Experience to collaborate with business analysts, developers, data scientists, and other stakeholders
Qualification
Required
72 Months 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
84 Months Red Hat Linux Proficiency: experience in Red Hat Linux operating systems, including command-line administration, scripting, and system troubleshooting
84 Months Data Modeling Experience: experience with data modeling techniques and tools, specifically Erwin Data Modeler, for designing and maintaining OLTP systems
84 Months 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
60 months Oracle Data Warehousing Knowledge: experience in data warehousing concepts on Oracle, DB2, or BigQuery platforms
60 months Data Integration Expertise: Experience with data integration tools and techniques, particularly IBM DataStage, for designing, developing, and executing ETL processes
60 months 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
84 Months Snowflake Data Warehouse Experience: Experience with Snowflake Data Warehouse, including data loading, performance optimization, and query development
84 Months AI/ML experience in Artificial Intelligence (AI) and Machine Learning (ML) concepts, data preparation, model deployment, and model monitoring
84 Months Communication and Collaboration experience to collaborate with business analysts, developers, data scientists, and other stakeholders
Company
JSM Consulting Inc.
We focus on improving our client’s assets performance and optimizing the operations through our industry best practices and asset management capabilities.
11-50 employees
H1B Sponsorship
JSM Consulting Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (18)
2024 (7)
2023 (11)
2022 (12)
2021 (20)
2020 (19)
Funding
Current Stage
Early StageCompany data provided by crunchbase