Senior SQL Server Developer

Position: Senior SQL Server Developer

Location: REMOTE

Duration: Long Term Contract

The Senior SQL Server Developer will work as part of the Application Development team and other SQL Server Developers that are part of the DBA/Development team. The main responsibilities include developing custom SQL Server Applications/Code (using T-SQL), creating and supporting robust ETL applications (using both T-SQL and SSIS), and root-cause analysis for various development related problems (bugs in code, performance, and locking/blocking). The ideal candidate will have experience in database design and the capability of understanding and implementing business requirements from Business Analysts and other interested parties.  Additionally, the understanding of other components of Microsoft’s BI stack (SSAS and SSRS) and IBM Cognos is a plus. The Sr. SQL Server Developer must have a proven record of excellent results, be a great communicator, and a team player.

Major Duties and Responsibilities:

Perform all aspect of database development under the direction of the DBA manager including:

• Thorough code review of current and past development efforts
• Code optimization and performance tuning
• Design, develop, enhance and support database applications
• Development of complex SQL Code (stored procedures, triggers, views and functions)
• Security assessment and compliance
• Through understanding of indexing (Clustered/Non-Clustered)
• Modify/Create/maintain and optimize ETL processes using SSIS
• Create Data extraction and Import programs using SSIS
• Conduct research on emerging database and data warehouse technologies
• Interact with all stake holders not limiting to the IT to ensure accurate and comprehensive understanding of business requirements
• Liaise with network administrators, systems analysts, and software engineers to assist in resolving problems and provide issue escalation in a timely fashion
• Other duties as needed

Required Qualifications:

• Bachelor’s degree in Information Systems/Technology, Computer Science, or a related field.
• 4+ years of experience working with databases preferably SQL Server.
• 4+ years of experience in developing ETL Processes including the use of SSIS packages in a Microsoft SQL Server database environment.
• 4+ years of extensive experience working in the MS SQL Server 2005 and 2008, 2008 R2 environments.
• Understanding and knowledge of Data Warehousing (Inmon & Kimball) and Business Intelligence.
• Working technical knowledge in Relational and Dimensional Database design.
• Understanding of database security and knowledge of applicable data privacy practices and laws.
• Understanding and experience in Database/Metadata analysis and design.
• Strong written and oral communication skills.
• Strong interpersonal skills.
• Self-directed and proactive; thinks beyond the immediate problem.
• Flexibility, ability to change priorities quickly, and capacity to handle multiple tasks.
• Work directly with both internal and external resources to insure timely completion of assigned deliverables.
• Ability to effectively prioritize and execute tasks in a high-pressure environment. Keen attention to detail.
• Proven analytical and problem-solving abilities.
• Experience working both independently and, in a team,-oriented, collaborative environment.

Desired Qualifications:

• Good understanding of Database Administration fundamentals and core concepts including:
• Backup, Recovery & Recovery Models
• Database Security (Users, Roles, Schemas, Orphaned Users)
• Database Storage Fundamentals (Pages, Extents, etc.)
• Working knowledge of SQL Server High Availability and Disaster Recovery including:
• SQL Server and Windows clustering
• Database Mirroring and Log Shipping
• Transactional Replication
• Understanding of Data Modeling (both physical and logical).
• Understanding of new Developer/DBA features for SQL Server 2012 and experience with using it even in the capacity of development or R&D.
• Understanding of SSRS, SSAS, IBM Cognos or other Reporting platforms.
• Experience in Healthcare IT or Support environment a plus.