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: 3 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: 22 days ago • Promoted
    Senior Business Analyst – DocuSign CLM - london

    Senior Business Analyst – DocuSign CLM - london

    MethodHub • london, on, ca
    Full-time
    Senior Business Analyst – DocuSign CLM.Contract Lifecycle Management (CLM) solutions.The role partners with Legal, Procurement, Sales, Compliance, and IT teams to streamline contract processes, imp...Show more
    Last updated: 8 days ago • Promoted
    Technical Lead - london

    Technical Lead - london

    Anime Universe • london, on, ca
    Full-time
    Minimum commitment : 20 hours per week.A Technical Lead provides technical direction and oversight for software projects, ensuring solutions are scalable, secure, and aligned with business objective...Show more
    Last updated: 15 days ago • Promoted
    Senior Java Developer (Trading Systems) - london

    Senior Java Developer (Trading Systems) - london

    Luxoft • london, on, ca
    Full-time
    Building a risk applications and tools for innovative international top-tier hedge fund from the ground up, comprising the systems for traders, pre-trade checks and analysis, risks and limits manag...Show more
    Last updated: 22 days ago • Promoted
    Workday PATT Architect - Focus on WD

    Workday PATT Architect - Focus on WD

    Focus on WD • london, on, ca
    Full-time
    This role requries a bilingual candidate and the requried language is French.We are hiring a Senior Manager to lead Workday Payroll, Time Tracking and Absence delivery across complex client program...Show more
    Last updated: 30+ days ago • Promoted
    Remote Senior SQL Engineer - AI Trainer

    Remote Senior SQL Engineer - AI Trainer

    SuperAnnotate • St. Thomas, Ontario, CA
    Remote
    Full-time
    As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...Show more
    Last updated: 30+ days ago
    DevOps SRE - london

    DevOps SRE - london

    TechDoQuest • london, on, ca
    Full-time
    Experience working on Google Cloud ( GCS, BigQuery ).Experience using GCP Data stack ( Composer, Dataflow, Dataproc ).Hands on with Terraform, SQL, Python. Knowledge on Pub / Sub, APIGEE, Datastream, ...Show more
    Last updated: 22 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
    Canada Payroll Data Conversion Specialist - london

    Canada Payroll Data Conversion Specialist - london

    ACL Digital • london, on, ca
    Full-time
    Payroll Data Conversion Specialist – ADP Streamline to Workday (Canada).Remote (Must support US Time Zones).Strong knowledge of Canadian payroll rules, taxation, and compliance.Hands-on experience ...Show more
    Last updated: 3 days ago • Promoted
    Business Analyst III - Confidential

    Business Analyst III - Confidential

    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
    Full Stack Engineer - london

    Full Stack Engineer - london

    Set 2 Close | B Corp • london, on, ca
    Full-time
    The ideal candidate brings strong backend development experience, solid database skills, and the ability to contribute to scalable, maintainable applications. Develop and maintain backend services u...Show more
    Last updated: 21 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
    Tier I SOC Analyst

    Tier I SOC Analyst

    CyberClan • london, ON, ca
    Full-time
    Tier I SOC Analyst - Job Description Summary / Objective Established in 2006, CyberC...Show more
    Last updated: 25 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: 13 days ago • Promoted
    Oracle Fusion Order Management Consultant - london

    Oracle Fusion Order Management Consultant - london

    Atom • london, on, ca
    Full-time
    We are currently looking for an.Oracle Fusion Oracle Order Management Consultant.Oracle Fusion Order Management Consultant. Atom adding value through your ability to think outside of the box while p...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