Database Administrator

Description

Database Administrator

Competition Number : 2024-348

Job Code : 0464

Posting Date : September 5, 2024

Closing Date : September 27, 2024 (at 6 : 00pm)

Job Status : Permanent Full-Time

The City of Kitchener is a vibrant and dynamic city of approximately 292,000, in the heart of southwestern Ontario. As the largest municipality in Waterloo Region, Kitchener continues to be poised for development and growth, enhancing its reputation as a leader in city-building and innovation, with nationally recognized strategies to build its neighbourhoods, its digital infrastructure and its diverse economy.

The City of Kitchener is WHERE you want to work! Learn more about the top reasons to join us :

Position Overview :

Provides database services to IT staff and other departments, ensuring the effective management of the City's data and information resources.

Establishes, implements, and oversees policies and procedures to ensure the integrity and availability of databases and related applications.

As a Database Administrator, you are :

A Team Player

• You understand that relationships take work.
• You build trust by doing what you say you will.
• You are a collaborative team player able to work across roles, teams, departments and with external agencies and partners.

An Innovator

• You ask thoughtful questions.
• You are not afraid to put new ideas on the table.
• You can spot opportunities to do things differently.

An Agile Problem Solver

• You have a positive attitude with a strong work ethic and high attention to detail.
• You are a strategic thinker that can see beyond the day-to-day grind to help reach strategic goals and improve the customer experience.
• You have effective time management skills and the ability to multitask and remain calm under pressure.
• You are an ace troubleshooter who can quickly identify and propose workarounds to issues.

You might be interested in this role if :

• You are looking to work on a collaborative team.
• You are willing to take on new challenges in an ever-changing environment.
• You have an aptitude for learning about new technologies and methodologies.

Responsibilities :

• Ensures the effective management of the City's data and information resources.
• Establishes, implements, and oversees policies and procedures to ensure the integrity and availability of databases and related applications.
• Designs, develops, and implements database operational standards, and procedures to ensure optimal database performance and integrity.
• Implements and maintains virtual hardware, software, operating systems, and application software for the Corporation's database management systems.
• Monitors and allocates resources to optimize the database performance.
• Implements database security and access policies; ensures the integrity and security of databases and database servers.
• Coordinates and performs data migrations, conversions and application integrations.
• Ensures policies and procedures are in place for disaster recovery to ensure effective protection and integrity of all data assets.
• Responsible for data archiving as required in accordance with policy, storage limitations and performance considerations.
• Supports enterprise applications, including implementation, integrations and upgrades.
• Provides user support for data collection, reporting and analysis.
• Monitors and ensures license agreement compliance.
• Provides database services to other TIS staff and other departments across the City.
• Keeps up-to-date of new or converging technologies.
• Performs other related duties as assigned.

Requirements :

• 3 year college diploma or university degree.
• Minimum 4+ years of experience in database administration.
• Thorough understanding of database administration methodologies.
• Extensive knowledge and experience in database monitoring and analyzing performance usage and reallocating resources to optimize database performance.
• Demonstrate experience in implementing and maintaining operating system and application software for a database management system.
• Proven ability to design and implement system integrations.
• Extensive experience working with Oracle RDBMS, SQL, additionally knowledge of Python would be preferred.
• Experience working with VMware.
• Ability to implement and maintain OS and application security.
• Comfortable working in a Linux environment.
• SAP basis experience would be considered an asset, including performing SAP upgrades, knowledge of PI / PO, Solution Manager, Hana, BOBJ, understanding SAP security principles, proficient in system monitoring and troubleshooting.
• Excellent oral and written communication skills and be able to communicate effectively with user groups and technical staff.
• Strong ability to organize, prioritize and work effectively to deadlines.
• Must be reliable with a good attitude and employment record.
• Must have the ability to support and project values compatible with the organization.

Note : All interested applicants are encouraged to apply. In the event there is no successful applicant with the stated level of education and experience, other applicants will be considered if a combination of their education and experience meets the following pre-determined equivalency :

2-Year Diploma (or 2-Year Specialized Post-Secondary Program) with minimum 7 years related and relevant experience or 4-Year Honours Degree with minimum 2 years related and relevant experience.

The City of Kitchener is committed to an equity-driven, inclusive, accessible, and barrier-free recruitment and selection process, and to ensuring our workforce reflects the full diversity of the community we serve.

We welcome applications from Indigenous, Black, racialized and 2SLGBTQ+ persons, as well as other equity deserving groups.

We will accommodate the needs of applicants under the Human Rights Code and Accessibility for Ontarians with Disabilities Act (AODA) throughout all stages of the recruitment and selection process.

Please contact Human Resources at, or 519-741-2200 ext. 7261 to make your needs known, so that we can support your full and equal participation throughout the hiring process.

We appreciate the interest of all applicants. Only candidates whose skills, experience and qualifications meet the requirements of the position will be contacted.

Please note that as per Human Resources Policy HUM-HIR-110, "Employment of Relatives of Staff Members and Elected Officials" :

The immediate relatives of staff of the Human Resources Division, all Directors, General Managers, or the Chief Administrative Officer and Elected Officials shall not be employed by the City in any capacity.

The immediate relatives of all other Management personnel shall not be employed where such employment would be :

• within the same Department in the case of permanent full-time, temporary full-time and part-time classifications.
• within the same Division in the case of students.

Department : Corporate Services

Division : Technology Innovation and Services

Union Affiliation : Non-Union / Management

Number of Positions : 1

Hours of Work : 35 hours per week, Monday to Friday

Location : Initial Location : City Hall, City : Kitchener

Compensation :

Salary Range : $100,145 - $125,183 annually effective Nov 1, 2024 : $103,829 - $129,788

Grade / Band : 11

J-18808-Ljbffr