System Analyst

The Systems Analyst is an applications design, development, and implementation specialist. The analyst is responsible for identifying and implementing application solutions to solve business problems and to make business operations more efficient. The individual is responsible for designing, developing, testing, and debugging new functionality, enhancements, customizations, interfaces, batch processes, queries, and reports.

•  Provide development and ongoing software support and issue resolution using Oracle SQL, PL/SQL, MySQL, Weblogic, Apache and PHP
  
• Develop and support Premia interfaces, C2B and B2C portals and third-party integrations.
  
• Partner with other business areas within Jubilee to understand application requirements and develop programming specifications for development.
  
• Build a standards-driven, scalable, secure and dynamic portal for the information delivery of specific-based applications.
  
• Capture, log and track applications issues and develop resolutions in the specified timeframes. This includes liaising with system vendors if the system is vendor supported.
  
• Develop enhancements, resolve issues, coordinate testing of statement releases and oversee regular production efforts including data extracts, data imports and printing.
  
• To create training materials and instruct employees in the proper usage and access of the premia system.
  
• To act as a focal point for resolution, including troubleshooting, root cause analysis, fine-tuning and optimizing the performance of tasks and programs that access the database.
  
• User security administration and management, including creation and deletion of user accounts.
  
• Take on other IT projects and assignments to be advised by management.
  

Requirements

• Bachelor’s degree in computer science, Information Systems or other related technical degree
  
• OCA – Oracle Certified Associate in PL/SQL
  
• 3 years minimum hands-on experience in technology and business fields in Oracle 10g, 11g & 12c
  
• Demonstrated ability to design, develop, unit test, and deploy Oracle apps using Oracle tools such as Oracle PL/SQL, Reports, Workflow, XML Publisher, JDeveloper, SOA, WebLogic and Oracle Fusion Middleware
  
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
  
• Expert in using tools such as TOAD, SQL Navigator & SQL Plus
  
• Experience in query optimization, performance and tuning (PL/SQL)
  
• Working knowledge of Web Logic, Apache, PHP / MySQL programming