Lead I - Data Analysis

Band :- B1

Location :- Trivandrum/Bangalore

- Data Operations Engineer

Roles and Responsibilities

Experience in Tier 2/3 production support of IT applications in large 24x7 enterprise environment

Experience conducting and participating in incident management calls and ability to drive production issues to resolution

Ability to understand all parts of a large complex application, the relations between the parts, and the ability to troubleshoot complex issues

Continuous process improvements including implementing monitoring tools, alerting, and automation of routine tasks

Supported Technologies: Azure, Linux, Java, Kafka, Kibana, application and system monitoring tools

Ability to communicate clearly with senior client leadership.

Roles & Responsibilities (Current as Lead-II production support engineer ) :

• Providing Detailed Tier 3 support for production BI applications Teradata, Informatica and on Azure Platform.


• Working closely with the following stakeholders to ensure smooth and seamless operation of the production BI applications as appropriate. (Application Owners, Testing Team, Database Administration Team, Infrastructure Team, Configuration Management Team, Development, Testing, Pre-Production, Production)


• Responsible to plan and prioritize the business process to meet performance and quality standards.


• Provide services as per the Scope of Services defined in the Statement of Work.


• Proactively seek and communicate opportunities for process and technology improvements to Customer Application Managers.


• Proactively monitoring the jobs (24/7) and taking required measures on failures and co ordinating with respect teams on the fix.


• Worked on Process Improvement and documentation.


• Actively Participated in knowledge Transfer sessions held in Copenhagen, Denmark to cross functional teams and other vendors.


• Understanding the Business Technical Requirements and Creating source to target mapping Documents for the development as per the business requirement.


• Design of the Teradata Framework to make development smooth and clear.


• Creating User stories in JIRA and assigning the tasks to team members and tracking the Progress


• Developed and delivered fixes, optimizations, and small enhancements for operational BI applications running in the BI DW/MDM sphere of operations.


• Handled various Deployments on Different environments and worked on all documents.


• Involved with DBA’s on the Tuning for the long running queries on Production.


• Reports which are developed are used by business and used for Forecasting of Monthly, weekly and Daily reporting.


• Managing a team of 06 members production support engineers to ensure Providing Detailed Tier 3 support for production BI applications Teradata and on Azure Platform.


• Support on Azure pipelines. Scheduling pipelines as per the requests from build teams.


• Providing Detailed Tier 3 support for production BI applications Teradata and on Azure Platform.


• Create tasks in Azure DevOps (ADO) to track workload and deploy objects across environments.’


• Developed and delivered fixes, optimizations, and small enhancements for operational BI applications running in the BI DW/MDM sphere of operations.


• Actively participated in the hand overs and understanding business logic and prepared the documents and sharing to team members for reference.


• Worked on the Monthly, weekly and daily issues and provided the permanent fixes for all the levels.


• Create tasks in Azure DevOps (ADO) to track workload and deploy objects across environments.’


• Support on Azure pipelines. Scheduling pipelines as per the requests from build teams.


• Having good knowledge on Control -M Scheduler tool and creates, scheduled and execution of jobs.


• Suggesting appropriate usage of stats collection to hint the optimizer for better execution plan selection, at query level.


• Worked with the collect stats to make sure that to be up to date.


• Identify, investigate, and resolve Queue Issues


• Performance Tuning the Applications to reduce the resource consumption


• Tuning Long Running Queries and High CPU, Impact CPU Queries


• Proactively monitoring the database for any problematic queries (based on resource consumption or execution plan) on the system and abort the queries sending notifications to the users with corrective steps for better performance (Performance tuning).


• Test Environments Creation for different projects and Cross DB grants replication as per production system.


• Developing Continuous Integrations Tool for deployments as a part of Agile and Scrum methodologies


• Providing end-to-end support to SAP BO Users with reporting queries issues
  

Software Used : Azure, I nformatica 10.2 Teradata 13.10, ,Teradata Utilities, Control M 9.0, Active Batch Oracle, Informatica MDM Hub, Putty .MSBI and Power BI.