Senior SQL Server Developer

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.
• Hands-on experience with Microsoft Fabric.
• 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.