Database Engineer

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

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

Requirements:

• 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