JOB PROFILE
Job Title: Associate Software Developer/ Software Developer/ Senior Software Developer
Job Specialization: SQL Developer (SQL/ SSIS)
Grade: C1/C2/C3
Occupational Level: Professionally Qualified & Experienced Specialist Job
Family: Information Technology
BU: India
MINIMUM EDUCATION
B.E/ M Tech, BSC in Computer Science,B.SC IT, BCA, MCA
MINIMUM EXPERIENCE
3 years and above years of experience
SKILLS AND QUALIFICATIONS
- Strong proficiency with SQL and its variation among popular databases SQL Server
- Experience with modern relational databases
- Skilled at optimizing large complicated SQL statements
- Knowledge of best practices when dealing with relational databases
- Capable of configuring popular database engines and orchestrating clusters as necessary
- Ability to plan resource requirements from high level specifications
- Capable of troubleshooting common database issues
- Familiar with tools that can aid with profiling server resource usage and optimizing it
JOB DESCRIPTION
- Performing logical and physical data modelling as well as assessing business rules
- Developing optimized stored procedures to solve complex problems, implement databases in Microsoft SQL Server 2014/ 2016/2017/2019 and 2022.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Profile server resource usage, and optimize and tweak as necessary
- Collaborate with other team members and stakeholders
- Contribute to advancing the teams design methodology and quality programming practices.
- Coordinate planning and scheduling of upcoming development tasks and support requests.
- Store procedures and joints
- Development of projects on SQL.
- Collaboration and implementation of integrated software solutions Monitor, troubleshoot, trend, analyze data and database problems in the production environment.
- Debug and resolve any problems, including urgent outages and on-going performance/scalability needs.
- Creating a standardized delivery platform to deliver across multiple brands with minimal duplication