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.