This job listing has expired and the position may no longer be open for hire.

Database Engr Lead at Cognizant

Posted in Information Technology 30+ days ago.

This job brought to you by eQuest

Type: Full-Time
Location: Chicago, Illinois

Job Description:

Database Engineer Senior


Analyzing, designing, programming and testing TriZetto software programs and applications. Working closely with Product Design, Business Analysis, Systems Analysis, Quality Assurance and Customer Support to assess, enhance, maintain and support software solutions to business problems. Using strong logic, computer language skills, combined with healthcare industry and practical knowledge, deliver and maintain applications and software providing comprehensive business solutions to the healthcare industry.


• SQL skills including object creation and query tuning.

o Be able to tune queries to alter the query plan

o Understand indexing and partitioning

• Basic understanding of OLTP and OLAP database structures.

• Basic understanding of ETL development including both Powershell and SSIS to move and transform data

o Development work to load Warehouse

• Basic understanding of role based permissions.

• Basic understanding of DBA type tasks like backing up, restoring, and creating databases.

o Used to maintain Dev/functional server for application teams

• SQL job Agent

o Support production jobs for SSIS, Powershell, and TSQL

Application level experience:

• Visual Studio and Team Foundation Server for source control/deployment

o Use source control to deploy SQL to different environments.

• SSMS for interaction with the SQL servers.

• Powershell

o Used often for data movement


o Basic understanding.  No new dev is being done in SSIS currently


Education:  Bachelor's degree in Computer Science or a related discipline. Master's degree preferred. An equivalent combination of education and work experience may be taken into consideration in lieu of a degree.

Experience:  Minimum of five years' related experience. Healthcare industry experience is preferred.



Technical Skills

SNo Primary Skill Proficiency Level * Rqrd./Dsrd.
1 Kronos SSRS Reports PL1 Required
2 SQL PL1 Required
3 MS Power BI PL1 Required
4 SQL Developer PL1 Required
5 PowerShell PL1 Required
6 Microsoft SSIS PL1 Required
7 MS SQL Server PL1 Required

* Proficiency Legends

Proficiency Level Generic Reference
PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.
PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.
PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects.
PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.