Job Title: Senior Consultant | MS SQL | 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
AWS Cloud Infrastructure Management:
- Administer and maintain AWS environments, including EC2, S3, RDS, VPC, IAM, Lambda, and CloudWatch, to ensure high availability, performance, and security.
- Automate cloud infrastructure management tasks using tools such as Terraform, AWS CloudFormation, and Ansible.
- Monitor AWS resources and services continuously to ensure optimal performance and cost-efficiency.
- Troubleshoot and resolve issues in AWS infrastructure quickly to minimize service disruptions.
- Collaborate with development teams to provision AWS resources required for new projects and applications.
RHEL System Administration:
- Configure, deploy, and maintain Red Hat Enterprise Linux (RHEL) systems across cloud environments.
- Perform regular maintenance tasks, including patching, updates, and security hardening, to ensure RHEL systems are secure and performing optimally.
- Troubleshoot and resolve system and network issues across RHEL servers, ensuring minimal downtime.
- Collaborate with other IT teams to ensure seamless integration of RHEL servers with other infrastructure and cloud-based resources.
Operations Support and Incident Management:
- Provide 24/7 operational support for cloud and RHEL environments, ensuring minimal downtime and maximum uptime.
- Respond to and resolve operational incidents, performance issues, and service outages in a timely manner.
- Perform root cause analysis on incidents to identify long-term fixes and avoid recurrence.
- Assist in creating and updating documentation for operational procedures, incident response, and system configurations.
- Handle escalated support issues related to AWS and RHEL infrastructure.
Automation and Process Optimization:
- Develop automation scripts and tools to streamline manual tasks, improve operational efficiency, and enhance scalability.
- Implement infrastructure-as-code (IaC) practices using tools like Terraform, Ansible, or AWS CloudFormation.
- Work with the DevOps team to ensure smooth deployment and configuration management for both AWS and on-premises systems.
Monitoring and Performance Optimization:
- Maintain monitoring solutions (e.g., AWS CloudWatch, Nagios, Prometheus) to track system performance, health, and resource utilization.
- Identify and troubleshoot performance bottlenecks and implement optimizations to improve system efficiency.
- Regularly review AWS resource utilization and recommend adjustments to optimize cost without compromising performance.
Security and Compliance:
- Implement AWS security best practices, including managing IAM roles and policies, configuring firewalls and VPNs, and securing sensitive data.
- Maintain security and compliance standards for both AWS and RHEL systems, ensuring adherence to company policies and industry regulations (e.g., PCI DSS, GDPR).
- Perform regular security audits and vulnerability assessments of cloud environments and RHEL systems.
Backup, Recovery, and Disaster Recovery:
- Ensure data backup and disaster recovery procedures are in place and are being followed for both cloud and on-premises systems.
- Perform regular tests of backup and recovery processes to ensure business continuity in the event of a failure.
- Develop and maintain disaster recovery plans, ensuring systems can be quickly restored in the event of a system outage or disaster.
Working Conditions
- Location: The role might require to be present in client location/Deloitte offices.
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.