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
