Collaborate with your agile team(s) throughout the sprint lifecycle to ensure database solutions meet performance, scalability, and reliability goals
Design, implement, and maintain SQL Server databases, schemas, stored procedures, functions, and triggers to support application features
Perform query tuning, index optimization, and execution plan analysis to maintain system performance
Review and optimize developer created Entity Framework queries for efficiency, maintainability and alignment with business requirements
Work with developers to ensure database code adheres to best practices for performance and security
Document processes related to database design, configuration, and performance as needed
Participate in the on-call rotation (approximately 2–3 times per year for one week at a time) to support production releases and CI/CD pipeline monitoring. During on-call weeks, serve as a liaison for the Database Engineering team, attending releases, ensuring database integrity, and assisting developers or QA team members with data-related questions or issues
Partner with QA team members to ensure test environments have accurate and performant data sets; assist in data-driven testing and automation
Requirements
BS/MS degree in Computer Science, Engineering or a related subject
5+ years' experience in database engineering
Strong knowledge of SQL, specifically Microsoft SQL Server
Strong experience with database technologies, architecture and coding
Demonstrable experience as a database developer
Portfolio of previous developments is preferred
Sound knowledge of best practices in database engineering and data security
Experience working in an Agile/Scrum development process
Strong organizational skills and attention to detail
Exceptional problem-solving and critical thinking skills
Excellent collaboration and communication skills
Self-starter and driver towards key projects with an eye towards impact and customer performance needs
Benefits
Free premium medical, dental, life and vision insurance
Generous 401(k) match
Aya also offers other benefits to those that are eligible and where required by applicable law, including reimbursements and discretionary bonuses
Aya provides paid sick leave in accordance with all applicable state, federal, and local laws. Aya’s general sick leave policy is that employees accrue one hour of paid sick leave for every 30 hours worked. However, to the extent any provisions of the statement above conflict with any applicable paid sick leave laws, the applicable paid sick leave laws are controlling
Celebrations! We hit our goals and reward ourselves.
Company-sponsored virtual events, happy hours and team-building activities are always on the horizon — plus, you get a special treat on your birthday!
Unlimited DTO — we believe in time off!
Virtual yoga, meditation or boot camp classes offered daily
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.