Database Engineer II

• Works collaboratively with Java development teams throughout the product design and development processes, to ensure optimal usage of SQL Server for storage and transaction processing
• Writes, refines, and optimizes T-SQL code for maximum performance, reliability, and maintainability
• Analyzes and interprets complex requirements, translating these into efficient backend processes
• Ability to reverse-engineer legacy code at times, improving and refining older T-SQL using newer and more efficient techniques and approaches
• Designs and implements relational databases and structures as needed
• Participates in developing cutting-edge storage design structures and data processing flows
• Creates documentation for both new and existing code

• 2-4+ years working as a database engineer or related role
• Intermediate to Advanced level T-SQL experience, including query tuning and optimization
• Experience with reporting platforms, and the ability to translate business needs into functional and efficient T-SQL driven reports
• SQL Server Administration experience is a plus
• ETL experience is also a plus
• Intimate knowledge of SSMS, and working knowledge of the other MS SQL Server Tools
• Ability to work with differing workflows, including agile, to quickly respond to a variety of business needs
• Has sound and demonstrable knowledge of best practices with regard to database development and coding standards
• Experience with Source Control and workflow ticketing systems
• IDERA for SQL Server tools, including Diagostic Manager and Admin Toolset
• Experience with SQL monitoring tools (Idera, Solarwinds, etc) a plus
• Knowledge of, or experience using, advanced SQL Server functionality (Examples include: service broker, resource governor, temporal tables, query store, Always-On, stretch database, etc)
• JOB COMPLEXITY:
• Position can involve complex logic and algorithms, and may require creative solutions at times. Leverages experience to promote best practices and help define procedures. Works with a team to promote innovation and knowledge transfer across the organization.
• SUPERVISION:
• Works under general supervision, primarily independent.
• EXPERIENCE:
• 2-4+ years of experience of database administration or development.
• EDUCATION:
• Bachelor’s degree or higher in Computer Science or a related field, or equivalent functional experience in the area.
• WORK ENVIRONMENT:
• Occasional off-hour/evening/weekend and/or overtime hours will be required.

• Remote-First & Flexible PTO - work from wherever you’re most productive
• 100% Company-Paid Employee Coverage - Medical, dental, and vision plans with a 100% company-paid employee-only option, plus company contributions toward dependent coverage and company-paid life and disability insurance.
• 401(k) + 4% Match - with financial advisors to help you plan
• 6 Weeks Parental Leave
• Invest in You - 30-60-90 day plans and frequent training
• Culture of Recognition - peer-to-peer bonuses & team celebrations

About mPulse: mPulse is the leader in conversational AI and member engagement for healthcare. We partner with the nation’s most innovative health plans - Medicare Advantage, Medicaid, and Commercial - to engage members in conversations that close care gaps, improve Stars ratings, and drive better health outcomes. Our platform reaches tens of millions of Americans and is built on the belief that better health starts with better conversations.