[Hiring] Database Developer @Capgemini

Role Description

Capgemini is looking for a highly skilled and experienced Software Engineer - Database Developer to join our outstanding Engineering team. As a Software Engineer - Database Developer, you will play an important role in maintaining and updating our databases, ensuring accurate data analysis and reporting. You will also collaborate with other team members to efficiently implement new queries, resolve any issues with automated jobs, and improve performance. More importantly, leverage AI-driven techniques to automate error classification, enable predictive analytics for recurring issues, and deliver intelligent reporting, dashboards, and optimized data retrieval solutions.

Your Role

• 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.
  • Run maintenance services, keep the indexes up to date, adapt to 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 databases: 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 troubleshoot the daily automated jobs to run the reports.
  • Work with other resources when there are issues or modifications needed with the SAGE DW interface
  • Pre-emptive maintenance, look for data clogs and issues 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.

Qualifications

• Minimum of 5 years of experience in database schema design, development, and management
• 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)

Requirements

• The base compensation range for this role in the posted location is: $53,580 - $122,400/Year
• Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws.
• The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.
• In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.

Benefits

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade
• Company paid holidays
• Personal Days
• Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility