Database Administrator & Developer
$70,736–$88,419 year
On-siteBrantford, Ontario, Canada
Job Summary
Design, develop, and administer SQL Server databases, ETL processes, and BI solutions using SSIS, SSAS, and SSRS. Manage backups, recovery testing, maintenance, indexing, and performance tuning while writing, debugging, and optimizing complex T-SQL. Support data migration, mapping, validation, and reconciliation alongside controlled deployments via Azure DevOps pipelines. Collaborate with SMEs, analysts, and developers to document business rules, standards, and dependencies. Ensure database security, access management, and secure data handling. Post-secondary education in Computer Science or IT required with strong SQL Server and ETL experience. Salary $70,736 - $88,419.
Required Qualifications
- Post-secondary education in Computer Science, IT, Information Systems, or a related field, or equivalent experience
- Strong experience with SQL Server, T-SQL, SSMS, SSIS, SSRS, SSAS, ETL development, and database administration
- Experience building and maintain data warehouses
- Experience with backup/restore, recovery testing, maintenance, performance tuning, indexing, monitoring, and troubleshooting
- Experience with data migration, mapping, reconciliation, validation, and data quality resolution
- Knowledge of database security, permissions, access reviews, service accounts, and handling sensitive data
- Ability to quickly learn complex business processes, systems, terminology, and data relationships
- Strong documentation skills to create clear standards, procedures, and support materials
- Excellent analytical, troubleshooting, communication, and collaboration skills
- A proactive, detail-oriented approach with sound judgment, curiosity, adaptability, and a commitment to reliable systems
- Experience using GitHub Copilot IDE and CLI tools
Desired Qualifications
- Experience with Azure DevOps, Visual Studio, Git, GitHub Copilot, deployments, pipelines, and environment promotion is an asset
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.