HP Server Automation Consultant (95% remote)

Metasys; Minneapolis (MN); Remote; USD 70,000 - 90,000; Full time

Job summary

A leading IT consulting firm in Minneapolis seeks a qualified candidate to generate custom reports for user role tracking. This role requires expertise in SQL and a strong understanding of Oracle procedures. Candidates must be either US Citizens or Green Card holders. Daily report submissions are necessary, ensuring data accuracy, and collaboration with system administrators may be required. Join a dynamic team committed to delivering high-quality IT solutions.

Qualifications

• Must be a US Citizen or Green Card holder.
• Experience with custom report generation using SQL.
• Ability to manage and deliver daily data feeds.

Responsibilities

• Generate custom reports with user role information.
• Ensure daily report submissions including weekends.
• Collaborate with DBA for scheduling Oracle procedures.

Skills

SQL

Oracle

Java API

Database management

Job description

• Contract

Company Description

Configure Consulting

We 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 clients

100s of successful projects across numerous industries

Certified and experienced consultants and thought leaders

Emphasis on best practices, lessons learned and strategic guidance

Supporting clients across North America

Unique offerings such as quick-start and upgrade factory

Job Description

No 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 expected
• File can be arrive at any time of the day but needs to be consistent
• Daily 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 days
• Results 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 database
• Oracle batch job might be used to run the SQL procedures as per the schedule and DBA needs to be schedule the same if required
• Java API might be used if required. System administrator help might be required