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