Senior Database Engineer II

Cambium Assessment is seeking a Senior Database Engineer to join their dynamic team of over 100 professionals dedicated to building innovative solutions. This role involves designing, developing, and optimizing database systems to support high-transaction applications, ensuring data integrity and performance in cloud environments.

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

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