Database Engineer | Remotive.com

Would you like to be part of a growing national healthcare solutions company? Are you looking to positively affect thousands of lives each day via health benefits? Do you have experience with MS SQL Servers?

We are hiring for a Database Engineer to join our team.

Who we are

Allied is a national healthcare solutions company that supports healthy workplace cultures.

What we do

We are problem-solvers, innovators, and collaborators. Our purpose is to work with employers to take care of their employees and their families every day – and it all starts with the Allied family. 

What’s in it for you?

Allied supports an inclusive culture focused on developing employees to succeed, innovate & impact the community.

Here’s how we do it

Training and Development: Allied offers tailored learning and development curriculums for all employees and a Learning Management Database with thousands of courses for professional and personal development.

Career Mobility: Growth opportunities are endless at Allied. In 2021 alone, one in five employees had a job change. 75% of these job changes were promotions!

Employee Engagement: We pride ourselves on employee engagement! With our recognition program, employees recognize their colleagues monthly or donate to charities with cash rewards. Allied has a dedicated committee planning monthly engagement activities to create endless opportunities to get to know your peers and destress in this new remote world.

Employee Feedback: We regularly survey our employees throughout the year to seek continuous feedback, ideas and suggestions on new initiatives.

Community Outreach: We have dedicated committees focused on fundraising efforts supporting our employees and their families, furthering education goals and providing funds for charitable organizations outside of Allied.

What will you be doing?

The Database Engineer will be responsible for maintaining existing database and designing new stored procedure, triggers, and views for internal and external products. This position will also be responsible for problem solving and finding ways to create performant back-end processes. As a Database engineer you will be working closely with the Database Administrator to resolve Database related issues. In addition, you will be responsible for providing appropriate database objects to the report writers and software developers to ensure success of projects assigned to your team.

ESSENTIAL FUNCTIONS

• 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.

EXPERIENCE AND SKILLS

Desired:

• 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

Preferred:

• 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

EDUCATION

BS degree in Computer Science, Information Systems, OR equivalent degree.

PHYSICAL DEMANDS:

This is an office environment requiring extended sitting and computer work.

WORK ENVIRONMENT

Remote

Hiring is contingent upon successful completion of our background and drug screening process. Allied is a drug-free and tobacco-free workplace.

Diversity creates a healthier atmosphere: Allied is an Equal Employment Opportunity / Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

#LI-DW1 #LI-REMOTE