Database Administrator (SQL)

Fenwick & West is a top-tier law firm with an open and inclusive culture. With more than 400 lawyers and 400 employees in Silicon Valley, San Francisco, Santa Monica, Seattle and New York, we work with companies on the cutting edge of technology, life sciences and cleantech. For more than four decades, our firm has helped some of the world's most recognized companies become and remain market leaders. We are proud to have been named one of the Best Places to Work in the Bay Area for the twelfth year.

Fenwick is seeking a Database Administrator who will be responsible for administering Microsoft SQL Server databases across the firm, as well as advising IT and departmental applications and systems groups on best practices with respect to database design and administration. This individual will also help chart the firm's database path to the cloud using Microsoft Azure SQL and related technologies. The position can be based in any of our offices - Mountain View, Foster City or San Jose (CA) being preferred, with remote as an option as specific duties allow.Responsibilities Include:Extract and/or load data from/to production and development database servers.

Set up and maintain database security both on-premises and in Azure (cloud).

Ensure all SQL hardware and software are updated and patched.

Monitor the performance of SQL hardware and software.

Configure servers and databases, both on-prem and cloud.

Preserve data integrity.

Work with development teams to optimize queries, indexes, and storage both on-prem and in Azure.

Support the firm's data-mart/warehousing efforts.

Estimate SQL Server instances costs on Microsoft Azure platform, and selecting the optimum compute models for a variety of application scenarios.

Initially manage current on-premises SQL Servers, with the objective to consolidate that number and migrate to Azure SQL Server.

Minimize database downtime and manage parameters to provide fast query responses.

Perform tests and evaluations regularly to ensure data security, privacy and integrity.

Monitor database performance, implement changes and apply new patches and versions when required.

Flexibility to be available for on-call as needed, possible after hours or weekend maintenance.Desired Skills and Qualifications:Problem-solving skills and ability to think algorithmically.

Hands-on experience with database standards and end user applications.

Excellent knowledge of data backup, recovery, security, integrity and SQL.

Excellent knowledge of SQL Server on Azure (cloud), as well as on-premises.

Expert in database design, documentation and coding (T-SQL stored procs, functions, triggers, etc.).

Familiarity with programming languages API.

Familiarity with SSMS, SSIS, SSAS, SSRS is required.

Familiarity with securing SQL Server in Azure while allowing access to other services & applications such as Power Automate, Logic Apps, or Power BI.

Reporting to the Director of Applications Development and Business Process, the qualified candidate will have 10+ years' experience with the skills and technical knowledge indicated above. Additionally, experience with Microsoft DevOps deployments involving SQL server, including automated provisioning of production and dev SQL servers. Previous experience with DBA case tools (frontend/backend) and third party tools. Cognos Db and other database technologies experience a plus.To be fully considered for this position, please apply directly online: https://fenwick.wd1.myworkdayjobs.com/en-US/FenwickExternalCareers/job/Mountain-View/Database-AdministratorSQL-R758