Database Administrator, It

2 weeks ago

Mississauga, Canada City of Mississauga Full time

Req ID: 22930

Vacancy Type: Permanent

Number of Positions: 1

Closing Date: 02/14/2023

**Job Summary**:
**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.
- 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**:

- Comply with relevant City policies.
- May require some light lifting of supplies/materials.
- Prolonged exposure to computer keyboards and screens. Primarily office environment.
- 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.
- 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.
- 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.

Hourly Rate/Salary: $ 83,485.00 - $ 111,315.00

Hours of Work: 35

Work Location: Civic Centre

Department/Division/Section: CPS/Corporate Services Dept, CPS/IT Division, Architecture & Innovation

Non-Union/Union: Non Union

All personal information is collected under the authority of the Municipal Act.

We are an Equal Opportunity Employer. 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.

  • Database Analyst

    4 days ago

    Mississauga, Canada IT DECK SYSTEMS Full time

    Education: College/CEGEP - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards...

  • analyst, database

    Found in: Talent CA 2 C2 - 2 weeks ago

    Mississauga, Canada Tyson IT Solutions Inc Full time

    Education: Expérience: EducationBachelor's degreeTasksCollect and document user's requirementsDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management...

  • analyst, database

    Found in: Talent CA 2 C2 - 2 weeks ago

    Mississauga, Canada Tyson IT Solutions Inc Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksCollect and document user's requirementsDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of...

  • Administrator, Database

    3 days ago

    Mississauga, Canada Sialka Cloud Solutions Full time

    Education: Bachelor's degree - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration...

  • administrator, database

    Found in: Talent CA 2 C2 - 3 weeks ago

    Mississauga, Canada 10221163 Canada Inc. Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksCollect and document user's requirementsData ScienceDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and...

  • administrator, database

    Found in: Talent CA 2 C2 - 7 days ago

    Mississauga, Canada 10221163 Canada Inc. Full time

    Education: Expérience: EducationBachelor's degreeTasksCollect and document user's requirementsData ScienceDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database...

  • Dba (Database Administrator)

    6 days ago

    Mississauga, Canada AG Marketing & Development Group Inc Full time

    Education: Bachelor's degree - Experience: 3 years to less than 5 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document...

  • database administrator

    Found in: Talent CA 2 C2 - 2 weeks ago

    Mississauga, Canada Delta Shutters Inc. Full time

    Education: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 yearsExperience: 1 year to less than 2 yearsTasksCollect and document user's requirementsDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsOperate database management systems to analyze...

  • database administrator

    Found in: Talent CA 2 C2 - 7 days ago

    Mississauga, Canada Delta Shutters Inc. Full time

    Education: Expérience: EducationCollege, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 yearsTasksCollect and document user's requirementsDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsOperate database management systems to analyze dataDevelop and...

  • DBA (database administrator)

    Found in: Talent CA 2 C2 - 2 weeks ago

    Mississauga, Canada AG Marketing & Development Group Inc Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management toolsOperate database management systems...

  • DBA (database administrator)

    Found in: Talent CA 2 C2 - 2 weeks ago

    Mississauga, Canada AG Marketing & Development Group Inc Full time

    Education: Bachelor's degreeExperience: 3 years to less than 5 yearsTasksDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management toolsOperate database...

  • Dba (Database Administrator)

    2 weeks ago

    Mississauga, Canada Six side Logistics Full time

    Education: Bachelor's degree - Experience: 3 years to less than 5 years **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Research and document...

  • DBA (database administrator)

    Found in: Talent CA 2 C2 - 2 weeks ago

    Mississauga, Canada Six side Logistics Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management toolsOperate database management systems...

  • DBA (database administrator)

    Found in: Talent CA 2 C2 - 2 weeks ago

    Mississauga, Canada Six side Logistics Full time

    Education: Bachelor's degreeExperience: 3 years to less than 5 yearsTasksDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management toolsOperate database...

  • Global SQL Database Administrator

    Found in: Talent CA C2 - 2 weeks ago

    Mississauga, Canada IKO Full time

    Description The Global SQL Database Administrator will support both operational and project related activities and maintain defined IT standards at all global IKO locations. The scope includes designing, developing, installing, monitoring, maintaining, and performance tuning of all MS SQL/Oracle databases while ensuring high levels of data...

  • analyst, database

    Found in: Talent CA 2 C2 - 2 weeks ago

    Mississauga, Canada A.P.H INTERNATIONAL LTD. Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 yearsTasksDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management toolsOperate database...

  • analyst, database

    Found in: Talent CA 2 C2 - 2 weeks ago

    Mississauga, Canada A.P.H INTERNATIONAL LTD. Full time

    Education: Expérience: EducationBachelor's degreeTasksDesign and develop databaseDesign, construct, modify, implement and test data models and database management systemsConduct research and provide advice to other informatics professionals regarding the selection application and implementation of database management toolsOperate database management systems...

  • SQL Database Administrator with XML

    Found in: Jooble CA O C2 - 4 days ago

    Mississauga, ON, Canada Canada Cartage Group Full time

    An iconic Canadian company with over 100 years of helping companies grow and succeed in Canada, we provide national dedicated fleet solutions, general freight services, managed transportation, fulfillment & distribution, and home delivery. With a national network of terminals, cross-docks, and distribution centers, we are one of Canada’s largest and most...

  • Database Analyst

    7 days ago

    Mississauga, Canada EPIC - Educational Program Innovations Center Full time

    Education: Bachelor's degree - Experience: 1 year to less than 2 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy,...

  • Database Analyst

    7 days ago

    Mississauga, Canada ABS Tech Solutions Full time

    Education: College/CEGEP - Experience: 1 year to less than 2 years **Work setting**: - Computer hardware or software retailer/wholesaler **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to...