Cognizant

SQL DBA+ Facets - (Job Number: 00056008361)


PayCompetitive
LocationPune/Maharashtra
Employment typeFull-Time

This job is now closed

  • Job Description

      Req#: 2114709
      !*!

      Product Consultant

      Qualification:

      Science / Engineering graduate

      Responsibility:

      Pre-sales:

      • 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.

      Product Consulting:

      • 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.

      Project Management:

      • 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.

      Design and Implementation:

      • 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.

      Testing:

      • 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.

      Innovation:

      • Contribute ideas / areas requiring improvements based on project implementation, team feedback etc.
      • Identify best practices related to the project/product & document the same.

      Capability Building:

      • 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.

      Knowledge Management:

      • Contribute towards updating knowledge assets.
      • Conduct knowledge transfer sessions for new joiners in the project team.

      People Management:

      • 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.

      Must Have Skills

      • .Net Core
      • Azure
      • Microsoft SSIS
      • ANSI SQL
      • PL/SQL

      Good To Have Skills

      • 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.
      !*!

      Technical Skills

      SNoPrimary SkillProficiency Level *Rqrd./Dsrd.
      1.Net CorePL3Required
      2AzurePL3Required
      3Microsoft SSISPL3Required
      4ANSI SQLPL2Required
      5PL/SQLPL3Required
      6FacetsPL3Desired


      * Proficiency Legends

      Proficiency LevelGeneric Reference
      PL1The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.
      PL2The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.
      PL3The 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.
      PL4The 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.