Database Administrator and Data Governance Analyst

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

  • Cqi Data

    7 months ago


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

    **Employer: Family and Children’s Services Niagara** **Location: Welland, Ontario** **Type: 12 Month Contract** **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. As a multiservice agency providing child welfare services, fostering and...


  • 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. Albert, Canada Alberta Gaming, Liquor and Cannabis Full time

    **Identity and Access 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...


  • 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 Brock University Students Union Full time

    **Job Overview** **This position is a one year parental leave coverage** DUTIES: **BUSU Board and Senate Elections**: - Works with the Graduate Students Association to recruit and hire for the Returning Officer (RO) and Deputy Returning Officer (DRO) positions. Supervise positions including payroll - Manage the distribution and verification of all...

  • Administrator, Data

    2 days ago


    St. Albert, Canada K&R Taxservices Inc Full time

    **Work Setting**: - Willing to relocate **Tasks**: - Collect and document user's requirements - 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 data requirements,...

  • Systems Analyst

    6 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

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

  • Server Analyst

    7 months ago


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

    **Server 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...

  • Gis Analyst

    3 months ago


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

    **Join us to shape the future of St. Catharines!**: **About the City**: At the City of St. Catharines, we are committed to realizing the vision outlined in The City of St. Catharines - Strategic Plan 2023 to 2027. Our goal is to cultivate a city that thrives on safety, innovation, sustainability, and caring, not just for today, but for generations to come....

  • Financial Analyst

    6 months 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...

  • E-learning Analyst

    2 days ago


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

    **E-Learning 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...

  • Fleet Data Analyst

    4 weeks ago


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

    As a Fleet Data Analyst at Irving Oil Ltd., you will play a crucial role in optimizing fleet operations and driving business growth. Your primary responsibility will be to analyze and interpret complex data related to fleet performance, identifying areas of improvement and implementing strategies to enhance efficiency.Key Responsibilities:Monitor and analyze...


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

    **Employer: Family and Children’s Services Niagara.** **Reporting to: Director of Child Welfare.** **Location: St. Catharines, Ontario.** **Salary: Competitive salary, benefits package and pension plan.** **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...


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

    **Summary**: **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). - Proactively gather and analyze user requirements to implement system changes, addressing both user needs and emerging business processes. - Regularly liaise with various...


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

    PURPOSE STATEMENT Reporting to the Manager of Business Administration and/or the Manager of Legal Administration, the Business Administrator II is responsible for providing administrative support to teams of Child Protection Workers, Legal Services, and the Family Counselling Centre to enhance the efficient and effective functioning of assigned...


  • St. Paul, Canada S&P Global Full time

    About the Role:Grade Level (for internal use): 11S&P Dow Jones Indices is seeking a seasoned technologist to lead the implementation and support of Platforms for S&P Dow Jones Indices. This role requires a key player who contributes to application development and maintenance, driving innovation by evaluating and integrating new technologies.Responsibilities...


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

    **Employer:Family and Children’s Services Niagara** **Location: St Catharines/Niagara Falls/Welland** **Type: Regular-Full Time (33.75 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...


  • St. Catharines, Canada Kanata Legal Services Full time

    Work Term: Permanent - Work Language: English - Hours: 30 to 44 hours per week - Education: College, CEGEP or other non-university certificate or diploma from a program of 3 months to less than 1 year - Experience: 1 year to less than 2 years - Legal studies, general - Legal administrative assistant/secretary - Legal assistant/paralegal - Political science...