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