Responsibilities:
- Develop expert level knowledge of specific lines of business within Chatham
- Consistently strive for high quality database solutions and exhibit a strong sense of ownership
- Develop and optimize stored procedures, functions, and triggers using T-SQL
- Identify, prioritize and communicate issues with regards to bugs and performance at the database tier
- Review and modify new and existing stored procedures to enhance performance while learning from and sharing knowledge with others
- Assist in the logical design of relational database schemas
- Participate in multiple high priority projects simultaneously while interacting with peers to make the best technical decisions
- Develop procedures and scripts for data migration
- Provide some off-hour support for production and development database environments as needed
Wymagania
Desired Technical Skills:- Expert level T-SQL development skills
- Expert level relational database design skills (Entity Relationships, Constraints, Primary and Foreign Keys, Defaults, Triggers)
- Strong understanding of Microsoft SQL Server 2008R2/2012/2014
- Strong analytical and problem-solving skills
- Experience with SQL Server Reporting Services (SSRS)
- Experience with OR/M
- General understanding of object oriented software architecture, design, and implementation
- General understanding of programming techniques and practices