Job Title: Senior Consultant | Database Management | Bengaluru | Engineering
What impact will you make?
Every day, your work will make an impact that matters, while you thrive in a dynamic culture of inclusion, collaboration and high performance. As the undisputed leader in professional services, Deloitte is where you will find unrivaled opportunities to succeed and realize your full potential
Deloitte is where you will find unrivalled opportunities to succeed and realize your full potential.
The Team
Deloitte’s Technology & Transformation practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning.
Learn more about Analytics and Information Management Practice
Work you’ll do
Position Overview
We are seeking a highly skilled L1/L2 Support Technician to join our Database Production Operations team. The ideal candidate will have over 7 years of experience in database management and support, with a strong focus on providing technical assistance and troubleshooting for various database systems. This role requires deep technical expertise, excellent problem-solving skills, and the ability to manage and resolve database-related issues efficiently.
Key Responsibilities
- Technical Support: Provide L1/L2 support for database production operations, including troubleshooting and resolving database-related issues.
- Incident Management: Respond to and manage incidents related to database performance, availability, and security. Ensure timely resolution and minimal impact on business operations.
- Monitoring and Maintenance: Monitor database systems to ensure optimal performance and availability. Perform regular maintenance tasks such as backups, patching, and updates.
- User Assistance: Assist users with database-related queries and issues, providing clear and effective solutions.
- Documentation: Maintain accurate and up-to-date documentation of database configurations, procedures, and incident resolutions.
- Performance Optimization: Identify and address performance bottlenecks and inefficiencies in database systems.
- Security Management: Implement and manage security measures to protect database systems and data.
- Compliance: Ensure that all database operations comply with relevant policies, standards, and regulations.
- Collaboration: Work closely with other IT teams to ensure seamless integration and operation of database systems within the broader IT infrastructure.
- Continuous Improvement: Stay current with advancements in database technologies and best practices, continuously improving support processes and procedures.
Technical Skills
1. Environment Monitoring:
2. "Reporting:
a. Generate and distribute System Health Indicator (SHI) reports for production environments.
b. Provide SHI reports for non-production environments.
c. Address alerts whenever necessary"
3. Perform daily health checks in addition to regular monitoring to ensure system stability and performance.
4. Upgrade various application releases within the database on a quarterly cycle.
5. Perform database upgrades as needed
6. Perform routine maintenance and updates through patch activities.
7. "Performance Team Support: Address and resolve issues related to database performance.
8. Provide ongoing support to the performance team."
9. Offer support to Level 3 (L3) operations, including scripting and automation tasks.
10. Implement automation solutions for database management and related tasks.
11. Manage tasks related to database certificate maintenance and updates.
12. Conduct proactive system checks focusing on users and other operating system-related tasks.
13. Experience in Database Installation, Patching, and Upgrade.
14. MySQL backup strategies full backup, incremental backup, and restoration
15. Understanding of Replication Master-Master, Master-Slave
16. Basic Cluster knowledge.
17. Understanding of DR-Drill activities.
Required Qualifications
- Experience: Minimum of 7 years of experience in database management and support, with a focus on production operations.
- Technical Expertise: Strong technical background with expertise in various database systems such as Oracle, SQL Server, MySQL, PostgreSQL, and MongoDB.
- Certifications: Relevant database certifications such as Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, MySQL Database Administrator, and PostgreSQL Certified Professional.
- Problem-Solving: Exceptional problem-solving skills and the ability to troubleshoot and resolve complex database issues.
- Communication: Strong written and verbal communication skills, with the ability to convey technical information to non-technical stakeholders.
- Documentation: Proficiency in maintaining accurate records and generating detailed reports.
- Security Knowledge: Understanding of database security principles and best practices.
- Compliance Knowledge: Familiarity with compliance standards such as GDPR, HIPAA, and SOC 2.
- Education: Bachelor's degree in Computer Science, Information Technology, or a related field. Advanced certifications in database technologies are preferred.
Preferred Qualifications
- Certifications: Additional certifications such as Certified Information Systems Security Professional (CISSP), Certified Database Security Expert (CDSE), and AWS Certified Database – Specialty.
- Industry Knowledge: Familiarity with industry-specific regulations and standards.
- Project Management: Experience in managing database-related projects and initiatives.
- Advanced Degree: Master's degree in a related field.
Working Conditions
- Location: The role might require to be present in client location/Deloitte offices/Work from Home.
- Shift Work: This position may require working in shifts, including nights, weekends, and holidays.
- On-Call: Availability for on-call duties to respond to major incidents outside of regular working hours.
Location and way of working:
- Hybrid is our default way of working. Each domain has customized the hybrid approach to their unique needs.
Connect for impact
Our exceptional team of professionals across the globe are solving some of the world’s most complex business problems, as well as directly supporting our communities, the planet, and each other. Know more in our Global Impact Report and our India Impact Report.
Empower to lead
You can be a leader irrespective of your career level. Our colleagues are characterised by their ability to inspire, support, and provide opportunities for people to deliver their best and grow both as professionals and human beings. Know more about Deloitte and our One Young World partnership.
Inclusion for all
At Deloitte, people are valued and respected for who they are and are trusted to add value to their clients, teams and communities in a way that reflects their own unique capabilities. Know more about everyday steps that you can take to be more inclusive. At Deloitte, we believe in the unique skills, attitude and potential each and every one of us brings to the table to make an impact that matters.
Drive your career
At Deloitte, you are encouraged to take ownership of your career. We recognise there is no one size fits all career path, and global, cross-business mobility and up / re-skilling are all within the range of possibilities to shape a unique and fulfilling career. Know more about Life at Deloitte.
Everyone’s welcome… entrust your happiness to us
Our workspaces and initiatives are geared towards your 360-degree happiness. This includes specific needs you may have in terms of accessibility, flexibility, safety and security, and caregiving. Here’s a glimpse of things that are in store for you.
Interview tips
We want job seekers exploring opportunities at Deloitte to feel prepared, confident and comfortable. To help you with your interview, we suggest that you do your research, know some background about the organisation and the business area you’re applying to. Check out recruiting tips from Deloitte professionals.
|
|