Senior Database Engineer
Posted 34ds ago
Employment Information
Job Description
Senior Database Engineer driving the design and optimization of database systems for high-transaction applications. Work with AWS and collaborate with engineering teams on data architecture.
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
- 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
Benefits:
- Remote First Work Environment
- Reimbursement to help cover the cost of setting up your home or remote office
















