Bitwarden Senior Database Engineer at Bitwarden leading design, development, and tuning of database systems. Responsible for query optimization, mentoring engineers, and maintaining secure data access.
Responsibilities
Maintain and enhance the performance of existing database scripts, queries, and other database objects
Assist engineering teams in designing new database implementations that meet the organization's data security, storage, and performance needs
Tune existing database scripts and queries for optimal performance and data security
Establish database observability practices and monitor databases and related systems to ensure optimized performance alongside operations staff
Partner with other engineers to develop new scripts and queries that support company growth
Review database and user reports as well as system information
Perform debugging procedures on database scripts and systems, including as a part of incident response
Mentor engineers and provide them with technical support
Adhere to best practices in securely accessing, storing, backing up, and archiving data
Document processes related to database design, configuration, and performance
Keep abreast of developments and best practices in database engineering
Participate in code reviews and learn and spread technical knowledge amongst the engineering organization
Qualification
Experience operating a largeExcellent problem-solving skillsExperience with observability tooling
Required
Expert knowledge of Microsoft SQL Server and T-SQL: execution plans, indexing, locking and blocking, and query tuning on very large tables
Experience reviewing other engineers’ database code (schema changes, stored procedures, queries, migrations) and giving clear, constructive feedback that developers act on
Experience making schema changes safely on live systems: backward-compatible migrations, zero-downtime deployments, and knowing which changes block
Experience operating a large, busy cloud-hosted database in production (Azure SQL preferred; equivalent experience on another managed platform is welcome)
Ability to diagnose performance problems with evidence, using tools such as Query Store, execution plans, and wait and blocking analysis
Excellent problem-solving skills: you might not know all the answers, but you know how to find and communicate the solution
Excellent written and verbal communication, including explaining database findings to developers, SRE and support
Proficiency using source control and working through pull requests
Around 5 years of experience in database engineering, or equivalent depth on a large production system
Ability to read and review C# data-access code (.NET, Dapper, Entity Framework migrations)
Working knowledge of at least one other RDBMS, such as PostgreSQL or MySQL
Experience with observability tooling, such as Datadog and a telemetry query language like KQL
Preferred
Ability to read and review C# data-access code
Working knowledge of other RDBMS such as PostgreSQL or MySQL
Experience with observability tooling such as Datadog