SQL Server Developer

         The purpose of SQL Server DBA/Developer role is to design, implement and manage solutions to ensure optimal performance and availability for all organization's Microsoft infrastructure and development for various Applications Primary Duties:          Hands on Experience on MS SQL Server 2014, 2012, 2008          Understanding and experience in SDLC, source control, unit testing and agile development methodologies          Design Complex Data Model.          Knowledge on data modeling: normalization, de-normalization, physical database design, relational models, star schemas, snowflake schemas, etc.          Create complex ad-hoc queries for system reporting and data management.          Fluency in writing T-SQL queries, and documenting any changes          Understanding and support SQL Server disaster recovery strategies and environment, including log shipping, clustering          Create and maintain developer environment and refresh from production environment as needed          Ability to code in C#.NET/VB.NET and Exposure to ASP.NET, MVC, IIS, SharePoint          Strong experience in Database Administration in MS SQL Server          Assist in maintaining SQL Server security and user administration at database segment          Experience troubleshooting MS SQL Server system level issues, such as crashes due to device failures, corruption, lock handling          Create and maintain T-SQL tables, stored procedures, views, triggers and functions.          Create and maintain SSIS packages and SSRS reports          Utilize DBA tools to monitor performance of database and recommend changes to server configurations          Familiarity with XML technologies - XML, XSLT, XSD, XQuery, and XPath          Troubleshoot operational DB issues (isolate problem queries or connections, capture and analyze DB traces, etc.)          Monitor backup notifications, weekly equipment performance, security logs          Work independently or as part of a team on assigned task and complete in a timely manner. Requirements:          The SQL Server DBA/Developer will work under the direction of the team lead and must be capable of performing in an accountable and efficient manner.          3 or more years of experience in SQL Server at the Developer Level          Experience with database consolidation and integration projects, specifically focused on healthcare data desired.          Ability to lead projects, coordinate across multiple groups & drive projects to completion.          Excellent verbal and written communication, presentation and authoring skills.          Strong analytical and problem solving skills.          Solid interpersonal and relationship-building skills that enable cross-functional partnerships. Education and Experience:          Associates degree in related field and/or 3 years of experience managing SQL servers (physical and virtual infrastructure), development around SQL using T-SQL and VB.NET (ASP.NET) Preferred Education and Experience:          Microsoft Certified Systems Expert (MCSE): Microsoft SQL Server or MCSA certifications is a plus Required education:          Bachelor's LOA: Permanent
Salary Range: NA
Minimum Qualification
Less than 5 years

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Development Specialist
Pittsburgh, PA MDA