Position Summary

CORE BUSINESS OPERATIONS

The Core Business Operations (CBO) portfolio is an integrated set of offerings that addresses our clients’ heart-of-the-business issues. This portfolio combines our functional and technical capabilities to help clients transform, modernize, and run their existing technology platforms across industries. As our clients navigate dynamic and disruptive markets, these solutions are designed to help them drive product and service innovation, improve financial performance, accelerate speed to market, and operate their platforms to innovate continuously.

Senior Consultant:

As a Senior Consultant at Deloitte Consulting, you will be responsible for individually delivering high quality work products within due timelines in an agile framework. Need-basis consultants will be mentoring and/or directing junior team members/liaising with onsite/offshore teams to understand the functional requirements.

Work you’ll do:

·       Provide guidance and support to Application Developers 

·       Assist with schema design, code review, SQL query tuning 

·       Install, tune, implement and upgrade DBMS installations 

·       Write and deploy SQL patches 

·       Assist Operations Team with any infrastructure /environment issues during application deployment across Development, QA, Staging and Production environments.  

·       Responsible for change management and performance tuning of the database for the particular applications they’re working on. Design, document, and monitor the database servers 

·       Develop standards and procedures for maintenance and modification of database platforms 

·       Provide systems architecture guidance in creating high availability systems 

·       Provide direction in capacity planning, performance improvement, and storage management in partnership with other clients and internal resources 

·       Plan and support the implementation of major architectural changes 

·       Develop backup and recovery procedures, including testing back-ups and data integrity 

·       Proactive and reactive performance analysis, monitoring, troubleshooting, and resolution of issues 

·       Create automation for repeating database tasks 

·       Be available for on-call support as needed 

·       Process work accurately and in a timely manner 

·       Always pay attention to detail  

·       Proactively and regularly make recommendations for system improvements 

·       Collate, prepare and present statistical information for internal and external use 

 

.

The team

At AMS system administration, 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 – Senior Consultant


Preferred:

·       Linux and Windows Admin 

·       Good knowledge on Performance tuning 

·       Knowledge in MSSQL Server database Architecture and Management 

·       Knowledge on High Availability like Replication, clustering and AlwaysOn 

·       Knowledge on SQL 

·       Knowledge on Stored Procedures 



Required:

·       Good knowledge on Microsoft SQL Server Database Administration 

·       Expertise in Analysis, designing and implementing Backup/Restore and Disaster recovery strategies and solutions 

·       Experienced in cloning, log shipping, archiving in SQL servers 

·       Experience working with support vendors, application owners, infrastructure teams 

·       Hands-on experience in SQL, query optimization, performance tuning & indexing. 

·       Hands-on experience in clustering, log shipping, replication techniques 

·       Knowledge to automate the activities like DB Creation, Patching and Health Check 

·       Knowledge and worked on implementing right Security policies and procedures 

·       Validated knowledge on capacity management and should know how to optimize it 

·       Worked on backup and recovery procedures and should be aware about the retention policy and the maintenance backup pieces 

·       Should have knowledge and worked on the process and procedures related to DR Activity 

·       24X7 Production support and should be able take up on-call on rotational basis 

·       knowledge on the ticketing tools and should be well aware about the ITIL Process. 

·       Involving performance related issues 

·       Basic Unix shell scripting skills 

·       Excellent written and verbal communication skills 

 

Education: 

B.E. / B.Tech / M.C.A. / M.Sc (CS) 

 

Prior Experience: 

6 to 9 years of Application and MSSQL DBA experience  


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.
Recruiting tips

From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters.
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.
Our people and culture

Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our client most complex challenges. This makes Deloitte one of the most rewarding places to work.
Our purpose

Deloitte’s purpose is to make an impact that matters for our clients, our people, and in our communities. We are creating trust and confidence in a more equitable society. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. We are focusing our collective efforts to advance sustainability, equity, and trust that come to life through our core commitments. Learn more about Deloitte's purpose, commitments, and impact.
Professional development

From entry-level employees to senior leaders, we believe there’s always room to learn. We offer opportunities to build new skills, take on leadership opportunities and connect and grow through mentorship. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.

Requisition code: 203364