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.
Job: _Infrastructure_
Organization: _CIS US MS_
Title: _Senior ITS Consultant - Database SRE_
Location: _FL-Orlando_
Requisition ID: _079999_C
Capgemini
About Capgemini
A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50-year heritage and deep industry-specific expertise, Capgemini enables organizations to realize their business ambitions through an array of services from strategy to operations. Capgemini is driven by the conviction that the business value of technology comes from and through people. It is a multicultural company of over 200,000 team members in more than 40 countries. The Group reported 2018 global revenues of EUR 13.2 billion (about $15.6 billion USD at 2018 average rate).
Visit us at www.capgemini.com. People matter, results count.
10,000 employees or more
https://www.capgemini.com