Job Title: T&T-EAD-Consultant | MS SQL | Coimbatore CEC | Engineering
India’s impact on the global economy has increased at an exponential rate and Deloitte presents an opportunity to unleash and realize your potential amongst cutting edge leaders, and organizations shaping the future of the region, and indeed, the world beyond.
At Deloitte, your whole self to work, every day. Combine that with our drive to propel with purpose and you have the perfect playground to collaborate, innovate, grow, and make an impact that matters.
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.
As a Analyst/Consultant/Senior Consultant in our T&T Team you’ll build and nurture positive working relationships with teams and clients with the intention to exceed client expectations: -
- Design, develop and deploy solutions using different tools, design principles and conventions.
- Configure robotics processes and objects using core workflow principles in an efficient way; ensure they are easily maintainable and easy to understand.
- Understand existing processes and facilitate change requirements as part of a structured change control process.
- Solve day to day issues arising while running robotics processes and provide timely resolutions.
- Maintain proper documentation for the solutions, test procedures and scenarios during UAT and Production phase.
- Coordinate with process owners and business to understand the as-is process and design the automation process flow.
Key Responsibilities:
- MS SQL Database Administration:
- Install, configure, and manage MS SQL Server instances (SQL Server 2012, 2014, 2016, 2017, 2019).
- Manage database security, including user roles, permissions, and access controls.
- Implement and manage backup and recovery strategies to ensure data integrity and availability.
- Monitor and optimize the performance of SQL Server instances, including query tuning, index optimization, and resource utilization.
- Configure and manage SQL Server replication, clustering, Always On Availability Groups, and other high-availability solutions.
- Perform database migrations, upgrades, and patches to ensure the environment is up-to-date and secure.
- Troubleshoot and resolve database issues, including performance problems, connectivity issues, and data corruption.
- Automate SQL Server administration tasks using PowerShell or other scripting tools.
- Windows Server Administration:
- Install, configure, and manage Windows Server environments (Windows Server 2012/2016/2019) to support SQL Server databases.
- Perform OS-level management tasks, including patching, system updates, and security hardening.
- Configure and manage Windows Server services such as Active Directory, DNS, and DHCP, as they relate to SQL Server environments.
- Monitor and optimize system performance to ensure SQL Server workloads run efficiently.
- Administer server hardware, storage, and networking components as required by the MS SQL Server infrastructure.
- Manage Windows Server security configurations and access controls.
- Implement and manage system backups and disaster recovery processes for Windows Server environments.
- High Availability & Disaster Recovery:
- Design, implement, and support high availability (HA) and disaster recovery (DR) solutions for MS SQL Server environments.
- Ensure SQL Server is configured for failover clustering, Always On, or other HA configurations.
- Work with the Windows administration team to ensure the underlying infrastructure is designed for fault tolerance and uptime.
- Performance Tuning & Optimization:
- Monitor and analyze SQL Server performance using built-in tools (e.g., SQL Profiler, Extended Events, DMVs) and third-party monitoring solutions.
- Identify performance bottlenecks and implement database tuning techniques to optimize query performance, memory usage, and resource allocation.
- Work with application teams to ensure that database design and queries are optimized for performance.
- Collaboration & Documentation:
- Collaborate with development teams to support database needs, including deploying and managing stored procedures, scripts, and SQL jobs.
- Provide guidance to junior DBAs and other technical staff on best practices for MS SQL Server administration and Windows server management.
- Create and maintain detailed documentation for SQL Server configurations, troubleshooting steps, and disaster recovery procedures.
- Participate in capacity planning and system upgrades, providing input on hardware and software requirements.
- Security & Compliance:
- Implement and manage database security best practices, including encryption, auditing, and vulnerability scanning.
- Configure SQL Server instances to comply with security standards and regulatory requirements.
- Manage SQL Server user access, roles, and permissions according to the principle of least privilege.
- Work with internal security teams to ensure both SQL Server and Windows environments are secure from potential threats.
Required Skills and Qualifications:
- 7+ years of experience as an MS SQL Server DBA with a strong focus on Windows Server administration.
- Hands-on experience with MS SQL Server versions (2012, 2014, 2016, 2017, 2019), including installation, configuration, and performance tuning.
- Strong knowledge of Windows Server (2012/2016/2019) administration, including OS-level security, system configuration, and performance optimization.
- Expertise in configuring and managing high availability solutions such as Always On Availability Groups, SQL Server clustering, replication, and log shipping.
- In-depth experience with SQL Server backup and recovery strategies, including point-in-time recovery and data restoration.
- Solid understanding of performance tuning for MS SQL Server, including query optimization, index management, and resource utilization.
- Familiarity with PowerShell scripting for automation and administration tasks in both SQL Server and Windows environments.
- Experience with database security, including encryption, auditing, and access control management.
- Familiarity with disaster recovery planning and implementation for both MS SQL Server and Windows environments.
- Strong problem-solving skills and the ability to troubleshoot complex SQL Server and Windows-related issues.
- Excellent communication skills, both written and verbal, and the ability to collaborate effectively with cross-functional teams.
Location and way of working:
- Base location: Bangalore, Mumbai, Delhi, Pune, Hyderabad
- This profile involves occasional travelling to client locations.
- Hybrid is our default way of working. Each domain has customized the hybrid approach to their unique needs.
Your role as a Consultant/Senior Consultant/Manager:
We expect our people to embrace and live our purpose by challenging themselves to identify issues that are most important for our clients, our people, and for society.
In addition to living our purpose, Analyst/Consultant/Senior Consultant across our organization must strive to be:
- Inspiring - Leading with integrity to build inclusion and motivation.
- Committed to creating purpose - Creating a sense of vision and purpose.
- Agile - Achieving high-quality results through collaboration and Team unity.
- Skilled at building diverse capability - Developing diverse capabilities for the future.
- Persuasive / Influencing - Persuading and influencing stakeholders.
- Collaborating - Partnering to build new solutions.
- Delivering value - Showing commercial acumen
- Committed to expanding business - Leveraging new business opportunities.
- Analytical Acumen - Leveraging data to recommend impactful approach and solutions through the power of analysis and visualization.
- Effective communication – Must be well abled to have well-structured and well-articulated conversations to achieve win-win possibilities.
- Engagement Management / Delivery Excellence - Effectively managing engagement(s) to ensure timely and proactive execution as well as course correction for
the success of engagement(s)
- Managing change - Responding to changing environment with resilience
- Managing Quality & Risk - Delivering high quality results and mitigating risks with utmost integrity and precision
- Strategic Thinking & Problem Solving - Applying strategic mindset to solve business issues and complex problems.
- Tech Savvy - Leveraging ethical technology practices to deliver high impact for clients and for Deloitte
- Empathetic leadership and inclusivity - creating a safe and thriving environment where everyone's valued for who they are, use empathy to understand others to adapt our behaviours and attitudes to become more inclusive.
How you’ll grow
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.