Job Responsibilities
Primarily, the Senior SQL Developer will be responsible for the development, maintenance, and support of Platform applications. This position will be accountable for the delivery of critical product requirements and will engage with a team that is culturally and technically diverse, including.QA, product management, SQL developers, and net developers.
Contribute to the project team’s architecture and technical design discussions, code evaluations, and technical design/specifications, as well as assist in the definition, documentation, and development of software applications.
Independently accountable for the development, enhancement, testing, support, maintenance, and troubleshooting/debugging of software applications that support business entities or support functions.
Develop comprehensive, professional-grade technical specifications and project documentation.
Conducts integration tests to mitigate risks; evaluates the influence of software modifications and new developments on other systems.
In addition to participating in and fostering a knowledge-sharing environment, mentors novice team members.
Basic Qualifications
- A minimum of eight years of relevant experience; or an equivalent combination of education and experience
Over eight years of experience in the complete software development life cycle, which encompasses design, testing, deployment, and documentation activities (including agile and scrum patterns). - 8+ years of advanced SQL development skills, including a comprehensive understanding of data modeling best practices, normalization techniques, and database design patterns. Proficiency in Transactional Replication, Clustering, Always On, and T-SQL.
- Expertise in the development of intricate SQL queries, stored procedures, functions, and triggers.
- Experience with the SQL BI suite, SSRS, SSIS, and SSAS.
- It is essential to possess experience in source control systems such as Bitbucket and GitHub.
- Programming/scripting languages: Python, Bash, and PowerShell.
- A comprehensive comprehension of the requisites for managing HA and DR, as well as troubleshooting performance and connectivity, is required, in addition to a high level of proficiency in Windows Server and WSFC.
- Extensive experience in the development of custom modules for administration and automation in SQL Server environments, in addition to the fundamental use of community-created modules like DBA Tools.
- Tune complex queries and optimize queries for optimal performance.
- Creating stored procedures and dynamic SQL.
- Utilizing indexes to expedite SQL queries.
- Expertise in the development of database schemas that facilitate and represent business processes.
- Proven expertise and practical experience in the design and development of objects and components for both relational and non-relational databases.
- Experience with MSMQ Triage and MSDTC MSDTC concern Review and prioritize private queues of MSMQ issues.
- Developing ERD in both physical and logical aspects.
Preferred Skills
- 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.
