Junior Database Administrator

4 weeks ago


Guelph, Canada Compusense Inc. Full time

_We are dedicated to excellent sensory and consumer science software that keep our clients at the forefront of their field. Over the last 30 years, Compusense has created innovative solutions for clients all over the world. Currently, Compusense has an exciting opportunity for a growth-motivated individual to join our team._

**Summary**: Working under the direction of the Director SaaS, the Database Administrator will work on maintaining existing databases, technical administrative tasks, new client installations and changes as well as assigned projects and subprojects in conjunction with the current DBA. The duties and responsibilities of this position may evolve over time. This is a full time position.

**Qualifications**:

- Degree in Information Systems or Computer Science required
- Solid PowerShell and/or scripting skills required
- Proficiency with DML/DDL database languages such as T-SQL
- Working knowledge of Windows 2019 servers OS
- Experience as a database administrator in MS 2016-2019 SQL Server environment preferred
- SSRS reports development experience preferred
- Knowledge of and experience with installation, configuration management, maintenance, security, back-up and recovery procedures for relational database management systems
- Analytical mindset and attention to details
- Ability to operate in a fast paced environment
- Excellent written and verbal communication

**Key Responsibilities**:
The duties for this position will also include, but are not limited to, the following areas:

- Ensure availability, security and performance of all client data and new client installations in the in the SaaS Production environment.
- Manage preparation and running of scripts and deployment of software releases and upgrades.
- Update the database schema and add/modify data as required.
- Creating shell and SQL scripts for database administration and deploy automation.
- Maintain data standards in test and production databases
- Maintain documentation and special information as required
- Ensure that client data is backed up regularly in accordance with commitments to clients, and test the backup restoration process to ensure that restore works
- Ensure that sensitive data are handled in an appropriate manner to ensure confidentiality and integrity
- Ensure that changes within the SaaS environment are made with proper authorization in accordance with change management policy and procedure
- Be familiar with disaster recovery plans and be able to implement these plans, if required
- Investigate data issues and correct/modify data as necessary with proper authorizations
- Use company standard systems/tools to handle information processing, sharing and communications.
- On an as-assigned basis be prepared to work or be on-call outside regular work hours to perform routine, system maintenance and to restore normal operations so clients can work with minimized downtime

We thank all applicants for their interest; however, only those applicants selected for an interview will be contacted.

Pay: $60,000.00-$70,000.00 per year

**Benefits**:

- Company events
- Dental care
- Disability insurance
- Employee assistance program
- Employee stock purchase plan
- Life insurance
- Paid time off
- Tuition reimbursement
- Vision care
- Work from home

Schedule:

- 8 hour shift
- Monday to Friday

Supplemental pay types:

- Bonus pay

Ability to commute/relocate:

- Guelph, ON N1G 3X7: reliably commute or plan to relocate before starting work (required)

**Experience**:

- Microsoft SQL Server: 1 year (preferred)

