SQL Developer (Need only local to PA)

Transcend IT Solutions; King of Prussia (PA); On-site; USD 110,000 - 150,000; Full time

Job summary

Transcend IT Solutions is seeking a SQL Developer in King of Prussia, PA. The role focuses on development, maintenance, and support of Platform applications and requires interaction with .Net, SQL, QA, and product teams.

Candidates should have 5+ years of experience with full SDLC, strong SQL, data modeling, and BI skills including SSRS/SSIS/Power BI, plus GitHub/Bitbucket and scripting languages. Local candidates preferred.

Qualifications

• 5+ years in software development lifecycle and agile/scrum.
• Advanced SQL development with data modeling and database design.
• Proficient in T-SQL, complex queries, stored procedures and functions.

Responsibilities

• Develop, maintain, and support platform applications.
• Deliver critical product requirements and assist QA and product teams.
• Document specifications and participate in code reviews.
• Mentor junior teammates and support knowledge sharing.

Skills

SQL development

Data modeling

T-SQL

Power BI

SSRS

SSIS

GitHub

Bitbucket

PowerShell

Python

Windows Server

HA/DR

Agile

SDLC

Query optimization

Indexing

ERD design

Full Text Searching

Dynamic SQL

Stored procedures

Tools

GitHub

Bitbucket

PowerShell

Job description

Job Title: SQL Developer

Location: King of Prussia, PA-Need locals to PA

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.