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
[job_card.variable_days_ago]
[job_preview.job_type]
- [job_card.full_time]
[job_card.job_description]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. 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. Implement RBAC, TDE, Always Encrypted, auditing, and data masking. Maintain compliance with organizational and regulatory security standards. Ensure database hardening and controlled deployments. 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. 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. 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. 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.
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
3. Performance Tuning & Optimization
4. Security & Compliance
5. Automation & DevOps
6. Collaboration & Documentation
Required Skills & Qualifications
Preferred Qualifications
[job_alerts.create_a_job]
Sql Dba • San Francisco, CA, United States
[internal_linking.similar_jobs]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
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]
A renowned cloud services provider is seeking a Senior Data Analytics and GenAI consulting specialist to lead projects that leverage AWS technologies.
This role requires extensive experience in data...[show_more]
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]
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]
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]
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]
Senior SAP ASE DBA
VirtualVocations • Oakland, California, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Data Modeler & Analytics Architect (Snowflake)
Salesforce, Inc. • San Francisco, California, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Manager, REMS Data Programmer
Jazz Pharmaceuticals • Redwood City, California, USA
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Senior Director, Data and AI Architecture Leader
Dynavax Technologies • Emeryville, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Senior SQL Server Architect & Data Modeling Lead
Purple Drive Technologies LLC • San Francisco, CA, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Software Engineer, Billing Platform
Scale AI, Inc. • San Francisco, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Lead Database Reliability Engineer
Qualys • Foster City, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Database Architect $110,089 – $165,134
ISC2 East Bay Chapter • San Carlos, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Senior Data Architect
Autodesk, Inc. • San Francisco, CA, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior / Lead Data Solution Engineer
Meltwater • Redwood City, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Senior Analytics EngineerSoftware Engineering • Berkeley, CA; Somerville, MA; Weirton, WV • Full time
Form Energy • Berkeley, CA, United States
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Senior Data Modeler & Analytics Architect
salesforce.com, inc. • San Francisco, California, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Data Architect & Modeler — Big Data & Analytics
USM • San Francisco, CA, United States
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Senior Data Analytics & GenAI Cloud Architect
Amazon • San Francisco, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Senior Database Engineer
Crunchyroll • San Francisco, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Delivery Architect - Sr. Data Architect
Capgemini • San Francisco, CA, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Senior AWS Data Architect - Databricks Lakehouse
Fractal • San Francisco, CA, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Database Architect, Scalable Infrastructure
Menlo Ventures • San Francisco, CA, United States
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]