Sql developer Jobs in Kamloops, BC

DUTIES

& RESPONSIBILITIES

1. Applies critical thinking and problem solving skills to semi-technical problems, known errors and workarounds. If unable to solve, escalates issues to appropriate levels for effective and expeditious solution.
2. Maintains a tracking system for reported issues, problems and solutions.
3. Maintains admissions/scheduling/registration/graduation systems functionality through entering, verifying and ensuring accuracy of data as well as related systems setup and reporting.
4. Performs regular audits of the student data in the systems and liaises with stakeholders to ensure accuracy of information including reporting, entering, or updating data.
5. Creates and runs standard and ad hoc reports using SQL queries and verifies the accuracy of the data reported.
6. Supports a reporting tool for end users to run on demand standard reports.
7. Provides training for related student information computer and software systems.
8. Develops and documents systems and procedures by detailing hardware and software specifications.
9. Assists with the development and continuous improvement of the student systems processes and procedures.
10. Manually runs routine processes.

REPORTS TO Associate Registrar, Systems and Reporting QUALIFICATIONS EDUCATION:

• Bachelor's Degree or equivalent post-secondary education in a related field

Experience:

• Four years practical experience working with an enterprise relational database which must include:
  • Working as a functional/technical user of educational or medical enterprise relational database system and its functions
  • Successful programming in SQL, PL/SQL in an enterprise relational database environment
  • Experience with intermediate level of office software skills - spreadsheet, communications, reporting and word processing, particularly Excel and Outlook

SKILLS, KNOWLEDGE OR ABILITIES RELATED TO THE JOB

• Excellent organizational skills with proven ability prioritizing own workload while working under pressure to produce accurate work and meet deadlines
• Excellent oral and written communication skills with proven ability to produce accurate and concise documentation and communications for a variety of audiences
• Demonstrated ability to understand and interpret data accurately and effectively, including writing data extract reports to answer functional user questions
• Ability to comprehend instructions and details but willing to question in order to clarify requirements
• Accountable and confident in own ability and judgment and willing to take the lead
• Proven adaptability and flexibility, enthusiastic to new ideas and approaches
• Strong determination to succeed
• Demonstrated ability to deal courteously and tactfully when dealing with others, even when faced with challenges and obstacles
• Demonstrated ability to communicate complex technical information to both technical and non-technical users in a clear, understandable manner

WORKING CONDITIONS

• Sitting at desk and computer for long periods of time, general office conditions.

The salary for the above position is determined by the Collective Agreement with the Canadian Union of Public Employees, Local 4879, as it presently exists.