Talent.com
Database Administrator
Database AdministratorThames Valley District School Board • London, Ontario, CA
Database Administrator

Database Administrator

Thames Valley District School Board • London, Ontario, CA
1 day ago
Job type
  • Permanent
Job description

POSITION SUMMARY

The Database Administrator supports the administration of the Board’s production, test, development, and web databases and ensures that access to databases meets with the applicable access and security protocols. The incumbent defines data structures and assumes responsibility for data relationships and inter-database integration, including data warehousing components. The incumbent supports Active Directory processes and provides technical support for all the Board’s applications and systems. The incumbent works with the IT Security Administrator to ensure the integrity and protection of all Board data and is responsible for the implementation, configuration, maintenance and performance of critical SQL Server RDBMS systems.

KEY RESPONSIBILITIES :

  • Provide advanced end-to-end technical support and complex problem resolution for ITS staff (including the service desk and SIS teams) and vendors utilizing Board-based databases applications (including, but not limited to, Student Information Systems, EQAO, Payroll, Finance, etc.)
  • Build and support the processes that drive the Board’s Active Directory environment.
  • Define Board data structures for the integration and replication throughout the distributed server environment; monitor and ensure that access adheres to the Board’s protocols and security policies; monitor database server performance; monitor data security on an ongoing basis; maintain database data dictionaries and provide normalization as required; maintain warehousing.
  • Provide support to staff regarding access to, and manipulation of, the data in test and production databases; assist Systems Integration team with data setup, installation and manipulation; assist with the implementation of new enterprise applications by providing database development and support; work with the Infrastructure team to ensure appropriate archiving, backup and restoration of databases and datasets
  • Maintain effective and cooperative liaison with staff, affiliated agencies, vendors, supplies, consultants, service providers, and staff in other government and community organizations; continually seek opportunities to increase customer satisfaction and strengthen customer and vendor relationships

