Required Skills & Expertise
Core Technical Skills
-
Strong experience with Microsoft SQL Server (2016/2019/2022)
-
Expertise in:
-
SQL Server Agent Jobs
-
Stored Procedures, Indexing, Query Optimization
-
Hands-on experience with ETL processes (SSIS or similar tools)
-
Experience with transactional replication
Monitoring & Performance Tools
-
Experience with tools like:
-
Foglight (preferred)
-
Azure Monitor / SQL Monitoring tools
-
Ability to analyze performance metrics and logs
Database Concepts
-
Strong understanding of:
-
Data warehousing concepts (fact/dimension tables)
-
Indexing and partitioning
-
Data modeling basics
Nice to Have
-
Exposure to insurance domain systems (e.g., AMS360)
-
Experience with Azure SQL / cloud environments
-
Knowledge of CDC, data migration, and conversion projects
-
Familiarity with BI/reporting systems
Soft Skills
-
Strong analytical and problem-solving abilities
-
High attention to detail (especially for data validation)
-
Ability to work in a high-availability production environment
-
Good communication skills for cross-team coordination and managing US stakeholders
What Success Looks Like
-
Zero missed ETL failures or unnoticed job issues
-
High data accuracy and consistency across systems
-
Minimal downtime and optimized database performance
-
Proactive identification and resolution of issues
Ideal Candidate Profile
A strong mid-level DBA who:
-
Is hands-on (not just support/ticket-based)
-
Has experience with data pipelines + application DBs
-
Can own production stability independently
-
Is comfortable working in complex, multi-database ecosystems
