What are the responsibilities and job description for the Lead Database Engineer position at Cambium Assessment?
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
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.
Remote First Work Environment
Our Remote First approach gives employees the flexibility and trust they need to effectively balance work with life. It creates a culture in which all employees are valued and where success is measured in results. It allows us to work collaboratively, inclusively and for greater positive impact, regardless of our individual locations.
If you will be working remotely, either occasionally or on a permanent basis, you must have a reliable internet connection through a cable or fiber-optic broadband service with minimum speeds of 10 Mbps download and 5 Mbps upload.
The successful candidate will be expected to actively participate in video-based interviews during the recruiting process and ongoing virtual meetings with their camera on, as part of their role.
As part of our Remote-First benefits, Cambium offers reimbursement to help cover the cost of setting up your home or remote office.
An Equal Opportunity Employer
We 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, age, religion, sex (including pregnancy, gender, gender identity/expression, or sexual orientation), national origin, protected veteran status, disability, or genetic information (including family medical history).
We will provide reasonable accommodations for qualified individuals with disabilities. You may request an accommodation during the recruiting process with your Talent Acquisition team member.
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 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.
- Study 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 design.
- B.S. in Computer Science, Engineering, Physics, Mathematics, or related discipline and 10 years related experience or M.S. and 8 years of related experience.
- At least 6 years of hands-on SQL Server development experience
- Skilled knowledge of all aspects of SQL Server 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 examine 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, etc.
- Familiarity with other opensource Relational database systems like MySQL or Postgres is a plus.
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 highly scaled and mission critical serving over a third of all students in grades 3-8 in the United States.
- Our web applications are highly interactive and universally accessible.
- 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.
Remote First Work Environment
Our Remote First approach gives employees the flexibility and trust they need to effectively balance work with life. It creates a culture in which all employees are valued and where success is measured in results. It allows us to work collaboratively, inclusively and for greater positive impact, regardless of our individual locations.
If you will be working remotely, either occasionally or on a permanent basis, you must have a reliable internet connection through a cable or fiber-optic broadband service with minimum speeds of 10 Mbps download and 5 Mbps upload.
The successful candidate will be expected to actively participate in video-based interviews during the recruiting process and ongoing virtual meetings with their camera on, as part of their role.
As part of our Remote-First benefits, Cambium offers reimbursement to help cover the cost of setting up your home or remote office.
An Equal Opportunity Employer
We 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, age, religion, sex (including pregnancy, gender, gender identity/expression, or sexual orientation), national origin, protected veteran status, disability, or genetic information (including family medical history).
We will provide reasonable accommodations for qualified individuals with disabilities. You may request an accommodation during the recruiting process with your Talent Acquisition team member.