We are Cambium Assessment, a Cambium Learning Group company.As the leader in online testing for K-12 state education standards, Cambium Assessment delivers secure, reliable, and scalable assessment solutions that improve student performance while supporting state education accountability. Through proven technology, research-backed psychometrics, and advanced machine learning, our solutions help reduce test time for students while improving educational outcomes.We're looking for smart, creative, and enthusiastic professionals to join our innovative team of software engineers, designers, project managers and software specialists.Job Overview:Cambium Assessment is looking for an experienced Lead Database Engineer who will design and develop highly scalable, performance driven databases which are simultaneously accessed by hundreds of thousands of users and students. This Lead Database Engineer will use latest database technologies, practices and schemas to address performance, scalability, and efficiency issues with high transaction volume systems. We are looking for Subject Matter Experts (SME) to provide leadership in Database architecture and Design to all cross functions in the department.Job Responsibilities: Optimize stored procedures to improve performance Design database schema based on data modeling of business requirements and entities Document schema design in E-R diagrams using MS Visio and maintain data dictionaries for all tables Write new stored procedures, functions, views, triggers, constraints, etc. Review SQL code written by application developers to ensure compliance to coding standards and best practices as well as maximum performance Create deployment and rollback scripts for all database objects manually or auto-generated Analyze access patterns and propose the best combination of indexes, constraints, foreign keys, and queries Troubleshoot performance problems and propose short term fixes and long term solutions Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer Work with Architects and Lead Developers to come up with optimal database designJob Requirements: BS in Computer Science, Engineering, Physics, Mathematics, or related discipline and 10+ years related experience or MS and 8+ years of related experience At least 6 years of hands on SQL Server development experience Expert knowledge of all aspects of SQL Server 2008/2012 Transact SQL including the ability to write and deploy effective triggers, stored procedures and user defined functions. Profound understanding of SQL Server concurrency features, transactions, and locking Excellent data modeling and schema design skills, including normalization and de-normalization Full grasp of the pros and cons of table partitioning and distributed partitioned views and how large data volume affects replication in SQL Server environment In-depth knowledge and hands-on experience developing, deploying, and maintaining substantial SSIS packages Thorough understanding of best practices for database maintenance, including index and file management, backups, failure recovery, database defragmentation, documentation Ability to analyze disk space requirements and hardware utilization, automate error notification Basic SQL Server administration skills, such as backups, restores, taking and reverting snapshots, user/role security, access permissions, etcWhy Work With Us?When you work with Cambium Assessment, you'll be helping to design and build inspiring solutions that make a real impact on the online testing industry, as well as the educators and students we support. Our systems are infinitely scalable and mission critical serving close to 1 million students simultaneously and over 60 million annually! Our machine scoring methods are driven by artificial intelligence allowing computers to perform such complex operations as grading essays with more accuracy than humans. Our processes use intensive algorithmic computing allowing a customized experience for each student as the exam adapts real-time based upon answers given.We currently serve more than 1/3 of US students with numerous patents and industry-standard certifications. In the 2018-2019 school year, we delivered more than 60 million tests to 860,000 simultaneous testers with an average 1/10 second response time. We have the most advanced features of any online testing system, and we continue to push boundaries for student performance measurement.Our ground breaking work includes: Advanced computer-adaptive algorithms Mobile support of user interfaces Learning management systems with social media features Universally accessible user interfaces Machine scorable itemsTo learn more about our organization and the exciting work we do, visit An Equal Opportunity EmployerWe are dedicated to fostering a culture that celebrates unique backgrounds, ideas, and experiences. All qualified applicants will receive consideration for employment without discrimination on the basis of race, color, religion, sex, gender, gender identity/expression, sexual orientation, national origin, protected veteran status, or disability.