Database Architect

Brandon Consulting Associates, Inc.

Job Location:

Albany, GA - USA

Monthly Salary: Not Disclosed

Posted on: 2 hours ago

Vacancies: 1 Vacancy

Job Summary

Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

Provide a short description of the Position:

This position will assist in supporting critical DOL operational functions which include the development support and optization of data related functions within the new NYS Unemployment Insurance System.

Provide a list of the day-to-day tasks to be performed by the Selected Candidate:

Daily tasks include but are not limited to:
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.

BM 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.

Sr . No	Requested Qualification	Experience you Have In Months
1	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
2	84 Months Red Hat Linux Proficiency: experience in Red Hat Linux operating systems including command-line administration scripting and system troubleshooting.
3	84 Months Data Modeling Experience: experience with data modeling techniques and tools specifically Erwin Data Modeler for designing and maintaining OLTP systems.
4	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.
5	60 months Oracle Data Warehousing Knowledge: experience in data warehousing concepts on Oracle DB2 or BigQuery platforms.
6	60 months Data Integration Expertise: Experience with data integration tools and techniques particularly IBM DataStage for designing developing and executing ETL processes.
7	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.
8	84 Months Snowflake Data Warehouse Experience: Experience with Snowflake Data Warehouse including data loading performance optimization and query development.
9	84 Months AI/ML experience in Artificial Intelligence (AI) and Machine Learning (ML) concepts data preparation model deployment and model monitoring.
10	84 Months Communication and Collaboration experience collaborate with business analysts developers data scientists and other stakeholders.
Required Documentation	R sum Copy of Candidate Identification (i.e. Driver s License/Green Card/Visa and Passport if applicable) Any documents referenced in the above Requested Qualifications (i.e. professional certifications degrees etc.)

Brandon Consulting Associates Inc. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 29years.

Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field. Provide a short description of the Position: This position will assist in supporting critical DOL operational functions which include the development su...