Cognizant
SQL DBA+ Facets - (Job Number: 00056008361)
PayCompetitive
LocationPune/Maharashtra
Employment typeFull-Time
This job is now closed
Job Description
- Req#: 2114709
- Participate in presales interactions with customers when showcasing solution etc.
- Participate in solution response teams to ensure technical feasibility.
- Provide support to the Product Consultant by creating case studies, solution etc under guidance, when required.
- Provide support to the product consultant, through analyzing customer requirements and provide recommendations through interactions with the customer.
- Coordinate with onsite team / clients for requirements gathering / functional clarifications.
- Identify valueadds (eg enhance existing features) which can address repeated issues during implementation.
- Create estimates for project planning.
- Participate in deployment activities like reviewing all deliverables as per the delivery checklist and mock testing all deliverables.
- Participate in periodic internal review meetings.
- Prepare status reports and share the same with the Product Consultant for review.
- Create impact analysis for change requests/ maintenance issues in own area of work and seek review from Product Consultant.
- Interface with quality reviewers and auditors for the projects.
- Submit necessary artifacts, data etc as requested by the DAG.
- Monitor design, development and testing to ensure alignment with requirements traceability matrix.
- Create high level design.
- Guide the product specialist in translating the high level design into detailed design.
- Review to ensure that the design is comprehensive and addresses all requirements.
- Code for complex components.
- Review code created by the developers based on requirements.
- Participate in peer design reviews.
- Drive the review meetings with the customers on the design with support from the Product Specialist.
- Conduct root cause analysis of defects / process issues.
- Identify/design reusable components and solution enablers.
- Create product based KT document, for the customer.
- Create unit test cases and perform unit testing including complex components.
- Review unit test cases as created by Product Specialist and Product Analyst.
- Assist the testing team by reviewing test strategy document, when required.
- Provide UAT and implementation support.
- Drive clarifications / defect resolution to ensure timely deployment.
- Contribute ideas / areas requiring improvements based on project implementation, team feedback etc.
- Identify best practices related to the project/product & document the same.
- Prepare guidelines and checklists for the team.
- Create and deliver training on products/modules.
- Mentor team from a technical/functional perspective to ensure delivery of the module.
- Contribute towards updating knowledge assets.
- Conduct knowledge transfer sessions for new joiners in the project team.
- Resolve conflicts within team members.
- Support team building activities.
- Provide administrative support.
- Provide inputs on goal setting and performance appraisal of team.
- Identify skill gaps and training needs required.
- Provide input into the learning and career plans for team members.
- Mentor team.
- Nominate team for awards.
- Conduct training through academy and induction of new team members.
- .Net Core
- Azure
- Microsoft SSIS
- ANSI SQL
- PL/SQL
- Facets SQL+DBA
- Monitor Databases for issues using tools such as RedGate
Identify long running processes and locks and resolve
Assist engineers in fine-tuning SQL code / building indexes
Understanding of SQL architecture, including availability groups
Backup and Restore databases
Maintain / create powershell scripts to automate various DBA tasks
Reset passwords, create user IDs, define security model
Handle incident tickets and change tickets for code deployments
Strong ability to multitask and work with minimal guidance.
!*!Product Consultant
Qualification:
Science / Engineering graduateResponsibility:
Pre-sales:
Product Consulting:
Project Management:
Design and Implementation:
Testing:
Innovation:
Capability Building:
Knowledge Management:
People Management:
Must Have Skills
Good To Have Skills
Technical Skills
SNo Primary Skill Proficiency Level * Rqrd./Dsrd. 1 .Net Core PL3 Required 2 Azure PL3 Required 3 Microsoft SSIS PL3 Required 4 ANSI SQL PL2 Required 5 PL/SQL PL3 Required 6 Facets PL3 Desired * 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. About the company
Cognizant is a multinational technology company that provides business consulting, information technology and outsourcing services.