DBA Engineer

Accountabilities:

• Optimize SQL Server performance across queries, indexes, stored procedures, and system resources (CPU, memory, disk), ensuring high availability and efficiency in production environments.


• Diagnose and resolve complex performance bottlenecks, including blocking, deadlocks, execution plan issues, and resource contention under tight SLAs.


• Perform advanced T-SQL development and optimization, including stored procedures, user-defined functions, triggers, and query tuning.


• Manage SQL Server administration tasks such as installations, upgrades, migrations, backups, recovery, monitoring, security, and integrity checks.


• Design, maintain, and support high availability and disaster recovery solutions including Always On Availability Groups, replication, and Log Shipping.


• Collaborate with DevOps, backend, and infrastructure teams to support deployments, incident resolution, and system improvements.


• Participate in architecture design discussions to improve scalability, data modeling, and long-term database strategy.

Requirements

• 5+ years of experience as a DBA or database engineer with strong expertise in Microsoft SQL Server (2016–2019 strongly preferred).


• Deep knowledge of SQL Server internals, including indexing strategies, locking, isolation levels, transaction management, and tempdb optimization.


• Expert-level proficiency in T-SQL, with proven ability to optimize complex queries, stored procedures, and database logic.


• Strong experience with performance tuning tools such as SQL Profiler, Extended Events, Query Store, and DMVs/DMFs.


• Hands-on experience with high-load production systems, production incident troubleshooting, and performance root cause analysis.


• Solid understanding of HA/DR solutions including Always On Availability Groups, replication, and Log Shipping.


• Ability to analyze execution plans and identify architectural or structural database issues.


• Nice to have: experience with MongoDB, ClickHouse, PowerShell (dbatools), monitoring tools like Zabbix or Grafana, and Windows Server administration.


• Strong problem-solving mindset with the ability to quickly understand and work with existing complex systems.


• Experience with 24/7 mission-critical environments is highly valued.

• Fully remote full-time position with flexible working arrangements.


• 28 calendar days of annual vacation plus 7 wellness days for personal rest and recovery.


• Annual reimbursement for health-related expenses or private insurance up to $1,000.


• Budget for professional development, including 50% reimbursement for training, conferences, and industry events.


• Corporate discounts for English language learning programs.


• Provided equipment or home office/co-working reimbursement up to $1,000 every 3 years.


• Employee reward system with bonuses, redeemable for merchandise and team experiences.


• Referral bonuses up to $5,000 for successful candidate recommendations.


• Collaborative, globally distributed engineering culture with strong focus on technical excellence.

Deze vacature komt van ats_lever. Originele vacature bekijken ↗