Sr Advanced Software Engr

Company Summary

Honeywell International Inc. is a Fortune 100 industrial technology company that makes a variety of commercial and consumer solutions, engineering services and aerospace systems for a wide variety of customers, from private consumers to major corporations and governments. The company operates four business units, known as Strategic Business Units – Honeywell Aerospace, Honeywell Building Technologies (HBT), Safety and Productivity Solutions (SPS), and Honeywell Performance Materials and Technologies (PMT).

Responsibilities:

• Design, develop, and maintain database systems to support web applications and micro services.
• Write complex SQL queries, stored procedures, and triggers to support application functionality.
• Optimize database performance and ensure data integrity and security.
• Develop and maintain backend services using C# and ASP.NET Web API.
• Collaborate with front-end developers and other team members to integrate user-facing elements with server-side logic.
• Troubleshoot and resolve database and backend issues.
• Participate in code reviews and provide constructive feedback to peers.
• Stay updated with the latest industry trends and technologies to ensure the use of best practices

Technologies:

RDBMS Concepts:

DDL, DML, Table, Constraints, Data Integrity, Relationship, Stored Procedure, Index, Statistics, View, Trigger, Sequence, Cursor, CTE, User Defined Function, User Defined Type, User and Role Management,

Deal with complex data type like Binary, XML, Json in database

Security, DB Script, Data Partition

Ability to design a normalized database

Ability of database design to meet scalability, security, performance, and reliability requirements

Ability of database performance tuning

Database Backup and Restore

Database Upgrade

Database Migration

ETL SSIS Package :

Create, extract, transform and load processes and programs in appropriate environments

Application of best practices of ETL processes and metadata

ETL Approach:

               Create, extract, load and transform processes and programs in appropriate environments

Application of best practices of ELT processes and metadata

                              Reporting technologies:

SQL Server Reporting Services (SSRS) as a reporting tool

Report Deployment from BIDS/Report Builder/SQL Server Data Tools

Report Deployment from Report Manager

Reporting Service command prompt utility

Troubleshooting, log analysis and recovery

Different Database flavor:

RDBS Database Type like MS SQL Server, PostgreSQL Flexi

               Timeseries Database Type

               NoSQL Database Type

               Distributed Database

Database Replication/Synchronization

NFR Requirements w.r.t. Concurrent Users and Performance

Using tools to run concurrent user test: JMeter and K6

                              Azure Cache for Redis Database

                              Backend Language:

                                             C#, Web API,.Net framework

                              Cloud:

Cloud related Data and Analysis

Azure Data & Analytics PaaS Services

Storage Accounts

Azure Data Factory

Cloud Metrics

Log Analytics Workspace

Kusto Query Language (KQL)

Azure Data & Analytics PaaS Services

Azure Data Lake

Azure Synapse Analytics

Azure Databricks

Azure HDInsight + Spark

ADX

Microsoft Fabric

• JOB ID: HRD255974
• Category: Engineering
• Location: HW Camp II,Bldgs 9A&9B,Plot C2,RMZ Ecoworld,Varturhobli,Sarjapur Marathahalli Outer Ring Road,Bangalore,KARNATAKA,560103,India
• Exempt