SQL Server Database Administrator (DBA) with a solid background in data modeling & architecture

Job Role :   SQL Server Database Administrator (DBA) with a solid background in data modeling & architecture

Location :   San Francisco/ San Ramon, CA (Onsite)

Mode of interview : Video Interview

Years of experience: 10+ years

Job Roles/Responsibilities:

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

Job Description/ Responsibilities SQL Server Database Administrator (DBA) with a solid background in data modeling & architecture

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

Faizan Shaikh

(678) 535-7175