HP Server Automation Consultant (95% remote)

ContractCompany DescriptionConfigure ConsultingWe specialize in Staff Augmentation and Consulting Services across HP Software, VMWare, EView Technology and other IT Operations vendor portfolios. Our unique quick-start solutions are designed to empower IT operations teams with the efficiency, stability and top performance in the delivery of business services.Proven implementation success with numerous fortune 500 clients100s of successful projects across numerous industriesCertified and experienced consultants and thought leadersEmphasis on best practices, lessons learned and strategic guidanceSupporting clients across North AmericaUnique offerings such as quick-start and upgrade factoryJob DescriptionNo third party consultants. And, must be US Citizen or Green Card.Custom reports will work with the current version of the tool. Version or service pack upgrade might cause the reports not to function as expectedFile can be arrive at any time of the day but needs to be consistentDaily sync report should contain the only active users. The file needs a header row (case sensitive) Column A = UserId, Column B = RoleNameo Inactivity Feed Report should contain the only active users whose last login date is greater than 180 daysResults will display one row per user/role combination such that Username_A should have two roles removed, Username_B should have one role removed, and Username_C should have all roles removed.Both feeds must arrive every day of the week including weekends and holidays.Reports might use SQL (or) SQl procedures that need to be created in HPE SA databaseOracle batch job might be used to run the SQL procedures as per the schedule and DBA needs to be schedule the same if requiredJava API might be used if required. System administrator help might be requiredJ-18808-Ljbffr