Back to results

DBA Analyst (Oracle & SQL Server)

  • QC, Canada

Full-time

Apply on fopconsultants.com About employer

Applications open in a new tab.

Job details

Job type
Full-time
Posting language
English
Posted

Original job description

Brief description of the position:

To meet the needs of its clients in the IT sector, FOP EXPERTS CONSEILS is looking for motivated consultants in DBA analysis (Oracle and SQL Server) for various projects. The main tasks would include developing functional specifications for programs and software, creating and testing solutions, monitoring productions, training users, and participating in continuous improvement programs.

Main Responsibilities:

Without being limited to them, the main responsibilities of the position are as follows:

  • Perform tasks related to the management of Oracle and SQL Server databases, including data refreshing (import/export), daily status checks of the database, managing access rights to various accounts, and creating, modifying, and deleting objects (tables, views, dblink, etc.);
  • Analyze and program requests by identifying possible solutions, considering impacts and efforts;
  • Analyze SQL programming and other supported open-source technologies for business solution development;
  • Ensure the resolution of operational problems of systems in production;
  • Provide advice on BI data exploitation (SAS, PowerBI, etc.).

Qualifications:

  • Bachelor’s or Master’s degree in Computer Science, Software Engineering, or any other related discipline recognized by the Ministry of Education and Higher Education or its equivalent;
  • A minimum of five (5) years of experience in the IT field in development OR maintenance OR system evolution, with at least three (3) years as an Oracle and SQL Server analyst;
  • A minimum of two (2) years of practical experience with the following technologies: Forms/Reports development, Oracle 12C DB, Oracle JDeveloper, SQL and PL/SQL programming;
  • In the past five (5) years, have completed, as an Oracle and SQL Server analyst, at least one (1) project, with a scope of at least 220 person-days, in a development OR maintenance OR system evolution context;
  • A minimum of one (1) year of practical experience with the "Visual Studio" development suite and the ".NET" and "C#" programming languages;
  • Excellent proficiency in the MS Office suite;
  • Good communication and writing skills in French and English;
  • Mobility (an asset).

Personal Skills:

  • Leadership;
  • Rigour and discipline;
  • Ability to manage multiple projects;
  • Analytical and critical thinking;
  • Perseverance;
  • Humility.

What We Offer:

To ensure the full development of its employees, FOP EXPERTS CONSEILS aims to provide the necessary support and comfort for the completion of their tasks. The main benefits offered are as follows:

  • Competitive salary level;
  • Group insurance;
  • Professional insurance;
  • Remote work according to client needs;
  • 3 weeks of vacation;
  • 3 paid sick leave days;
  • Monthly transportation expense package;
  • Advancement opportunities;
  • Continuous training.
More about this job

Responsibilities

The DBA analyst at FOP Consultants will manage Oracle and SQL Server databases, including refreshes, daily checks, access rights and object changes. The role also analyzes and programs client requests, fixes production problems and advises on BI data use.

Requirements

Candidates need a computer science or related degree, at least 5 years of IT experience and 3 years as an Oracle and SQL Server analyst. They also need hands-on skill with Oracle 12c, PL/SQL, Forms/Reports, JDeveloper, and .NET/C# with Visual Studio, plus good French and English.

Skills

  • Oracle Database
  • Microsoft SQL Server
  • SQL
  • PL/SQL
  • Oracle Forms
  • Oracle Reports
  • Oracle JDeveloper
  • Visual Studio
  • C#
  • .NET
  • MS Office
  • SAS
  • Power BI
  • Database administration
  • Data import/export
  • Access rights management
  • Database object management
  • Production support
  • Requirements analysis
  • Functional specifications
  • Software testing
  • User training
  • Continuous improvement
  • Business intelligence
  • Project management

Benefits

  • Group insurance
  • Professional insurance
  • 3 weeks of vacation
  • 3 paid sick leave days
  • Advancement opportunities
  • Continuous training
  • Remote work

Categories

  • Software
  • Technology
  • Consulting
  • Data & Analytics

Keywords

  • Oracle DBA
  • SQL Server
  • Oracle 12c
  • PL/SQL
  • SQL
  • Oracle Forms
  • Oracle Reports
  • Oracle JDeveloper
  • Visual Studio
  • C#
  • .NET
  • database administrator
  • database analyst
  • BI
  • SAS
  • Power BI
  • production support
  • IT consulting
  • Oracle SQL Server analyst
  • database management

Seniority

Senior

Perks

  • Generous paid time off
  • Transit support
  • Paid training

Tools

  • Oracle Database
  • SQL Server
  • Oracle Forms
  • Oracle Reports
  • Oracle JDeveloper
  • Visual Studio
  • C#
  • .NET
  • MS Office
  • SAS

Languages

  • English
  • French

Fields of study

  • Computer Science
  • Software Engineering

Report this job

Get in touch
MovoJobs

Contact us