SQL Dba

Compugen is one of Canada's largest privately-owned Information Technology (IT) Solution Providers. We help customers design, acquire, integrate and operate technology. Our mission is to help organizations realize new possibilities. Every day, our dedicated staff across North America focus on providing extraordinary customer service and support experiences to private and public sector organizations. We combine breadth of skill, depth of expertise, and commitment to operational excellence at scale to deliver exceptional, customer-focused experiences.

If you are driven to make a difference, relentlessly curious and collaborative at the core, we’d love to talk to you. Join us and help us make a difference.

About the Role

The SQL Server Database Administrator will actively work with the DBA team to provide database support across business critical SQL server system.

**Requirements**:

- Provide support on database architectural design of existing and new systems, database administration, performance monitoring tuning, troubleshooting problems and expansion
- Evaluate and implement products to enhance existing database solutions (reduce costs, improve efficiency, improve performance)
- Review, enhance and develop backup and recovery strategies depending on SLA requirements
- Capacity planning and monitoring database growth.
- Maintain, and administer SSIS and SSAS environments.
- Design, maintain and ensure High Availability solutions including replication, clustering, etc.
- Design, implement and document Disaster Recovery strategies for critical business servers
- Perform capacity planning work on Production, UA, QA, DEV environments.
- Research improvements to improve overall system performance.
- Communicate and coordinate with other IT teams to successfully resolve support and maintenance issues
- Develop and enforce database standards and best practices including performance, security, policy and procedure monitoring
- Deliver on assigned SQL Server Infrastructure projects, including, but not limited to new software releases, patch upgrades, feature exploitation, security, and audit, with participation throughout the project lifecycle
- Establish and maintain written best practices and operational procedures as build books and checklists
- Other duties as assigned

Qualifications:
Education
- Undergraduate degree in computer science or a related field

Experience
- 6-8 years of progressive experience as SQL Server DBA
- Excellent knowledge and experience in building and maintaining high availability clusters and all the associated components as replication, log shipping and always on and CDC
- Experience with creating database documentation including ERD’s, data dictionaries and architecture diagrams
- Experience in Performance Tuning Query Optimization using Performance Monitor SQL Profiler and other related monitoring and troubleshooting tools (preferably SQL Sentry and SolarWinds)
- Experience on database migrations upgradation and patching (including Azure SQL)
- Experience in implementing operational automation
- Ability to troubleshoot SQL Server in a VMware environment
- Experience in administering Oracle and MySQL and MongoDB atlas databases preferred and a definite asset

Competencies
- Excellent listening and interpersonal skills
- Strong written and verbal communication skills
- Strong attention to detail and requirements with the ability to meet deadlines.
- Ability to collect, organize, analyze, and disseminate significant amounts of information

Consistent with our commitments to equity and diversity, we actively recruit from all designated groups. We also provide employment accommodation upon request to current staff members and to applicants during the recruitment process. We aim to provide a work environment where excellence is allowed to flourish and diversity is prized. Compugen is committed to providing accommodation throughout the interview and employment process. If you require an accommodation, the hiring manager and the human resources contact will work with you to meet your needs.