C

Capgemini

Global consulting, technology services, outsourcing

Database Developer

Database AdministrationUpdated on Nov 14
Full-timeIrving, TX, USA

About the Job

Requirements

  • At least 5 years of experience in database schema design, development, and management.
  • Experience with database administration and performance optimization, including SQL Server, indexing, query tuning, and backups.
  • Experience with data warehousing and ETL management, including SAGE data warehouse, cubes, data extraction, and ETL processes.
  • Experience with reporting and SQL development, including complex queries, stored procedures, and automated reporting.
  • Experience with system monitoring and troubleshooting, including job monitoring, performance tracking, and issue resolution.
  • Experience with AI and machine learning advanced analytics, including anomaly detection, predictive analytics, AI-driven optimization, and dashboards.

Responsibilities

  • Manage data extractions from the SAGE data warehouse cubes, including troubleshooting, maintenance, and modifications as necessary.
  • Ensure server hardware and software are updated, primarily RARS.
  • Update drivers and plug-ins; run maintenance services, keep indexes up to date, adapt to IT network changes, and protect against viruses.
  • Monitor hardware and software performance.
  • Preserve and organize data and secure backups.
  • Make changes to server configuration as needed.
  • Maintain the internal reporting database and the install-base database.
  • Update lookup tables for new errors and new error classifications by weight and functional category.
  • Update cubes to allow required queries for data analysis.
  • Create queries to produce reports from existing cubes for internal testing and the install base.
  • Monitor and troubleshoot daily automated reporting jobs.
  • Work with other resources to resolve issues or make modifications to the SAGE data warehouse interface.
  • Perform preventive maintenance by looking for data congestion and report-generation issues.
  • Update stored procedures for Excel reports with new errors, remove previous errors, and add system information.
  • Apply AI and machine learning tools and techniques for database performance optimization, including query tuning, indexing strategies, and workload prediction.
  • Use intelligent anomaly detection for system performance and data flows.
  • Apply predictive maintenance to database infrastructure.
  • Use AI techniques for automated error classification and pattern detection.
  • Use predictive analytics to identify recurring system and reporting issues.
  • Develop 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.

About the Company

Capgemini

Global consulting, technology services, outsourcing

Capgemini provides consulting, technology services, and outsourcing to help organizations transform digitally. Its offerings include strategy and transformation consulting, system integration, application development, IT infrastructure management, and managed IT operations. It differentiates itself with a global presence in over 50 countries and a focus on applying AI, cloud, and cybersecurity to real business problems. Its goal is to help clients navigate digital transformation and improve efficiency and innovation through tailored, contract-based or managed services.

Company size
10,001+
Company stage
IPO
Headquarters
Paris, France
Founded
1967

Recently Posted Jobs

Explore more opportunities at Capgemini

See more jobs