Senior Database Engineer
New
B
BitwardenIdentity security
Location: US Remote; we are looking for someone located in the U.S.Full-TimeSenior
Salary150,000 - 210,000 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- Around 5 years of experience in database engineering, or equivalent depth on a large production system
- Required Skills
- PostgreSQLMicrosoft SQL ServerMySQL
Requirements
- Have expert knowledge of Microsoft SQL Server and T-SQL, including execution plans, indexing, locking and blocking, and query tuning on very large tables.
- Have experience reviewing database code, including schema changes, stored procedures, queries, and migrations, and giving constructive feedback.
- Have experience making safe schema changes on live systems, including backward-compatible migrations and zero-downtime deployments.
- Have experience operating a large, busy cloud-hosted database in production; Azure SQL is preferred, with equivalent managed-platform experience welcome.
- Be able to diagnose performance problems using evidence and tools such as Query Store, execution plans, and wait and blocking analysis.
- Have around 5 years of database engineering experience, or equivalent depth on a large production system.
- Be proficient with source control and working through pull requests.
- Be able to explain database findings to developers, SRE, and support.
- Be able to read and review C# data-access code, including .NET, Dapper, and Entity Framework migrations.
- Have working knowledge of at least one other RDBMS, such as PostgreSQL or MySQL.
- Have experience with observability tooling such as Datadog and a telemetry query language such as KQL.
- Have scripting experience in PowerShell or Python.
Responsibilities
- Maintain and improve the performance of database scripts, queries, and other database objects.
- Assist engineering teams in designing database implementations that meet data security, storage, and performance needs.
- Tune database scripts and queries for performance and data security.
- Establish database observability practices and monitor databases and related systems with operations staff.
- Partner with engineers to develop scripts and queries that support company growth.
- Review database and user reports and system information.
- Debug database scripts and systems, including during incident response.
- Mentor engineers and provide technical support.
- Document database design, configuration, and performance processes.
- Participate in code reviews and share technical knowledge across the engineering organization.
View Full Description & ApplyYou'll be redirected to the employer's site