Jr SQL Developer (Maintenance)

Jr SQL Developer (Maintenance)Database AdministratorWeston, MAFinanceJO- Jr. SQL Developer Weston, MA Working with our client means you'll be helping a 10-person Agile team that's responsible for developing several of their most visible and critical web applications, including a public-facing application. These products are at the heart of what our clients offer to financial advisors—and to their clients—and we are always adding new features.Your days will have you maintaining and troubleshooting OLTP databases, ODS, and data marts. As one of us, you'll bring a positive attitude and excellent communication skills to your work.Key responsibilities:Responding within agreed time limits to call-outsEnsuring data quality is excellentTroubleshooting complex SQL statements and making recommendations on fixing bugsMonitoring and troubleshooting build failures, system alerts, and reported outagesWriting SQL scripts to fulfill data requests from business usersWriting SQL unit tests and monitoring test failuresDeveloping and modifying scripts to perform complex data migration or data manipulationsWorking on a variety of projects and systems, from big to small and from complex to simplePerforming code reviews, learning from your peers, and sharing your knowledge with the teamDocumenting and maintaining data dictionaries, metadata, and configuration settingsContributing 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:1-3 years of SQL experienceExcellent communication skillsProblem-solving skillsAttention to detailGood understanding of relational modeling conceptsAbility to write and troubleshoot stored proceduresKnowledge of T-SQLKnowledge of C# a plusKnowledge of TFS, including build and release definitions within a CI and CD environment a plus