SQL Database Administrator

Role: SQL Server Database Administrator (DBA) with a solid background in Mata Modelling & Architecture Location: San Francisco, CA | San Ramon, CA – Onsite Type: Contract About Smart IT Frame: At Smart IT Frame, we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together. Required Skills: • Hands-on experience administering SQL Server databases across multiple versions (2012, 2014, 2019, etc.) • Data modeling experience, including enterprise-scale model design and implementation • Creating data flows and architecture diagrams 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 modelling 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 Skills: • 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 Apply today or share profiles at venkatesh@smartitframe.com