---

---

Location

Trivandrum | India

---

Job description

JOB DESCRIPTION

Role Proficiency:

Resolve enterprise trouble tickets within agreed SLA and raise problem tickets for permanent resolution and/or provide technical leadership (lateral or hierarchical) for the team to resolve customer issues

Outcomes:

1) Update SOP with updated troubleshooting instructions and process changes2) Mentor new team members in understanding customer infrastructure and processes3) Perform alert analysis for driving incident reduction4) Escalate high priority incidents to customer and organization stakeholders for quicker resolution5) Contribute to planning and successful migration of platforms6) Perform root cause analysis to find out corrective and preventive actions after every major incidents and escalations7) Work on problem tickets for finding permanent solutions of repeated issues8) Create roll out and roll back plan for change implementation and ensure adherence for preventing unauthorized changes

Measures of Outcomes:

1) SLA Adherence2) Time bound resolution of elevated tickets - OLA3) Manage ticket backlog timelines - OLA4) Adhere to defined process - Number of NCs in internal/external Audits5) Number of KB articles created6) Number of incidents and change ticket handled 7) Number of elevated tickets resolved8) Number of successful change tickets9) % Completion of all mandatory training requirements

Outputs Expected:

Resolution:

1. Understand Priority and Severity based on ITIL practice
   resolve trouble ticket within agreed resolution SLA

Troubleshooting:

1. Troubleshooting based on available information from previous tickets or consulting with seniors. Participate in online knowledge forums reference. Covert the new steps to KB article
   
2. Perform logical/analytical troubleshooting. Work on problem tickets to identify permanent solutions

Escalation/Elevation:

1. Escalate within organization/customer peer in case of resolution delay. Understand OLA between delivery layers (L1
   L2
   L3 etc)
   adhere to OLA. Elevate to next level
   work on elevated tickets from L1

Tickets Backlog/Resolution:

1. 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 tickets for infrastructure.

Installation:

1. Install and configure tools
   software and patches

Runbook/KB:

1. Update KB with new findings
   
2. Document and record troubleshooting steps as knowledge base

Collaboration:

1. Collaborate with different towers of delivery for ticket resolution (within SLA) resolve L1 tickets with help from respective tower. Collaborate with other team members for timely resolution of tickets. Actively participate in team/organization-wide initiatives. Co-ordinate with UST ISMS teams for resolving connectivity related issues.

Stakeholder Management:

1. Lead the customer calls and vendor calls. Organize meeting with different stake holders. Take ownership for function's internal communications and related change management.

Strategic:

1. Define the strategy on data management
   policy management and data retention management.
   
2. Support definition of the IT strategy for the function's relevant scope and be accountable for ensuring the strategy is tracked
   benchmarked and updated for the area owned.

Process Adherence:

1. Thorough understanding of organization and customer defined process. Suggest process improvements and CSI ideas. Adhere to organization' s policies and business conduct.

Process/efficiency Improvement:

1. Proactively identify opportunities to increase service levels and mitigate any issues in service delivery within the function or across functions.
   
2. Take accountability for overall productivity efforts within the function
   including coordination of function specific tasks and close collaboration with Finance.

Process Implementation:

1. Coordinate and monitor IT process implementation within the function

Compliance:

1. Support information governance activities and audit preparations within the function. Act as a function SPOC for IT audits in local sites (incl. preparation
   interface to local organization
   mitigation of findings etc.) and work closely with ISRM(Information Security Risk Management). Coordinate overall objective setting preparation and facilitate process in order to achieve consistent objective setting in function Job Description. Coordination Support for CSI across all services in CIS and beyond.

Training:

1. On time completion of all mandatory training requirements of organization and customer. Provide On floor training and one to one mentorship for new joiners. Complete certification of respective career paths

Performance Management:

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

Skill Examples:

1) Good communication skills (Written verbal and email etiquette) to interact with different teams and customers. 2) Modify / Create runbooks based on suggested changes from juniors or newly identified steps3) Ability to work on an elevated server ticket and solve4) Networking:a. Trouble shooting skills in static and Dynamic routing protocolsb. Should be capable of running netflow analyzers in different product lines5) Server:a. Skills in installing and configuring active directory DNS DHCP DFS IIS patch managementb. Excellent troubleshooting skills in various technologies like AD replication DNS issues etc.c. Skills in managing high availability solutions like failover clustering Vmware clustering etc.6) Storage and Back up:a. Ability to give recommendations to customers. Perform Storage & backup enhancements. Perform change management.b. Skilled in in core fabric technology Storage design and implementation. Hands on experience on backup and storage Command Line Interfacesc. Perform Hardware upgrades firmware upgrades Vulnerability remediation storage & backup commissioning and de-commissioning replication setup and management.d. Skilled in server Network and virtualization technologies. Integration of virtualization storage and backup technologiese. Review the technical diagrams architecture diagrams and modify the SOP and documentations based on business requirements.f. Ability to perform the ITSM functions for storage & backup team and review the quality of ITSM process followed by the team.7) Cloud:a. Skilled in any one of the cloud technologies - AWS Azure GCP.8) Tools:a. Skilled in administration and configuration of monitoring tools like CA UIM SCOM Solarwinds Nagios ServiceNow etcb. Skilled in SQL scriptingc. Skilled in building Custom Reports on Availability and performance of IT infrastructure building based on the customer requirements9) Monitoring:a. Skills in monitoring of infrastructure and application components10) Database:a. Data modeling and database design Database schema creation and managementb. Identify the data integrity violations so that only accurate and appropriate data is entered and maintained.c. Backup and recoveryd. Web-specific tech expertise for e-Biz Cloud etc. Examples of this type of technology include XML CGI Java Ruby firewalls SSL and so on.e. Migrating database instances to new hardware and new versions of software from on premise to cloud based databases and vice versa.11) Quality Analysis: a. Ability to drive service excellence and continuous improvement within the framework defined by IT Operations

