Sr. SQL Developer

Sr. SQL DeveloperDatabase AdministratorWeston, MAFinanceJO-1908-1248Do you have a natural willingness to dive in, solve problems, and get things done? Are you a strong SQL developer? If so, then you may be just the person we need to become part of an Agile team that's responsible for developing several of our clients most visible and critical web applications, including a public-facing application. These products are at the heart of what our client offers to our advisors and their clients, and we are always adding new features. In addition to having an Agile mindset and a desire to produce great software, you'll need a positive attitude and excellent communication skills. You will develop and troubleshoot OLTP databases, ODS, and data marts.Key responsibilities:Developing schema, data dictionaries, and SQL code behind our complex suite of applicationsEnsuring data is stored efficiently and can be retrieved quicklyTroubleshooting and tuning complex SQL statements and making recommendations on indexing strategiesParticipating in database architectural review and design discussionsAnalyzing complex data requirementsDeveloping and modifying procedures to solve complex database design problems, including performance, scalability, security, and integration issuesWorking on a variety of projects and systems, from big to small and complex to simplePerforming code reviews, learning from your peers, and sharing your knowledge with the teamContributing to end-to-end application developmentCollaborating with team members on effective development practices and communicating with tact, professionalism, and an eye toward team progression over self-interestCore strengths:10+ years of SQL server database development experienceA solid understanding of relational modeling conceptsAbility to write, troubleshoot, and performance-tune stored proceduresProficiency in T-SQLExperience in extracting, transforming, and loading (ETL)Experience in developing packages in SSISKnowledge of C# a plusExperience with Azure SQL and cloud services, as well as visualization tools, a plusKnowledge of TFS, including build and release definitions within a CI and CD environment a plus