Senior Database Specialist (CDA/Replacement)

Updated: about 2 years ago
Deadline: 16/03/22; 16/03/2022


Career Development Assignment (CDA):

The successful candidate must request and obtain a leave of absence from their current and substantive position, where applicable. Permission for such leave must not be unreasonably withheld.


If you are an internal applicant, please make sure to update your current union status in your candidate profile each time you apply for a vacancy. Internal candidates will be given priority consideration at this time. Please note: Carleton University encourages applications from all qualified candidates.

Situated on a beautiful campus bordered by the Rideau River and Canal, Carleton is just minutes from the heart of our nation’s government and enjoys easy access to the many organizations, associations and businesses which thrive in Ottawa. As members of a dynamic, research-intensive university, Carleton’s faculty and staff provide a superior learning experience for our fine students who hail from every province and more than 100 countries around the world. University Advancement supports this mission by initiating and brokering collaborative partnerships and contributions of time, wisdom, and funds from supporters worldwide.

The Department of University Advancement reports directly to the President’s Office. Working closely with the university’s senior leadership, the department leads and coordinates effective alumni relations, fundraising, stewardship and related communication efforts to re-engage alumni, find potential philanthropic and community partners, and then collaborate on solutions for mutual and societal benefit. Professionals within the overall department collaborate to ensure Carleton University graduates, friends and supporters can enjoy a strong and beneficial relationship with the university.


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Duties and Responsibilities:

Reporting to the Director, Advancement Services, the incumbent is responsible for database management and execution of the Banner Advancement database, reporting solutions to further the donor and alumni objectives of Carleton University. The incumbent will be responsible for the analysis, development, testing, implementation and documentation for Advancement Database projects, training users and liaising with ITS on technology matters, as required. The Senior Database Specialist will execute medium to large projects as required and have staff assigned to report to the incumbent to assist with these projects.

The incumbent is responsible for engaging with the Department of University Advancement and departments across campus to define requirements, analyze alternative system solutions, propose and review system design to ensure requirements are met, and coordinate the implementation of system enhancements/changes. The incumbent is responsible for providing measurable value by improving strategy, process development and renewal of systems including but not limited to DUAShare, Tableau, Microsoft Access and ARGOS. Utilizing both established and emerging technologies, the incumbent is involved in the effective use of enterprise-wide databases, application system security and application performance monitoring.


Qualifications:

The incumbent must possess the following qualifications:
• Possess thorough knowledge of the use of database management software, spreadsheets, word processing and report writer software. Excellent knowledge of relational database technology is required. Familiarity with multi-tier, client/server and mainframe environments is necessary.
• Undertake relevant training and attendance at seminars to maintain current base of knowledge on trends and developments in information technology, project management methodology, University administrative policies and procedures, reporting and financial management principles.
• Demonstrate the ability to write reports and procedure manuals and the ability to effectively present information and respond to user questions. S/he must be able to clearly define problems, collect data, establish facts and draw valid conclusions is necessary.
• Exhibit excellent client service and conflict resolution skills to establish/maintain priorities manage time and provide effective support to staff at all levels.
• Possess highly developed analytical, problem solving and organizational skills; demonstrated ability to think logically through complex business and systems processes; strong understanding of project management methodologies; strong leadership, communication, presentation, consultation and interpersonal skills required.
• Demonstrate workflow system experience; knowledge and/or experience in Banner Advancement, SQL, Visual Basic and Access; packaged software implementation experience for large systems; and experience working in a fund raising/alumni relations environment would all be assets.


Education and Experience:

The above is normally acquired through the completion of:
• Bachelor’s Degree in Information Technology.
• Five years’ experience in managing relational database applications, database reporting and management.
• Experience with SQL/JavaScript/JQuery coding is an asset.


HR Note:

Carleton University and CUPE 2424 are currently completing a joint job evaluation and pay equity project. The University and the Union are working together to describe the skills, effort, responsibilities and working conditions associated with every CUPE 2424 job, including this one. As a result, the job description that is currently associated with this posting (for recruitment purposes) may be revised to reflect the actual duties captured in the new job descriptions.

By applying for this job you are acknowledging that the actual duties associated with this job may differ somewhat from those identified in the job posting and that you will agree to perform the duties of this job as determined through the joint job evaluation process.

Equivalencies will be considered. Applicants are encouraged to provide information which may demonstrate equivalent qualifications. Please note that applicants may be required to complete an employment test as part of the selection process for this position. Those applicants that are selected for an interview will be requested to contact the Human Resource Advisor assigned to this competition as soon as possible to discuss any accommodation requirements. Arrangements will be made to accommodate your request in a timely manner. Carleton University is strongly committed to fostering diversity within its community as a source of excellence, cultural enrichment, and social strength. We welcome those who would contribute to the further diversification of our University including, but not limited to: women; visible minorities; First Nations, Inuit and Métis peoples; persons with disabilities; and persons of any sexual orientation or gender identity and expressions.


Important Note Regarding Pandemic Related Operations:

This position is required to work on campus. Exceptionally, since March 2020, many staff and faculty at Carleton University have been working from home in order to comply with public health requirements while continuing to provide services to support the operational functioning of the university. We are currently in the process of identifying positions that need to work on campus as part of our return to campus process. This position may be required to work temporarily remotely due to public health requirements or it may have been identified as one of the roles that are required to work on campus. If this position is required to work on campus, the successful candidate will be informed of the health and safety measures that are in place to ensure their safety on campus. If there is a requirement to work remotely (it is possible that there could be a requirement to work both remotely and on campus), the successful candidate will work with the manager to set up a remote work environment including discussing appropriate technology and requirements. Please note that once public health requirements permit, Carleton University will resume normal on campus operations and at that point there will be a timely notification provided by the manager and the requirement to working full time physically onsite will resume. Therefore, we are looking for candidates currently in or looking to relocate to the Ottawa area.

Additionally, Carleton University is continuing to maintain a safe work environment and requires mandatory vaccination against COVID-19 as per Public Health recommendations under the Reopening Ontario Act. As Carleton University requires that staff be available to attend on-campus meetings and to work, as required, in person, the successful candidate will be required to comply with this policy and be fully vaccinated before commencing employment. Subject to permitted exemptions under the Ontario Human Rights Code, if you are the successful candidate, your offer of employment will be conditional upon you attesting that you are fully vaccinated with a course of vaccines that have been approved by Health Canada and submitting appropriate proof of vaccination.


View complete position description


You must login first before attempting to apply for any postion.

Please confirm that you have updated your candidate profile, if you are a returning applicant. Please note your profile includes important screening information.



Similar Positions