Responsibilities:
Enhance java application(s) (Spring Boot) code, bug fixes, code-review, unit tests, debugging and
troubleshooting.
Write SQL queries extensively for data analysis, to compare bleedoff data (planned, actual) between NetControl and TCS. Write java code to select data from Teradata tables and load into Oracle tables.
Use HYDRA extensively (Client’s tool based on Liquibase) for creating database objects (tables, indexes, global temporary tables, oracle procedures)
Write various metrics procedures (using Oracle Stored Procedures, and MySql) to capture row-level and fieldslevel matches for 24-hour load (200K to 1 million rows) between NC and TCS.
Create timed jobs (Client’s framework) to invoke java applications to perform database operations (e.g. load data
from Teradata to Oracle, run metrics stored procedures, Drop and Add oracle tables partitions)
Work with DBAs to performance tune the SQL queries for metrics procedures, define tables partitions template, to monitor database sessions, temporary tables space errors etc
Monitor the applications and their dependencies (Subscribers, JMS queues, database etc) to make sure they are up and running and are in good health.
Follow Client’s infrastructure and process to deploy the code in DEV, TEST, the Release Process to deploy the code in PROD in Cloud Environment. Post-Live support for NetControl.
Utilized home-grown tools to create timed-job, APIs and its consumers, JMS queues, Kafka subscribers, to deploy Spring boot applications in Production (Docker, Kubernetes), USM to monitor applications, JMS queues, subscribers, consumers, databases, Open Source for logs. Post-Live support for NetControl.
Environment:
Eclipse, Java 8, Spring, Spring Boot, log4j, jcache, maven, GIT, Git Lab, SVN, Jenkins, Fisheye, Liquibase, JMS, Kafka, Docker, Kubernetes, OpenSource for log monitoring, Conjure, CyberArk, SQLs, Oracle Stored Procedures, MySql, Oracle, Teradata, Windows and Linux, JIRA, PagerDuty