Senior Sql Database Administrator

This is not a Remote Position. You will be required to be in the Office Mon-Thur every week, in either San Francisco or San Ramon Office. Friday work may be Mostly work from Home, as long as the situation Allows.

We are seeking an Experienced SQL Server DBA with a Solid Background in Data Modelling & 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 Need.

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 and 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 and Similar Industries

· Familiarity with Data Governance Frameworks