Sr. SQL Developer

Americas International - King of Prussia, PA

Full-time - Mid Level

King of Prussia, PA

10,001+ employees

Nursing and Residential Care Facilities

About the position

The Senior SQL Developer will focus on the development, maintenance, and support of Platform applications, delivering critical product requirements while collaborating with a diverse team of .Net developers, SQL developers, QA, and product management. This role requires extensive experience in SQL development and a strong understanding of software development life cycles, particularly in Agile environments.

Responsibilities

• Define, document, and develop software applications, contributing to architecture and technical design discussions.
• Independently develop, enhance, test, support, maintain, and troubleshoot software applications.
• Create thorough, professional quality project documentation and technical specifications.
• Assess the impact of software changes and new development on other systems; conduct integration tests to mitigate risks.
• Mentor junior team members and promote a knowledge-sharing environment.

Requirements

• 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.
• Advanced SQL development skills, including in-depth understanding of data modeling best practices and database design patterns.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Experience with SQL BI stack or SSRS, SSIS, and SSAS.
• Experience in source controls GitHub and Bitbucket.
• Knowledge in scripting/programming languages: PowerShell, Bash, Python.
• High level of knowledge of Windows Server and WSFC, with an understanding of HA and DR management.
• Extensive experience with PowerShell for management and automation in SQL Server environments.
• Performance tuning complex queries and query optimization.
• Experience in creating database schemas that support business processes.
• Extensive knowledge and hands-on experience designing and developing relational and non-relational database objects.
• Experience with MSDTC and MSMQ, including triaging issues.
• Strong experience with Agile methodologies.

Nice-to-haves

• Familiarity with various design and architectural patterns.
• Skill for writing reusable functions, views, and database objects.

Benefits

• Competitive salary
• Health insurance
• 401k plan
• Paid time off
• Professional development opportunities