Need California based candidates only
SQL Server DBA with a solid background in data modeling
Onsite - San Francisco / San Ramon, CA
Experience : 12+ years
What are the top 3 skills required for this role?
1. Hands-on experience administering SQL Server databases across multiple versions (2012, 2014, 2019, etc.)
2. Data modeling experience, including enterprise-scale model design and implementation
3. Creating data flows and architecture diagrams
Key Responsibilities
- Administer, configure, and maintain SQL Server databases (including Always On, backups, indexing, integrity checks, and security audits)
- Design and build conceptual, logical, and physical data models to support business requirements and analytics use cases
- Develop and maintain enterprise data architecture, including data integration, data movement, and data storage strategies
- Define and enforce data architecture standards, best practices
- Create and document data flows and architecture diagrams using industry-standard tools (e.g., Visio, Lucidchart, ERWIN)
- Reverse-engineer schemas, perform data profiling, and evaluate models for discrepancies and optimization opportunities
- Implement and enforce modeling standards (normalization, star schema, data vault, 3NF) using tools such as ERWIN or similar
- Monitor system health, automate detection of anomalous database activity, and ensure compliance with enterprise policies
- Collaborate with engineering, analytics, and business teams to deliver robust data solutions
Required Qualifications
12+ years of hands-on experience administering SQL Server databases across multiple versions (2012, 2014, 2019, etc.)3+ years of data modeling experience, including enterprise-scale model design and implementationExperience in creating data flows and architecture diagramsProficiency in SQL, Python, and PowerShell scripting for automation and data managementExperience with data modeling tools (ERWIN or similar) and advanced modeling techniquesStrong communication skills and ability to work independently and collaboratively