Database Administrator and Data Governance Analyst

3 weeks 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**: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.



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


  • St. Catharines, Canada District School Board of Niagara Full time

    Education: College/CEGEP - Experience: 3 years to less than 5 years **Work setting**: - School or educational institution/establishment **Tasks**: - 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 - Research and...

  • Data Analyst

    1 week ago


    St. Albert, Canada BILKINS INC Full time

    **Hiring!** **Data Analyst** **Manadatory Skills**: - The proposed resource must be proficient in Microsoft SQL Query Language, T-SQL and Microsoft SQL Server Database - The proposed resource must be proficient in Microsoft BI Stack - SSIS, SSRS - The proposed resource must have demonstrated experience in Power BI - The proposed resource must have good...

  • Data Analyst

    1 week ago


    St. Albert, Canada WEBNOVA Full time

    WebNova is seeking a talented and experienced Data Analyst to join our team. We are committed to leveraging data and analytics to drive business insights and fuel our mission. If you have a strong passion for transforming raw data into valuable insights, we want to hear from you. **Responsibilities**: **Provide Strategic Insights**: Support decision making...


  • St. Albert, Canada Alberta Gaming, Liquor and Cannabis Full time

    **Master Data Management Analyst** **ABOUT AGLC** Alberta Gaming, Liquor & Cannabis (AGLC) is a dynamic organization leading Alberta’s gaming, liquor and cannabis industries. Our team of high performers is driven to provide our customers with outstanding service and Albertans with choices they can trust. **ABOUT INFORMATION TECHNOLOGIES** IT proudly...


  • St. John's, Canada EndPoint Security Inc. Full time

    Education: Secondary (high) school graduation certificate - Experience: 1 year to less than 2 years - or equivalent experience **Work setting**: - Computer hardware or software retailer/wholesaler - Willing to relocate **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data...


  • St. Jacobs, Canada Home Hardware Stores Limited Full time

    Home Hardware has an exciting opportunity available for a **Data and Reporting Analyst** to join our Corporate Finance team. Reporting to the Manager, FP&A, you will support leadership in the development and creation of Category Management reporting and will work cross-functionally to support reporting and analysis of store level KPI’s (sales, purchases,...


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

    **Summary of Duties**: Reporting to the Manager of Applications, the Systems Solution Analyst will analyze and support a wide range of user requirements to ensure the City is efficiently using its information systems. This position ensures that activities align with corporate, departmental, and project needs while building a positive working relationship...


  • St. Catharines, Canada Canadian Mental Health Association, Niagara Branch Full time

    **JOB POSTING # 114** **Position Title**: Data Integrity Assistant **Vacancies**: 1 **Workgroup**: Clinical Operations **Posting Date**: April 23 - April 30, 2024 **Status**: Full-time Temporary **Start Date/ End Date**: May 6 - August 23, 2024 **Hours**: 35-hours per week; Monday to Friday 8:30 AM - 4:00 PM **Salary Range**: $17.80 per hour -...


  • St. Catharines, Canada Meridian Credit Union Full time

    **Who we are**: Meridian’s dedication to helping Canadians goes beyond banking, it’s about achieving a better life! Thriving communities are essential to the individual well-being of our Members and the overall well-being of Canadians. At Meridian, we’re committed to providing exceptional banking, services, security, and advice so our Members can get...

  • Financial Analyst

    1 month ago


    St. Catharines, Canada District School Board of Niagara Full time

    Financial Analyst District School Board of Niagara - Education Centre Financial Reporting One (1) Full-time position 35 Hours per week The District School Board of Niagara has a position for Financial Analyst in DSBN’s Financial Services Department. Reporting to the Manager, Financial Reporting, the successful applicant will be a key part of the...


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

    _For more than a century, Family and Children’s Services Niagara, the local Children’s Aid Society, has provided vital child welfare, family/community support, counselling, foster care and adoption services to residents in the Niagara Region._ **Business Administrator II** **(Regular Part Time)** Reporting to the Manager of Business Administration,...

  • Systems Analyst

    1 month ago


    St. Albert, Canada Alberta Gaming, Liquor and Cannabis Full time

    **Systems Analyst** **ABOUT AGLC** Alberta Gaming, Liquor & Cannabis (AGLC) is a dynamic organization leading Alberta’s gaming, liquor and cannabis industries. Our team of high performers is driven to provide our customers with outstanding service and Albertans with choices they can trust. **ABOUT INFORMATION TECHNOLOGIES** IT proudly provides the...

  • Systems Analyst

    2 months ago


    St. Albert, Canada Alberta Gaming, Liquor and Cannabis Full time

    **Systems Analyst** **ABOUT AGLC** Alberta Gaming, Liquor & Cannabis (AGLC) is a dynamic organization leading Alberta’s gaming, liquor and cannabis industries. Our team of high performers is driven to provide our customers with outstanding service and Albertans with choices they can trust. **ABOUT INFORMATION TECHNOLOGIES** IT proudly provides the...

  • Systems Analyst

    2 months ago


    St. Albert, Canada Alberta Gaming, Liquor and Cannabis Full time

    **Systems Analyst** **ABOUT AGLC** Alberta Gaming, Liquor & Cannabis (AGLC) is a dynamic organization leading Alberta’s gaming, liquor and cannabis industries. Our team of high performers is driven to provide our customers with outstanding service and Albertans with choices they can trust. **ABOUT INFORMATION TECHNOLOGIES** IT proudly provides the...

  • Systems Analyst

    2 days ago


    St. Albert, Canada Alberta Gaming, Liquor and Cannabis Full time

    **Systems Analyst** **ABOUT AGLC** Alberta Gaming, Liquor & Cannabis (AGLC) is a dynamic organization leading Alberta’s gaming, liquor and cannabis industries. Our team of high performers is driven to provide our customers with outstanding service and Albertans with choices they can trust. **ABOUT INFORMATION TECHNOLOGIES** IT proudly provides the...


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

    _For more than a century, Family and Children’s Services Niagara, the local Children’s Aid Society, has provided vital child welfare, family/community support, counselling, foster care and adoption services to residents in the Niagara Region._ **Business Administrator II** **(Up to 12 month contract)** Reporting to the Manager of Legal Business...


  • St. John's, Newfoundland and Labrador, Canada Irving Oil Full time

    As a Data Integration Analyst your role is to work collaboratively with business stakeholders, vendors, and other members of IT to define, build, test and support the implementation of IT solutions related to our data integration and data analytics platforms. You will be responsible for identifying business requirements, understanding issues, propose...


  • St. John's, Newfoundland and Labrador, Canada Irving Oil Full time

    As a Data Integration Analyst your role is to work collaboratively with business stakeholders, vendors, and other members of IT to define, build, test and support the implementation of IT solutions related to our data integration and data analytics platforms. You will be responsible for identifying business requirements, understanding issues, propose...


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

    _For more than a century, Family and Children’s Services Niagara, the local Children’s Aid Society, has provided vital child welfare, family/community support, counselling, foster care and adoption services to residents in the Niagara Region._ **Technical Systems Analyst** Reporting to the Senior Manager of Information Technology Services, the...