Database Developer

Key Responsibilities

• Data Base Administration: Management of data extractions from the SAGE Datawarehouse cubes (troubleshooting, maintenance, and modifications as necessary)
• Server Maintenance: Ensuring servers' hardware and software are updated (RARS mainly), updating new drivers, plug-ins, running maintenance services, keeping indexes up to date, adapting to IT network changes, protecting against viruses, etc.
• Performance Monitoring: Monitoring the performance of hardware and software, preserving data, organizing data, securing backups, changing server configurations as needed, and reporting (error summary and system and shot reports).
• Reporting: Maintaining both data bases (internal reporting and IB), updating lookup tables for new errors and classifications, updating cubes for queries, creating new queries, and monitoring and troubleshooting automated jobs.
• Ai/ML Integration: Leveraging AI-driven techniques for database performance optimization, intelligent anomaly detection, predictive maintenance, and integrating AI into reporting and dashboard creation.

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

Optional Skills

• Python