Role: Senior SQL Developer

Location: Oaks, PA

Mode Of Hire: Full Time

Experience Required: 10 years

Key Skills: SQL development, SQ queries, Agile, Stored Procedures

Essential Functions/Responsibilities:

• Can help in defining, documenting and developing software, software applications, as well as contributes to architecture and technical 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
• Mentor junior team members, and participates in and promotes a knowledge-sharing environment

Skills Required:

• 8 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.
• 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.