very urgent demand // SQL Developer // King of Prussia, PA (HYBRID)

Please share profiles for below job description

Job title: SQL Developer
Location: King Of Prussia, PA (3 days onsite in a week)

Job Summary:
The Senior SQL Developer will primarily focus on development, maintenance, and support of Platform applications. This role will be responsible for delivery of critical product requirements and will be interact with a culturally and technically diverse team, which includes .Net developers, SQL developers, QA and product management teams.
Essential Functions/Responsibilities:

Can help in defining, documenting and developing software, software applications, as well as contributes design discussions, code reviews and technical design/specifications in collaboration with the project team
Independently responsible for development, enhancement, testing, support, maintain and troubleshoot/ debug software applications that support business units or support functions.
Create thorough, professional quality project documentation and technical specifications
Assesses the impact of software changes and new development on other systems; conducts integration tests to mitigate risks

Specific Job Skills and Experience:
5 or more years of related experience; or equivalent combination of education and experience
Experience with the full software development life cycle, including design, testing, deployment, and documentation activities (including agile and scrum patterns)
Advance SQL development skills like –
Creating complex queries and stored procedures
Performance tune complex queries and query optimization
Developing Dynamic SQL and stored procedures
Using indexes to speed up the SQL queries
Experience in creating database schemas that represent and support business processes
Extensive knowledge and hands on experience designing and developing objects and components of relational and non-relational database
Experience with SSRS report development
Full Text Searching
Developing ERD – both physical and logical
Strong experience with Agile methodologies
Knowledge and understanding of SDLC, with a strong preference for Agile experience
Skill for writing reusable functions, views and database objects
Excellent written/verbal communication, presentation, and listening skills
Excellent collaboration/teamwork skills
Understanding of fundamental design principles for building a scalable application
Familiar with various design and architectural patterns

Thanks & Regards

Yash Bhatt