Allient Health Plans - The Colony, TX
posted 2 days ago
About the position
The Sr. Database Developer plays an advanced role in all aspects of the Information Technology Department including database analysis, query writing, creation of stored procedures, SSIS packages, SQL jobs, and data movement. This position is essential in ensuring data integrity among systems and collaborating to define projects, develop and interpret business rules, and debug technical issues when they arise. The role requires a deep understanding of user needs and the ability to create solutions that meet those needs. The developer will also be responsible for developing custom database objects, stored procedures, functions, and T-SQL, as well as troubleshooting slow performing queries and database servers. Additionally, the position involves providing support for off-hour deployments and production issues, participating in off-hours support rotation, and maintaining compliance with HIPAA regulations and professional conduct.
Responsibilities
- Ensures data integrity among systems
- Collaborates to define projects, develops and interprets business rules, and debugs technical issues when they arise
- Applies business and database analysis skills to gain deep understanding of user's needs
- Aids in the definition and creation of solutions that meet user's needs
- Develops custom database objects, stored procedures, functions, and T-SQL
- Effectively communicates project status and planning activities with team and customers
- Troubleshoots slow performing queries and database servers
- Provides support for off-hour deployments and production issues
- Participates in off-hours support rotation
- Follows established Company and department standards and best practices
- Stays abreast of industry trends and technologies
- Works independently and within the team structure
- Maintains regular and predictable attendance
- Consistently demonstrates compliance with HIPAA regulations, professional conduct, and ethical practice
- Works to encourage and promote Company culture throughout the organization
- Other duties as may be assigned
Requirements
- Bachelor's Degree from an accredited college in Computer Science, Software Engineering, Information Systems or closely related field
- Minimum of 4 years' experience with all phases of enterprise software design and development
- 4 years minimum experience with SQL Server 2008 or higher, T-SQL development
- 4 years minimum experience with Data Warehouse Development/ Dimensional Modeling
- Database Administrator roles (backup, restore, security) experience preferred
- Intermediate level experience with object-oriented software engineering in an enterprise environment using the MS Visual Studio suite of tools
- Proven analytical skills interpreting and implementing business and functional requirements
- Healthcare information experience preferred
- SSAS experience preferred
Benefits
- 401K (4% Match, Immediate Vesting)
- Accident insurance
- Competitive salary
- Critical Illness Insurance
- Dental Insurance
- Employee Assistance Program
- Flexible Spending Account
- Health & Wellness Program
- Health Savings Account
- Life & AD&D Insurance
- Long Term Disability
- Medical Insurance
- Paid Time Off
- Pet Insurance
- Short Term Disability
- Vision Insurance
