Data Warehouse Analyst/SQL server DBA

JN & GJ SAI TECHNOLOGIES LLC

Tallahassee, FL, United States

2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience required

1 year minimum

Compensation

$124,800.0 - $135,200.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Health Informatics Databases Data Transmissions Data Deduplication Data Infrastructure Data Integration Extract Transform Load (ETL) Data Mining Data Warehousing Relational Databases Database Security Decision Support Systems

+16 more

Disaster Recovery Microsoft SQL Server Online Analytical Processing Online Transaction Processing Performance Tuning Release Management Shell Script SQL Stored Procedures SQL Databases SQL Server Reporting Services SQL Server Integration Services SQL Server Analysis Services Scripting Build Management Data Management Tools for Reporting

Job description

Data Warehouse Analyst - services to develop, test, and maintain databases and data transfer packages.

Requirements

Do you have experience in System tuning?, * A minimum of five years in data modelling, data mining, database standardization, deduplication and performance tuning.

A minimum of five years developing Online Analytical Processing (OLAP) cubes using SQl Server Analysis Services.
A minimum of five years developing SQL Server Integration Services packages performing Extraction, Transformation and Loading activities.
A minimum of five years with dashboard and scorecard development.
A minimum of five years with the development of reports using MS SQL Server Reporting Services (MS SSRS) and maintenance of enterprise reports using MS SSRS.
A minimum of five years with business intelligence tools and systems, such as SSRS.
A minimum of five years with MS SQL product inclusive of MS SQL 2016,2019, 2022.
A minimum of five years with SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and linked servers.
A minimum of five years with SQL relational databases, Online Transaction Processing (OLTP) and Decision Support System (DSS) serving in high performance, service-oriented, multi-tiered environments.
A minimum of three years with software build and release management methodologies.A minimum of two years in a healthcare IT domain.
A minimum of one year with Prenatal Risk Screening datasets.
Skilled in performance tuning techniques for SQL queries and database systems to maximize efficiency.
Familiarity with ETL tools like SSIS for data integration workflows.
Ability to develop scripting solutions using Shell Scripting or other scripting languages for automation tasks.
Experience with database security best practices, backup strategies, and disaster recovery planning.
Excellent problem-solving skills with a detail-oriented approach to managing complex data environments. Join us in shaping the future of data management! We’re committed to fostering an energetic environment where your skills will directly impact organizational success while providing opportunities for growth in the evolving world of databases and data warehousing.