Work Location: Hybrid remote in Guelph, ON N1G 3X7



  • Guelph, Canada Compusense Inc. Full time

    Education: College/CEGEP - Experience: Will train - or equivalent experience **Tasks**: - Design, construct, modify, implement and test data models and database management systems - Develop and implement data administration policy, standards and models - Research and document data requirements, data collection and administration policy, and data access...


  • Guelph, Canada Ontario Universities' Application Centre Full time

    **, permanent with benefits.** **Submission deadline: January 29, 2023.** The OUAC values equity, diversity and inclusion and believes that every person has a right to equal treatment. We are strengthened by diverse backgrounds, perspectives and experiences. We have equitable and accessible employment practices, based on the principles specified in Ontario...


  • Guelph, Ontario, Canada Compusense Inc. Full time

    Education: College/CEGEP Experience: Will train- or equivalent experienceTasks: Design, construct, modify, implement and test data models and database management systems Develop and implement data administration policy, standards and models Research and document data requirements, data collection and administration policy, and data access rules Write scripts...


  • Guelph, Canada OUAC Full time

    **, permanent with benefits** **Submission deadline: January 29, 2023** The OUAC values equity, diversity and inclusion and believes that every person has a right to equal treatment. We are strengthened by diverse backgrounds, perspectives and experiences. We have equitable and accessible employment practices, based on the principles specified in Ontario...


  • Guelph, Canada Skyline Group of Companies Full time

    We’re growing!! And looking for passionate, driven and energetic candidates to join our team for the position of Junior System Administrator  located in our Head Office in Guelph, Ontario. Job Description Are you passionate about managing a broad range of IT related tasks and projects to reach a shared goal of profitable operation through...


  • Guelph, Canada Linamar Corp Full time

    **Junior Application Administrator** **Performance Expectations** - Work with all members of the IT team on ITIL processes to increase the number of first call resolutions and improve overall customer satisfaction. - Create and maintain effective system documentation. - Work with the QA team to develop, coordinate and perform in-depth tests, including...


  • Guelph, Canada Linamar Corp Full time

    **Junior Application Administrator** Powering Vehicles, Motion, Work, and Lives since 1966. **Performance Expectations - Work with all members of the IT team on ITIL processes to increase the number of first call resolutions and improve overall customer satisfaction. - Create and maintain effective system documentation. - Work with the QA team to develop,...


  • Guelph, Ontario, Canada Skyline Group of Companies Full time

    And looking for passionate, driven and energetic candidates to join our team for the position of JuniorSystem Administrator located in our Head Office in Guelph, Ontario. Are you passionate about managinga broad range of IT related tasks and projects to reach a shared goal of profitable operation through increased efficiency? As a Junior System...

  • Database Assistant

    6 days ago


    Guelph, Canada United Way Guelph Wellington Dufferin Full time

    **Position Overview** Reporting to the Systems & Database Manager, your work will ensure effective donor data capture and quality. You will assistant with importing and inputting data, data maintenance and clean up, and support for the development of online donation pages. This behind the scenes role provides vital support in ensuring we have data we can...


  • Guelph, Ontario, Canada Skyline Group of Companies Full time

    We're growing And looking for passionate, driven and energetic candidates to join our team for the position of JuniorSystem Administratorlocated in our Head Office in Guelph, Ontario.Job DescriptionAre you passionate about managinga broad range of IT related tasks and projects to reach a shared goal of profitable operation through increased efficiency? As a...


  • Guelph, Canada Linamar Corp Full time

    **Desktop and System Support Technician, Junior** The Desktop and System Support Technician, Junior position will be responsible for maintaining the integrity of the operating system server environment and installing system software upgrades including planning and scheduling, testing and coordination. Primarily accountable for performing workstation and...


  • Guelph, Canada Linamar Corp Full time

    **Desktop and System Support Technician, Junior** The Desktop and System Support Technician, Junior position will be responsible for maintaining the integrity of the operating system server environment and installing system software upgrades including planning and scheduling, testing and coordination. Primarily accountable for performing workstation and...


  • Guelph, Canada Linamar Corp Full time

    **Desktop and System Support Technician, Junior** The Desktop and System Support Technician, Junior position will be responsible for maintaining the integrity of the operating system server environment and installing system software upgrades including planning and scheduling, testing and coordination. Primarily accountable for performing workstation and...


  • Guelph, Canada Skyline Group of Companies Full time

    We’re growing!! And looking for passionate, driven and energetic candidates to join our team for the position of JuniorSystem Administratorlocated in our Head Office in Guelph, Ontario.Job DescriptionAre you passionate about managinga broad range of IT related tasks and projects to reach a shared goal of profitable operation through increased efficiency?...


  • Guelph, Canada Skyline Group of Companies Full time

    We’re growing!! And looking for passionate, driven and energetic candidates to join our team for the position of JuniorSystem Administratorlocated in our Head Office in Guelph, Ontario.Job DescriptionAre you passionate about managinga broad range of IT related tasks and projects to reach a shared goal of profitable operation through increased efficiency?...


  • Guelph, Ontario, Canada Linamar Corporation Full time

    Automation Technician, Junior The Automation Technician, Junior position is responsible for working with the manufacturing engineer, project engineers, and program managers, set up personnel, and maintenance departments to reduce costs and remove non-value-added material from production lines. Performance Expectations # Work with program managers and...


  • Guelph, Canada Linamar Corp Full time

    **System Administrator - Intermediate** Under general supervision, responsible for installing, configuring, and maintaining operating system workstations and servers, including web servers, in support of business processing requirements. Perform software installations and upgrade to operating systems and layered software packages. Schedule installations and...


  • Guelph, Canada Lovett Signs Full time

    **Job Title: Junior Sales Representative** **Company**: Lovett Signs **About Lovett Signs**: Lovett Signs is a leading provider of innovative signage solutions, specializing in creating eye-catching displays that help businesses stand out and attract customers. With over 88 years of experience in the industry, we pride ourselves on our commitment to...


  • Guelph, Canada University of Guelph Full time

    Home Careers @ Guelph Current Opportunities Senior Analyst, Database Services Senior Analyst, Database Services Forbes Ranks U of G Among Canada's Top Employers Professional and Managerial Group Senior Analyst, Database Services Computing and Communications Services (CCS) Hiring #: 2024-0313 Please read the Application Instructions before applying Computing...


  • Guelph, Canada University of Guelph Full time

    Home Careers @ Guelph Current Opportunities Senior Analyst, Database Services Senior Analyst, Database Services Forbes Ranks U of G Among Canada's Top Employers Professional and Managerial Group Senior Analyst, Database Services Computing and Communications Services (CCS) Hiring #: 2024-0313 Please read the Application Instructions before applying Computing...