SQL Database Administrator

SQL Server DBA with a solid background in data modeling & architecture 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.) 1. Data modeling experience, including enterprise-scale model design and implementation 1. 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 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