Database Engineer II

免费注册后解锁"你的匹配分 vs 高分画像"与个人技能缺口。

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. PRIMARY 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 POSITION REQUIREMENTS: • SKILLS AND QUALIFICATIONS: ◦ 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. Why mPulse? • 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 Equal Opportunity: mPulse is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Employment decisions at mPulse are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other characteristic protected by applicable law. If you require any accommodation

关于 mPulse：mPulse 是医疗保健领域对话式 AI 和会员互动领域的领导者。我们与美国最具创新性的健康计划合作——Medicare Advantage、Medicaid 和 Commercial——通过对话与会员互动，弥合护理差距、提升 Stars 评级并推动更好的健康结果。我们的平台覆盖数千万美国人，其建立在“更好的健康始于更好的对话”这一信念之上。主要职责：在产品设计和开发过程中与 Java 开发团队协作，确保 SQL Server 在存储和事务处理方面得到最佳使用 编写、完善并优化 T-SQL 代码，以实现最大性能、可靠性和可维护性 分析并解读复杂需求，将其转化为高效的后端流程 有时能够逆向工程遗留代码，使用更新、更高效的技术和方法改进和完善较旧的 T-SQL 根据需要设计和实现关系数据库及结构 参与开发前沿的存储设计结构和数据处理流程 为新增和现有代码创建文档 职位要求：• 技能和资格：◦ 2-4+ 年担任数据库工程师或相关职位的经验 ◦ 中级至高级 T-SQL 经验，包括查询调优和优化 ◦ 具有报告平台经验，并能够将业务需求转化为功能高效、由 T-SQL 驱动的报告 ◦ 具有 SQL Server 管理经验者优先 ◦ 具有 ETL 经验者亦优先 ◦ 熟悉 SSMS，并具备其他 MS SQL Server 工具的工作知识 ◦ 能够适应不同的工作流程，包括敏捷流程，以快速响应各种业务需求 ◦ 对数据库开发和编码标准方面的最佳实践具有扎实且可证明的知识 ◦ 具有源代码控制和工作流工单系统经验 ◦ 使用 IDERA for SQL Server 工具的经验，包括 Diagnostic Manager 和 Admin Toolset ◦ 具有 SQL 监控工具经验（Idera、Solarwinds 等）者优先 ◦ 了解或具有使用高级 SQL Server 功能的经验（示例包括：service broker、resource governor、temporal tables、query store、Always-On、stretch database 等）• 工作复杂性：◦ 该职位可能涉及复杂逻辑和算法，有时可能需要创造性解决方案。利用经验推广最佳实践并帮助定义流程。与团队合作，促进整个组织的创新和知识转移。• 监督：◦ 在一般监督下工作，主要独立开展工作。• 经验：◦ 2-4+ 年数据库管理或开发经验。• 教育：◦ 计算机科学或相关领域学士学位或更高学位，或在该领域具有同等职能经验。• 工作环境：◦ 偶尔需要非工作时间/晚间/周末和/或加班。为什么选择 mPulse？• 远程优先 灵活带薪休假——在您最高效的地方工作 100% 公司支付员工保险——医疗、牙科和视力计划提供 100% 公司支付的仅员工选项，另有公司对受抚养人保险的缴款以及公司支付的人寿和残疾保险。401(k) + 4% 匹配——并有财务顾问帮助您规划 6 周育儿假 投资于您——30-60-90 天计划和频繁培训 认可文化——同伴奖励 团队庆祝活动 平等机会：mPulse 是平等机会雇主。我们崇尚多样性，并致力于为所有员工创造包容的环境。mPulse 的雇佣决定基于业务需求、职位要求和个人资格，不考虑种族、肤色、宗教、性别、性取向、性别认同、国籍、年龄、残疾、退伍军人身份或任何其他受适用法律保护的特征。如果您需要任何便利

⚑ 岗位信息收录自公开招聘页（Himalayas），以雇主官网为准