Senior Database Engineer II

• 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.

Job 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.

To apply for this opportunity, simply click on the “Apply” button and submit a cover letter and resume.

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, religion, sex, gender, gender identity/expression, sexual orientation, national origin, protected veteran status, or disability.

Originally posted on Himalayas

• Senior Database Engineer
• Database Engineer
• SQL Server Developer
• Database Administrator

Source: Himalayas