Smollan India Technology Pvt.Ltd.

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 4 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. SQL query writing 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 Role & responsibilities Preferred candidate profile