SQL Developer

Job Posting Title: Sr. SQL Developer

Location: Oaks, PA (Hybrid)

Duration: 06 Months

Specific Job Skills and Experience:

·         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 -

·         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

·         Proficiency in writing complex SQL queries, stored procedures, functions and triggers.

·         Experience with SQL BI stack or SSRS, SSIS and SSAS.

·         Must have 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.

·         Experience with MSDTC and MSMQ – Triage MSDTC issue Triage private queues of MSMQ issues.

·         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.

s