Description

Key Responsibilities:
Data Base Administration
Management of the data extractions from the SAGE Datawarehouse cubes (this requires, troubleshooting, maintenance and modifications as necessary)
Ensures that the servers hardware and software are updated (RARS mainly)
o Making sure that the new drivers, plug-ins are updated. Make sure to run the maintenance services , keep the indexes up to day, adapt to the IT network changes, protection against virus, etc.
Monitoring of the performance of the hardware and software
Preserving data. Organize the data and secure backups
Changes to the server configuration as needed

Reporting (Error summary and system and shot reports)
Maintain both data bases: the internal reporting and the IB one
Update the look up tables for new errors and new classification of errors per weight and functional category
Update the cubes to allow queries that are required to analyze the data
Create new queries that allow to get the necessary reports from the existing cubes (internal testing and install base)
Monitor and troubleshooting of the daily automated jobs to run the reports.
Work with other resources when there are issues or modification are needed with the SAGE DW interface
Pre-emptive maintenance, look for data clogs and issue on the reports generation
Update the stored procedures for the excel reports with new errors, remove previous ones, add system info, etc
Apply AI/ML-driven tools and techniques for:
o Database performance optimization (query tuning, indexing strategies, workload prediction)
o Intelligent anomaly detection in system performance and data flows
o Predictive maintenance of database infrastructure
AI Integration in Reporting
Leverage AI techniques for:
o Automated error classification and pattern detection
o Predictive analytics for identifying recurring system/reporting issues
o Intelligent report generation and recommendation systems
Build and maintain smart dashboards with predictive insights and anomaly alerts.
Use AI-assisted tools to optimize report queries and improve data retrieval efficiency.

Mandatory skills:
Database Administration & Performance Optimization (SQL Server, indexing, query tuning, backups)
Data Warehousing & ETL Management (SAGE DW, cubes, data extraction, ETL processes)
Reporting & SQL Development (complex queries, stored procedures, automated reporting)
System Monitoring & Troubleshooting (job monitoring, performance tracking, issue resolution)
AI/ML & Advanced Analytics (anomaly detection, predictive analytics, AI-driven optimization & dashboards)
 

Key Skills

Education

Bachelor's degree