Senior SQL Server DBA Data Modeling & ArchitecturePurple Drive • San Francisco, CA, United States

Senior SQL Server DBA Data Modeling & Architecture

Purple Drive • San Francisco, CA, United States

4 days ago

Job type

Full-time

Job description

Senior SQL Server DBA - Data Modeling & Architecture

Job Description

We are seeking an experienced Senior SQL Server Database Administrator with strong expertise in data modeling, database architecture, and performance optimization . The ideal candidate will design scalable data models, build robust database architectures, and manage SQL Server environments to ensure high availability, security, and optimal performance.

Key Responsibilities

1. Data Modeling & Architecture

Design conceptual, logical, and physical data models.
Develop scalable OLTP / OLAP database architectures.
Create and enforce data standards, naming conventions, and modeling best practices.
Partner with application architects to align data design with system workflows.

2. Database Administration

Install, configure, upgrade, and maintain SQL Server environments (2014-2022 / Azure SQL).

Administer Always On Availability Groups, clustering, log shipping, and replication.

Manage backup / restore strategies and disaster recovery planning.

3. Performance Tuning & Optimization

Analyze and tune SQL queries, indexing strategies, statistics, and execution plans.

Resolve locking / blocking issues, parameter sniffing, and resource bottlenecks.

Implement partitioning, compression, and storage optimization techniques.

4. Security & Compliance

Implement RBAC, TDE, Always Encrypted, auditing, and data masking.

Maintain compliance with organizational and regulatory security standards.

Ensure database hardening and controlled deployments.

5. Automation & DevOps

Automate repetitive tasks using PowerShell and T-SQL scripts.

Support CI / CD pipeline integration for database deployments.

Build monitoring and alerting solutions for performance and health checks.

6. Collaboration & Documentation

Work closely with developers, architects, and data teams to improve database design.

Review T-SQL code and provide performance recommendations.

Maintain documentation for data models, architecture diagrams, and DBA procedures.

Mentor junior DBAs and contribute to data governance initiatives.

Required Skills & Qualifications

7-12+ years of experience as a SQL Server DBA.

Strong expertise in data modeling , normalization, and relational design.

Solid understanding of OLTP and OLAP database structures.

Advanced T-SQL scripting and query optimization skills.

Hands-on experience with Always On AGs , clustering, and high-availability solutions.

Knowledge of Azure SQL, Managed Instance, and hybrid cloud environments.

Proficiency with monitoring tools (e.g., Redgate, SentryOne, SolarWinds DPA).

Strong analytical, communication, and problem-solving abilities.

Preferred Qualifications

Experience with ER modeling tools (ERwin, ER / Studio, Visio).

Azure certifications (AZ-900, DP-300, DP-203).

Familiarity with DevOps pipelines (Azure DevOps, Git, CI / CD).

Knowledge of ETL / Data Warehousing environments.

Create a job alert for this search

Sql Dba • San Francisco, CA, United States

Similar jobs

Senior SAP ASE DBA

VirtualVocations • Oakland, California, United States

Full-time

A company is looking for a Senior SAP ASE / Sybase DBA to support a Federal Customer in a cybersecurity modernization initiative. Key Responsibilities Lead the technical mapping of legacy SAP ASE ...Show more

Last updated: 2 days ago • Promoted

Senior Data Modeler & Analytics Architect (Snowflake)

Salesforce, Inc. • San Francisco, California, United States

Full-time

A leading cloud-based software company seeks a Data Model Architect with extensive experience in data modeling and architecture. The role involves designing robust data models that integrate various...Show more

Last updated: 8 days ago • Promoted

Senior Manager, REMS Data Programmer

Jazz Pharmaceuticals • Redwood City, California, USA

Full-time

If you are a current Jazz employee please apply via the Internal Career site.Jazz Pharmaceuticals is a global biopharma company whose purpose is to innovate to transform the lives of patients and ...Show more

Last updated: 30+ days ago • Promoted

Senior Director, Data and AI Architecture Leader

Dynavax Technologies • Emeryville, CA, United States

Full-time

This position can be 100% remote, but must be located in the United States.Dynavax is a commercial-stage biopharmaceutical company developing and commercializing novel vaccines to help protect the ...Show more

Last updated: 30+ days ago • Promoted

Senior SQL Server Architect & Data Modeling Lead

Purple Drive Technologies LLC • San Francisco, CA, United States

Full-time

