Oracle and SQL Server Database Administrator

2 months ago


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 legislation (Human Rights Code and Accessibility for Ontarians with Disabilities Act [AODA]). Accommodations for job applicants with disabilities are available upon request.

The OUAC is seeking an Oracle and SQL Server Database Administrator to work within the Systems Infrastructure team to maintain its Oracle 19c and SQL Server databases.

**Responsibilities**:

- Installing, configuring, and maintaining Oracle 19c databases for multiple test and production PeopleSoft environments
- Monitoring Oracle databases and troubleshooting any issues
- Implementing and maintaining Oracle database security and auditing
- Refreshing Oracle databases in test environments, including writing and maintaining the related scripts
- Installing, configuring, and maintaining SQL Server databases
- Supporting developers and other internal users
- Recommending and implementing patches, upgrades, and system improvements
- Implementing and testing disaster recovery capabilities
- Planning, documenting, and effectively implementing projects
- Off-hours monitoring on a rotating basis, along with occasional off-hours patching or upgrades

**Qualifications Sought**:

- Degree in Computer Science or Software Engineering, or equivalent education and experience
- 10+ years of in-depth IT experience
- 4+ years as an Oracle Database Administrator
- Extensive knowledge and experience with Oracle 19c database administration, including RMAN, Data Guard, OEM, security, patching, and upgrades
- SQL Server database administration experience, including installation, backups, monitoring, security, patching, and upgrades
- Linux and SQL scripting experience
- Demonstrated project management skills

**Abilities/Skills**:

- Excellent organizational, communication, and interpersonal skills
- Strong analytical and problem-solving skills
- Ability to operate effectively both independently and in a team environment

**Qualifications Considered an Asset**:

- Oracle DBA certification
- Microsoft SQL Server certification
- Experience with PeopleSoft administration and tools, such as monitoring, tuning, debugging, scheduling, or Phire change management software

Remote work arrangements may be available.

**Job Types**: Full-time, Permanent

**Benefits**:

- Casual dress
- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- On-site parking
- Paid time off
- RRSP match
- Vision care
- Wellness program

Schedule:

- Monday to Friday

Work Location: One location

Application deadline: 2023-01-29



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

  • Analyst, Database

    2 months ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Work Term: Temporary - Work Language: English - Hours: 30 hours per week - Education: Bachelor's degree - Experience: 5 years or more - or equivalent experience **Work setting**: - Willing to relocate - Consulting firm **Tasks**: - Collect and document user's requirements - Data Science - Design and develop database - Design, construct, modify, implement...


  • Guelph, Canada Linamar Corp Full time

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


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

  • Analyst, Database

    3 weeks ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Durée de l'emploi: Temporaire - Langue de travail: Anglais - Heures de travail: 30 hours per week - Education: - Expérience: **Education**: - Bachelor's degree - or equivalent experience **Work setting**: - Willing to relocate - Consulting firm **Tasks**: - Data Science - Design and develop database - Collect and document user's requirements - Write,...


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

  • analyst, database

    2 months ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Work Term: TemporaryWork Language: EnglishHours: 30 hours per weekEducation: Bachelor's degreeExperience: 5 years or more or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate technical problems,...

  • analyst, database

    2 weeks ago


    Guelph, Ontario, Canada Aarorn Technologies Inc. Full time

    Work Term: TemporaryWork Language: EnglishHours: 30 hours per weekEducation: Bachelor's degreeExperience: 5 years or more or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate technical problems,...

  • analyst, database

    3 weeks ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Work Term: TemporaryWork Language: EnglishHours: 30 hours per weekEducation: Bachelor's degreeExperience: 5 years or more or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate technical problems,...

  • analyst, database

    4 weeks ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Durée de l'emploi: TemporaireLangue de travail: AnglaisHeures de travail: 30 hours per weekEducation: Expérience: EducationBachelor's degree or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate...

  • analyst, database

    2 months ago


    Guelph, Canada Aarorn Technologies Inc. Full time

    Durée de l'emploi: TemporaireLangue de travail: AnglaisHeures de travail: 30 hours per weekEducation: Expérience: EducationBachelor's degree or equivalent experienceWork settingWilling to relocateConsulting firmTasksData ScienceDesign and develop databaseCollect and document user's requirementsWrite, modify, integrate and test software codeCommunicate...

  • Analyst, Database

    2 weeks ago


    Guelph, Ontario, Canada Aarorn Technologies Inc. Full time

    Work Term: Temporary Work Language: English Hours: 30 hours per week Education: Bachelor's degree Experience: 5 years or more- or equivalent experienceWork setting: Willing to relocate Consulting firmTasks: Collect and document user's requirements Data Science Design and develop database Design, construct, modify, implement and test data models and database...


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

  • Analyst, Database

    2 weeks ago


    Guelph, Ontario, Canada Aarorn Technologies Inc. Full time

    Durée de l'emploi: Temporaire Langue de travail: Anglais Heures de travail: 30 hours per week Education: Expérience:Education: Bachelor's degree- or equivalent experienceWork setting: Willing to relocate Consulting firmTasks: Data Science Design and develop database Collect and document user's requirements Write, modify, integrate and test software code...

  • Analyst, Database

    2 weeks ago


    Guelph, Ontario, Canada Aarorn Technologies Inc. Full time

    Work Term: Permanent Work Language: English Hours: 30 hours per week Education: Bachelor's degree Experience: 5 years or more- or equivalent experienceWork setting: Consulting firmTasks: Write, modify, integrate and test software code Identify and communicate technical problems, processes and solutions Prepare reports, manuals and other documentation on the...


  • 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 Geosyntec Consultants, Inc. Full time

    Overview: Essential Duties and Responsibilities: Is this the right position to help you achieve your professional goals? Some of the key responsibilities for position include: - Monitoring and maintaining existing scripting tools and workflows, while also performing regular audits and assessments; - Authoring scripts in Python or other languages to compile,...


  • Guelph, Ontario, Canada Avanti Software Inc. Full time

    We provide our customers with quality products and top service to keep them riding their snowmobiles, ATVs, motorcycles, dirt bikes and more. The Data Warehouse Administrator will support the implementation and integration of data warehouses, data marts, and cubes. Additionally, the Data Warehouse Administrator will perform data warehouse design and...