Lead Engineer - IT

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