SQL Developer
Apply NowCompany: CERES Group
Location: Waltham, MA 02453
Description:
About the Opportunity
Do you-like us-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 are looking for to work as part of a small team of developers, business analysts, and business owners to architect, develop, implement, support, and troubleshoot our firm's OLTP database and applications.
Overall, our tight-knit Development team builds and maintains a large private website that is built primarily using Microsoft technologies, including .NET and SQL Server. We also have a public-facing site and mobile versions of our tools. Our development approach has always been "agile," and we recently revamped our team structure based on scrum.
As a SQL developer, your responsibilities would include:
A solid understanding of relational modeling concepts
Do you-like us-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 are looking for to work as part of a small team of developers, business analysts, and business owners to architect, develop, implement, support, and troubleshoot our firm's OLTP database and applications.
Overall, our tight-knit Development team builds and maintains a large private website that is built primarily using Microsoft technologies, including .NET and SQL Server. We also have a public-facing site and mobile versions of our tools. Our development approach has always been "agile," and we recently revamped our team structure based on scrum.
As a SQL developer, your responsibilities would include:
- Building the schema and SQL code behind our complex suite of web-based applications
- Making sure data is stored efficiently and can be retrieved quickly (We maintain numerous databases and servers that integrate as an ecosystem to serve our clients' needs.)
- Troubleshooting and tuning complex SQL statements and making recommendations on indexing strategies
- Creating data transformation jobs that load market and industry data from multiple sources
- Working on a variety of projects and systems, from big to small and complex to simple
- Working with a dynamic team of web developers, business analysts, and product owners to build the best applications in the financial industry
- Performing code reviews, learning from your peers, and sharing your knowledge with them in a positive, friendly way
A solid understanding of relational modeling concepts
- Ability to write, troubleshoot, and performance-tune stored procedures and ad hoc scripts
- A willingness to dive in, solve problems, and get things done
- Experience with data warehousing a plus
- Experience in the financial sector a plus
We offer you:
- Stock options and use of vacation properties
- A more relaxed dress code
- A free on-site fitness center
- Ample opportunity to volunteer with and support local charities
- Tuition reimbursement
- Free breakfast on Fridays
- A competitive benefits package-and much more