Deloitte

MSSQLDBA- Analyst/ Consultant - Bengaluru/Hyderabad

Deloitte

July 20, 2021

SCAM ALERT: Caution against fraudulent job offers!
More Info
×
SCAM ALERT
Caution against fraudulent job offers!
We have been informed of instances where jobseekers are led to believe of fictitious job opportunities with Deloitte India (“Deloitte”). In one or more such cases, false promises of actual or potential selection, or initiation or completion of the recruitment formalities appear to have been or are being made. Some jobseekers appear to have been asked to pay money to specified bank accounts of individuals or entities as a condition of their selection for a ‘job’ with Deloitte. These individuals or entities are in no way connected with Deloitte and do not represent or otherwise act on behalf of Deloitte.
We would like to clarify that:
At Deloitte, ethics and integrity are fundamental and not negotiable.
We are against corruption and neither offer bribes nor accept them, nor induce or permit any other party to make or receive bribes on our behalf.
We have not authorised any party or person to collect any money from jobseekers in any form whatsoever for promises of getting jobs in Deloitte.
We consider candidates on merit and that we provide an equal opportunity to eligible applicants.
No one other than designated Deloitte personnel (e.g., a Deloitte recruiter or Deloitte hiring partner) is permitted to extend any job offer from Deloitte.
Anyone who at any time has made or makes any payment to any party in exchange of promises of job or selection for a job with Deloitte or any matter related to this (including those for ‘registration’, ‘verification’ or ‘security deposit’) or otherwise engages with any such person who has made or makes fraudulent promises or offers, does so (or has done so) entirely at their own risk. Deloitte takes no responsibility or liability for any such unauthorised or fraudulent actions or engagements.
We encourage jobseekers to exercise caution.
Microsoft SQL Server DBA
Microsoft SQL Server DBA Consultant at Deloitte Consulting
Work you’ll do
As a SQL Server DBA you would be expected to,
Have complete understanding of SQL Server 2012, 2014 and later versions Architecture and Technical concepts related to Database Administration involving AlwaysOn, SQL Clustering, Replication and Mirroring
Automate and perfect operational DBA duties which will include installation, database upgrades, patching, implementing backup/recovery and monitoring procedures, capacity planning and site failover/switchover
Provides leadership and expertise in investigation and resolution of performance related issues for Production environments
Design major reconstructions of database structures to ensure appropriate levels of performance, data integrity, recovery and security
Develop and implement standards, procedures, and policies regarding software and applications databases (including naming, migration, backup, recovery, and security)
Respond quickly and effectively to production & development issues and taking responsibility for seeing those issues through resolution adhering to Service Level objectives
Available to work in shifts including night shift on rotation basis.
On-call DBA support on rotation basis.
Be a team player and work with the team members across geographies to deliver innovative solutions to client.
Create and maintain documentation relating to DBA processes and technical information.
The team
At AMS SQL Server we understand that people are our most precious resource. We don’t look at our people as resources but as practitioners leveraging their capabilities in their respective technology domains. We bring together a strong combination of experience, scale and capabilities to help clients address their most complex business problems. The organizational structure of our parent organization, Deloitte LLP (“Deloitte”) and our collaborative approach integrate our consulting services with other Deloitte subsidiaries offering tax services, financial advisory services, and risk management capabilities. Clients depend on us for straightforward advice and results that create value.
Qualifications - Consultant/Analyst
Required:
Hands-on experience in administration of SQL Server 2008 and later versions is a must
Minimum 4 years of Production support DBA experience in SQL Server 2008 and above versions, with strong hands-on experience in installation, upgrade, migrate, troubleshooting and performance tuning stand-alone and clustered environments
Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes
Assist developers with complex query tuning and schema refinement.
Provide 24x7 support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Preferred:
2+ years of experience with disaster recovery, performance analysis and tuning, index maintenance, and data monitoring, including administering, maintaining, analyzing, and implementing policies and procedures for ensuring database security and integrity
Hands-on experience in administration of SQL Server 2012, 2014, 2016 and SQL Server 2017
Knowledge in SQL Server Integration Services (SSIS), SQL Server Reporting Services
(SSRS) and SQL Server Analysis Services (SSAS)
Qualifications – Consultant
Required:
Hands-on experience in administration of SQL Server 2008 and later versions is a must
Minimum 5 years of Production support DBA experience in SQL Server 2008 and above versions, with strong hands-on experience in installation, upgrade, migrate, troubleshooting and performance tuning stand-alone and clustered environments
Expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services
(SSRS) and SQL Server Analysis Services (SSAS)
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes
Assist developers with complex query tuning and schema refinement.
Provide 24x7 support for critical production systems.
Perform scheduled maintenance and support release deployment activities after hours.
Experience with backups, restores and recovery models
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience working with Windows server, including Active Directory
Excellent written and verbal communication
Flexible, team player, “get-it-done” personality
Ability to organize and plan work independently
Ability to work in a rapidly changing environment
Ability to multi-task and context-switch effectively between different activities and teams
Preferred:
5 + years of experience with disaster recovery, performance analysis and tuning, index maintenance, and data monitoring, including administering, maintaining, analyzing, and implementing policies and procedures for ensuring database security and integrity
Hands-on experience in administration of SQL Server 2012, 2014, 2016 and SQL Server 2017
MCTS, MCITP, and/or MVP certifications a plus
How you’ll grow
At Deloitte, we’ve invested a great deal to create a rich environment in which our professionals can grow. We want all our people to develop in their own way, playing to their own strengths as they hone their leadership skills. And, as a part of our efforts, we provide our professionals with a variety of learning and networking opportunities—including exposure to leaders, sponsors, coaches, and challenging assignments—to help accelerate their careers along the way. No two people learn in exactly the same way. So, we provide a range of resources including live classrooms, team-based learning, and eLearning. DU: The Leadership Center in India, our state-of-the-art, world-class learning Center in the Hyderabad offices is an extension of the Deloitte University (DU) in Westlake, Texas, and represents a tangible symbol of our commitment to our people’s growth and development. Explore DU: The Leadership Center in India
Benefits
At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.
Deloitte’s culture
Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture that is inclusive, invites authenticity, leverages our diversity, and where our people excel and lead healthy, happy lives. Learn more about Life at Deloitte.
Corporate citizenship
Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Deloitte’s impact on the world.
\\“Deloitte\\” is the brand under which tens of thousands of dedicated professionals in independent firms throughout the world collaborate to provide audit, consulting, financial advisory, risk management and tax services to selected clients. These firms are members of Deloitte Touche Tohmatsu Limited DTTL, a UK private company limited by guarantee. Each member firm provides services in a particular geographic area and is subject to the laws and professional regulations of the particular country or countries in which it operates. DTTL does not itself provide services to clients. DTTL and each DTTL member firm are separate and distinct legal entities, which cannot obligate each other. DTTL and each DTTL member firm are liable only for their own acts or omissions and not those of each other. Each DTTL member firm is structured differently in accordance with national laws, regulations, customary practice, and other factors, and may secure the provision of professional services in its territory through subsidiaries, affiliates and/or other entities.
In the United States, Deloitte LLP is the member firm of DTTL. Like DTTL, Deloitte LLP does not provide services to clients. Instead, services are primarily provided by the subsidiaries of Deloitte LLP, including:
Deloitte & Touche LLP
Deloitte Consulting LLP
Deloitte Financial Advisory Services LLP
Deloitte Tax LLP
Requisition code: E22BCCONEG-MSSQLDBAS