Knowledge Examples:

1) Good understanding of customer infrastructure and related CIs.

2) ITIL Foundation certification3) Thorough hardware knowledge 4) Basic understanding of capacity planning5) Basic understanding of storage and backup6) Networking:a. Hands-on experience in Routers and switches and Firewallsb. Should have minimum knowledge and hands-on with BGPc. Good understanding in Load balancers and WAN optimizersd. Advance back and restore knowledge in backup tools7) Server:a. Basic to intermediate powershell / BASH/Python scripting knowledge and demonstrated experience in script based tasksb. Knowledge of AD group policy management group policy tools and troubleshooting GPO alertsc. Basic AD object creation DNS concepts DHCP DFSd. Knowledge with tools like SCCM SCOM administration8) Storage & Backup:a. Subject Matter Expert in any of the Storage and Backup technology9) Tools:a. Proficient in the understanding and troubleshooting of Windows and Linux family of operating systems10) Monitoring:a. Strong knowledge in ITIL process and functions11) Database:a. Knowledge in general database management b. Knowledge in OS System and networking skills

Additional Comments:

RESPONSIBILITIES/TASKS: . Proven ability to mentor the offshore team and provide technical expertise when necessary. . Acts as a SME for the DBA team . Administer, maintain, tune, and troubleshoot Oracle databases to provide high availability and reliability to the databases and applications running on them. . Leads, troubleshoots and resolves complex issues with regards to client/server . Recommend and implement emerging database technologies and Advise developers on the most efficient database designs. . When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. . Provide code reviews to make sure the database code meets company standards for readability, reliability, and performance. . Support release processes for assigned projects/development teams. . Work within a scrum team to complete any necessary development tasks. . Support the Data management team in production loading and release processes. . Consults with users to identify current database requirements and clarify objectives. . Develop understanding of and stay current with advances in information technology by reading manuals, trade periodicals, and technical reports relating to Oracle and SQL Server databases. . Provide technical assistance to other Information Services personnel. . Participate in on-call rotation for production database support. . Make technical recommendations and implement policies and standards relating to the architectural design of databases, network communications, data access and security requirements, and backup and recovery procedures for production and development databases. . Plan, develop, test, and tune databases. . Assist and mentor development staff in data modeling, SQL and PL/SQL tuning, application tuning, creation of database objects, utilities, LINUX commands and LINUX programs. . Install third-party applications for testing and implementation in production. . Leads in the development and maintenance of SQL and Linux programs to monitor database conditions and activities. . Identify application and/or SQL performance problems and assist in their resolution. . Analyze, review, and alter database parameters and structure to increase operating efficiency or adapt to new requirements. . Consults with users to identify current database requirements and clarify objectives. . Document current, revised, and new processes and procedures. . Perform prototyping and database tuning and optimizing. . Stay up to date with advances in information technology by reading manuals, trade periodicals, and technical reports relating to Oracle and SQL Server databases. . Provide technical assistance to other Information Services personnel. . Analyze and plan for future database, server, storage, and network requirements. . Gather database statistics for trend analysis. . Availability to participate in 24/7 on-call rotation as needed. . Research and plan implementation of new database features and enhancements. . Design database growth management strategies. . Design database backup and recovery strategy including usage of standby databases for Business Resumption Plan. . Produce periodic reports for management and staff. . Work with no supervision and exercise discretion and independent judgment. . Experience . 12+ years in Oracle database administration . Education Requirements . Bachelor's/Master's degree in computer science, system analysis, or equivalent experience SKILLS REQUIRED: . Having hands on experience in Oracle deployment on Azure. . Strong software Development Life Cycle principles, processes, tools, and techniques. . Ability to communicate factual and technical information with customers clearly and concisely. . Experience in working with Oracle19c databases and able to resolve and collaborate on complex, multifaceted issues. . Experience with performance tuning, database backup, restoration, refresh using Recovery Manager (RMAN). . Experience with software Installation and Creation of 19c Databases on Azure VM. . Experience with database upgrades. . Experience with cross-platform database migrations. . Experience working with ASM storage and Oracle Enterprise Manager 13c. . Experience in applying database patches as per the organization policies. . Experience with design, set up and maintenance of data guard environments and disaster recovery solution to avoid any downtime. . Capability to document and develop standard operating procedures for day to day activities. . Skill to make technical recommendations. Demonstrated high level of competency in Oracle and/or SQL Server database administration. . Thorough knowledge of and ability to use Oracle and/or SQL Server database utilities and management tools. . Advanced knowledge of communication layer between client, network and Oracle/SQL Server databases. . Advanced knowledge of and demonstrated competency in all facets of Oracle and/or SQL

---

Job tags

---

---

Salary