Transcend IT Solutions
Transcend IT Solutions

SQL Developer

King of Prussia, PA, US • Posted 2 days ago • Updated 2 days ago
Contract W2
Contract Independent
Contract Corp To Corp
12 Months
No Travel Required
Able to Sponsor
On-site
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • SQL Server
  • T-SQL
  • SQL Development
  • Database Development
  • Stored Procedures
  • Functions
  • Triggers
  • Dynamic SQL
  • Query Optimization
  • Performance Tuning
  • Data Modeling
  • Database Design
  • ERD
  • Always On
  • Transactional Replication
  • Clustering
  • WSFC
  • High Availability
  • Disaster Recovery
  • SSIS
  • SSRS
  • Power BI
  • PowerShell
  • Python
  • Bash
  • GitHub
  • Bitbucket
  • Windows Server
  • Agile
  • Scrum
  • SDLC
  • Full Text Search
  • Relational Databases
  • Non-Relational Databases
  • Application Development
  • Technical Design
  • Code Review
  • Integration Testing
  • Troubleshooting
  • Automation

Summary

Position: SQL Developer
Location: King of Prussia, 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91140092
  • Position Id: TIS04564
  • Posted 2 days ago

Company Info

About Transcend IT Solutions

Our business model has scaled to successful heights on account of the long-lasting and loyal relationship with our clients, partners and candidates who have been pillar foundation of why Transcend IT Solutions is a market leader.

Our team has an outstanding track record of success in project staffing, project development and management, and consulting services. With firsthand experience in these areas, we have a sound understanding of our client’s needs.

Transcend IT Solutions provides assistance with staffing for all Information Technology roles. Providing the best-fit person of the highest caliber is our recruiting team’s goal. Our success is based on longevity of client-candidate relationships. Whether it is an individual team member or an entire team, Transcend IT Solutions will assist you with your staffing needs.

Our consulting services cover all aspects of Information Technology. Our expert consultants provide expertise in the areas of project management, requirement gathering and management, analysis and design, construction, quality control and assurance, and system deployment. As well as being individual contributors, our consultants also provide mentoring, process improvement expertise, and reviews and audits of existing projects.

About_Company_OneAbout_Company_Two
Go to company profile
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

It looks like there aren't any Similar Jobs for this job yet.

Search all similar jobs
More jobs at Transcend IT Solutions in King of Prussia, PA