Senior Database Developer

Insight Global; Richmond (VA); On-site; USD 125,000 - 135,000; Full time

Job summary

Insight Global is seeking a Senior SQL Database Developer to support a large-scale enterprise database environment at a Virginia State Agency. This role focuses on designing, developing, and optimizing SQL Server databases, stored procedures, ETL processes, and reporting models to support complex business needs.

You will collaborate with application developers, implement indexing strategies, and drive performance improvements across hundreds of databases.

Qualifications

• 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. Exposure to Azure Data Factory, Data Lake, or Databricks.

Responsibilities

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

Skills

SQL Server

T-SQL / Stored procedures

SSIS

SSRS

SSAS / Azure Analysis Services

ETL development

Query tuning / performance analysis

Data warehousing concepts

Azure Data Factory / Data Lake / Datab

Enterprise database environments

Tools

SSIS

SSRS

SSAS

Azure Data Factory

Azure Data Lake

Databricks

Job description

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 value diversity and inclusion

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 [e-mail]. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/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.