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.
Responsibilities:
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
- 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
- Experience with Cloud Data Platforms AWS, Google, Azure
- Experience with automating environments (python or shell scripting)