WORK PERFORMED :

  • Complete tasks to define data structures, follow protocols to integrate data across the distributed servers and the replicated corporate data on to other servers as required
  • Monitor access to corporate data according to access protocols and security policy
  • Maintain the data dictionary and provide normalization as required
  • Analyze, evaluate, document and present requirements for new or modified information in the data structures
  • Provide support to the information technology team and staff in other departments regarding access to, and manipulation of the data in production databases
  • Assist systems integration staff with the data set-up, installation and manipulation
  • Assist with the implementation of new enterprise applications by providing database development and support
  • Maintain warehousing, archiving, backup and restoration
  • Perform data modeling for the corporate web database
  • Demonstrate current knowledge and skills related to database administration
  • QUALITIES / SKILLS / SPECIALIZED KNOWLEDGE :

  • Excellent interpersonal skills with effective communication skills, both orally and in writing
  • Ability to create and share documentation through Microsoft O365 and applicable MS Office Suite, in addition to IT work processing tools (e.g. JIRA, DevOps, Topdesk, etc)
  • Ability to work both independently and as part of a team
  • Ability to manage several concurrent issues, balancing priorities, deadlines, risks to deliver effective solutions
  • Knowledge of relational database management systems (e.g. SQL Server), operating systems (e.g. Windows Server 2016, 2019, 2022), data modelling, classification, and mapping
  • Detailed knowledge of Structured Query Language (SQL) and Database Utilities; SSIS, SSRS, SAS and TFS
  • General understanding of computer language, coding and database calls from web applications
  • EDUCATION, EXPERIENCE AND QUALIFICATIONS :

  • Completion of four (4) year post-secondary education in a computer related field or equivalent
  • Five (5) years of related experience is required
  • Database Administrator Associate, Microsoft Certified Solutions Associate (MSCA) Certification in the following areas is an asset : SQL Server, SQL Database Development, SQL Database Administration, SQL Business Intelligence Development
  • Please note it is the responsibility of the applicant to ensure that the application is received by Human Resources on or before the deadline date. This posting is for a permanent existing vacancy.

    Thames Valley does not utilize any assistive technology in the recruitment and selection process.

    The recruitment process requires a criminal background check for work with vulnerable persons at your own expense. In accordance with regulations, this will be an ongoing expectation of employment for TVDSB employees every five years of employment.

    If you were educated outside of Canada, you must have your certificates and / or diplomas or degrees assessed against Canadian education standards. This will enable you to provide proof of Canadian equivalency when applying for a job. The Alliance of Credential Evaluation Services of Canada is a membership organization that offers fair and credible academic credential assessment services in Canada.

    Create a job alert for this search

    Database Administrator • London, Ontario, CA

    Similar jobs
    Guidewire Billing Business Analyst - london

    Guidewire Billing Business Analyst - london

    Coforge • london, on, ca
    Full-time
    Guidewire Billing Business Analyst.Guidewire cloud, Billing, Agile.We at Coforge are hiring Guidewire Billing Business Analyst with the following skillset : . Strong knowledge of Guidewire applicatio...Show more
    Last updated: 2 days ago • Promoted
    Senior Quality Assurance Analyst - london

    Senior Quality Assurance Analyst - london

    Saint Laurent Consulting • london, on, ca
    Part-time
    Quality Assurance (QA) Analyst.Saint Laurent Consulting is hiring on behalf of our client.We are seeking a detail-oriented Quality Assurance (QA) Analyst to support ongoing testing for a large, pub...Show more
    Last updated: 21 days ago • Promoted
    Guidewire Billing Business Analyst - Coforge

    Guidewire Billing Business Analyst - Coforge

    Coforge • london, on, ca
    Full-time
    Guidewire Billing Business Analyst.Guidewire cloud, Billing, Agile.We at Coforge are hiring Guidewire Billing Business Analyst with the following skillset : . Strong knowledge of Guidewire applicatio...Show more
    Last updated: 2 days ago • Promoted
    Business Analyst III - london

    Business Analyst III - london

    Confidential • london, on, ca
    Full-time
    Our teams are committed to always being innovative and staying at the forefront, by joining our Training Center Operations Experience team, you will have the opportunity to actively participate in ...Show more
    Last updated: 4 days ago • Promoted
    EMS / SCADA Engineer - london

    EMS / SCADA Engineer - london

    Pacer Group • london, on, ca
    Full-time
    Network or Transmission Application preferably Reliance.LINUX and Windows Operating Systems.Proficient in Electric Transmission EMS / SCADA / Implementation. Good knowledge of Electric SCADA applicat...Show more
    Last updated: 16 days ago • Promoted
    Tier I SOC Analyst

    Tier I SOC Analyst

    CyberClan • london, on, ca
    Full-time
    Tier I SOC Analyst - Job Description.Established in 2006, CyberClan’s carefully selected team of experts are capable of solving complex cyber security challenges – keeping data secure and businesse...Show more
    Last updated: 25 days ago • Promoted
    Contract T4 || Oracle Integration Cloud (OIC) - london

    Contract T4 || Oracle Integration Cloud (OIC) - london

    Ampstek • london, on, ca
    Full-time
    Role : Oracle Integration Cloud (OIC).Good knowledge in with Oracle Integration Cloud (OIC).Oracle SaaS modules and their integration touchpoints. Exposure to REST / SOAP web services, XML, JSON and o...Show more
    Last updated: 8 days ago • Promoted
    Algebra Private Tutoring Jobs Exeter

    Algebra Private Tutoring Jobs Exeter

    Superprof • Exeter, Canada
    Full-time +1
    Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
    Last updated: 30+ days ago • Promoted
    Senior Statistical Analyst I - london

    Senior Statistical Analyst I - london

    Tigermed • london, on, ca
    Full-time
    Communicate with clients as the.Archive all programming deliverables and documentation per SOPs.Mentor team members and support their technical and professional development.CDISC standards, and com...Show more
    Last updated: 4 days ago • Promoted
    Database and Donor Records Administrator

    Database and Donor Records Administrator

    Employment Services Elgin • St. Thomas
    Full-time
    Database and Donor Records Administrator.BARRIE FAMILY HOSPICE OF ELGIN, St.Job Position : Database and Donor Records Administrator. Reports to : Finance Coordinator.Works with : Manager of Fund Develo...Show more
    Last updated: 1 day ago • Promoted
    Contract T4 || Oracle Integration Cloud (OIC) - Ampstek

    Contract T4 || Oracle Integration Cloud (OIC) - Ampstek

    Ampstek • london, on, ca
    Full-time
    Role : Oracle Integration Cloud (OIC).Good knowledge in with Oracle Integration Cloud (OIC).Oracle SaaS modules and their integration touchpoints. Exposure to REST / SOAP web services, XML, JSON and o...Show more
    Last updated: 8 days ago • Promoted
    Data Security Services Compliance Manager - london

    Data Security Services Compliance Manager - london

    Entrust • london, on, ca
    Full-time
    At Entrust, we’re shaping the future of identity centric security solutions.From our comprehensive portfolio of solutions to our flexible, global workplace, we empower careers, foster collaboration...Show more
    Last updated: 30+ days ago • Promoted
    Senior Clinical Data Manager - london

    Senior Clinical Data Manager - london

    Barrington James • london, on, ca
    Full-time
    Senior Clinical Data Manager - CRO - Remote.Barrington James is proud to partner with a highly respected well established CRO client, seeking an experienced Senior Clinical Data Manager to join the...Show more
    Last updated: 12 days ago • Promoted
    Clinical Data Management Specialist - Warman O'Brien

    Clinical Data Management Specialist - Warman O'Brien

    Warman O'Brien • london, on, ca
    Full-time
    Senior Data Team Lead / Specialist – Clinical Data Management - USA / Canada - Remote.Are you ready to lead global clinical data management projects that shape the future of healthcare?.We’re looki...Show more
    Last updated: 30+ days ago • Promoted
    Information Technology Private Tutoring Jobs Exeter

    Information Technology Private Tutoring Jobs Exeter

    Superprof • Exeter, Canada
    Full-time +1
    Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
    Last updated: 30+ days ago • Promoted
    Clinical Data Management Specialist - london

    Clinical Data Management Specialist - london

    Warman O'Brien • london, on, ca
    Full-time
    Senior Data Team Lead / Specialist – Clinical Data Management - USA / Canada - Remote.Are you ready to lead global clinical data management projects that shape the future of healthcare?.We’re looki...Show more
    Last updated: 30+ days ago • Promoted
    Senior DevOps with Infrastructure (Security Clearance) - Orion Innovation

    Senior DevOps with Infrastructure (Security Clearance) - Orion Innovation

    Orion Innovation • london, on, ca
    Full-time
    Senior DevOps with Infrastructure.Senior DevOps with Infrastructure.Must be eligible for up to a Top-Secret Security Clearance. The Senior DevOps Engineer is a critical hands-on role responsible for...Show more
    Last updated: 4 days ago • Promoted
    Tier I SOC Analyst - london

    Tier I SOC Analyst - london

    CyberClan • london, on, ca
    Full-time
    Tier I SOC Analyst - Job Description.Established in 2006, CyberClan’s carefully selected team of experts are capable of solving complex cyber security challenges – keeping data secure and businesse...Show more
    Last updated: 25 days ago • Promoted