Programmer IV

OLSA Resources, Inc.; Atlanta (GA); On-site; USD 80,000 - 100,000; Full time

Job summary

A recruiting firm is seeking a Database Developer to support the critical information needs of the organization in Atlanta, Georgia. The successful candidate will design solutions for large data volumes, creating and optimizing queries, stored procedures, and ETL processes. Strong knowledge of T-SQL and SQL Server is essential, along with excellent communication skills. This position offers a significant opportunity to contribute to analytics and performance optimization within the Business Intelligence group.

Qualifications

• Knowledge of T-SQL language & SQL Server database engine.
• Experience performance tuning T-SQL queries, indexes, disk I/O, memory, and CPU.
• Strong communication skills are a must.

Responsibilities

• Create complex analytic queries on large data sets.
• Create stored procedures, triggers, and functions.
• Analyze trends in key metrics.
• Design and build ETL processes from production to data warehouse.
• Identify performance bottlenecks and optimize key queries.
• Maintain uptime demands on the BI system.

Skills

T-SQL language

SQL Server database engine

Performance tuning

Strong communication skills

Tools

.NET

Tableau

SSRS

SSIS

Job description

Overview

Working in the Business Intelligence group, the Database Developer will service the critical information and infrastructure needs across the organization. In this highly visible position, you will have the opportunity to design a solution handling the large data volumes and assist in analytics, as well as building and tuning queries, SSIS packages and SQL jobs.

Responsibilities

• Create complex analytic queries on large data sets
• Create stored procedures, triggers, and functions
• Analyze trends in key metrics
• Design and build processes that extract, transform and load data from production data sources to the data warehouse
• Identify performance bottlenecks and optimize key queries
• Maintain uptime demands on the BI system

Qualifications

• Knowledge of T-SQL language & SQL Server database engine
• Experience performance tuning T-SQL queries, indexes, disk I/O, memory and CPU
• Strong communication skills a must

Desirable Skills

• Knowledge of .NET
• Experience using Tableau software
• Experience with using SSRS and SSIS