DATABASE ADMINSTRATOR
S.i Systems
Ottawa
7d ago

Scope of Work

The Contractor must provide maintenance and support to the following systems and

applications :

i. Realty Asset Management System (RAMS) programmed in Visual Basic 6, VB.net,

  • Silverlight, ASP.net, Microsoft SQL Server Transact-SQL;
  • ii. AE Personnel Management System (AEPERMS)programmed in Office 2010 Visual Basic

  • for Applications;
  • iii. Canadian Aircraft Arresting System Online Database (CAASOLD) programmed in

    Microsoft Visual Basic .NET, ASP.NET, Silverlight, HTML, Microsoft SQL Server Transact-

  • SQL;
  • iv. Central Heating Plant Reporting System (CHPRS) programmed in Visual Basic 6.0, Excel ,

  • Microsoft Transact-SQL;
  • v. ADM(IE) Winnipeg sql server (vastng1) programmed in Microsoft Transact-SQL for

  • Microsoft Relational Databases, HTML, XML;
  • vi. ADM(IE) WINNIPEG file server ADM(IE) WINNIPEG (vastng1)programmed in Microsoft

    Visual Basic .NET, ASP.NET, HTML, XML; and

    vii. Sustainability Initiative programmed in Office 2010 Visual Basic for Applications,

    Microsoft Visual Basic .NET, ASP.NET, HTML.

    In addition to the above, the Contractor must also :

    viii. Provide DBA MS SQL Server >

    10 years 5 years

    experience as a MS SQL RDBMS Administrator supporting corporate

    databases for web application systems (custom of COTS) on a Unix / Linux

    or Windows operating system. Experience claimed using either of

    versions 2005 or 2008R2 will be accepted. (Must-have)

    5 years of

    experience as a Microsoft SQL Server Database Administrator including

    installing, configuring, tuning, troubleshooting and upgrading MS SQL

    relational database management system. Experience claimed using either

    of versions 2005 or 2008R2 will be accepted. (Must-have)

    5 years of

    experience writing and evaluating SQL scripts including writing and tuning

    SQL and TRANSACT-SQL code for stored procedures, functions and

    triggers in MS SQL. Experience claimed using either of versions 2005 or

    2008R2 will be accepted. (Must-have)

    Valid Secret Clearance (Must-have)

    Location of Work

    19. The Work is to be performed on the Department of National Defence premises at 17 Wing

    Winnipeg, 1 Canadian Air Division, a military facility. Upon verification of a valid security clearance, an

    access badge will be provided to Contractor personnel for access to 1 Canadian Air Division.

    Apply
    Add to favourites
    Remove from favourites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form