Position: TECHNICAL CONSULTANT

Department: INFORMATION TECHNOLOGY

Location: NORTH CAMPUS

Position Status: Full Time

JOB SPECIFICATION:

• ACADEMIC QUALIFICATIONS

  Bachelor’s /BCS/Masters in IT related filed/preferred.

• WORK EXPERIENCE

  3+ years of experience in related job.

• PROFESSIONAL QUALIFICATIONS

  Relevant certification is preferred.

JOB SUMMARY:

The Oracle Technical consultant will manage technical side of Oracle E-Business Suite and other key integrated application environments with functional professionals. This role is responsible for the technical solutions of the business oriented issues. Collaboration with application with respect to Oracle E-Business Suite, provide the best solutions to the management and co-workers.

• Understands complex database concepts and effectively employ different design techniques
• Expertise in programming complex SQL queries stored procedures, views user defined functions macros and triggers.
• To develop high performance, PL/SQL reusable, packages, hierarchical queries, cursor procedures/functions, triggers and views in Oracle
• To develop customize concurrent program, reports, forms, workflows, Interfaces and alerts for Oracle
• Help maintain code quality, organization, and automatization.
• To troubleshoot and resolve issues.
• To do performance tuning.
• To do data and code Analysis, Design.
• Analyze data processing modules and identify areas of enhancements and improvement
• Integration between Oracle and Others custom application and utilities

• Provide expertise in technical solutions, assess client needs, and develop proposals, contracts, and statements of work
• Responsible for optimizing the system for easy use, and training employees in its functions.

• Responsible for performing day-to-day maintenance on the ERP system, as well as installing new upgrades and testing for bugs.
• System configuration and data migration will be part of the job responsibilities as well.

• Total vs. Open Tickets.
• Number of Reopened tickets assessment, analyses, evaluation, & monitoring.