Senior Database Engineer II

Cambium Learning Group

7d

About The Position

Cambium Learning Group is seeking a Senior Database Engineer to join their dynamic team of over 100 software engineers, designers, project managers, and specialists. The role involves building innovative, high-quality solutions using advanced algorithms for computer-adaptive testing, highly scalable, high-performance distributed systems, comprehensive learning management systems, universally accessible user interfaces, and AI-driven scoring and assessment tools. The Senior Database Engineer will drive the design, development, and optimization of database systems for mission-critical, high-transaction applications, ensuring data integrity, performance, and scalability in modern cloud environments and microservice-based architectures. This role acts as a Subject Matter Expert (SME), collaborating with engineering and DevOps teams to shape and advance the company's data architecture and strategy in AWS.

Requirements

• B.S. in Computer Science (or related field) and 5+ years related experience or M.S. Degree and 3+yrs of experience.
• 5+ years of hands-on SQL Server development experience
• Expert knowledge of all aspects of SQL Server including the ability to write and deploy effective triggers, stored procedures and user defined functions
• Authoritative understanding of SQL Server concurrency features, transactions, and locking; Excellent data modeling and schema design skills, including normalization and de-normalization
• 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, etc.
• Experience operating SQL Server in AWS: Amazon RDS for SQL Server, RDS Custom, or SQL Server on EC2.
• Familiarity with AWS microservices architecture: designing databases to support a microservice‑based application in AWS.
• Experience optimizing data access from microservices (e.g. minimizing cross‑service latency, designing efficient APIs, minimizing coupling).
• Knowledge of containerization (Docker), orchestration (Kubernetes, AWS ECS/EKS) in microservices context.

Responsibilities

• Develop state of the art database solutions to meet the stringent performance, scalability and integrity needs of high transaction systems
• Design database schema based on data modeling of business requirements and entities
• Development work will involve writing stored procedures, functions, views, triggers, constraints, etc.
• 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
• Work with Architects and drive developers in the future evolution of the data layer researching options and developing prototypes before eventual introduction into the tech stack
• Stay current with evolving databases, AWS, microservices, and cloud‑native technologies; prototype new tools/features for adoption.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior