Sql Developer

V-Soft Consulting Inc.

Nicholasville, KY, United States

11 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Microsoft Excel Agile Methodology Databases Crystal Reports (Reporting Software) Data Architecture Extract Transform Load (ETL) Data Mart Data Vault Modeling Data Warehousing Database Development Software Debugging Team Foundation Server

+23 more

Online Analytical Processing Online Transaction Processing Performance Tuning Pivot Tables Powerpivot Power BI Standard Sql SQL Stored Procedures SQL Databases SQL Server Reporting Services SQL Server Integration Services SQL Server Analysis Services Tableau (Software) Transact-SQL Virtual Studio Database Performance Sap Business Objects Git Powerquery Star Schema Tools for Reporting Network Server Software Version Control

Job description

Database Administration:

Optimize database performance by improving queries, defragging indexes, shrinking databases, and offloading legacy data at scale.
Manage the SQL Enterprise environment, nodes, clusters, servers, availability groups and databases with a goal of high performance, efficiency, and redundancy.

Development:

Translate business needs into long-term data architecture solutions
Evaluate reusability of current data for separate analysis
Provides analysis, design and development of SQL code. Debugs and resolves data errors.

General:

Participate in team meetings for alignment, strategy, architecture, and direction purposes.
Utilization of ai tools like Claude for optimization and efficiency
Other Duties as assigned.

Requirements

7+ years’’ combined experience in SQL development and database administration, or equivalent experience in a similar hybrid role
7+ years’’ experience coding in T-SQL including queries, stored procedures and functions

Knowledge, Skills and Abilities »

Practical experience with SQL Standard and SQL Enterprise along with Availability Groups in a complex environment
Experience creating data models for OLTP or OLAP (star schema preferred)
Experience with a data warehouse, data vault, data marts or SQL Server Analysis Services (SSAS) tabular model
Experience with Power BI
Experience with ETL using SQL Server Integration Services (SSIS)
Experience analyzing, maintaining, testing, troubleshooting and performance tuning existing code
Ability to identify and define relationships between objects
Some experience with a fixed-format reporting tool such as SQL Server Reporting Services (SSRS), Tableau or Crystal Reports/Business Objects
Advanced Excel skills using pivot tables, Power Pivot and Power Query
Experience with software version control using TFS/VSTS or Git
Experience with Agile software development

About the company

V-Soft Consulting is currently hiring for a Sr Level SQL Developer and DBA Candidates Must be 3-4 hours from Nicholasville, KY for our premier client in Nicholasville, KY., V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America, V-Soft Consulting Group is headquartered in Louisville, KY with strategic locations in India, Canada and the U.S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks.

As a valued V-Soft Consultant, you’re eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more. V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth.