Database Architect
- Gain America Inc.
2 Days Ago
65-70 per Hourly
NA
Albany-NY
7-15 Years
Required Skills: Database Architect, DB2, Oracle, Google Cloud database administration, Red Hat Linux administration & scripting, Data modeling using Erwin Data Modeler, IBM Cognos analytics, data warehousing, IBM cloud Pak for data, Snowflake, AI/ML
Job Description
Due Date: 11/25/2025
Note: Requires local candidates; only independent candidates. Requires fully qualified candidates; must meet all minimum qualification requirements.
Mandatory details, No Exception:
Note: The State of New York has strict documentation requirements; all requested documents must be submitted. The candidate will be considered for other suitable positions also as opportunities become available, and updates will be provided when relevant roles are identified.
- PP Number
- Visa Copy
- DL Copy
- Highest qualification Degree certificate copy
- Three professional references
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.
• 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.
• 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.
Education
Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field (degree copy required).
