Senior SQL Developer

Experience these Xtraordinary benefits when you join Med-Metrix

• Day 1 HMO with 2 of your dependents covered for FREE
• Medical Cash Allowance
• Rice Allowance
• Clothing Allowance
• Paid Time Off
• Training and Staff Development
• Employee Engagement Activities
• Opportunities for Internal Mobility

Description

• Develop Complex ETL and Analytics Programs using SQL, Store Procedures and various query tools.
• Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement.
• Develop, maintain and support SQL Server Integration Services (SSIS) packages related to the extraction, transformation and loading (ETL) process using Microsoft SQL Server 2012 or later
• Maintain HIPPA transactions specifically 835 and 837 transaction sets, create the ad hoc reports to query the transaction sets.
• Responsible for data profiling as well as SQL and database tuning / optimization
• Analyze the client requirements and design technical solutions based on those requirements.
• Perform day to day troubleshooting of issues related to QA and Production.
• Design ETL audit control and scheduling processes.
• Develop testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issues
• Guide the developers in the team to implement the client requirement and review the software developed by the team members.
• Provide technical leadership by making recommendations for application development to enhance the existing solution or resolve production issues
• Work within a fast paced, objective oriented environment
• Managing and versioning the SSIS projects using Visual Studio Foundation Server.
• Participates in Client meetings, lead technical review meetings with team and/or client as required.
• Responsible for providing accurate and timely communication of the status of assignment, job responsibilities, and the resolution of problems to the appropriate parties following established policies and procedures.

Requirements

• Requires a four-year degree in Computer Science/Information Technology
• Minimum two years working as a Database engineer or a related role.
• Minimum of one year SSIS experience
• Thorough understanding of database structures, theories, principles, & practices.
• Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints.
• Extensive knowledge of MS SQL Server
• Extensive knowledge with SSRS\SSIS\T-SQL
• Experience with C# and\or VB.NET.
• Technical knowledge of MS SQL Server internals with emphasis on query performance.
• Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations.
• Strong oral and written communication skills with the ability to communicate technical and non-technical concepts to peers, customers, and management
• Must be capable of routinely making effective and timely decisions in alignment with departmental direction and based on sound business knowledge and industry best practices.
• Require ability to work independently with minimal supervision
• Ability to multi-task with several complex and demanding Projects

Working Conditions:

• Remote: You'll be joining a distributed, fully remote team. Experience working remotely is a plus.
• Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear.
• Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress.
• Work Environment: The noise level in the work environment is usually minimal.
• Work Timings: You are expected to work in Eastern time zone with US team initially.