**CTC007099 - Database Administrator - Intermediate IT**:
• *Secteur industriel: Telecommunications**:
• *Type d'emploi: Contract**:
• *Durée: Two months**:
• *Mode de travail: On Site**:
• *Description**:
IMPORTANT
Is this work from home? (please provide details and when/if to return to office)
- Work from home, except the initial setup requires the person to visit a secure site in Ottawa.
Hours per week - 20-25 hours per week
In your own words, describe what the contractor will be doing on a day-to-day basis.
- Architecting and validating a SQL solution that might be similar or different from the current environment
What are the top three functions of this role? (Top duties the contractor will be accountable for)
- Architecting a SQL DBA solution for the Government of Canada
- Migrating data
- Build and testing
What will the contractor need to deliver in their initial 1-6 months?
- A validated or net new solution
- Perform SQL Server installations, architecting new solutions
- Best practise for SQL DB
- Experience with SQL Server High Availability options: Replication, Log Shipping, and Mirroring. Clustering (Failover Cluster) and AlwaysON Availability Groups (AG)
Which qualifications are essential, if any, for the role?
- Strong knowledge of MS SQL Server and related tools
- Administration and Database Management background.
- Understanding of Relational Database Management System Concept
- Experience in Disaster Recovery Planning.
- Someone who has designed SQL solutions in secure environments in the past
Any testing in the interviews/Interview format? No
Any potential to hire full time? potentially
- 5-10 years experience.
- Competent in most areas of database administration
- security, user access, performance optimization, backup, installations and upgrades.
- Design, install, monitor, maintain, and tune production and/or non-production databases while ensuring high levels of data availability.
- Typically works under the direction of a senior database administrator, project manager or a functional IT manager.
• *Etes-vous sûr?**:
