Allied Benefit Systems · 1 week ago
Database Engineer
United States
Full-time
Remote
Mid Level
$110K/yr - $125K/yr
4+ years expAllied Benefit Systems is looking for a Database Engineer responsible for maintaining existing databases and designing new stored procedures, triggers, and views for their internal and external products. The role involves optimizing back-end processes and collaborating closely with the Database Administrator to resolve database-related issues.
Health CareInsuranceWellness
Responsibilities
Create databases with efficient structures
Data modeling, including an understanding of all normalized forms, design and development of stored procedures, views and triggers
Design stable, reliable and effective databases
Optimize and maintain legacy systems
Modify databases according to requests and perform tests
Solve database usage issues and malfunctions
Liaise with developers to improve applications and establish best practices
Gather user requirements and identify new features
Develop technical and training manuals
Provide data management support to users
Ensure all database programs meet company and performance requirements
Research and suggest new database products, services and protocols
Help create and test SQL statements for data presentation and further automation
Setting up and monitoring routine maintenance SQL jobs and developing / maintaining an alert strategy(s) for failed jobs and database problems and/or failures
Modify / update T-SQL scripts for importing and organizing data
Manage daily / monthly data and reporting processes automated through SQL Server agent
Excellent attention to detail, ability to detect and correct problems within SQL script
Meet Allied’s expectations for productivity, quality, and goal accomplishment
Work closely with manager to complete assigned tasks
Adhere to, and apply all applicable privacy and security laws, including but not limited to HIPAA, HITECH and any regulations promulgated thereto
Perform other duties and responsibilities, as assigned
Attend continuing education classes as required, including but not limited to HIPAA training
Qualification
Required
BS degree in Computer Science, Information Systems, OR equivalent degree
4+ years' experience with MS SQL Server
Experience with SQL Server Development – creating and modifying stored procedures, views, and triggers
Ability to debug and enhance improvement of complicated stored procedures
Ability to work closely with DBA team and create appropriate indexes/re index as needed
Ability to adhere to DB coding standards
In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
Excellent analytical and organization skills
An ability to understand front-end users requirements and a problem-solving attitude
Maintain high standards of data quality and integrity
Excellent verbal and written communication skills
Exposure to Agile Development Methodology
Usage of SQL Profiler, performance monitor and other performance analysis tools
Knowledge of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services
Company
Allied Benefit Systems
Allied offers insurance products, self-insurance solutions, custom insurance and healthcare solutions to the individuals and organizations.
501-1000 employees
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Stone Point Capital
2021-02-18Private Equity
Leadership Team
D
Dina H. Tank
Senior Vice President of Sales, Western Region
Recent News
2025-06-04
2025-06-03
Company data provided by crunchbase