Database Engineer

SATYA SOFT SOLUTIONS; Kansas City (MO); On-site; USD 90,000 - 120,000; Full time

Job summary

SATYA SOFT SOLUTIONS is seeking a skilled ETL/BI professional to manage data integration and reporting across healthcare domains. The role requires strong SQL Server, SSIS/SSAS expertise and experience building cubes with Tabular/Multidimensional models.

You will work onsite in Kansas City, collaborating with clients to deliver reliable data solutions, dashboards, and reports while ensuring data quality and performance.

Qualifications

• Bachelor’s degree in computer science or its equivalent.
• Excellent organizational skills.
• Persuasive and resilient.
• Gained knowledge on EMR/EHR systems is an added advantage.
• Effective communication skills.
• Exceptional customer service skills.
• Domain knowledge in healthcare and health information systems is preferred.

Responsibilities

• Expertise in MongoDB, SQL Server, Oracle, SSIS, SSAS, Powerpivot, DQS and T-SQL.
• Experience in query optimization, tracing and SQL Server DBA activities.
• Expertise knowledge in designing, developing and deploying ETL solutions using SSIS.
• Experience on Tabular Model and Multidimensional Model for building cubes.
• Working with DQS for de-duplication, validation, data standardization and data cleansing.
• Experience on creating reports involving SSRS, Powerview, Powerpivot, PPS, Excel and Business Objects, T-SQL, MDX and DAX.
• Good at SSIS package performance improvement using profiler, Execution plan and Performance monitor.
• Good at writing stored procedures, triggers, functions, SQL Reports with T-SQL, SQL jobs, linked servers, replication, partitioning, back-up and recovery activities.
• Experience of working with client at onsite environment.
• Managing client and enterprise information and reporting deliverables.
• Hands-on new development as well as support, maintenance, or enhancement of the existing production processes.
• Researches and evaluates alternative solutions and makes recommendations, designs, develops and tests the solution in Databases and MSBI.
• Design and development of Zero Downtime Architecture to achieve operational stability.
• Performance Tuning/improvement for Pl/sql , Forms , Reports, Packages and Sub-programs by code /Query Tuning
• Code reviews and Looking after Enhancements and Testing(Unit,Functional) the Test cases.
• Any experience of working in human health oriented organization.
• Domain specific knowledge related to Healthcare and human health management and translating it into information technology perspective.
• Excellence in improving operations and coordination by introducing better processes, building relationships and other technics.

Skills

Excellent organizational skills

Persuasive and resilient

Effective communication skills

Exceptional customer service skills

Gained knowledge on EMR/EHR systems

Education

Bachelor’s degree in computer science or its equivalent

Tools

MongoDB

SQL Server

Oracle

SSIS

SSAS

Powerpivot

DQS

T-SQL

Job description

Requirements

• Bachelor’s degree in computer science or its equivalent.


• Excellent organizational skills.


• Persuasive and resilient.


• Gained knowledge on EMR/EHR systems is an added advantage.

Requirements

• Bachelor’s degree in computer science or its equivalent.


• Excellent organizational skills.


• Effective communication skills.


• Exceptional customer service skills.


• Persuasive and resilient.


• Gained knowledge on EMR/EHR systems is an added advantage.

Responsibilities

• Expertise skills in MongoDB, SQL Server, Oracle, SSIS, SSAS, Powerpivot, DQS and T-SQL.


• Experience in query optimization, tracing and SQL Server DBA activities.


• Expertise knowledge in designing, developing and deploying ETL solutions using SSIS.


• Experience on Tabular Model and Multidimensional Model for building cubes.


• Working with DQS for de-duplication, validation, data standardization and data cleansing.


• Experience on creating reports involving SSRS, Powerview, Powerpivot, PPS, Excel and Business Objects, T-SQL, MDX and DAX.


• Good at SSIS package performance improvement using profiler, Execution plan and Performance monitor.


• Good at writing stored procedures, triggers, functions, SQL Reports with T-SQL, SQL jobs, linked servers, replication, partitioning, back-up and recovery activities.


• Experience of working with client at onsite environment.


• Managing client and enterprise information and reporting deliverables.


• Hands-on new development as well as support, maintenance, or enhancement of the existing production processes.


• Researches and evaluates alternative solutions and makes recommendations, designs, develops and tests the solution in Databases and MSBI.


• Design and development of Zero Downtime Architecture to achieve operational stability.


• Performance Tuning/improvement for Pl/sql , Forms , Reports, Packages and Sub-programs by code /Query Tuning


• Code reviews and Looking after Enhancements and Testing(Unit,Functional) the Test cases.


• Any experience of working in human health oriented organization.


• Domain specific knowledge related to Healthcare and human health management and translating it into information technology perspective.


• Excellence in improving operations and coordination by introducing better processes, building relationships and other technics.