Mindlance · 2 months ago
Database Architect - Expert
Albany, NY
Full-time
Onsite
Senior Level
$61.80/hr - $66.80/hrMindlance is a company that focuses on providing staffing solutions, and they are seeking a Database Architect to support critical operational functions related to the NYS Unemployment Insurance System. The role involves monitoring and optimizing various database systems, ensuring data quality, and collaborating with analysts and developers to meet business needs.
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 IBM Cognos Analytics for business intelligence
Experience with Oracle for data warehousing
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 monitoring and optimizing AI models
Strong communication skills for collaboration with business analysts and developers
Ability to document work performed and update knowledge base articles
Experience in data governance and compliance
Ability to troubleshoot and resolve database and report performance issues
Experience in performance tuning of databases
Company
Mindlance
Mindlance is a Staffing and Recruiting company which provides multi-vertical staffing services
Founded in 1999
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