• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 6th Jul 2021

 The Software Technology Solutions department is responsible for developing and maintaining hosted software solutions that provide integration, reporting, and analytics capabilities for the company’s portfolio of products. In addition, using industry best practices, the department is responsible for delivering high-quality, robust software applications that meet present and future requirements.

Database developer
The database developer is responsible for designing and developing database objects and procedural code to support various products for the organization. The database developer also creates programs to populate and maintain the data in the department’s transaction processing and data warehousing systems. This involves creating ETL programs and supporting stored procedures, functions, triggers, and constraints. The position requires extensive hands-on experience developing database queries, ETL, and associated code in a Microsoft SQL Server environment.

III. Specific Duties, Activities, and Responsibilities
1. Understand and apply database design and development principles for transactional and dimensional schemas to support application requirements.
2. Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems.
3. Maintain source code for database and ETL projects. Ensure that projects build successfully in a continuous integration environment.
4. Diagnose and resolve database performance issues.
5. Follow and improve development processes, including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standards best practices.

7. Design a process to archive the databases to Azure cloud using Azure Data Factory and similar tools

 IV. Position Requirements

Education or Equivalent

BS in Computer Science or Information Systems
Experience or Equivalent

9+ years of experience working with Microsoft SQL Server with emphasis on database code development.

 V. Knowledge, Skills, and Abilities Requirements

Data modeling tools such as ER/Studio

Hands-on experience with Cloud Database, Azure Data Factory

Database design skills, including normalization and data warehouse design
T-SQL development skills, including stored procedure, function, and trigger creation
Excellent query optimization and performance tuning skills
Strong SSIS skills
Detailed analytical skills
Structured troubleshooting skills

Azure Cloud Technologies

Experience TFS and GIT source control
Experience in the healthcare industry is a plus

VI. Toolset
Microsoft SQL Server 2014 and above
Microsoft SQL Server Integration Services (SSIS)
Microsoft Visual Studio 2014 and above
Microsoft SQL Server 2014 to 2019 migration experience is a plus
Embarcadero ER/Studio is a plus
Microsoft SQL Server Reporting Services (SSRS) is a plus
Experience with automatic code deployment tools (Octopus) is a plus

VII. Physical/Mental Requirements
Ability to communicate clearly both verbally and in writing.
Ability to analyze complex application and business operational issues.

VIII. Any Additional/Important Information
The database developer will additionally be responsible for the following tasks:
Analyzing requirements to create software designs
Estimation and timely completion of tasks
Documenting developed modules
Supporting application developers and software testers
Creating and executing unit tests for developed code