DBA Engineer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
DBA Engineer optimizing SQL Server database performance at Social Discovery Group with tasks including troubleshooting, optimizing queries and database administration.
Responsibilities:
- Optimizing the performance of the database infrastructure (queries, indexes, locks, CPU/RAM/disk resource usage, etc.)
- Solving performance issues within short timeframes, supporting business-critical services
- Analyzing and optimizing stored procedures, functions, and triggers
- Diagnosing and resolving performance issues
- Carrying out routine database administration tasks
- Optimizing administration processes for multiple SQL Server instances
- Creating and maintaining replications (transactional, snapshot, merge)
- Collaborating with backend/devops/infrastructure teams on shared tasks
- Updating production systems with patches
- Assisting other departments with data retrieval
- Participating in the design of data storage architecture
Requirements:
- Deep knowledge of Microsoft SQL Server architecture and internals
- Expert-level experience with SQL Server versions 2016–2019
- Practical experience optimizing high-load systems and performance bottlenecks
- Excellent knowledge of T-SQL, including writing and optimizing stored procedures, UDFs, and triggers
- Understanding of indexes, locking, isolation levels, transaction management, waits analysis, deadlock analysis, tempdb optimization
- Experience with built-in diagnostics tools (SQL Profiler, Extended Events, Query Store)
- Experience with SQL Server setup, migrations and upgrades
- Experience with HA/DR solutions (Always On Availability Groups, Log Shipping)
- Experience troubleshooting production incidents
- Basic knowledge of MongoDB and ClickHouse (nice to have)
- Experience creating and supporting SQL Server replications (Transactional / Snapshot / Merge) (nice to have)
- Knowledge of PowerShell (including dbatools module) (nice to have)
- Experience with monitoring systems (Zabbix, Grafana) (nice to have)
- Experience with partitioning, compression, archiving strategies (nice to have)
- Ability to quickly understand and work with existing code (nice to have)
Benefits:
- REMOTE OPPORTUNITY to work full-time
- Vacation 28 calendar days per year
- 7 wellness days per year (time off)
- Bonuses up to $5000 for recommending successful applicants
- 50% payment for professional training, international conferences, and meetings
- Corporate discount for English lessons
- Health benefits
- Reimbursement of workplace costs up to $1000 gross every 3 years
Similar Jobs
Mulesoft Engineer
Mulesoft Engineer joining Tekton Labs for international security projects in a remote setting. Collaborating with multidisciplinary teams to develop high-impact technological solutions.
Senior Controls Engineer
Technical lead managing advanced microgrid control system projects from development to commissioning at Generac. Emphasizing strong accountability and technical expertise in a high-pressure customer environment.
Tier 3 MSP Engineer
Senior engineer overseeing security operations and incident response at Mechanicus LLC. Managing complex issues in Microsoft 365 and Azure environments with a focus on proactive measures.
R&D Engineer – Mission Solutions
R&D Engineer for defense-relevant software and platform solutions at Rackner. Focusing on prototyping and refining software based on user feedback and technical requirements.
Senior Functional Safety Engineer
Senior Functional Safety Engineer developing safety assessments for autonomous vehicles at Torc Robotics. Leading hazard identification and risk analysis for functional safety in autonomous trucking systems.
Camera BSP Engineer
Camera BSP & Middleware Engineer driving the design and development of a unified camera infrastructure across Linux and Android platforms. Collaborating on embedded Linux expertise and camera subsystem integration in a leading automation systems company.
Protection & Control Specialist – Field Technologist/Engineer
Protection & Control Specialist supporting field commissioning and testing activities on power system projects. Ideal for those who enjoy troubleshooting and working on-site in British Columbia.
Senior Protection & Control Specialist – Technologist/Engineer
Senior Protection & Control Specialist leading field execution in critical power system projects. Focusing on commissioning, testing, and client delivery, not design.
Junior Protection & Control Specialist – Technologist or Engineer
Junior Protection & Control Specialist assisting in the commissioning and testing of power systems at Shermco Industries. Ideal for early-career professionals looking for hands-on experience.
Protection & Control Specialist – Field Technologist or Engineer
Protection & Control Specialist supporting field commissioning and testing on power system projects. Working hands-on to troubleshoot and collaborate for high-quality results.
Tier 3 Engineer
Tech Lead managing IT environments for managed services clients at On Call Computer Solutions. Proactively solve technical problems and improve technology environments in a fast-paced MSP setting.
Junior Protection & Control Specialist, Technologist, Engineer
Junior Protection & Control Field Specialist at Shermco Industries supporting field commissioning and testing activities in British Columbia. Engaging in substation environments and power system protection with hands-on training.
Senior Protection & Control Field Specialist – Technologist or Engineer
Senior Protection & Control Field Specialist leading field execution and providing technical expertise on critical power system projects at Shermco Industries.
Senior Protection & Control Specialist – Technologist or Engineer
Senior Protection & Control Field Specialist leading field execution in critical power system projects. Join Shermco Industries for hands-on leadership in commissioning and testing.
Lead Substation Protection & Control Engineer
Lead Substation Protection & Control Engineer designing protection and control projects for high voltage substations in Canada. Seeking motivated engineers to enhance client services and deliver quality engineering solutions.
M365 Engineer
Microsoft 365 Engineer managing Microsoft Teams and 365 environment for Farmer Business Services. Configuring, optimizing, and supporting MS Teams alongside M365 services to enhance collaboration.
Principal Network/Firewall Engineer
Network/Firewall Engineer Principal supporting design, operations, and maintenance of network and security infrastructure. Collaborating with senior engineers on Palo Alto firewall management in a multi-tenant environment.
Senior Online Engineer
Senior Online Engineer implementing multiplayer online services for Bad Robot Games. Collaborating with teams to optimize network performance and manage online systems.
Senior Protection & Control Field Specialist – Technologist, Engineer
Senior Protection & Control Field Specialist leading complex commissioning projects in British Columbia. Overseeing technical expertise in protection & controls and electrical testing.
Demo Engineer
Pre-Sales Demo Engineer at Sureify maintaining demo environments for sales presentations. Position offers career growth towards customer-facing roles in solution consulting.