Lead the engineering efforts in database management, project planning and tracking, coding, testing, and process management. Oversee SQL Server administration, troubleshooting, and implement automation in large environments.
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:
· 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.
This position can be based in any of the following locations:
Chennai, GurgaonTop Skills
AWS
Foglight
MongoDB
MySQL
Oracle
Pl/Sql
Postgres
SQL Server
Guardian Life Chennai, Tamil Nadu, IND Office
D Block, 5th Floor, Tidel Park, #4 Rajiv Gandhi Salai Taramani, , Chennai, Tamil Nadu, India, 600 113
Similar Jobs
Insurance • Financial Services
The Lead Engineer will create detailed technical designs, develop applications, mentor team members, ensure adherence to processes, and manage project documentation.
Top Skills:
Asp.Net MvcC#CSSEntity FrameworkHTMLJavaScriptJSONMs Sql ServerMsbiRest ApisSoapSQLTfsVisual Studio
Insurance • Financial Services
Seeking a skilled Techno Functional Tester for insurance software, responsible for manual and automation testing, defect tracking, and ensuring compliance with industry standards.
Top Skills:
JavaSelenium
Insurance • Financial Services
The Lead Engineer will oversee project planning, design, and development, ensuring quality, adherence to specifications, and assisting in debugging and documentation.
Top Skills:
AnsibleAntAWSAws Cloud FormationAws EcsAws EksDockerGitGroovyJenkinsJfrog ArtifactoryKubernetesLinuxMavenPowershellPuppetPythonShellTerraformWindows
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
