Location: Omaha NE or Brookfield WI ( Day 1 Onsite )
Duration: 6+ months
Implementation Partner: Donyati
End Client: To be disclosed
Jd
Design logical database models and provide technical guidance during each phase of the development process
Provide performance tuning and optimization of existing SQL code
Deliver technical support for the database environment and database objects such as stored procedures, functions, triggers, tables, and views
Production support.
Work with developers, business analysts, other team members and clients to review the business requirements and translate them into database objects
Create, maintain, and publish data models, data dictionaries and entity relationship diagrams using industry standard tools and technologies
Qualifications
Minimum five years of recent and progressive experience developing, unit testing and troubleshooting SQL Server 2019 and above including SSRS, SSIS and SSAS
Minimum five years of recent experience in overall SQL Server performance tuning and optimization related field or equivalent industry experience; minimum five years of recent experience in logical and physical database modeling, as well as designing database schema, stored procedures, triggers, and other database related objects
Advanced knowledge of T-SQL/Stored Procedure/Function programming and design
Advanced knowledge of SSIS, SSRS package development.
Experience with Python
Experience in PowerBI, including dataflow and data model design, measures, DAX, calculated tables and columns, row-level security, and advanced visualizations
Bachelor's degree in Computer Science from an accredited college/university is preferred
Knowledge of .Net will be an added advantage.