Database Administrator and Data Governance Analyst

7 days ago


St Catharines, Ontario, 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 online multiuser 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:50 Church Street City Hall (eligible for remote work)

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

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.
  • CQI Data

    1 week ago


    St. Catharines, Ontario, Canada Family and Children's Services Niagara Full time

    Employer: Family and Children's Services NiagaraLocation: Welland, Ontario Type: 12 Month Contract WHO WE AREFamily and Children's Services has been making a positive difference in the lives of children, youth, and families in Niagara for more than a century. As a multiservice agency providing child welfare services, fostering and adoption, counselling, and...

  • Manager, Data

    1 week ago


    St. Catharines, Ontario, Canada Brock University Full time

    One of Canada's leading comprehensive universities and a Top Employer in Hamilton-Niagara, Brock University is an inclusive, welcoming campus community that offers a wide range of unique career opportunities for those with passion, energy and expertise. We're looking for team members who want to help us continue to deliver an exceptional student experience,...


  • St. Catharines, Ontario, Canada Ministry of Children, Community and Social Services Full time

    Do you thrive in a client-service environment and possess demonstrated administrative, communication and customer service skills? If so, consider this challenging opportunity with the Ontario Disability Support Program (ODSP), in the Ministry of Children, Community and Social Services (MCCSS).The Ontario Disability Support Program serves a population that is...


  • St. Catharines, Ontario, Canada Family and Children's Services Niagara Full time

    Employer: Family and Children's Services Niagara.Location: Welland, Ontario.Type: Regular-Full Time hour/week).Benefits: 4 weeks paid vacation, 5 personal days, pension, health and dental benefits.WHO WE ARE:Family and Children's Services has been making a positive difference in the lives of children, youth, and families in Niagara for more than a century....


  • St. Catharines, Ontario, Canada Hospice Niagara Full time

    Hospice Niagara, a not-for-profit charitable organization that focuses on improving the quality of life for people living with life-limiting illnesses, death, dying, grief and loss, is seeking a Finance and Data Administrative Assistant for a Summer Contract Position.Qualifications: Eligible to participate in the Canada Summer Jobs Program; Educational...


  • St. Catharines, Ontario, Canada Hospice Niagara Full time

    Hospice Niagara, a not-for-profit charitable organization that focuses on improving the quality of life for people living with life-limiting illnesses, death, dying, grief and loss, is seeking a Finance and Data Administrative Assistant for a Summer Contract Position.Qualifications Eligible to participate in the Canada Summer Jobs Program Educational...

  • Analyste Technique

    7 days ago


    St. Catharines, Ontario, Canada Oradeo Full time

    Analytical Analysts – Days/Weekends/part time| West of Ireland Leading Pharma Company in the West of Ireland They shall report to the Analytical Services Manager and the main duties & responsibilities shall be: Assist in setting up the analytical methods like HPLC, protein concentration by A280 or water content assay including development and validation...


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

    Summary: To perform legal administrative, clerk and customer service duties as part of a team on behalf of the City Solicitor, legal staff, and Claims/Risk Insurance Coordinator.The Administrative Coordinator is responsible for assisting with the daily administration of municipal claims. This includes, but is not limited to, intake process, digital file...

  • Icqa Data Analyst

    3 weeks ago


    St. Thomas, Ontario, Canada Amazon Full time

    DESCRIPTIONAt Amazon, we're working to be the most customer-centric company on earth. To get there, we need exceptionally talented, bright, and driven people. If you'd like to help us build the place to find and buy anything online, this is your chance to make history.Amazon Canada Fulfillment Services is hiring a Data Analyst to support the Inventory...

  • Icqa Data Analyst

    1 month ago


    St. Thomas, Ontario, Canada Amazon Full time

    DESCRIPTIONAt Amazon, we're working to be the most customer-centric company on earth. To get there, we need exceptionally talented, bright, and driven people. If you'd like to help us build the place to find and buy anything online, this is your chance to make history.Amazon Canada Fulfillment Services is hiring a Data Analyst to support the Inventory...


  • St. Catharines, Ontario, Canada Family and Children's Services Niagara Full time

    DISCLOSURE & PRIVACY ADMINISTRATORReporting to the Director of Quality Assurance, Planning Support, & Privacy, the Disclosure Clerk provides support to the agency in producing confidential disclosures, access to confidential Personal Information, and assisting the Privacy Designate as necessary in meeting the agency's privacy mandate.Main Duties and...


  • St. Thomas, Ontario, Canada St. Thomas Elgin General Hospital Full time

    POSITION:Finance - Data AnalystUNIT:Finance and Decision SupportSTATUS:Full TimeSALARY:$ $35.648:Reporting to the Director of Finance & Health Information, the Finance-Data Analyst will be an integral member of both of our fast paced analytical teams. The incumbent will perform a range of accounting activities including but not limited to journal entries,...

  • CQI Representative

    1 week ago


    St. Catharines, Ontario, Canada Family and Children's Services Niagara Full time

    Employer: Family and Children's Services NiagaraLocation: Welland, Ontario Type: Regular-Full Time hour/week)Benefits: 4 weeks paid vacation, 5 personal days, pension, health and dental benefits WHO WE AREFamily and Children's Services has been making a positive difference in the lives of children, youth, and families in Niagara for more than a century. As a...


  • St. Catharines, Ontario, Canada ALGOMA CENTRAL CORPORATION Full time

    12-Month contractWho We Are:Your Marine Carrier of Choice. What we carry is more than just cargo; we carry essential goods that become a part of our everyday lives. We move cargo that feeds us, keeps our roads safe, helps to build our communities and moves us forward. Marine transportation is the most sustainable mode of transportation, and we take pride in...


  • St. Catharines, Ontario, Canada Niagara Health System Full time

    Reporting to the Manager Accounting and Budgets the Junior Financial Analyst will assist with monthly, quarterly and year-end processes. The successful incumbent will be responsible for preparing analytical reports and graphs, preparation of accurate and timely financial information for various programs, evaluating general ledger activities and balances,...


  • St. Catharines, Ontario, Canada ELA JUASE FINE ART INC Full time

    Education: College, CEGEP or other non-university certificate or diploma from a program of 1 year to 2 years Experience: 2 years to less than 3 yearsTasks: Arrange and coordinate seminars, conferences, etc. Supervise other workers Train other workers Record and prepare minutes of meetings, seminars and conferences Determine and establish office procedures...


  • St. Catharines, Ontario, Canada GOLDEN AUTO REPAIRS Full time

    Education: No degree, certificate or diplomaExperience: 7 months to less than 1 yearTasksEstablish work priorities and ensure procedures are followed and deadlines are metCarry out administrative activities of establishmentCo-ordinate and plan for office services such as accommodation, relocation, equipment, supplies, forms, disposal of assets, parking,...

  • Budget Planning

    7 days ago


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

    Summary:Reporting to Manager of Financial Planning, the Budget Planning & Analysis Student is responsible for assisting the Budget Office Team in the Financial Management Services Department in developing and analyzing budgets, conducting financial forecasts, and supporting fiscal decision-making processes. This co-op opportunity provides an excellent...


  • St. Catharines, Ontario, Canada Queen Genetics Canada Inc. Full time

    Queen Genetics Canada Inc. is looking for a skilled and detail oriented Administrative CoordinatorQueen Genetics supplies B2B Horticultural customers in Canada and the US with an innovative and ever-developing assortment of high-quality plant material. We use customized solutions, efficient customs clearance and reliable logistics to serve each of our...


  • St. Catharines, Ontario, Canada 2649476 Ontario Inc. Full time

    Education: Secondary (high) school graduation certificateExperience: 2 years to less than 3 yearsTasksArrange and co-ordinate seminars, conferences, etc.Supervise other workersTrain other workersRecord and prepare minutes of meetings, seminars and conferencesDetermine and establish office procedures and routinesSchedule and confirm appointmentsAnswer...