SQL DBA Architect

Job title: SQL DBA Architect

Job description: RESPONSIBILITIES

• Perform 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.
• Maintain documentation procedure and standards.
• Attend team, client, and vendors meetings to discuss plans, growth, changes, and issues.
• Respond to Level 1 and Level 2 Support team concerns/questions.
• Analyze database performance, including determining bottlenecks optimizing queries, indexes, and transaction rates on an ah-hoc or continual basis.
• Perform periodic restore procedures as needed
• Involvement in all phases of the software development life cycle: planning, designing, implementing, and maintaining databases.
• Provide 24×7 support for critical production systems

QUALIFICATIONS

• 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.
• Experience with SQL Server High Availability options: Replication, Log Shipping, Mirroring. Clustering (Failover Cluster) and AlwaysON Availability Groups (AG)
• 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 with Cloud Data Platforms AWS, Google, Azure
• Experience Patching for infrastructure in database, version control – updates on versions
• proven and demonstrable troubleshooting and analytical experience
• Experience with root cause vulnerability remediation and investigation
• Experience with automating environments (python or shell scripting)
• Ability to work effectively in a fast-paced, dynamic environment and prioritize workload and deliverables within schedule constraints to deliver results.
• Detail orientated with good organizational skills.
• Strong communication and interpersonal skills
• (Required) Security Clearance Level II (CCIS)
• Minimum of eight years as regular SQL Server Database Administrator

WHO ARE WE?

We’re Ian Martin: a full-service recruiting firm with 60+ years’ experience hiring engineering and IT professionals like you.

Ian Martin has a proven track record of contractor success and candidate satisfaction. 98.9% of our contractors are satisfied with their experience and 99.2% of them complete their assignments.

When you apply, you’ll have support throughout the entire hiring process-our recruiters will assess your qualifications and put you in touch with jobs and employers that are right for you.

Company: Ian Martin

Expected salary:

Location: Ottawa, ON

Job date: Thu, 06 Oct 2022 04:45:06 GMT

Job Source: Careerjet.ca

Click Here to Apply