Software Developer 2

Design, develop, troubleshoot and debug software programs for databases, applications, tools, etc.

Career Level - IC2

Autonomous Healthcheck Framework:
In this era of cloud and big data computing, systems supporting complex IT environments become larger, more complex, and numerous, often with many hosts clustered into a single system or distributed among different data centers, it s challenging to keep systems healthy and respond to problems quickly. With hundreds of interconnected components, misconfiguration can cause problems while running the system and has a serious business impact. When problems occur it can be difficult and time-consuming for those managing these systems to isolate the issue and know which diagnostics to collect.

Our team designed and develop the Autonomous Health Framework(AHF) product to monitor and keep the Oracle database infrastructure healthy and running. AHF has many components like Trace File Analyzer, ORAChk, EXAchk, CHM, hang manager, etc. EXAchk proactively checks the health of the database infrastructure to avoid any issues before it causes an outage. It is designed to do periodic runs and these runs produce lots of data about Database systems like versions, platforms, patches, parameters, network configurations, disk configuration, etc. We also build analytics and machine learning models based on the history of data gathered by the EXAchk component and which helps in providing predictions for resource usage and workload etc.

Desired Skill Set:

The candidate must have the following knowledge and experience:
* Should be very good at Python
* Should be very good at SQL, PL/SQL
* Solid foundation in data structures, algorithms
* Write clean code, test-driven development
* Good understanding of the Unix operating system
* Hands on experience in python ML libraries like Scikit learn, sklearn etc is value add
* Good problem-solving skills
* Knowledge of Version Control is a plus
* Knowledge of Oracle database/GI stack is plus
* Should be self-driven and result oriented
* Should be good at Problem solving and Analytical Skills
* Should be flexible and team contributor
* Excellent written and verbal communication skills and the ability to communicate with individuals across the organization