Database Administrator and Data Governance Analyst

5 months ago

St Catharines, Canada City of St. Catharines Full time

**Summary**:
This position works with the various members of the Information Technology team to create efficiencies, review current processes, analyze, and develop or modify databases including coding stored procedures, testing, debugging, and installing database software. This position provides direction and guidance on the use of the various technologies for process improvements usability and accessibility.

**Duties and Responsibilities**:
(These set out the principal functions of the position and shall not be considered as a detailed description of all the work requirements).
- Develop standards for database structures. Write technical procedures and documentation for database technology including operations, user guide, etc.
- Develop database backup and recovery scripts for new databases and database environments including disaster recovery procedures.
- Recommend database technology for new solutions.
- Evaluate new vendor software as it relates to databases.
- Participate as a member of the Records Information Management (RIM) project team.
- Participate in the modeling of data in conjunction with the developers. Write conversion scripts to move data.
- Design the test plan in collaboration with the Business Support Analyst.
- Act as an agent of change for the corporation.
- Develop and enhance data governance policies including data classification and data retention.
- Act as project leader on development and maintenance projects (planning, scheduling, monitoring, and reporting).
- Perform other related duties as assigned.

**Position Requirements**
- University Degree in Information Technology, Computer Science, Software Engineering or related field.
- Five (5) years database administration and data governance experience in an on-line multi-user environment within a medium sized IT Department.
- Three (3) years experience in monitoring and managing Oracle databases.
- Project Management, Lean Six Sigma, Business Analysis, or ITIL Certifications are considered an asset.
- Proven knowledge of data governance and data security including relevant data privacy regulations.
- Knowledge and experience in data modeling.
- Expert knowledge of and experience with ORACLE RDBMS, SQL/PLSQ, and Microsoft SOL RDBMS.
- Certificates in database administration for Oracle and MS SQL server are considered an asset.
- Proficiency with Microsoft Power BI, Tableau and SSRS tools.
- Knowledge of and experience with Toad software and Crystal Reports.
- Ability to identify and solve database issues.
- Ability to gather and analyze user requirements and make appropriate suggestions.
- Ability to think proactively to solve support issues and prevent future occurrences.
- Good interpersonal, relationship building and communication skills.
- Proven completion of Ministry of Labour Worker Health and Safety Awareness training.
- Demonstrated commitment to a safety culture.

**CUPE 157 Pay Group 11 **- Minimum $82,968 annually; Maximum $95,200 annually

**Expected Work Location**: City Hall (eligible for remote work)

**Hours of Work**:Currently Monday-Friday 8:30am-4:30pm.

Applications received any other way will not be accepted.

The City of St. Catharines is an equal opportunity employer committed to inclusive, barrier-free recruitment and selection processes and work environments. We will accommodate the needs of applicants under the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act (AODA) throughout all stages of the recruitment and selection process. Please advise the Human Resources Division to ensure your accessibility needs are accommodated throughout this process.

**Job Types**: Full-time, Permanent

**Salary**: $82,968.00-$95,200.00 per year

**Benefits**:

- Casual dress
- Company pension
- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- Paid time off
- Vision care

Flexible Language Requirement:

- French not required

Schedule:

- Monday to Friday

Work Location: Hybrid remote in St. Catharines, ON L2R 7E8

  • Database Administrator and Data Governance Analyst

    5 months ago

    St. Catharines, Canada City of St. Catharines Full time

    **Summary**: This position works with the various members of the Information Technology team to create efficiencies, review current processes, analyze, and develop or modify databases including coding stored procedures, testing, debugging, and installing database software. This position provides direction and guidance on the use of the various technologies...

  • Data Analyst

    4 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to store and manage dataDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...

  • Data Analyst

    4 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to store and manage dataDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...

  • Data Analyst

    3 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job SummaryWe are seeking a skilled Data Analyst to join our team at Rainbook Canada Inc. The successful candidate will be responsible for developing and maintaining computer databases, documenting customer requirements, and providing advice to informatics professionals.Key ResponsibilitiesDevelop and maintain computer databases to store and manage...

  • Data Systems Specialist

    3 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business requirementsCollaborate with stakeholders to document customer needs and develop data administration policiesProvide expert advice on database management tools and best practicesOperate database...

  • Data Management Specialist

    1 month ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business requirementsDocument customer needs and provide advice on database management toolsOperate database management systems to analyze data and provide insightsDevelop and implement data administration...

  • Data Management Specialist

    1 month ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business requirementsDocument customer needs and provide advice on database management toolsOperate database management systems to analyze data and provide insightsDevelop and implement data administration...

  • Data Management Specialist

    4 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business needsDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...

  • Data Management Specialist

    4 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business needsDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...

  • Data Management Specialist

    2 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team. The ideal candidate will have a strong background in database management and a passion for developing and maintaining computer databases.Key ResponsibilitiesDatabase Development: Design, develop, and maintain computer databases to meet the needs of our...

  • Data Management Specialist

    3 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Rainbook Canada Inc. is seeking a skilled Database Analyst to join our team. The ideal candidate will have a strong background in computer database development and management.Key Responsibilities:Develop and maintain computer databases to ensure data accuracy and integrity.Document customers' requirements for projects and provide advice to other informatics...

  • Data Management Specialist

    2 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team. As a key member of our data management team, you will be responsible for designing, developing, and maintaining computer databases to meet the needs of our organization.Key ResponsibilitiesDatabase Design and Development: Design and develop database systems to store...

  • Data Management Specialist

    3 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business needsDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...

  • Data Management Specialist

    3 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business needsDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...

  • Data Management Specialist

    1 month ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business requirementsDocument customer needs and develop data administration policiesProvide expert advice on database management tools and best practicesLead and coordinate teams to implement data policies and...

  • Data Management Specialist

    1 month ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business requirementsDocument customer needs and develop data administration policiesProvide expert advice on database management tools and best practicesLead and coordinate teams to implement data policies and...

  • Data Management Specialist

    1 month ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business needsDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...

  • Data Management Specialist

    1 month ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business needsDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...

  • Data Management Specialist

    4 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business needsDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...

  • Data Management Specialist

    4 weeks ago

    St. Catharines, Ontario, Canada Rainbook Canada Inc. Full time

    Job DescriptionRainbook Canada Inc. is seeking a skilled Database Analyst to join our team.Key ResponsibilitiesDesign and develop databases to meet business needsDocument customer requirements and provide advice on database management toolsOperate database management systems to analyze data and develop data administration policiesResearch and document data...