Description

Our team is highly skilled, passionate about our community, and we care. Let’s grow together.

Database Architect

Who We Are

In Whitby, we are dedicated to our work, our community, and each other. We work hard, we have fun, and we celebrate our successes.

The Town of Whitby is a community in transformation that is located in the heart of Durham Region in the eastern Greater Toronto Area. Whitby is the second-largest municipality in the region and one of the fastest-growing communities in Canada. Located on Lake Ontario and only an hour east of Toronto, the population of Whitby is expected to grow from 140,000 to more than 200,000 by 2031. Whitby’s Official Plan has been updated to establish new directions for Whitby’s planned growth and development; the protection of our natural and built environments; urban design intensification; sustainability; community improvement; and, new employment within this time frame.

The Town of Whitby combines a small town atmosphere with the sophistication and amenities of a larger urban centre. Whitby boasts two beautiful heritage downtowns, one of the finest recreational harbours with an award-winning marina, year round sports and recreation activities, parks, trails, and a robust arts and culture scene, all of which are part of the extraordinary amenities that Whitby residents enjoy every day.

Whitby has an exciting and aspiring future, with a community that is welcoming, growing and transforming. On our team, you can expect to make a difference through your work and have a direct impact on shaping our growing community. Creating an inclusive environment where employees experience job satisfaction and have rewarding careers is important to us. We live our values and foster a culture of collaboration, accountability, respect and engagement where people enjoy coming to work.

The Town of Whitby is a hybrid organization. This means staff are empowered to do their best work from various locations, as appropriate for the position.

We want to be the preferred employer for the most talented people who care about the Town of Whitby, and are excited and proud to serve our vibrant community.

Let’s grow together.

What You Will Get To Do

The successful candidate will have a positive impact on our corporate culture by demonstrating the Town’s CARE core values (Collaborative, Accountable, Respectful, Engaged) through daily interactions with individuals at all levels of the organization, external contacts and elected officials.

By effectively building positive rapport and relationships both internally and externally, the successful candidate will help us achieve our mission that together we deliver services that make a difference in our community.

Reporting to the Senior Manager of Business Solutions, the Database Architect is accountable for overall database administration, setting data architecture principles and creating models of data that enables the implementation of the intended business architecture. The Database Architect defines how the data will be stored, secured, backed up, consumed, integrated and managed by the various IT systems and applications using or processing that data. The Database Architect focuses on the data itself and how it will be used, by looking at the big picture and how the corporation will make use of it.

Duties for this progressive role include, but are not limited to:

• Responsible for conducting feasibility studies as required on new business opportunities and challenges;

• Provides overall direction, guidance, and definition of IT architecture to effectively support the corporate business strategy;

• Assists Business Analysts with preparing Business Case, Business Requirements, Gap Analysis, Logical Data Models and Design documents for proposed solutions;

• Responsible for providing input on transformation of business requirements as represented by logical data models into physical data models;

• Responsible for designing and implementing business and data/information requirements into databases management systems;

• Responsible for developing programs to translate business requirements and designs into information systems;

• Assists in the development, implementation, and testing of the Town of Whitby software solutions including software configuration and customization. Performs testing of purchased software packages and liaises with the vendor for modifications;

• Responsible for development and maintenance of the TIS database operational documentation database as outlined in the IT service catalog;

• Responsible for providing technical expertise as it relates to the design, development, support and administration of key information systems in the context of data modeling, connectivity, performance and security;

• Develop, implement and maintain safeguards to ensure integrity of corporate data;

• Leads programs to develop, maintain, and govern the enterprise architecture across the organization;

• Contributes to the overall construction of logical, functional, and physical database and application designs and features, and ensures adherence to project deadlines, specifications, and budget;

• Assess and cultivate long-term strategic goals for data warehousing in conjunction with data users, department managers, clients, and other key stakeholders;

• Develop, implement and maintain routine backup & recovery and disaster recovery procedures;

• Network with vendors and peers in external IT organizations, through user groups, in order to remain current with emerging technologies to satisfy the Enterprise’s needs;

• Installing and testing new versions and patches of the database management systems;

• Act as a project/technical lead where assigned on projects; and,

• Create and maintain functional and technical documentation at system level.

Who You Are

You stay focused, and nothing falls through the cracks on your watch. You can successfully manage concurrent and complex projects. You communicate effectively, receive and share information within and across teams in a timely and transparent manner. Outcome focused, critical thinker with the ability to analyze and visualize, to ensure continuous improvement across our entire business. Using your extensive knowledge and experience in the field allows you to navigate through complex problems and recommend innovative solutions. You keep focused on the client when making decisions and taking actions.

To you, being at work is a mindset and not a location. You can switch seamlessly across modes of work and cultural norms of working in different environments. You know you best, including the tasks you do better when working virtually versus on-site. You believe that the cornerstone of successful working relationships is trust and understand how this positively impacts productivity and performance. You have a high degree of accountability, readily adapt to disruption, like to learn to skills, and explore new ways to connect and collaborate in the digital world.

What You Bring To Our Team

As the successful applicant, you must possess:

Knowledge Requirements

• College or University degree in a related discipline (e.g., Computer Science, Management Information Systems) including a database certification program, with ten (10) years of progressively responsible related experience in the information technology environment for a complex, multi-site, unionized enterprise environment, or equivalent combination of education and experience;

• Five (5) + years of expertise in: SQL Server, Oracle and Database Administration and Programming;

• Five (5) + years of experience using Java based middleware technologies such as Tomcat and Apache;

Skill requirements

• A broad understanding of relational database security and audit compliance standards;

• Experience with various scripting languages such as PowerShell and batch file programming to support automation of database administration tasks;

• Hands-on experience with data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis;

• Working technical experience with designing, building, installing, configuring and supporting data warehouses;

• Completion of Oracle Database Administration Certification.

• Microsoft SQL Server certification would be considered an asset.

• Strong project planning, tracking and management skills;

• Strong understanding of IT Service Management discipline as it relates to change, incident and problem management. ITILv3 or higher certification is considered an asset.

What We Offer You

• Salary: $101,210 - $119,070 per annum (Band E)

• Benefits and a retirement plan offered in accordance in Corporate programs and/or the applicable Collective Agreement.

• A hybrid work environment and flexible work arrangements where employees are empowered to do their best work in the way that works for them. This is designated as a designated as a Remote Hybrid role. Remote Hybrid recognizes that up to 60% of job functions associated with the role can be done virtually, from a remote office. Further details on these programs will be discussed through the selection process.

We are an Equal Opportunity Employer

At the Town of Whitby, our values guide everything that we do. We celebrate our differences, which is why we are committed to building an inclusive and barrier-free environment for our team. If you need a specific accommodation during the recruitment process, please let us know, and we will be happy to provide. Any information received relating to accommodation will be addressed confidentially.

Acknowledgement will only be forwarded to those applicants who are invited for an interview.

Personal information provided is collected under the authority of The Municipal Act, 2001 and the Municipal Freedom of Information and Protection of Privacy Act.

For your safety and the safety of others, if offered a role with the Town you will be required to demonstrate in writing, from an Ontario Ministry of Health authorized site, that you are fully vaccinated for COVID-19 as of your hire date.

Vaccination requirements are subject to bona fide medical and/or human rights exemptions. Any request for an exemption will be reviewed on a case-by-case basis, as per our COVID-19 Vaccine Policy, and would be subject to the Town’s accommodation process.

Union Affiliation: No Affiliation

Hours: Monday to Friday 8:30a.m.to 4:30p.m. (35 hours per week).

Hybrid Work Model: Remote Hybrid

Work Location: Whitby, ON