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)
• 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:
• Database performance optimization (query tuning, indexing strategies, workload prediction)
• Intelligent anomaly detection in system performance and data flows
• Predictive maintenance of database infrastructure

AI Integration in Reporting

• Leverage AI techniques for:

• Automated error classification and pattern detection
• Predictive analytics for identifying recurring system/reporting issues
• 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