A technology solutions provider is seeking a Senior SQL Server Database Administrator in San Francisco.The candidate will be responsible for designing data models, managing SQL Server environments,...Show more

Last updated: 9 days ago • Promoted

Senior Software Engineer, Billing Platform

Scale AI, Inc. • San Francisco, CA, United States

Full-time

At Scale AI, our mission is to accelerate the development of AI applications.For 8 years, Scale has been the leading AI data foundry, helping fuel the most exciting advancements in AI, including : g...Show more

Last updated: 30+ days ago • Promoted

Lead Database Reliability Engineer

Qualys • Foster City, CA, United States

Full-time

Come work at a place where innovation and teamwork come together to support the most exciting missions in the world!.The Qualys SaaS platform is database centric and relies heavily on Oracle, Elast...Show more

Last updated: 30+ days ago • Promoted

Database Architect $110,089 – $165,134

ISC2 East Bay Chapter • San Carlos, CA, United States

Full-time

Database Architect $110,089 – $165,134.Be among the first 25 applicants.San Mateo County Transit District.The Database Architect reports to the Manager, IT Technology and Telecommunications and is ...Show more

Last updated: 30+ days ago • Promoted

Senior Data Architect

Autodesk, Inc. • San Francisco, CA, United States

Full-time

We are seeking a • •Senior Data Architect • • to lead • •data architecture and design • • across • •real-time streaming and enterprise batch systems • •. You will be the principal authority for data modeling...Show more

Last updated: 21 days ago • Promoted

Senior Database Reliability Engineer (DBRE)

Okta, Inc. • San Francisco, CA, United States

Full-time +1

Okta# Senior Database Reliability Engineer (DBRE)San Francisco, California • •Get to know Okta • •Okta is The World’s Identity Company. We free everyone to safely use any technology, anywhere, on any de...Show more

Last updated: 30+ days ago • Promoted

Senior / Lead Data Solution Engineer

Meltwater • Redwood City, CA, United States

Full-time

We're thrilled to embark on the search for a seasoned Senior / Lead Data Solution Engineer to join our vibrant team.This pivotal role offers an exciting opportunity to shape the future of technology ...Show more

Last updated: 30+ days ago • Promoted

Senior Analytics EngineerSoftware Engineering • Berkeley, CA; Somerville, MA; Weirton, WV • Full time

Form Energy • Berkeley, CA, United States

Full-time

Are you ready to build America's energy future? Form Energy is an American manufacturing and energy technology company.We're revolutionizing energy storage with cost-effective, multi-day technology...Show more

Last updated: 10 hours ago • Promoted • New!

Senior Data Modeler & Analytics Architect

salesforce.com, inc. • San Francisco, California, United States

Full-time

A leading cloud-based software company in San Francisco is looking for a Data Architect.This role requires mastering data modeling and architectural design for enterprise-scale solutions.Applicants...Show more

Last updated: 6 days ago • Promoted

Senior Data Architect & Modeler — Big Data & Analytics

USM • San Francisco, CA, United States

Full-time

A leading IT staffing firm located in California is seeking a Senior Data Modeler / Data Architect to lead the design and implementation of data architecture solutions. The role requires extensive exp...Show more

Last updated: 1 day ago • Promoted

Senior Database Engineer

Crunchyroll • San Francisco, CA, United States

Full-time

Join our team and help us shape the future of anime!.Founded by fans, Crunchyroll delivers the art and culture of anime to a passionate community. We serve over 100 million anime and manga fans acro...Show more

Last updated: 30+ days ago • Promoted

Delivery Architect - Sr. Data Architect

Capgemini • San Francisco, CA, United States

Full-time

Job Description - Delivery Architect - Sr.Provide insight into the changing database storage and utilization requirements for the company and offer suggestions for solutions.Analyze database implem...Show more

Last updated: 30+ days ago • Promoted

Senior AWS Data Architect - Databricks Lakehouse

Fractal • San Francisco, CA, United States

Full-time

A leading strategic AI company in San Francisco is seeking an AWS Lead Data Architect / Engineer to design scalable data platforms and automate data pipelines. The ideal candidate will have at least 8...Show more

Last updated: 21 days ago • Promoted

Senior Database Architect, Scalable Infrastructure

Menlo Ventures • San Francisco, CA, United States

Full-time

A leading AI research company in San Francisco is looking for a Staff Software Engineer to design and scale database infrastructure for their products. You will drive technical direction, develop da...Show more

Last updated: 18 hours ago • Promoted • New!