Sr. DBA

Job Title: Sr. DBA

Location: San Ramon or SFO - 4 days a week onsite

Length: 6-10 months

We are seeking an experienced SQL Server Database Administrator (DBA) with a solid background in data modeling & architecture. The ideal candidate will be responsible for the administration, optimization, and security of SQL Server environments, while also designing and documenting data models, data flows, and architecture diagrams to support business and analytics needs.\

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 implementation

Experience in creating data flows and architecture diagrams

Proficiency in SQL, Python, and PowerShell scripting for automation and data management

Experience with data modeling tools (ERWIN or similar) and advanced modeling techniques

Strong communication skills and ability to work independently and collaboratively

Preferred

Experience with Snowflake platform administration and optimization

Experience with managed SQL instances and SQL Server on Azure

Background in asset management or similar industries

Familiarity with data governance frameworks

--