Exarca Inc. · 2 hours ago
SQL Server DBA :: 4 days onsite in Wilmington, DE 19898
Responsibilities
SQL Server development and administration, including installation, configuration, tuning, and maintenance
Advanced T‑SQL (Stored Procedures, functions, triggers, complex queries, performance tuning)
ETL development using Microsoft Visual Studio (SSIS or similar)
Strong schema design, database architecture, indexing, partitions, and constraints
Experience with SQL Server security frameworks (roles, permissions, least‑privilege access)
Proven ability to ingest data from databases, APIs, and file formats (CSV, Excel, JSON, XML, SFTP)
Experience delivering data to downstream systems via integrations or flat‑file exports
Solid dimensional modelling (facts, dimensions, star/snowflake schemas)
Troubleshooting SQL Server, ETL pipelines, performance issues, and integration failures
Experience supporting enterprise data warehouses/reporting environments
Knowledge of Cognos or Power BI; IQMS experience is a plus
Strong analytical, communication, and documentation skills
Qualification
Required
8+ years of SQL Server development and administration, including installation, configuration, tuning, and maintenance
Advanced T‑SQL (Stored Procedures, functions, triggers, complex queries, performance tuning)
ETL development using Microsoft Visual Studio (SSIS or similar)
Strong schema design, database architecture, indexing, partitions, and constraints
Experience with SQL Server security frameworks (roles, permissions, least‑privilege access)
Proven ability to ingest data from databases, APIs, and file formats (CSV, Excel, JSON, XML, SFTP)
Experience delivering data to downstream systems via integrations or flat‑file exports
Solid dimensional modelling (facts, dimensions, star/snowflake schemas)
Troubleshooting SQL Server, ETL pipelines, performance issues, and integration failures
Experience supporting enterprise data warehouses/reporting environments
Knowledge of Cognos or Power BI; IQMS experience is a plus
Strong analytical, communication, and documentation skills