RQ08345 - Sr. Database Administrator

Rubicon Path; Canada; On-site; CAD 90,000 - 120,000; Full time

Job summary

Rubicon Path is seeking a skilled SQL Server Database Administrator to design, administer, and optimize our database environments in Canada. The role focuses on performance tuning, backup/recovery, and ensuring high availability.

You will implement security best practices, patching, access control, and proactive monitoring. Collaboration with cross-functional teams and adherence to ITIL-like processes is expected.

Qualifications

• Proven experience managing, upgrading, and maintaining SQL Server databases.
• Strong skills identifying and resolving performance issues and tuning.
• In-depth knowledge of database security, patching, and access control.
• Experience with high-availability solutions and pro-active monitoring.

Responsibilities

• Creates physical database designs and administers DBMS including optimization and capacity planning.
• Installation, migration, backup and recovery, and performance tuning.
• Monitor and enforce database rules and security best practices.
• Collaborate with teams and support incident, change, and configuration management.

Skills

SQL Server

Database Administration

Performance tuning

Security best practices

Backup and recovery

Monitoring

Patching

High availability

Agile methodologies

Tools

Always On

Clustering

Replication

Job description

Responsibilities

• Creates physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.

General Skills

• Experience with one or more operating systems
• Experience with one or more database technologies
• Experience in one or more programming languages
• Experience in the use of information retrieval packages and proficiency with query languages
• Experience in monitoring and enforcing database rules
• Experience in Incident, Change and Configuration Management procedures
• Experience with one or more communications protocols
• Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
• A team player with a track record for meeting deadlines

Desirable Skills

• Experience with distributed data systems
• Experience with middleware and gateways
• Experience with researching and implementing cyber security vulnerability remediations
• Awareness of emerging IT trends and directions
• Experience with Computer Aided Software Engineering (CASE) tools
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Experience in Database Administration, Maintenance OptimizationSkills

Experience and Skill Set Requirements Must-Haves:

• Proven experience in managing, upgrading, and maintaining SQL Server databases, including patching, backup, and recovery processes.
• Strong skills in identifying and resolving database performance issues, implementing optimization techniques, and setting up proactive alerting and monitoring tools to ensure high availability and stability.
• In-depth knowledge of database security best practices, including regular patching, access control

Technical Knowledge and experience - 50%

• Proven experience as a SQL Server Database Administrator with expertise in managing SQL Server environments (versions 2012 and above).
• Extensive experience in database upgrades, patching, backup, and recovery processes.
• Strong understanding of database security concepts, including access control, encryption, and compliance standards.
• Hands-on experience with performance tuning, troubleshooting, and high-availability solutions (e.g., Always On, clustering, replication).
• Proficiency in developing database roadmaps and implementing best practices for database management.

Methodology, testing, and troubleshooting - 30%

• Experience in creating and implementing structured processes for patching, testing, and verifying upgrades and restorations.
• Demonstrated ability to conduct end-to-end testing of backup and recovery plans.
• Strong troubleshooting skills to identify root causes of database issues and resolve them efficiently.
• Knowledge of agile methodologies or structured project delivery frameworks.

Planning, documentation, and communication - 20%

• Strong ability to develop and document database processes, including upgrade paths, patching strategies, and backup/recovery procedures.
• Excellent communication and reporting skills to provide status updates and knowledge transfer to internal teams.
• Experience in collaborating with cross-functional teams and stakeholders to ensure alignment and delivery of project goals.
• Ability to provide clear and concise technical documentation to support ongoing maintenance and operational needs.

Must-Haves:

• Proven experience in managing, upgrading, and maintaining SQL Server databases, including patching, backup, and recovery processes.
• Strong skills in identifying and resolving database performance issues, implementing optimization techniques, and setting up proactive alerting and monitoring tools to ensure high availability and stability.
• In-depth knowledge of database security best practices, including regular patching, access control