Capgemini

Database Operations Engineer

Capgemini

full-time

Posted on:

Location Type: Remote

Location: Mexico

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AnsibleAWSAzureCloudCognosGoogle Cloud PlatformInformaticaMySQLOraclePostgresPythonSQLTerraformVault

About the role

  • Design and implement cloud-native database infrastructure using Terraform /Ansible to provision managed DB instances in multi-clouds (RDS/Azure DB /Cloud SQL) and self-managed clusters
  • Automate Configuration Management, security hardening, and patching of database instances across all environments. Automate workflows to reduce manual effort and improve reliability.
  • Develop internal tools and scripts (Python/Bash) to enable production support teams to manage their own database instances and environments safely.
  • Integrate advanced observability platforms (Dynatrace, CloudWatch) with AIOps tools to establish SLOs and train models for anomaly detection and proactive forecasting of database degradation like predicting slow queries or imminent connection pool exhaustion).
  • Design, deploy, and govern AI-powered agents (using Azure Copilot /AWS Bedrock) to achieve autonomous self-healing capabilities and automated resource management.
  • Implement advanced monitoring (CloudWatch, Dynatrace) for key database metrics (SLIs/SLOs) like latency, throughput, error rates, and connection pools. Develop and train predictive ML models to analyze historical telemetry and forecast potential system outages or performance bottlenecks and configure proactive monitoring and alerting for critical services.
  • Execute backup strategies and validate recovery procedures using Rubrik and Perform restores as needed
  • Work closely with application operations / Production support teams to troubleshoot issues on database layer (performance, locks, schema) and the platform layer (multi-cloud /middleware /network, resource limits) to find the root causes
  • Lead incident response and root cause analysis (RCA) for database outages, performance degradations, and data integrity issues. Collaborate with DBAs and application teams for root cause analysis.
  • Implement AI tools to perform real-time Root Cause Analysis (RCA), correlate complex event data (logs, metrics) and auto-generate runbooks
  • Define and automate scaling strategies (read replicas, sharding, auto-scaling) based on predicted load and business growth. Provide input for capacity planning and resource optimization.
  • Implement cost management policies, including rightsizing instances, managing storage tiers, and defining lifecycle rules for backups and snapshots.
  • Support DBA teams in performance tuning initiatives.
  • Implement robust secrets management solutions (AWS Secrets Manager, HashiCorp Vault) for database credentials, ensuring applications retrieve secrets securely at runtime.
  • Ensure database environments meet regulatory requirements (PCI, HIPAA, GDPR) through encryption-at-rest and in-transit, audit logging, and automated compliance checks.
  • Define and enforce least-privilege access policies (IAM roles, service accounts) for databases.
  • Implement encryption and data masking policies as directed.
  • Manage security and compliance by utilizing AI agents to detect configuration drift and auto-generate compliant updates for IAM, network, and security policies.

Requirements

  • 5+ years of experience in Oracle / DB2 /MSSQL/Snowflake/PostgreSQL and MySQL administration, with a strong focus on AIOps integration. - Advanced
  • 4+ years of experience in public cloud operations (AWS, Azure, GCP). - Advanced
  • Deep, demonstrable expertise designing and operationalizing solutions leveraging AWS Bedrock/Agent Frameworks and Azure Copilot for DB Operations. - Advanced
  • Expertise in Infrastructure as Code (Terraform, CloudFormation), Ansible, and CI/CD pipelines, including supervising AI-generated infrastructure artifacts. – Advanced
  • Expertise integrating observability platforms into AI/ML platforms for predictive analysis and anomaly detection. - Advanced
  • Hands-On experience on Informatica PowerCenter / PowerBI /Cognos /Sapiens /Alteryx/IDMC/ILM/SAS / BusinessObjects / Glue / SPSS /ODI - PLUS
  • Proficiency in scripting languages (Python or Bash) - Advanced
Benefits
  • A competitive salary and performance-based bonuses.
  • Comprehensive benefits package.
  • Flexible work arrangements (remote and/or office-based).
  • You will also enjoy a dynamic and inclusive work culture within a globally renowned group.
  • Private Health Insurance.
  • Paid Time Off.
  • Training & Development opportunities in partnership with renowned companies.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
TerraformAnsiblePythonBashAWS BedrockAzure CopilotRDSAzure DBCloud SQLOracle
Soft Skills
incident responseroot cause analysiscollaborationtroubleshootingcapacity planningresource optimizationperformance tuningcommunication