Database Administrator and Data Governance Analyst
7 months ago
**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
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...
-
Database Analyst
23 hours ago
St. Catharines, Canada Clickback Inc. Full timeor equivalent experience **Management Systems (erp or db)**: - MS SQL Server **Computer Experience**: - Database development **Area of Specialization**: - Reports and records - Reports **Work Setting**: - Computer hardware or software retailer/wholesaler **Technical or Specialized Writing**: - Analysis **Specific Skills**: - Collect and document user's...
-
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...
-
Data and Email Delivery Specialist
7 days ago
St. Catharines, Canada Clickback Inc. Full timeClickback has an exciting new position, where this position is all things ‘database’, ‘data’ and ‘data analysis’. - If you love to administer and manage databases, we have close to 200 databases that we need you to ensure are running optimally. - If you like to build queries and pull data to help customers or the company to improve or innovate,...
-
Data and Reporting Analyst
3 days ago
St. Jacobs, Canada Home Hardware Stores Limited Full timeHome 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,...
-
Identity and Access Management Analyst
4 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...
-
Database Coordinator
2 weeks ago
St. Catharines, Canada Alzheimer Society Niagara Region Full time**Position Summary** The Database Coordinator is responsible for managing the Society and Foundation’s data management systems to ensure the accuracy and integrity of the database, overseeing data input and output to ensure information is reliable and up-to-date for the purposes of analyzing and statistical reporting. The Coordinator will also assist in...
-
Governance Administrator
3 months 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...
-
Systems Solutions Analyst
7 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 Administrator
1 week ago
Fort St. John, Canada Overflow Restoration Ltd Full timeEducation: College/CEGEP - Experience: 2 years to less than 3 years **Work setting**: - Help desk - Consulting firm **Tasks**: - Collect and document user's requirements - Design and develop database - Operate database management systems to analyze data - Develop and implement data administration policy, standards and models - Develop policies and...
-
Administrator, Data
2 weeks 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,...
-
Administrator, Data
4 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
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...
-
Financial Analyst
7 months ago
St. Catharines, Canada District School Board of Niagara Full timeFinancial 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 weeks 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...
-
Administrative Assistant
7 months ago
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...
-
Amanda Business and Applications Analyst
7 months ago
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...
-
Business Administrator Ii
8 months ago
St. Catharines, Canada Family and Children's Services Niagara Full timePURPOSE 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...
-
Business Administrator Ii
7 months ago
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...
-
Case Processing Administrator
3 months ago
St. Catharines, Canada Kanata Legal Services Full timeWork 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...