Position Overview
We are seeking an experienced SQL Server Database Administrator (DBA) with a solid background in data modeling & architecture. The ideal candidate will be responsible for the administration, optimization, and security of SQL Server environments, while also designing and documenting data models, data flows, and architecture diagrams to support business and analytics needs.\
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
Never miss an opportunity! Create an alert based on the job you applied for.
