Lead SQL Developer
Lead SQL Developer
Posted on :
21-10-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Title: Lead SQL Developer
Location: Oaks PA
Type: Contract
Senior SQL Developer/ Lead Onsite Hybrid
- The Senior 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:
- 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
- Indepth understanding of data modeling best practices normalization techniques and database design patterns Advanced Knowledge in Always On Transactional Replication Clustering and TSQLProficiency 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.
- 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 nonrelational 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 knowledgesharing environment.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
