• Job Description

  Req#: 25348

  Req ID: 25348
  Vacancy Type: Permanent - Hybrid
  Number of Positions: 1
  Closing Date: 09/11/2024

  Job Summary

  Create secure and reliable storage structures that allow business applications to utilize City data. Plan, develop, forecast, manage and implement a process to monitor and enhance the overall performance of the databases and business applications, ensuring availability. Manage and monitor database security administration and service performance. Provide technical leadership and guidance to Information Technology and business units.

  Duties and Responsibilities

  • Configure and provide database performance and general health / capacity monitoring as an ongoing task for the City to conduct business in a safe, reliable and stable environment.
  • Monitor reports generated from the system and take necessary action to resolve incidents that may affect the continuity of business.
  • Monitor vendor notifications for patches and alerts - review, evaluate impact to City data and infrastructure, and make necessary recommendations.
  • Lead and coordinate other City staff to implement changes i.e. version upgrade of database where a major upgrade could span over two years and a minor upgrade could span over several months.
  • Tune databases for optimal performance and implementing database load balancing technologies.
  • Provide maintenance on databases for optimal performance i.e. rebuilding of databases/indexes.
  • Support development and implementation of projects - performing installations, database loading, data conversions, promoting application changes to various environments, testing, etc.
  • Troubleshoot and resolve database problems in a timely manner.
  • Design and Implement the electronic storage structures using industry standard software such as Oracle Database Server, SQL Server and Cloud related databases.
  • Configure to ensure that the data in these structures is reliable and secure by adhering to policies and guidelines regarding database security to meet legislative, audit and Privacy Act requirements i.e. audit database security for projects to meet audit requirements.
  • Review, recommend, plan and implement database patches to mitigate issues and to ensure the databases are maintained in supported versions.

  Skills and Qualifications

  • Post-secondary degree/diploma in Computer Science or related discipline with a minimum of five years of database administration using Microsoft SQL Server, Oracle and Cloud related databases.
  • Database related certifications related to Oracle, SQL Server, Amazon Web Services (AWS), Microsoft Azure, etc.
  • Detailed knowledge of Oracle, SQL Server database and application server concepts and design.
  • Thorough knowledge of conceptual, logical data repository development and management, database administration and data architecture technologies i.e. desktop client, web based, cloud computing.
  • In-depth knowledge of relational objects such as tables, stored procedures, triggers and DTS/SSIS packages is required.
  • Knowledge of related technologies such as AD, Windows OS, Amazon, Azure, Dynamics, MySQL, .Net, Oracle and Microsoft products, and IIS application Server.
  • Must understand the impact of new applications on existing information technology infrastructures (hardware platforms, communications network, standards, security, etc.
  • Thorough knowledge of interface methods for database and enterprise applications.
  • Must have an overall knowledge of the City's technical infrastructure i.e. Servers, Windows, operating systems, and Communication networks in place.
  • Excellent technical, project management, analytical and communication skills.
  • May require some light lifting of supplies/materials.
    

  Hourly Rate/Salary: $ 86,858.00 - $ 115,812.00
  Hours of Work: 35
  Work Location: Civic Centre
  Department/Division/Section: CPS/Corporate Services Dept , CPS/IT Division , Infrastructure Services
  Non-Union/Union: Non Union

  
  
  We thank all who apply, however, only those candidates selected for an interview will be contacted. You can also check your application status in your candidate profile online.
  
  All personal information is collected under the authority of the Municipal Act.
  
  Equity, Diversity and Inclusion
  The City of Mississauga is committed to creating a respectful and supportive workplace that fosters a culture of equity, diversity and inclusion which broadly reflects the communities and residents we serve. Throughout the employee life cycle, the City is working to include an EDI lens to attract, retain and support the growth of diverse talent.
  
  Learn more about the City’s commitment to Equity, Diversity and Inclusion.
  
  Accommodations
  The City of Mississauga is an Equal Opportunity Employer and is committed to removing barriers in our selection process for people with visible and invisible disabilities. In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, the City of Mississauga will provide accommodations throughout the recruitment, selection and/or assessment process to applicants with disabilities.
  
  If selected to participate in the recruitment, selection and/or assessment process, please inform Human Resources of the nature of any accommodation(s) that you may require in respect of any materials or processes used to ensure your equal participation.

• About the company

  Mississauga (/ˌmɪsɪˈsɔːɡə/ mih-sih-SAW-gə) is a city in the Canadian province of Ontario.

Notice