logo

JobNob

Your Career. Our Passion.

Lead Engineer - IT


Guardian Life


Location

Chennai | India


Job description

Job Description:

Requirements Elicitation, Understanding, Analysis, & Management

  • Understand the project's Vision and requirements, and contribute to the creation of the supplemental requirements, building the low-level technical specifications for a particular platform and/or service solution.

Project Planning, Tracking, & Reporting

  • Estimate the tasks and resources required to design, create (build), and test the code for assigned module(s).
  • Provide inputs in creating the detailed schedule for the project.
  • Support the team in project planning activities, in evaluating risks, and shuffle priorities based on unresolved issues.
  • During development and testing, ensure that assigned parts of the project/modules are on track with respect to schedules and quality.
  • Note scope changes within the assigned modules and work with the team to shuffle priorities accordingly.
  • Communicate regularly with the team about development changes, scheduling, and status.
  • Participate in project review meetings.
  • Tracking and reporting progress for assigned modules

Design:

  • Create a detailed (LLD) design for the assigned piece(s) with possible alternate solutions.
  • Ensure that LLD design meets business requirements.
  • Submit the LLD design for review.
  • Fix the detailed (LLD) design for the assigned piece(s) for the comments received from team.

Development & Support

  • Build the code of high-priority and complex systems according to the functional specifications, detailed design, maintainability, and coding and efficiency standards.
  • Use code management processes and tools to avoid versioning problems.
  • Ensure that the code does not affect the functioning of any external or internal systems.
  • Perform peer reviews of code to ensure it meets coding and efficiency standards.
  • Act as the primary reviewer to review the application code created by software engineers to ensure compliance to defined standards. Recommend changes to the code as required.

Testing & Debugging

  • Attend the Test Design walkthroughs to help verify that the plans and conditions will test all functions and features effectively.
  • Perform impact analysis for issues assigned to self and software engineers.
  • Actively assist with project- and code-level problem solving, such as suggesting paths to explore when testing engineers or software engineers encounter a debugging problem, and escalate urgent issues.

Documentation

  • Review technical documentation for the code for accuracy, completeness, and usability.
  • Document and maintain the reviews conducted and the unit test results.

Process Management

  • Adhere to the project and support processes.
  • Adhere to best practices and comply with approved policies, procedures, and methodologies, such as the SDLC cycle for different project sizes.
  • Shows responsibility for corporate funds, materials and resources.
  • Ensure adherence to SDLC and audits requirements.
  • Adhere to best practices and comply with approved policies, procedures, and methodologies.

Qualifications:

  • 7+ years of SQL Server DBA experience
  • Strong Experience with SQL Server Clustering, Mirroring, Log Shipping, AlwaysON
  • Experience on AWS is plus
  • Experience with SQL coding and tuning
  • Must be hands-on, technically adept DBA, capable of performing required DB tasks.
  • Deep knowledge with SQL Server 2008, 2012, 2014, 2016, 2019, 2022 databases
  • Strong troubleshooting/performance tuning skills required. Must be able improve SQL performance.
  • Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers).
  • Ability to implement automation to reduce manual administrative tasks through use of jobs, shell scripts, PL/SQL, cron, or other techniques.
  • Expert level of SQL Server RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in -large and very dynamic environments.
  • Experience with very complex database environments.
  • Experience in SQL and/or PL/SQL.
  • Experience in working controlled environment, change control, and validated systems.
  • Experience with Foglight is a plus
  • Experience on Oracle/MySQL/Postgres/MongoDB is a plus
  • Customer service orientation.

Location:

This position can be based in any of the following locations:

Chennai, Gurgaon


Job tags



Salary

All rights reserved