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

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.

Responsibilities:

• 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)