• Skip to primary navigation
  • Skip to main content
  • Skip to footer
  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter

1.844.822.0541

info@nexusgroup.ca

  • English
    • Français
  • Consultant Login
  • Find Your Opportunity
Nexus Systems Group

Nexus Systems Group

  • Home
  • What We Do
    • Staffing Solutions Made Easy
    • Contingent Workforce Management and Payroll Solutions
    • Technology Consulting and Delivery
  • Who We Serve
  • Who We Are
    • Our Team
    • News and Awards
    • Associations and Community
  • Contact Us
  • News

SQL Database Administrator

September 16, 2024 by

Typical Day in Role:
• Configuration planning & deploying MSSQL servers on public mostly on cloud and on-premise servers.
• Performance tuning, capacity planning and monitoring.
• Database maintenance/housekeeping including database rebuilds/re-indexing/expansion and archiving.
• Trouble-shoot MSSQL server problems and assist in the resolution of application problems.
• MSSQL Server Software currency resolution including Patching/Upgrades/Migrations.
• Assist in database code promotions & data fixes following internal change control process.
• Disaster Recovery/High Availability (DR/HA) support with backup, recovery and
• failover/failback of local and remote replicated databases.
• Provide DBA support to development/implementation projects as assigned, doing
• installations, database loading, migrations, testing, and go live support etc.
• Follow Database best practices, security and change control process of the bank.

Candidate Requirements/Must-Have skills:
1. 8-10+ years of progressive technical working experience as a Database Administrator.
2. 5+ years of experience with Public Cloud including GCP Cloud SQL (MSSQL) and Azure MI/DBaaS/IaaS database administration.
3. Hands on experience with MSSQL Services (SSRS/SSAS/SSIS/PolyBase, R Service, Power BI etc.) and MSSQL Instance/Database Installation/Configuration/Hardening.
4. Hands on experience with MSSQL Servers 2022/2019/2017, Database Security, HA/DR, Performance & Tuning, Database Backup, and prior versions DB Administration.
5. Hands on experience with Scripting and Automation with Power Shell, C#, VB Scripts, SSIS, TSQL etc.

Nice-To-Have Skills:
• Microsoft and/or Google Data Platform certification.
• Windows Servers 2019/2016 and prior versions.
• AD, Firewall IP/Port, domain trust/authentication methods related to MSSQL/Windows database connectivity.
• Application side tuning vs. server-side tuning.
• Setup MSSQL Always-On, Availability groups & Database Replication.
• Logical & Physical Backup/Recovery/Compression techniques.

Education:
• Post-secondary education in Computer Science, Math, or related discipline.

  • Apply Now
  • See All Jobs

Footer

ABOUT NEXUS SYSTEMS GROUP

Nexus is one of North America’s leaders in the provision of technology staff augmentation and strategic resource consulting. With a team of talented professionals using best of breed methodologies, Nexus consistently over delivers with quick, quality and trusted results to its clients and consultants.

LATEST OPPORTUNITIES

  • Advisor Solutions Manager June 19, 2025
  • Bilingual Translation Proofreader June 19, 2025
  • QA Test Lead – Salesforce June 18, 2025
  • Software Developer June 18, 2025

SOCIAL

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
Report on Business Canada's Top Growing Companies - Nexus Group
Nexus Group Growth 500 2019
Nexus Systems Group Growth 500 2018
NEXUS GROUP SYSTEMS GROUP INC. NEXUSGROUP.CA
  • Contact Us
  • Terms & Conditions
  • Privacy Policy