Database Administrator and Data Governance Analyst

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

  • Database Administrator and Data Governance Analyst

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

  • Cqi Data

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

  • database analyst

    3 weeks ago

    St-Eugène, Canada Skotidakis Goat Farm Full time

    Education: Bachelor's degreeExperience: 1 year to less than 2 years or equivalent experienceTasksDevelop and maintain computer databasesTest data models and database management systemsOperate database management systems to analyze dataResearch and document data requirements, data collection and administration policy, and data access rulesAnalyze data...

  • database analyst

    3 weeks ago

    St-Eugène, Canada Skotidakis Goat Farm Full time

    Education: Expérience: EducationBachelor's degree or equivalent experienceTasksDevelop and maintain computer databasesTest data models and database management systemsOperate database management systems to analyze dataResearch and document data requirements, data collection and administration policy, and data access rulesAnalyze data Screening questionsAre...

  • Data and Research Analyst

    2 weeks ago

    St. Thomas, Ontario, Canada Ontario Municipal Social Services Association Full time

    Job Title: Data and Research Analyst**Job Summary:**We are seeking a highly skilled Data and Research Analyst to join our team at the Ontario Municipal Social Services Association. The successful candidate will be responsible for collecting, analyzing, and interpreting data to support effective planning and decision-making.Key Responsibilities:Collect and...

  • Data and Research Analyst

    2 weeks ago

    St. Thomas, Ontario, Canada Ontario Municipal Social Services Association Full time

    Job Title: Data and Research Analyst**Job Summary:**We are seeking a highly skilled Data and Research Analyst to join our team at the Ontario Municipal Social Services Association. The successful candidate will be responsible for collecting, analyzing, and interpreting data to support effective planning and decision-making.Key Responsibilities:Collect and...

  • Computer Database Analyst

    3 weeks ago

    St-Eugène, Canada Skotidakis Goat Farm Full time

    About the RoleWe are seeking a skilled Database Information Specialist to join our team at Skotidakis Goat Farm. As a key member of our operations team, you will be responsible for developing and maintaining our computer databases to support our business operations.Key ResponsibilitiesDatabase Development and Maintenance: Design, implement, and maintain...

  • Data Systems Specialist

    2 hours ago

    St-Eugène, Canada Skotidakis Goat Farm Full time

    Database Analyst Job DescriptionWe are seeking a skilled Database Analyst to join our team at Skotidakis Goat Farm. As a key member of our team, you will be responsible for developing and maintaining our computer databases, ensuring data accuracy and integrity.Key ResponsibilitiesDesign, implement, and maintain databases to support business operationsDevelop...

  • Dba (Database Administrator)

    3 months ago

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

  • Identity and Access Management Analyst

    6 days ago

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

  • Systems Solutions Analyst

    3 months ago

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

  • Database Systems Architect

    1 week ago

    St. John's, Newfoundland and Labrador, Canada Stantec Full time

    Database Administrator - SecurityWe're growing our team with talented individuals who share our passion for operational excellence. Our diverse group of 31,000 team members in over 450 locations worldwide is dedicated to delivering exceptional results.Key Responsibilities:Design and implement secure database systemsDevelop and enforce data governance...

  • Database Systems Architect

    1 week ago

    St. John's, Newfoundland and Labrador, Canada Stantec Full time

    Database Administrator - SecurityWe're growing our team with talented individuals who share our passion for operational excellence. Our diverse group of 31,000 team members in over 450 locations worldwide is dedicated to delivering exceptional results.Key Responsibilities:Design and implement secure database systemsDevelop and enforce data governance...

  • Data Insights Specialist

    4 days ago

    St-Eugène, Canada Skotidakis Goat Farm Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Skotidakis Goat Farm.Key ResponsibilitiesDevelop and maintain computer databases to ensure efficient data management and analysis.Test data models and database management systems to identify areas for improvement.Operate database management systems to analyze data and provide...

  • Data Insights Specialist

    4 days ago

    St-Eugène, Canada Skotidakis Goat Farm Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Skotidakis Goat Farm.Key ResponsibilitiesDevelop and maintain computer databases to ensure efficient data management and analysis.Test data models and database management systems to identify areas for improvement.Operate database management systems to analyze data and provide...

  • Spatial Data Analyst

    3 weeks ago

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

    Job SummaryThe City of St. Catharines is seeking a highly skilled Geographic Information Systems (GIS) Technician to join our team. As a GIS Technician, you will play a critical role in supporting the City's geographic information systems and spatial data management initiatives.Key ResponsibilitiesGIS Data Management: Convert existing drawings, sketches, and...

  • Spatial Data Analyst

    3 weeks ago

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

    Job SummaryThe City of St. Catharines is seeking a highly skilled Geographic Information Systems (GIS) Technician to join our team. As a GIS Technician, you will play a critical role in supporting the City's geographic information systems and spatial data management initiatives.Key ResponsibilitiesGIS Data Management: Convert existing drawings, sketches, and...

  • Data Insights Specialist

    1 day ago

    St-Eugène, Canada Skotidakis Goat Farm Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Skotidakis Goat Farm.Key ResponsibilitiesDevelop and maintain computer databases to ensure efficient data management and analysis.Test data models and database management systems to identify areas for improvement.Operate database management systems to analyze data and provide...

  • Data Insights Specialist

    2 days ago

    St-Eugène, Canada Skotidakis Goat Farm Full time

    Job DescriptionWe are seeking a highly skilled Database Analyst to join our team at Skotidakis Goat Farm.Key ResponsibilitiesDevelop and maintain computer databases to ensure efficient data management and analysis.Test data models and database management systems to identify areas for improvement.Operate database management systems to analyze data and provide...

  • Data Analyst

    7 days ago

    St. Thomas, Ontario, Canada Ontario Municipal Social Services Association Full time

    Data and Research AnalystJoin the Ontario Municipal Social Services Association as a Data and Research Analyst and contribute to the development of effective planning for services and programs. This role supports the Children Services division, the Early Learning and Child Care sector, Ontario Works, and Housing and Homelessness in collecting, tracking,...