We have an opening in our IT department for a Database Administrator (SQL) who will be the subject matter expert on Fenwick’s SQL design, integrations, optimization, monitoring, licensing and securement. The Database Administrator will liaise across all departments that require SQL assistance and provide occasional on-call support. This position can be based in any of our offices with Mountain View/San Francisco office being preferred.
Data management including traces, backups/recovery, logins, replication, SQL policy and best practices.
Monitor and ensure appropriate parameters are alarmed so problems are caught prior to impact.
Design and code reviews by partnering with development DBAs to ensure optimal designs and coding practices are followed.
Analysis and evaluation of system designs, practices and problems.
Assist in migrating our SQL environment/workloads to the cloud as needed.
Control and monitor user access to the database; contacting database vendor for technical support as needed.
Generate various reports by querying from database as per need.
Desired Skills and Qualifications:
Knowledge of current SQL, operating systems and related components.
Knowledge of server configuration and patch management utilizing Microsoft SCCM.
Experience in data center operations including multisite data replication.
Able to prioritize and execute tasks in a deadline-driven environment.
Ability to conduct research, develop and present training programs and/or workshops.
Excellent problem solving, analytical and organizational skills.
Strong interpersonal and communication skills (verbal and written), including the ability to work effectively with all attorneys and staff professionals across the firm.
Highly self-motivated and customer-oriented.
Ability to deal responsibly with sensitive and confidential information in a discreet and secure manner.
Windows Failover Clustering.
HA Technology like Availability Groups and Listeners.
Reporting Services / Data Warehousing / Indexing.
Use of SQL in a hybrid cloud environment in Azure.
Security incorporated into design and services (access control for example).
Consolidate and eliminate databases; moving SQL data between on-prem and cloud systems.
Experience with installing and configuring advanced monitoring and alerting using SCOM and other tools.
Reporting to the Manager of Enterprise Applications, the ideal candidate will have 5+ years of experience in a complex network environment and a bachelor's degree in Computer Science and/or equivalent applicable experience. Systems certification (MCSE, etc.) or equivalent experience is a plus.
To be fully considered for this position, please apply directly online: http://www.fenwick.com/pages/Careers-Professional-Staff.aspx
Internal Number: R758
About Fenwick & West LLP
Fenwick & West is a top-tier law firm with an open and inclusive culture. With more than 300 attorneys and 400 employees in the 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.