We are currently seeking a SQL Developer to join our team in King Of Prussia, Pennsylvania (US-PA), United States (US).
Job Description:
The 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.
Specific Job Skills and Experience:
- 5+ years of related experience; or equivalent combination of education and experience
- 5+ years Experience with the full software development life cycle, including design, testing, deployment, and documentation activities (including agile and scrum patterns)
- 5+ years Experience with Advance SQL development skills like -
- In-depth understanding of data modeling best practices, normalization techniques, and database design patterns Advanced Knowledge in Always On, Transactional Replication, Clustering and T-SQL
- 5+ years Experience Proficiency in writing complex SQL queries, stored procedures, functions and triggers.
- 5+ years Experience with SQL BI stack or SSRS, SSIS and PowerBI.
- Must have 5+ years experience in source controls GitHub and bitbucket.
- Knowledge in scripting/programing languages: PowerShell, Bash, Python.
- High level of knowledge of Windows Server and WSFC with an understanding of things needed to manage HA and DR as well as troubleshoot performance and connectivity.
- Extensive experience with PowerShell and creating your own modules for management and automation in SQL Server environments (beyond basic use of community created modules such as DBA Tools).
- 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.
- 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.
