Database Specialist Capgemini

About Capgemini

Job Description

We are seeking a highly skilled and experienced Site Reliability Engineer (SRE) Database Specialist to ensure the reliability, performance, and scalability of our database infrastructure. This role involves managing mission-critical database systems, automating operational tasks, and collaborating with engineering teams to build robust and scalable solutions. Primary Responsibilities: Ensure high availability, reliability, and performance of database systems. Develop and implement monitoring tools to proactively detect and resolve database issues. Optimize queries, indexes, and configurations for peak performance. Automate routine database tasks to improve efficiency and reduce manual intervention. Forecast and plan for database growth and scalability. Design and manage robust backup and disaster recovery strategies. Enforce database security best practices and conduct regular audits. Partner with development teams to design scalable and efficient database solutions. Maintain detailed documentation of database architecture, procedures, and policies. Required Skill Set: Primary Technical Skills: Expertise in RDBMS platforms: MySQL, PostgreSQL, Oracle, SQL Server, DB2. Strong command of SQL and database performance tuning. Experience with monitoring tools: Prometheus, Grafana, etc. Proficiency in scripting languages: Python, Bash, etc. Deep understanding of backup/recovery and high availability strategies. Knowledge of database security and compliance best practices. Secondary Skills: Familiarity with DevOps/SRE practices and tools. Experience with CI/CD pipelines and infrastructure as code (IaC). Exposure to cloud platforms (AWS, Azure, GCP) and managed database services. Knowledge of storage engines like InnoDB, MyISAM. Experience with SSIS, SSAS, SSRS is a plus.,