ZipRecruiter

Log In

1

Live In Data Modeling Jobs in California (NOW HIRING)

ShoreWise Consulting

Data Modeler

Ontario, CA · On-site

$55.75 - $72.25/hr

In depth experience with SAP Power Designer * Advanced knowledge of data modeling techniques with an understanding of data gathering, inspection, cleansing, and transformation. * Advanced skill in ...

Perficientcorp Inc

Data Engineer

Santa Clara, CA · On-site

$134K - $161K/yr

Deep expertise in data modeling techniques, including dimensional modeling, star schema, and snowflake schema. Ability to optimize compute and storage costs across Snowflake and Databricks platforms.

ShoreWise Consulting

Data Modeler

Ontario, CA

$55.75 - $72.25/hr

In depth experience with SAP Power Designer * Advanced knowledge of data modeling techniques with an understanding of data gathering, inspection, cleansing, and transformation. * Advanced skill in ...

ShoreWise Consulting

Data Modeler

Ontario, CA · On-site

$55.75 - $72.25/hr

In depth experience with SAP Power Designer * Advanced knowledge of data modeling techniques with an understanding of data gathering, inspection, cleansing, and transformation. * Advanced skill in ...

Perficientcorp Inc

Sr. AWS Data Engineer

San Francisco, CA · On-site

$134K - $162K/yr

The ideal candidate will lead data engineering initiatives, design robust data pipelines, perform code reviews, and ensure best practices in data modeling and governance. Key Responsibilities Lead ...

Paradigminfotech

Data Architect

Sacramento, CA

$68 - $87.50/hr

Paradigm has been one of the trendsetters in global delivery practices with our Client-Centric Model for customer management and delivery. JOB DETAILS: Position: Data Architect Location: Sacramento ...

Experian

Senior Data Modeling Analyst - Remote

Costa Mesa, CA · On-site +1

$92K - $116K/yr

Experian invests in people and new advanced technologies to unlock the power of data. We have an ... Build statistical and machine learning models through all phases of development, from design ...

Zoom

Senior Data Analyst

San Jose, CA

$187K - $228K/yr

Utilizing DBT in data modeling and transformation; * Utilizing Elementary to create data quality checks; * Utilizing Python (Pandas) in data analysis; * Utilizing Tableau to build enterprise BI ...

Experian

Senior Data Modeling Analyst - Remote

Costa Mesa, CA · On-site +1

$92K - $116K/yr

Experian invests in people and new advanced technologies to unlock the power of data. We have an ... Build statistical and machine learning models through all phases of development, from design ...

next page

Showing results 1-20

All JobsLive In Data Modeling JobsLive In Data Modeling Jobs in California

Live In Data Modeling information

What is the difference between Live In Data Modeling vs Data Analyst?

AspectLive In Data ModelingData Analyst
Required CredentialsBachelor's in Data Science, Computer Science, or related field; certifications like CDMPBachelor's in Statistics, Data Science, or related; certifications like CAP or Microsoft Data Analyst
Work EnvironmentCollaborative, often on-site, working closely with data teams and stakeholdersOffice or remote, analyzing data sets, creating reports, and visualizations
Industry UsageUsed in industries requiring detailed data modeling for live systems, such as finance or techCommon across various industries for interpreting data and supporting decision-making
Search & Comparison IntentPeople comparing roles involving live data modeling tasks with data analysis

Live In Data Modeling focuses on designing and maintaining data structures for live systems, requiring technical modeling skills. Data Analysts interpret data through reports and visualizations. While related, Live In Data Modeling emphasizes data architecture, whereas Data Analysts focus on data interpretation and insights.

What are the most commonly searched types of Data Modeling jobs in California? The most popular types of Data Modeling jobs in California are:
What cities in California are hiring for Live In Data Modeling jobs? Cities in California with the most Live In Data Modeling job openings:
Live In Data Modeling jobs near you

Senior SQL Server DBA - Data Modeling & Architecture

Purple Drive

San Francisco, CA • On-site

Other

Posted 11 days ago

Key responsibilities

  • Design conceptual, logical, and physical data models and develop scalable OLTP/OLAP database architectures.

  • Install, configure, upgrade, and maintain SQL Server environments and administer high-availability solutions.

  • Analyze and tune SQL queries, indexing strategies, and execution plans to optimize database performance.

Job description

Overview:
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.

Apply