Sql Database Administrator
Apptoza Inc.
The person will lead Microsoft SQL Server database administration, production support, operational governance and database service delivery. The role requires hands-on SQL DBA expertise, leadership, troubleshooting, availability management, performance tuning, backup/recovery governance and cross-team coordination.
Key Accountabilities
Lead end-to-end SQL Server DBA operations, technical delivery and L2/L3 support.
Administer installation, configuration, upgrades, patching, migrations, cloning, refreshes, SQL Agent jobs, storage and capacity.
Manage Always On Availability Groups, Failover Cluster Instances, log shipping, replication and mirroring as applicable.
Plan and validate full, differential and transaction log backups, restore testing, point-in-time recovery and DR exercises.
Monitor health, availability, performance, space, jobs, alerts, wait statistics, blocking, deadlocks and logs.
Tune execution plans, indexes, statistics, queries, waits, memory, CPU, I/O and workloads.
Support database security, access, logins/users/roles, auditing, encryption awareness, vulnerability remediation and compliance.
Troubleshoot availability, backup, transaction log, disk capacity, Agent job, connectivity and authentication incidents.
Coordinate with application, infrastructure, backup, Windows/Unix, security, vendor and customer teams.
Lead technical reviews, guide DBAs, perform peer reviews, allocate tasks and ensure SLA/standards adherence.
Participate in incident, problem, request, change, release and knowledge management.
Maintain runbooks, SOPs, architecture notes, implementation plans, DR evidence, RCA, release notes and knowledge articles.
Experience Required
Good communication with customer stakeholders, application owners, infrastructure, security, DBAs and delivery leadership.
Minimum 10-15 years of enterprise Microsoft SQL Server DBA production support experience.
SQL Server 2016/2019/2022 or later, SSMS, SQL Agent, Always On, clustering and backup/recovery.
Installation, configuration, patching, upgrades, migrations, refresh, tuning and monitoring.
Windows Server, services, event logs, filesystem, permissions, PowerShell and deployment support.
Mission-critical HA/DR, monitoring and 24x7 production support.
T‑SQL troubleshooting, execution plans, index/statistics tuning, waits, deadlocks, blocking, Query Store and resource management.
Security, access controls, auditing, vulnerability remediation and compliance preferred.
CommVault or enterprise backup platform experience preferred.
Utility, regulated infrastructure, NERC CIP‑adjacent, cloud readiness or managed services preferred.
Ability to lead DBAs and deliver to SLA.
Technical Skills
SQL Server 2016/2019/2022 or later: installation, configuration, upgrade, patching, migration, cloning and refresh.
Always On Availability Groups, Failover Cluster Instances, log shipping, replication, mirroring, HA and DR.
Backup/recovery, transaction log management, restore testing, point-in-time recovery and DR exercises.
SSMS, SQL Agent, DMVs, Query Store, Extended Events, Profiler, counters and monitoring tools.
T‑SQL, stored procedures, functions, jobs, indexes, statistics, plans, waits, deadlocks/blocking and tuning.
Windows Server DBA support, PowerShell, event logs, service accounts, storage and deployment.
Database security, auditing, access management, encryption awareness and vulnerability remediation.
ITIL and ServiceNow/Jira/BMC Remedy.
Managed services, SLA reporting, RCA, runbooks, SOPs, audit evidence and knowledge management.
#J-18808-Ljbffr
Key Accountabilities
Lead end-to-end SQL Server DBA operations, technical delivery and L2/L3 support.
Administer installation, configuration, upgrades, patching, migrations, cloning, refreshes, SQL Agent jobs, storage and capacity.
Manage Always On Availability Groups, Failover Cluster Instances, log shipping, replication and mirroring as applicable.
Plan and validate full, differential and transaction log backups, restore testing, point-in-time recovery and DR exercises.
Monitor health, availability, performance, space, jobs, alerts, wait statistics, blocking, deadlocks and logs.
Tune execution plans, indexes, statistics, queries, waits, memory, CPU, I/O and workloads.
Support database security, access, logins/users/roles, auditing, encryption awareness, vulnerability remediation and compliance.
Troubleshoot availability, backup, transaction log, disk capacity, Agent job, connectivity and authentication incidents.
Coordinate with application, infrastructure, backup, Windows/Unix, security, vendor and customer teams.
Lead technical reviews, guide DBAs, perform peer reviews, allocate tasks and ensure SLA/standards adherence.
Participate in incident, problem, request, change, release and knowledge management.
Maintain runbooks, SOPs, architecture notes, implementation plans, DR evidence, RCA, release notes and knowledge articles.
Experience Required
Good communication with customer stakeholders, application owners, infrastructure, security, DBAs and delivery leadership.
Minimum 10-15 years of enterprise Microsoft SQL Server DBA production support experience.
SQL Server 2016/2019/2022 or later, SSMS, SQL Agent, Always On, clustering and backup/recovery.
Installation, configuration, patching, upgrades, migrations, refresh, tuning and monitoring.
Windows Server, services, event logs, filesystem, permissions, PowerShell and deployment support.
Mission-critical HA/DR, monitoring and 24x7 production support.
T‑SQL troubleshooting, execution plans, index/statistics tuning, waits, deadlocks, blocking, Query Store and resource management.
Security, access controls, auditing, vulnerability remediation and compliance preferred.
CommVault or enterprise backup platform experience preferred.
Utility, regulated infrastructure, NERC CIP‑adjacent, cloud readiness or managed services preferred.
Ability to lead DBAs and deliver to SLA.
Technical Skills
SQL Server 2016/2019/2022 or later: installation, configuration, upgrade, patching, migration, cloning and refresh.
Always On Availability Groups, Failover Cluster Instances, log shipping, replication, mirroring, HA and DR.
Backup/recovery, transaction log management, restore testing, point-in-time recovery and DR exercises.
SSMS, SQL Agent, DMVs, Query Store, Extended Events, Profiler, counters and monitoring tools.
T‑SQL, stored procedures, functions, jobs, indexes, statistics, plans, waits, deadlocks/blocking and tuning.
Windows Server DBA support, PowerShell, event logs, service accounts, storage and deployment.
Database security, auditing, access management, encryption awareness and vulnerability remediation.
ITIL and ServiceNow/Jira/BMC Remedy.
Managed services, SLA reporting, RCA, runbooks, SOPs, audit evidence and knowledge management.
#J-18808-Ljbffr
Vacancy posted 17 minutes ago
Similar jobs that could be interesting for youBased on the Sql Database Administrator in Winnipeg, MB vacancy
- Master Azure SQL administration and performance tuning as a Senior Azure SQL Database Administrator across hybrid environments. Lead critical database operations.This senior position focuses on SQL Server, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure...Suggested
- Azure SQL administration and performance tuning define this senior database role across on-premises and cloud environments. Work spans Microsoft SQL Server platforms and production operations.This Senior SQL Server Administrator requires 8–14 years of relevant database administration...Suggested
- Protect enterprise SQL environments through recovery operations, restore testing... ...This work centers on recoverability.As a Database Administrator and Back-up Consultant, you will... ...security, and recoveryOperating system administration and relevant scripting experienceAbility...SuggestedContract workWork at office
- ...recoverable. You combine deep SQL Server expertise with... ...troubleshoot complex issues, improve database performance, reduce recurring... ...day for the Senior Database Administrator Administer APS SQL Server... ...upgrades, refreshes, security administration, and capacity planning. Monitor...Suggested
- ...optimize, scale, and maintain mission-critical database applications. This role partners closely... ...to ensure high availability, optimal SQL/PL-SQL performance, and smooth database... ...Qualifications Experience with Oracle Exadata administration and performance tuning features (Smart...SuggestedInternshipManual labor
- ## PostgreSQL Database Administrator (Production DBA)Apply: Toronto, ON: Full time: Posted 30+ Days Ago: JR192**About Centric Software:**Centric Software... ...support engineers and developers on Postgres internals, SQL tuning, and operational best practices.* Participate in on-call...Full timeRemote work
- ...Position SummaryWe are seeking a Senior Database Administrator (DBA) with deep, hands-on expertise... ...The primary focus of this role is administration and platform engineering: configuring,... ...environments. Solid command of SQL and a scripting/automation language...
- Administer and support SQL Server across on-premises, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.Lead performance... .../experience:8–14 years of relevant database administration experience, with strong L3 MSSQL and Azure DBA expertise...
$70k - $150k per year
...seeking a highly skilled and motivated Database Administrator to join our NACB Database... ...technical expertise in Oracle, Microsoft SQL Server, AWS RDS, Oracle GoldenGate, and... ...Operations & Support Provide day-to-day administration and support for Oracle, Microsoft SQL...Part time- Job Title :Database Administrator and Back-up ConsultantJob ID :91107Location :Edmonton, AlbertaOverviewOur... ...be doing: Provide senior-level administration and operational support for enterprise... ..., security and integrity of SQL database environments through monitoring...Contract work
$118.3k - $135.26k per year
Page 1 of 3 Position Title: Senior Database Administrator Classification: IS30 Department/Account: HIBC Services Job Code: 90000668... ...Science with 7 plus years’ experience in a systems administration environment; with structured training in DB2 Database Administration...Full timeWork at officeWeekend work- ...currently looking for a Senior Oracle Database Administrator (DBA) with experience in Oracle... ...@Customer (ExaCC), Oracle Database administration, RAC, ASM, Data Guard, GoldenGate, OCI... ...performance analysis and tuning across SQL execution, execution plans, wait events...Contract work
- ...customer deployments. Analyze incidents and improve database operations.Centric Software seeks a PostgreSQL Database Administrator for its R&D Customer Support team. The... ...years of hands-on PostgreSQL DBA experienceStrong SQL, EXPLAIN, and EXPLAIN ANALYZE skillsExperience with...Remote work
$92.1k - $142.1k per year
# DB2 / IMS Database Administrator (Canada)DXC TechnologyFull-timeCAN - ON - TORONTOUSD 92,100 - 142... ...• Experience with **IMS** DBRC/RECON administration, DBD/PSB/ACB management, **IMS** recovery... ...**IMS** performance issues.• Perform SQL and database performance tuning.•...Permanent employmentFull timeContract workRemote workFlexible hours- ...OS platforms in Toronto for BMO, using SQL performance tuning to support secure,... ...enterprise banking applications.As a Senior Database Administrator, you will support BMO’s Mainframe... ...The position focuses on Db2 for z/OS administration, database design, performance optimization...
- Lead Oracle database availability, performance, and security for Advanced Solutions in... ...a hybrid work model.As Senior Database Administrator, you will support HIBC Services within... ...diplomaSeven or more years in systems administration environmentsStructured DB2 Database Administration...Weekend work
- Optimize Oracle databases and PL/SQL performance as a Senior Oracle Application DBA supporting mission-critical applications. Partner with development... ...on data modeling, schema design, and PL/SQL deploymentsTune SQL queries, execution plans, and index structuresLead database...
- Oracle AWS Cloud Database Administrators in Toronto use PL/SQL and Amazon RDS expertise within a hybrid... ...design, and PL/SQL deploymentTune SQL queries, execution plans, and index structuresLead... ...RDS, Amazon Aurora, and PostgreSQL administration knowledgeProven AWS migration...
- Recruitment Government of British ColumbiaISL 27R - Senior Database Administrator Upcoming Government of British Columbia BC provincialGovernment of British Columbia has published ISL 27R - Senior Database Administrator. Eligible candidates should apply through the official...
- Drive data management excellence as a Senior Database Administrator for the Government of British Columbia. This role is critical for maintaining robust database systems and ensuring data integrity. The Government of British Columbia is seeking a Senior Database Administrator...
- ...solutions is looking for an experienced Database Platform Engineer, responsible for designing... ...database generalist. You'll work across SQL Server, PostgreSQL, MySQL and... ...Strong Linux (Ubuntu) and Windows Server administration skills. Experience with high availability...
- ...innovative, high-quality IT solutions is looking for a Database Reliability Engineer.They are looking for a motivated Database... ...role.2+ years of experience in IT operations database administration.Solid understanding of SQL databases — hands‑on experience with MySQL and/or...Long term contract
$96.8k - $145.2k per year
...and advancement. Your OpportunityStantec is seeking a Senior Database Geologist to join our Energy and Resources Canada West team. This... ...maintain geological databases using systems such as Microsoft Access, SQL-based platforms, AcQuire, or similar tools Manage large and...Long term contractFull timeTemporary workPart timeCasual workLocal areaRemote workWork from homeHome office- ...between data and business.3+ years of analytics experience in marketing data governance, database marketing, campaign management, hypothesis testing and experimental design.3+ years of SQL/SAS programming with enterprise-level database.3+ years of BI reporting and...Permanent employment
- ...methodology in experimental design. Pull campaign lists by using SQL scripts and ensure waterfalls are signed off, lists are error-... ...between data and business. 3+ years of analytics experience in database marketing, marketing analytics, campaign management, hypothesis testing...Work from home
- Lead Oracle architecture and database administration on-site five days weekly, applying enterprise infrastructure and performance tuning expertise... ...integration, and technology upgrades. The work spans Oracle, SQL Server, DB2, UNIX/Linux, Windows Server, and enterprise platforms...
$80k - $95k per year
...Range: $80,000.00 To $95,000.00 AnnuallyJob DescriptionPosition:Database Marketing ManagerReports To:Director of MarketingOVERVIEWThe CRM... ...reports (Security daily headcount report and GS new sign up report)Run SQL queries to locate data needed to support marketing and financial...Long term contractTemporary work- Lead Azure SQL performance engineering through Query Store, execution plans, Dynamic Management... ...and Azure monitoring. Improve measurable database performance across enterprise platforms.... ...: 8-14 years of relevant database administration experienceDeep Query Store and execution-...
- Job DescriptionJob Title : Database Software developerLocation : Montreal, QCJob Type : Contract on W2Work Status: US Citizen / Canadian... ...in DB2 (Release 9.5 or later) and or Sybase 15.Xgeneral administration, development, programming and performanceturning experience....Contract work
$17 - $20 per hour
...service Recruit and hire workers and carry out related staffing actions Recruit and hire staff Maintain and manage digital database Coaching Evaluate work environments, programs and procedures to control, eliminate, and prevent disease or injury Supervision...Full timeContract workPart timeWork at officeRemote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Sql Database Administrator. Be the first to apply!

