Senior Programmer (Oracle)

at  Queens University

Senior Programmer (Oracle)
About Queen’s University
Queen’s University is the Canadian research intensive university with a transformative student learning experience. Here the employment experience is as diverse as it is interesting. We have opportunities in multiple areas of globally recognized research, faculty administration, engineering & construction, athletics & recreation, power generation, corporate shared services, and many more.
We are committed to employment equity and diversity in the workplace and welcome applications from individuals from equity seeking groups such as women, racialized/visible minorities, Indigenous/Aboriginal peoples, persons with a disability, persons who identify in the LGBTQ+ community and others who reflect the diversity of Canadian society.
Come work with us!
Job Summary

A BRIEF OVERVIEW

Reporting to the Associate Director, Information Automation and Delivery, the Senior Programmer (Oracle) performs a crucial role in managing data, application programming, data integration, reporting, and project support for the Office of Advancement. This role will work closely and collaboratively with our team of developers, analysts, and business subject matter experts to support the Office of Advancement’s goal of increasing philanthropy, stewarding donors, and engaging our alumni around the world.
The Senior Programmer (Oracle) is responsible for advanced programming in PL/SQL, report and dashboard creation, supporting the needs of the data warehousing and business intelligence environment, assisting in the definition and prioritization of data, and reporting requests. As an ideal candidate, you are curious, detail-oriented and will execute tasks and activities with a professional, results-focused, collaborative approach, and will communicate in a proactive manner. Success in this role requires working closely with end-users to understand their unique needs, and to translate these into practical solutions within an appropriate timeframe, by leveraging your technical knowledge.
We value strong developers who have a passion for building efficient solutions with the end-user in mind. We will offer a wide range of challenges and interesting projects while encouraging skill development in areas of interest. Our goal is to create a rewarding environment where you can grow, learn, and improve your skills. If you are interested in working with an exceptional group of people and playing a pivotal role in supporting the evolving needs of our organization - we encourage you to apply.This position programs, maintains, develops and supports various databases, applications, websites, and/or systems. This position consults with units or departments on a variety of applications needs. This position installs, designs, codes, modifies, tests, debugs, and maintains applications to meet user needs. This position also analyses and revises system logic, develops and maintains bridging integrations between systems, modifies procedures, and documents changes.
This position is fully remote within Ontario.
Job Description
What you will doPrograms, maintains, develops and supports various databases, applications, websites, and/or systems.
-
Consults with units or departments on a variety of applications needs.
-
Installs, designs, codes, modifies, tests, debugs, and maintains applications to meet user needs.
-
Analyses and revises system logic, modifies procedures, and documents changes.
-
Develops scripts to automate processes.
-
Develops and maintains bridging integrations between systems.
-
Provides detailed instructions and documentation on system operations.
-
- Revises procedures and documentation to describe program development, logic, coding, and corrections.
- Other duties as required in support of the department and/or unit.

Required Education

• Three-year Community College Diploma or Three-Year Bachelor Degree, or equivalent. In addition, requires trade certification, qualification, or on-going learning to remain ahead of changes in technology or emerging fields.

Required Experience

• More than 3 years and up to and including 5 years of experience.Experience in database administration/management, design and/or technologies considered an asset (e.g., MySQL, PostgreSQL, and/or Oracle/DB2, relational databases, warehoused databases, etc.).

• Experience in program analysis and reporting considered an asset.

• 
  Experience working in a comparable client-focused environment considered an asset
• 
  
  
  
• Familiarity with software development best practices, including coding standards, code reviews, source control management, build processes, testing, and operations considered an asset.
  
  Consideration may be given to an equivalent combination of education and experience.

Job Knowledge and Requirements

• Knowledge of concepts and principles in a specialist field that is typically acquired through a combination of advanced professional or academic qualifications and/or substantial work experience.
• Provide effective consultation and advice on non-straightforward and/or complex issues.
• Interaction with others requires interpersonal skills and the ability to understand and influence.
• Adapt messages to meet the different needs of different audiences.
• Builds relationships, trust and credibility.
• Prioritize and distribute work to deliver objectives on time and to the highest standard.
• Identify in advance when the intended results may not be achieved and develops a plan to address the gaps.
• Actively participate in project team meetings and develop individual and unit project plans.
• Lead procedural or technological change within a unit.
• Identify opportunities to improve the effectiveness and efficiency of work processes.
• Seek information and input to fully understand the cause of problems.
• Appropriately assesses risks before making a decision.
• Contribute to the creation and evaluation of possible solutions.
• Take action to remove obstacles and address problems before the impact performance and results.
• Apply equity, diversity, accessibility, inclusion and Indigenization considerations to decision making and planning.
• Promote a work environment that is free from sexual violence, harassment and discrimination, and the ability to show empathy for those who have experienced trauma.

Employment Equity and Accessibility Statement
The University invites applications from all qualified individuals. Queen’s is committed to employment equity and diversity in the workplace and welcomes applications from women, visible minorities, Aboriginal Peoples, persons with disabilities, and persons of any sexual orientation or gender identity. In accordance with Canadian Immigration requirements, priority will be given to Canadian citizens and permanent residents.
The University provides support in its recruitment processes to applicants with disabilities, including accommodation that takes into account an applicant’s accessibility needs. Candidates requiring accommodation during the recruitment process are asked to contact Human Resources at hradmin@queensu.ca.

Please refer the Job description for details