Note: The job is a remote job and is open to candidates in USA. mPulse is hiring a Database Engineer II to support its healthcare member engagement platform. The role develops and optimizes SQL Server databases and T-SQL processes, collaborates with Java development teams, and documents new and existing code.

Responsibilities

• 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

Skills

• 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
• 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
• Knowledge of, or experience using, advanced SQL Server functionality (Examples include: service broker, resource governor, temporal tables, query store, Always-On, stretch database, etc)
• 2-4+ years of experience of database administration or development
• Bachelor's degree or higher in Computer Science or a related field, or equivalent functional experience in the area
• SQL Server Administration experience is a plus
• ETL experience is also a plus
• Experience with SQL monitoring tools (Idera, Solarwinds, etc) a plus

Benefits

• Remote-first work and flexible PTO
• Medical, dental, and vision plans with a 100% company-paid employee-only option
• Company contributions toward dependent coverage
• Company-paid life and disability insurance
• 401(k) with a 4% match and financial advisors to help you plan
• 6 weeks parental leave
• 30-60-90 day plans and frequent training
• Peer-to-peer bonuses and team celebrations

Company Overview

Company H1B Sponsorship