Associate Iii

Role Proficiency:

- 4 to 7 years of experience in MS SQL DB server administration
- L2/L3 experience with database platforms like MySQL & MongoDB which includes
- Capable of Deploying SSIS Packages, SSAS Data Cubes, setting up environment variables, Debugging and Troubleshooting SSIS package failures
- Experience in Configuring and maintaining HA methodologies like Availability Groups, Replication, Log shipping, Mirroring
- Performance Tuning and management
- Backup, DR, Replication and HA
- Monitoring and observability (Native monitoring tools and open source tools like Prometheus
- Experience necessary in IBM Workload Scheduler (Tivoli), and experience in DB monitoring tools like Spotlight, SCOM etc.)
- Configuration management - (Preferably Salt, Ansible/Puppet/Chef)
- Automation and deployment - Jenkins - Coding and Scripting
- Python, PHP, Shell Node.js
- Security best practices
- Cloud Platforms - AWS AZURE
- Strong OS (AIX, Linux) concepts and fundamentals
- Database patching - Managing & scheduling of database jobs
- Familiar with Change Management and ITIL Process - Strong Communication and Collaboration Skills

Outcomes:

- 1) Monitor customer infrastructure using tools or defined SOPs to identify failures and mitigate the same by raising tickets with defined priority and severity2) Update SOP with updated troubleshooting instructions and process changes3) Mentor new team members in understanding customer infrastructure and processes4) Perform alert analysis for driving incident reduction5) Resolve L1 incidents and service requests

Measures of Outcomes:

- 1) SLA Adherence2) Compliance towards runbook based troubleshooting process3) Time bound elevations and routing of tickets - OLA Adherence4) Schedule Adherence in managing ticket backlogs5) # of NCs in internal/external audits6) Number of KB changes suggested7) Production readiness of new joiners within agreed timeline by one-on-one mentorship8) % Completion of all mandatory training requirements9) Number of tickets reduced by alert analysis 10) Number of installation SR handled for endpoints / change tasks completed for infrastructure 11) Number of L1 tickets closed

Outputs Expected:
Monitoring:

- Understand Priority and Severity based on ITIL practice. Understand agreed SLA with customer and adhere.
- Repetitive alert analysis for finding high ticket generating Cis. Adhere to ITIL best practices

Runbook Reference/Change:

- Follow runbook for troubleshooting
record troubleshooting steps and provide inputs for runbook changes.

Escalation/Elevation/Routing of tickets:

- Escalate within organization/customer peer in case of resolution delay.
- Understand OLA between delivery layers (L1
L2
L3 etc)
adhere to OLA
route the tickets to relevant queue
initiate intimation respective teams/customer based on defiled process.

Tickets Backlog/Resolution:

- Follow up on tickets based on agreed timelines
manage ticket backlogs/last activity as per defined process.
- Resolve incidents and SRs within agreed timelines. Execute change tasks for infrastructure.

Collaboration:

- Collaborate with different towers of delivery for ticket resolution (within SLA)
document learnings for self-reference.
- Close/resole L1 tickets with help from respective tower.
- Actively participate in team/organization-wide initiatives.

Installation:

- Install software software/tools and patches

Stakeholder Management:

- Lead the customer and vendor calls.
- Organize meetings with different stake holders. Participate in RCA meetings.

Process Adherence:

- Thorough understanding of organization and customer defined process.
- Consult with mentor when in doubt.
- Adherence to defined processes.
- Adhere to organization’ s policies and business conduct.

Training:

- On time completion of all mandatory training requirements of organization and customer.
- Provide On floor training and one-on-one mentorship for new joiners.

Performance Management:

- Update FAST Goals in NorthStar
track
report and seek continues feedback from peers and manager.
- Set goals and provide feedback for mentees.
- Assist new team members to understand the customer environment.