Job description
Wilson Sonsini Goodrich & Rosati is the premier legal advisor to technology, life sciences, and other growth enterprises worldwide. We represent companies at every stage of development, from entrepreneurial start-ups to multibillion-dollar global corporations, as well as the venture firms, private equity firms, and investment banks that finance and advise them. The firm has approximately 1,100 attorneys in 19 offices: 14 in the U.S., three in China, and two in Europe. Our broad spectrum of practices and entrepreneurial spirit allow our staff exceptional opportunities for professional achievement and career growth.
The Database Administrator, under the direction of the Director of IT Applications will collaborate with our internal IT team to design, analyze, and maintain our various data platforms. The Database Administrator should be a forward-thinking professional who can bridge the operational, technical, and strategic challenges of managing diverse database systems between on-premises, hybrid, and cloud environments. They will lead the effort to standardize, streamline and modernize our data architecture. They will work to ensure all our databases and our data platforms comply with our security standards, policies, and risk guidance.
This role can be located in any of the firm's U.S. offices and we will also consider fully remote.
Primary Responsibilities:
- Provide architectural roadmap for our data platform focusing on our current on-premises SQL database environment and recommend Azure SQL when needed.
- Perform legacy SQL database migrations to latest or vendor recommended versions and deliver to on-premises or Azure datacenters.
- Proactively monitor and alert application members when issues are encountered in SQL environments.
- Provide expert level administration and support, along with physical database design, architecture and development for high-performing business applications and their associated databases, and analytics functions.
- Troubleshoot complex queries and execution plans that are internally created as well as vendor supplied ensure performance targets are met.
- Provide data infrastructure support to all IT teams to comply with risk and security remediations.
- Audit both internally developed, and vendor supplied databases and associated SQL to ensure operational and performance targets are met.
- Work with our data team, to optimize our data storage and help facilitate the data lake for the firm.
- Provide automation and methods for proactive data storage management to prevent outages and secure our environment.
- Create data extracts and data transfers as needed.
- Operational support for patching, indexing and other associated maintenance for our data platforms.
- Ensure proper access, integrity, availability, and performance of databases.
- Work with vendors to implement new data platforms.
- Develop and modify database objects such as stored procedures, triggers, views, and ad-hoc queries as part of project implementation.
Requirements:
- Experience with and knowledge of cloud-based database tools and platforms (preferably Microsoft Azure SQL Database Architecture and related tools).
- Knowledge of database clustering for high scalability.
- Advanced skills in data automation, SQL Performance Tuning and Optimization (PTO).
- Experience integrating SQL Server and Power Bi Premium throughout the enterprise.
- Experience working with Data Science and Data Operations teams to optimize data flows, ETL processes and reporting/analytics in a high-availability SQL Server capacity.
- Proven problem-solving skills and the ability to applying critical thinking to performance issues with our data platforms.
- Strong analytical skills which should include basic knowledge of software design and product development and management.
- Database Virtualization Experience with Azure and VMware.
- Ability to support new tools and technologies.
- Skilled at foreseeing possible issues and proactively offering solutions.
- Ability to train/share knowledge with various levels of technical understanding with engineers and developers within IT.
- Available for 24/7 support when critical issues arise.
- Self-starter, take charge, highly motivated, positive demeanor and able to juggle multiple assignments simultaneously.
Qualifications:
- 7+ years’ experience as a Database Administrator or comparable experience.
- Bachelor’s degree or equivalent preferred.
- Experience with the legal vertical preferred.
We offer a highly competitive salary and benefits package. Visit our website
here
. Equal Opportunity Employer.
The
firm
requires
all
U.S.
employees
to
be
fully
vaccinated
and
new
hires
will
be
required
to
upload
proof
of
vaccination
prior
to
their
start
date.
At
the
current
time,
in
accordance
with
CDC
guidance,
individuals
are
considered
“fully
vaccinated”
two
weeks
after
completing
the
second
dose
of
a
two-dose
COVID-19
vaccine
(e.g.,
Pfizer-BioNTech
or
Moderna)
or
two
weeks
after
receiving
a
single
dose
of
a
one-dose
vaccine
(e.g.,
Johnson
&
Johnson/Janssen).
If
the
CDC
or
local
health
authorities
for
our
office
locations
amend
their
definition
of
“fully
vaccinated”
to
include
vaccine
boosters,
the
firm
will
do
the
same.
Individuals
who
wish
to
be
considered
for
an
accommodation
on
religious
or
medical
grounds,
or
as
allowed
by
applicable
law,
may
do
so
by
contacting
the
firm’s
Human
Resources
department.
blackflymedia.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, blackflymedia.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, blackflymedia.com is the ideal place to find your next job.