Database Administrator and Data Governance Analyst

6 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

    6 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 Engineer

    3 weeks ago

    St. John's, Newfoundland and Labrador, Canada Data Engineer Jobs Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining the infrastructure and systems required for data storage, processing, and analysis.About the RoleData Engineer ResponsibilitiesDesign and develop data pipelines that extract data from various...

  • Cqi Data

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

  • Geospatial Data Analyst

    2 weeks ago

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

    Job SummaryWe are seeking a skilled Geospatial Data Analyst to join our team at the City of St. Catharines.About the RoleAs a GIS Technician, you will play a crucial role in converting existing drawings and records into digital formats, integrating data from various sources, and maintaining a central spatial database repository.You will prepare graphics,...

  • Chief Data Infrastructure Specialist

    2 weeks ago

    St. John's, Newfoundland and Labrador, Canada Data Engineer Jobs Full time

    Company Overview:Data Engineer Jobs is a leading provider of innovative data engineering solutions. Our mission is to empower organizations to make data-driven decisions by designing, developing, and maintaining scalable and efficient data infrastructure.Salary: The estimated annual salary for this position is $123,000 - $170,000, depending on experience and...

  • Data Sovereignty Database Developer

    2 weeks ago

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

    Job DescriptionWe are seeking a skilled Data Sovereignty Database Developer to join our team at SmartICE.About the RoleThis is an exciting opportunity for a talented individual to develop and implement data management systems that prioritize Indigenous data sovereignty.You will work closely with external partners to design and implement a database that...

  • CQI Data

    1 month ago

    St. Catharines, Canada Family and Children's Services Niagara Remote Work Freelance Full time $31 - $37

    Employer: Family and Children’s Services NiagaraLocation: Welland, OntarioType: Up to 12 Month ContractWHO 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 adoption,...

  • CQI Data

    1 month ago

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

    Employer: Family and Children’s Services NiagaraLocation: Welland, OntarioType: Up to 12 Month ContractWHO 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 adoption,...

  • CQI Data Specialist

    4 weeks ago

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

    CQI Data Administrator Job SummaryFamily and Children's Services Niagara is seeking an experienced CQI Data Administrator to join their team. The successful candidate will be responsible for producing and coordinating organizational performance and service data to support the efficient functioning of the Agency.Main Responsibilities:Continuous Quality...

  • Dba (Database Administrator)

    5 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

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

  • Governance Administrator

    3 weeks ago

    St. Catharines, Canada Brock University Students' Union (BUSU) Full time

    Brock University Students' Union (BUSU), which was established in 1970, has long served the needs of students through impactful initiatives such as comprehensive access to healthcare benefits and public transit. Additionally, BUSU offers employment opportunities to hundreds of students on campus, hosts year-round events, and facilitates over...

  • Systems Solutions Analyst

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

  • Governance Administrator

    1 month ago

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

  • Data Quality and Reporting Specialist

    2 weeks ago

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

    Job Description:We are seeking a highly skilled Data Quality and Reporting Specialist to join our team at Family and Children's Services Niagara. This is an exciting opportunity for someone who is passionate about data analysis, quality assurance, and continuous improvement.About the Role:The successful candidate will be responsible for producing and...

  • 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

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

  • Gis Analyst

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

  • Server Analyst

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

  • Financial Analyst

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