Senior ITS Consultant - Database SRE

Responsibilities:

Database Management: Ensure the reliability, availability, and performance of database systems.

Monitoring and Incident Response: Develop and implement monitoring solutions to detect and respond to database-related issues promptly.

Performance Tuning: Optimize database performance through tuning queries, indexes, and configurations.

Automation: Automate repetitive tasks and processes to improve efficiency and reduce manual intervention.

Forecast database capacity needs and plan for future growth.

Backup and Recovery: Implement and run backup and recovery strategies to ensure data integrity and availability.

Security: Ensure database security by implementing standard processes and regular audits.

Collaboration: Work closely with development teams to design and implement database solutions that meet application requirements.

Documentation: Maintain comprehensive documentation of database configurations, procedures, and policies. Day-to-Day Jobs:

Incident Management: Respond to and resolve database-related incidents and outages.

Performance Analysis: Analyze database performance metrics and identify areas for improvement.

Automation: Develop and maintain scripts and tools to automate database management tasks.

Build self-service tools for engineers to run databases efficiently

Provide guidance on database design, query optimization, and schema changes to engineering teams

Collaboration: Participate in design and code reviews with development teams to ensure database standard processes are followed.

Maintenance: Perform regular maintenance tasks such as backups, patching, and upgrades.

Reporting: Generate reports on database performance, incidents, and capacity plans. Skills Requirements:

Technical Skills:

Proficiency in database management systems (e.g., MySQL, PostgreSQL, Oracle, SQL Server, DB2).

Strong knowledge of SQL and database performance tuning.

Experience with database monitoring tools (e.g., Prometheus, Grafana).

Familiarity with automation tools and scripting languages (e.g., Python, Bash).

Understanding of backup and recovery strategies.

Knowledge of database security standard processes.

Relevant certifications (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator) are a plus.

Soft Skills:

Excellent problem-solving and analytical skills.

Good communication and collaboration abilities.

Attention to detail and a proactive approach to database management. Basic Qualifications:

7+ years of database management experience in a global enterprise environment.

Ability to work in a 24x7 on-call after hour rotation environment.

Advocate for DevOps/SRE standard processes, leading postmortems/RCAs, incident retrospectives, and operational readiness reviews.

Significant experience with following products is a plus: InnoDB and MyISAM storage engines; SSIS, SSAS, and SSRS.

Bachelor's degree or equivalent experience in computer science or related subject area. Capgemini is equal opportunity employer.

Benefits- PTO, Sick days, 401K, Health insurance, Vision and Dental Insurance.