Senior Database Performance & Benchmark Engineer

Senior Database Performance & Benchmark Engineer, the responsible for designing and executing rigorous testing strategies across a complex hybrid

environment consisting of large-scale on-premises SQL Server instances and public cloud managed database services. You will act as the bridge between infrastructure engineering, database administration, and application development to ensure our systems are resilient, highly scalable, and optimized for peak

production workloads.

• Hybrid Benchmarking & Load Testing: Design, script, and execute comprehensive load, stress, and

endurance tests utilizing synthetic tools (e.g., HammerDB, OStress, Apache JMeter) and production

replay tools (e.g., WorkloadTools, DEA).

• Performance Telemetry & Monitoring: Establish performance baselines and build continuous

monitoring dashboards utilizing OS-level metrics (PerfMon/Linux Sysstat) and SQL Server Dynamic

Management Views (DMVs).

• Cloud Migration & Scaling Validation: Benchmark on-premises workloads and simulate equivalent

performance in public cloud environments (such as AWS RDS/EC2, Azure SQL, or GCP Cloud SQL)

to accurately size cloud infrastructure and control costs.

• Bottleneck Isolation & Optimization: Analyze execution plans, identify plan regressions, and isolate

resource contention bottlenecks (CPU, Memory, Disk I/O, TempDB, and network latency).

• Concurrency & Lock Management: Diagnose and resolve complex locking, blocking, and deadlock

scenarios discovered during high-concurrency simulation cycles.

• Cross-Functional Collaboration: Partner with Performance QA, DevOps, Infrastructure, and

Application teams to establish quality gates and provide actionable code/indexing optimization

recommendations.

Must-Have

• Bachelor’s degree in computer science, information technology, engineering, or a related discipline, or equivalent with 7+ years of experience in dedicated database administration (DBA), database engineering, or specialized database performance testing experience.
• Hybrid Environment Mastery: Proven track record managing or benchmarking both traditional

on-premises enterprise hardware and public cloud architectures (AWS, Azure, or GCP).

• Deep SQL Server Internals: Expert-level knowledge of SQL Server query optimization, execution plan

analysis, Query Store, Extended Events (XEvents), and system DMVs and Extensive experience setting up and operating database benchmarking suites such as HammerDB, SQLQueryStress, OStress, or similar automated simulation frameworks.

• Solid understanding of underlying storage configurations (SAN, NVMe, Cloud IOPS allocations), virtualization layers, and network latency mechanics in hybrid setups and Scripting & Automation: Proficiency in PowerShell, T-SQL, or Python to automate test deployments,

data generation, and telemetry collection.

• Experience with cloud native infrastructure-as-code tools (e.g., Terraform) to spin up and tear down

transient performance testing sandboxes and Experience with production workload masking and synchronization methodologies to generate

high-fidelity, non-sensitive testing datasets.

Nice-To-Have

• Relevant certifications such as Azure Database Administrator Associate or

historical Microsoft SQL Server certifications.