Login | Register

Intermediate Database Architect to architect a new SQL environment to replace a current operating environment

Job Type: Contract
Positions to fill: 1
Start Date: May 24, 2022
Job End Date: Aug 24, 2022
Pay Rate: Hourly: Negotiable
Job ID: 119207
Location: Montreal, Ottawa, Toronto
Our valued Telecommunications client is seeking an Intermediate SQL Database Architect for an initial 3-month Part-Time Contract in Ottawa (100% Remote - Average of 20 flexible hours/week)! 

As the successful candidate, you will be responsible for architecting and configuring a new SQL environment to replace the current operating environment; following industry-standard best practices and performing SQL Server installations, backups, upgrades, patches, and troubleshooting.

  • Architect a new SQL environment to replace a current operating environment
  • Develop maintenance plan for SQL Servers and Application Servers.
  • Configure SQL Server environment following industry-standard best practices.
  • Analyze database performance, including determining bottlenecks optimizing queries, indexes, and transaction rates on an ad-hoc or continual basis.
  • Perform periodic restore procedures as needed
  • Maintain documentation procedure and standards.
  • Attend team, client, and vendors meetings to discuss plans, growth, changes, and issues.
  • Perform SQL Server installations, backups, upgrades, patches, and troubleshooting.
  • Respond to Level 1 and Level 2 Support team concerns/questions.
  • Involvement in all phases of the software development life cycle: planning, designing, implementing, and maintaining databases.
  • Provide 24x7 support for critical production systems
Must-Have Skills:
  • Minimum 8+ years as SQL Server Database Administrator
  • Demonstrated experience architecting DBA Solutions 
  • Demonstrated experience in Disaster Recovery Planning
  • Valid Government of Canada Level II (Secret) Security Clearance
  • Experience with SQL Server High Availability options: Replication, Log Shipping, Mirroring. Clustering (Failover Cluster) and AlwaysON Availability Groups (AG)
  • Demonstrated understanding of Relational Database Management System Concept
  • Experience in migrating data from a variety of sources into MS SQL Server
  • Experience in programming with SQL, Net, Powershell & DOS Scripting and Python
  • Experience Patching for infrastructure in database, version control - updates on versions
  • Experience with root cause vulnerability remediation and investigation
Nice-to-Have Skills:
  • Experience with Cloud Data Platforms AWS, Google, Azure
  • Experience with automating environments (python or shell scripting)