SQL Server Database Administrator; DBA

Job Description

SQL Server Database Administrator (DBA) with a solid background in data modeling & architecture.

• 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

• 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 and 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

• 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 Power Shell 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

• 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

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.