Database Administrator providing technical support and administration of IDMS databases for a consulting firm specializing in digital transformation. Collaborating to support operational processes and software upgrades.
About the role
- Database Administrator focused on SQL Server and DevOps tasks at a sports & entertainment marketing firm. Joining a fixed-term contract team supporting mission-critical database environments.
Responsibilities
- Manage and support mission-critical SQL Server environments across Production, QA, and Development.
- Install, configure, and maintain enterprise-wide SQL Server instances (2016 and higher).
- Perform Windows Server administration (2016/2019/2022) and manage OS/SQL Server patching via AWS tools (SSM, RunCommand).
- Configure and manage SQL Server AlwaysOn availability groups and failover clustering.
- Optimize database performance through query optimization, index tuning, and execution plan analysis.
- Manage backup/restore processes and perform point-in-time recovery.
- Administer database security, users, roles, and permissions, including AWS IAM roles and permissions.
- Develop and maintain SSIS packages and SSRS reports.
- Monitor and rightsize infrastructure using tools like CloudWatch and NewRelic.
- Understand and configure ODBC clients and HAProxy as needed.
- Perform capacity planning, forecasting, and proactive performance tuning.
- Conduct root cause analysis for outages and performance issues.
- Automate tasks using T-SQL scripts, SQL Agent jobs, and basic PowerShell scripting.
- Troubleshoot connectivity and network issues, including TCP/IP, DNS resolution, and hostname configuration.
- Use Performance Monitor (Perfmon) to monitor OS-level metrics (CPU, memory, disk I/O).
- Basic understanding of Windows Firewall rules, VPN access, and private vs public network configurations.
- Experience with AWS services (RDS, S3, DynamoDB, EC2, IAM); Azure experience is a plus.
Requirements
- Strong expertise in SQL Server administration and performance tuning.
- Hands-on experience with Windows Server environments.
- Knowledge of DevOps practices and cloud platforms, particularly AWS.
- Solid troubleshooting skills across database, network, and server layers.
- Familiarity with monitoring, automation, and reporting tools.
- Excellent communication skills, with the ability to guide less experienced team members.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Database Administrator (Oracle) maintaining and adapting software architecture with Exposant 3's team in a hybrid role based in Montréal.
LP
Database Administrator
LinkedIn Recruiter Post
Database Administrator supporting Microsoft SQL Server environments on - premises and in the cloud. Ensure database availability, security, and performance in a financial services environment.
Senior Database Administrator at Silverchair, managing IBM Db2 LUW databases with operational and development support in a remote - first setting.
LP
Senior Database Administrator (Oracle DBA)
LinkedIn Recruiter Post
Senior Oracle DBA role in Toronto (Hybrid). Requires 10+ years experience with Oracle 10g/11g/12c/19c, database optimization, performance tuning, and cloud/on - prem environments.
LP
Senior Database Administrator
LinkedIn Recruiter Post
Senior Database Administrator supporting Azure migration and SQL Server management. Focus on installation, configuration, security, performance tuning, and disaster recovery for public sector healthcare client.
LP
ServiceNow Lead Administrator (L2)
LinkedIn Recruiter Post
Lead ServiceNow Service Mapping design, deployment & optimization. Manage CMDB accuracy, KPIs, dashboards, and drive enhancements with training.
LP
Payroll & Benefits Administrator
LinkedIn Recruiter Post
Part - time Payroll & Benefits Administrator role requiring hands - on payroll experience with ADP Workforce Now. 100% onsite in North West Toronto, 3 days/week.
LP
Contract Administrator – IT Vendor Management
LinkedIn Recruiter Post
Contract Administrator for IT Vendor Management role in Mississauga, Ontario. Contractor position focused on IT vendor contract administration.
Senior Database Administrator at Kohl's, driving database product development, collaborating across teams, and leading technical aspects of database lifecycle.