This is Ashish form Resource Logistics, We have a Job Opening for a "SQL Server Database Administrator (Contract) "Onsite at San Francisco/ San Ramon, CA"
Please find the details below:
If you are interested, please reply with mentioned your Updated CV with LinkedIn URL, Contact Details and Current Location with ZIP Code.
Job Title: SQL Server Database Administrator (DBA)
Solid background in data modeling & architecture
Location: Onsite - San Francisco/ San Ramon, CA, Client Location
Years of Experience: 14.00 Years of Experience
SKILL MATRIX:
Skill
Years of Exp.
Last Used
Developing Diagrams
SQL Server
Data Modeling
What are the top 3 skills required for this role?
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
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