Job Description

Title: SQL Server Developer

=====================================================================================

MedPOINT, a large MSO in the San Fernando Valley has an immediate opening for the following position. Competitive salary and benefits in a collaborative working environment. For immediate consideration, please e-mail your resume and salary requirements to personnel@medpointmanagement.com

Duties and Responsibilities:

1. Identify and understand business needs during requirements gathering to effectively design, develop, test, and deploy reports or applications.

2. Stress test and optimize the system for efficiency in a distributed database.

3. Analyze internal processes and make recommendations for automated workflow processes with eventual implementation.

4. Propose technical solutions, new application design, process flows.

5. Build custom data imports as required.

6. Troubleshoot and problem solve SQL database issues.

7. Implement and test software/server upgrades as needed to gain better functionality.

8. Propose and implement database architectural changes to make database infrastructure highly scalable and optimized.

9. Demonstrate SQL best practices in regards to security and privacy as well as design.

10. Create SQL views, Common Table Expressions (CTEs) and stored procedures to combine/aggregate data needed for reporting purposes.

11. Performs problem resolution and root cause analysis along with recommending and implementing preventive techniques.

12. Develop and foster a team atmosphere that exhibits teamwork within the department and with other departments and clients.

13. Be responsive and timely with ad-hoc data requests.

14. Take on technical leadership responsibilities of database projects across various teams in the organization.

15. Be an engaged and productive member of the MPM Development team, willing to work across roles and provide full support to software and products as needed.

16. Mentor junior team members as needed.

17. Additional responsibilities as required by management.

Minimum Job Requirements:

· SSIS: 5+ experience

· Transact SQL: 5+ experience

· SQL database administration

· C#, VB application development experience

· Expert level experience with Microsoft SQL Server 2008/2012 Enterprise Edition

· Expert level knowledge of designing, constructing, administering and maintaining data warehouses

BS/BA in Computer Science, Business, Management Information Systems, Mathematics or relevant degree is highly preferred

Knowledge, Skills and Abilities Required:

· Excellent interpersonal, analytical, and problem solving skills

· Excellent oral and written communication skills

· Ability to learn quickly and ‘get things done’

· Ability to multi-task in a fast paced environment

· Motivated to share knowledge in a team environment

· Strong skills in performance turning especially tuning complex queries, procedure and indexing strategies.

· Healthcare industry experience helpful

· Experience with data warehouses highly desirable

· Self-directed and able to prioritize own workload

· EZ-CAP® knowledge a plus