Senior Database Developer

Job Description

Insight Global is seeking a Senior SQL Database Developer to support a large-scale enterprise database environment at a Virginia State Agency. This role will focus on developing and optimizing database solutions, collaborating with application developers, and improving performance across complex SQL Server environments. The pay rate for this role is between $60-$65 an hour depending on the candidates years of experience.

Day to Day:

Design, develop, and maintain SQL Server databases, stored procedures, functions, triggers, tables, and views.

Create and enhance SSIS packages, ETL processes, and data integration solutions.

Develop and maintain SSRS reports and reporting models with dynamic user-driven filtering and parameters.

Support SSAS/Azure Analysis Services cubes, dimensions, and data models.

Analyze database structures and query performance to identify optimization opportunities.

Design and implement indexing strategies and performance tuning solutions.

Partner with development teams to support application and reporting requirements.

Work within a large enterprise-scale database environment containing hundreds of databases and thousands of tables.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to View email address on click.appcast.io learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and Requirements

6+ years of SQL Server database development experience.

6+ years developing and maintaining complex stored procedures, functions, triggers, tables, and views.

6+ years working with SSIS, including advanced ETL development and custom scripting.

6+ years creating complex SQL queries and performance optimization solutions.

6+ years building and maintaining SSRS reports and reporting models.

6+ years working with SSAS or Azure Analysis Services.

5+ years supporting large data warehouse environments and enterprise database architectures.

Strong understanding of indexing, query tuning, execution plans, and database performance analysis.

Experience with data warehouse concepts including star schema, snowflake schema, data marts, and data lakes. Experience with database performance monitoring and optimization tools.

Exposure to Azure Data Factory, Azure Data Lake, or Databricks.