20 hours ago
Remote, United StatesSenior
Base Salary
$150k - $210k/yr
Responsibilities
- Maintain and enhance the performance of database scripts, queries, and other database objects.
- Assist engineering teams with database implementations addressing data security, storage, and performance needs.
- Tune database scripts and queries for optimal performance and data security.
- Establish database observability practices and monitor databases and related systems with operations staff.
- Develop scripts and queries with other engineers to 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.
- Follow best practices for securely accessing, storing, backing up, and archiving data.
- Document database design, configuration, and performance processes.
- Participate in code reviews and share technical knowledge across the engineering organization.
Requirements
- Expert knowledge of Microsoft SQL Server and T-SQL, including execution plans, indexing, locking and blocking, and query tuning on very large tables.
- Experience reviewing database code, including schema changes, stored procedures, queries, and migrations, and providing actionable feedback.
- Experience making safe schema changes on live systems, including backward-compatible migrations and zero-downtime deployments.
- Experience operating a large, busy cloud-hosted production database; Azure SQL is preferred.
- Ability to diagnose performance problems using Query Store, execution plans, and wait and blocking analysis.
- Strong problem-solving, written communication, and verbal communication skills.
- Proficiency with source control and pull requests.
- Approximately five years of database engineering experience or equivalent depth on a large production system.
- Preferred experience reading and reviewing C# data-access code using .NET, Dapper, or Entity Framework migrations.
- Preferred working knowledge of PostgreSQL or MySQL.
- Preferred experience with Datadog, KQL, PowerShell, Python, Docker, production incident response, controlled data fixes, and data-security practices.
Benefits
- All-remote work arrangement for someone located in the United States.
- Opportunity to work in security and open source software and contribute to a more secure internet experience.
- Supportive, diverse, and talented team distributed across the world.
- Professional development opportunities and access to the company growth club.
Tech Stack
Categories
Data Engineering
About Bitwarden
Bitwarden builds open-source security software for storing and sharing credentials and other secrets, used by individuals, developers, and enterprises. Its products include a cross-platform password manager, an enterprise secrets manager, and passkey/passwordless features, sold via subscriptions with free and paid plans. Founded in 2015 and headquartered in Santa Barbara, California, Bitwarden serves millions of users worldwide and operates as a privately held company.
