Engineer- GISOCC Infrastructure IS

As a Team Member, ensure that,

• Work with N+1 to formulate the tactical plan to meet the Development Strategies for database 

• Support automated methodologies for integrating data from multiple sources and use queries to build a reporting dashboard / indicators

• Expertise in ETL tools (e.g., Apache NiFi, Talend, Informatica) and data integration techniques

• Development Practices

  • Use stored procedures, functions, and views where appropriate

  • Keep business logic centralized when necessary

  • Use parameterized queries to prevent SQL injection

• Testing

  • Unit test stored procedures and queries

  • Use staging databases for integration testing

  • Validate performance (e.g., query execution plans)

• Performance Optimization : 

  • Add indexes where needed, but not excessively

  • Regularly analyze slow queries

• Scripting and Automation

  • JavaScript: Many  tools rely heavily on JavaScript for scripting business rules, UI actions, and custom workflows.

  • Python: Can be used for automating tasks, integrating with APIs, or handling backend operations.

  • PowerShell / Bash: For automating system administration tasks and integrating with IT infrastructure.

• API Integration

  • Understanding how to work with REST APIs to integrate tools with other platforms like network monitoring, alerting systems, or cloud environments (AWS, Azure).

  • Skills in webhooks, JSON, and XML data formats.

• Database Management

  • tools typically rely on databases (like MySQL, SQL Server, Oracle, etc.) to store service-related data (incident records, configuration items, etc.). 

  • Familiarity with SQL and relational databases (e.g., MySQL, PostgreSQL)

• CMDB: 

  • Understand and knowledge of  CMDB, Oversee cmdb engagement activities and governance

  • Understanding of data modeling concepts and experience with data visualization tools like Tableau or Power BI.

  • Have a broad knowledge of asset/CI discovery tools, both agent-based and agentless

  • Have experience with CMDB integrations from a variety of data sources

  • Understand and be able to direct data normalization and reconciliation

  • Have hands-on, practical experience with the operation and maintenance of cmdb

  • Understand and be able to explain application and/or service modeling concepts and modeling execution in the CMDB

  • Understand and be able to explain the hardware asset lifecycle

  • Maintain CI class, attribute, and relationship properties for all Cis

  • Maintain data certifications and a CMDB health dashboard

  • Evolve the CMDB to include both on premise and cloud assets

  • Coordinate with other Sites Managers to ensure proper CMDB integration

  • Build / Update views & forms

  • Manage Access Rights

  • Coordinate the data collection

• Maintain installation and configuration procedures, and drive complex projects and technical solutions

• Support the efforts for cross-training and collaboration with other members of the Infrastructure Operations team 

• Develop shared knowledge of leveraged tools on the Infrastructure Operations team, eliminating single points of knowledge and dependencies 

• Work with N+1 & Lead Engineers to establish and support technical policies and procedures 

• Drive compliance and security efforts related to systems managed by GISOCC

• Drive improved “Efficiency” using consistent and documented procedures 

• Work with the stakeholders on project progress, issues and solutions 

Apply, (communicate and ensure if manager) the compliance with the procedures and Environmental, Safety and Security good practices, to know, for their activities and the activities of subcontractors, the potential risks and their consequences, be there attentive and be reagent and know the associated action plans.