Scope of WorkASD requires the full time professional services of a Database Administrator (Senior) to provide database design and development, database modeling and database conversion in support of IMTD operations.
Technical EnvironmentThe current technological environment at the CNSC is as follows:
Microsoft SQL Server 2008 (Standard) and 2012 (Enterprise)
Microsoft ASP.NET (Visual Basic and C#) web applications;
Microsoft SharePoint 2007 (32-bit) and 2013 (64);
Adobe ColdFusion 11;
SAP PowerBuilder 12.6;
Microsoft Team Foundation Server 2012;
Microsoft Windows Server 2008 R2;
Microsoft Windows 7 (64-bit);
Microsoft Office 2010
3. Tasks to be Performed
The tasks to be performed include, but are not limited to the following:
Install and configure SQL Server instances and databases;
Build, convert, test, repair, configure and document all objects in the database environment, including, but not limited to, tables, indexes, views, stored procedures, triggers and agent jobs;
Work very closely with the team members in order to maintain and safeguard the databases;
Develop and implement procedures that will ensure the accuracy, completeness, and timeliness of data stored in the database;
Identify requirements for improvements to existing databases by determining users' information requirements and system performance and functional requirements;
Ensure data consistency with IMTD data model standards and best practices;
Advise programmers, analysts, and partners about the efficient use of data;
Maintain configuration control of the databases;
Analyse and tune databases for optimal efficiency;
Provide database support and advice to the developers;
Perform and/or coordinate updates to the database design;
Develop and implement security procedures for the database, including access and user account management;
Ability to work beyond the normal working hours, including evenings and weekends as and when required on approval from Technical Authority.
4. Deliverables
Interpret systems requirements documents in order to develop IT solutions;
Create, modify, support and document databases;
Create, modify, support and document database programmable objects;
Document database design and detailed deployment instructions;
Document database procedures and processes;
Re-use existing standard modules, developed by IMTD;
Create/perform unit testing of the solution modules during development;
Respond to bug reports and fix issues in a timely fashion;
Reports as defined in Section 6
