Mindlance · 2 months ago
Database Architect - Expert
Albany, NY
Full-time
Onsite
Senior Level
$61.80/hr - $66.80/hr
5+ years expMindlance is a company that focuses on supporting critical operational functions for the Department of Labor. The Database Architect will assist in the development, support, and optimization of data-related functions within the new NYS Unemployment Insurance System, including monitoring and maintaining various database systems and ensuring data quality and performance.
Human Resources
Responsibilities
Morning Check-in: Review overnight alerts and monitoring dashboards for any critical issues across all systems (DB2, Oracle, Cognos, Datastage). Check for any new service requests or incidents related to data management. Prioritize tasks based on urgency and impact
Communication: Respond to emails and messages related to data management tasks. Participate in daily stand-up meetings (if applicable) to provide updates on progress and any roadblocks
Documentation: Document all work performed, including changes made, issues encountered, and resolutions. Update knowledge base articles as needed
DB2 Administration (Bare Metal Red Hat Linux): Database Monitoring: Monitor DB2 database performance metrics (CPU usage, memory usage, disk I/O, buffer pool hit ratios). Check for any database errors or warnings in the DB2 diagnostic logs. Monitor database backup and recovery processes
Maintenance: Perform routine database maintenance tasks (e.g., running RUNSTATS, REORGCHK, REORG). Apply database patches and upgrades as needed (following change management procedures)
Security: Review DB2 security settings and user access privileges. Monitor for any unauthorized access attempts
Data Modeling (Erwin Data Modeler): Model Maintenance: Update data models based on changes to business requirements or system implementations. Ensure data models are consistent and accurate. Maintain version control of data models
Collaboration: Work with business analysts and developers to understand data requirements. Review data models with stakeholders to ensure they meet business needs
Business Intelligence (IBM Cognos Analytics): Report Monitoring: Monitor the performance of Cognos reports and dashboards. Investigate and resolve any report errors or performance issues
Content Management: Manage Cognos content (reports, dashboards, data modules). Ensure content is organized and accessible to users
User Support: Provide support to Cognos users, answering questions and troubleshooting issues
Data Warehousing (Oracle): ETL Monitoring: Monitor the execution of ETL (Extract, Transform, Load) processes that load data into the Oracle data warehouse. Investigate and resolve any ETL errors or performance issues
Data Quality: Monitor data quality in the data warehouse. Identify and correct data quality issues
Performance Tuning: Tune Oracle database performance to optimize query response times
Data Integration (IBM Datastage): Job Monitoring: Monitor the execution of DataStage jobs. Investigate and resolve any job failures or performance issues
Job Maintenance: Modify and update DataStage jobs as needed to meet changing data integration requirements
IBM Cloud Pak for Data / Knowledge Catalog: Metadata Management: Review and update metadata in the Knowledge Catalog. Monitor data lineage and impact analysis
Data Governance: Enforce data governance policies. Address any data quality or compliance issues identified
Snowflake Data Warehouse: Data Pipeline Monitoring: Monitor data pipelines loading data into Snowflake. Troubleshoot any pipeline failures or performance issues
Performance Optimization: Optimize Snowflake queries and data structures for performance
Artificial Intelligence (AI): Model Monitoring: Monitor the performance of deployed AI models. Work with data scientists to address any model degradation or accuracy issues
Data Preparation: Prepare data for AI model training and deployment
Qualification
Required
Experience with DB2 Administration on Bare Metal Red Hat Linux
Experience with Data Modeling using Erwin Data Modeler
Experience with Business Intelligence tools, specifically IBM Cognos Analytics
Experience with Data Warehousing, particularly Oracle
Experience with ETL processes and monitoring using IBM Datastage
Experience with IBM Cloud Pak for Data and Knowledge Catalog
Experience with Snowflake Data Warehouse
Experience with Artificial Intelligence model monitoring and data preparation
Strong communication skills for collaboration with business analysts and developers
Ability to document work performed and update knowledge base articles
Experience in monitoring database performance metrics and troubleshooting issues
Ability to enforce data governance policies and address compliance issues
Company
Mindlance
Mindlance is a Staffing and Recruiting company which provides multi-vertical staffing services
1001-5000 employees
H1B Sponsorship
Mindlance 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 (71)
2024 (53)
2023 (37)
2022 (72)
2021 (36)
2020 (40)
Funding
Current Stage
Late StageLeadership Team
R
Rajat Paul Dhall
Co-Founder & Managing Director
V
Vik Kalra
Co-Founder and Managing Director
Recent News
2025-11-19
Kelly Services, Inc.
2025-05-17
2025-04-14
Company data provided by crunchbase