Sharepoint Developer / SQL Administrator

¨ Development of graphic and multi-media design elements for the sites in connection with firm sponsored projects and goals; ¨ Develops and updates, in cooperation with the various departments and practice groups site architecture, search and navigation capabilities and other programming functions; ¨ Analyzes site traffic patterns and navigation capabilities for the purpose of determining possible enhancements. Recommends changes to the site and inclusion of new technologies; ¨ Ensures maximum visibility and accessibility of the sites through strategic linking and meta-tagging, SEO techniques and social media; ¨ Creates, maintains, and edits HTML, CSS, XML, ASP and .NET pages, JavaScript; ¨ Assists in SharePoint management, maintenance and security tasks ¨ Prepares workflow charts and diagrams to specify in detail operations to be performed by equipment and computer programs and operations to be performed by personnel in the system; ¨ Identifies problems and learns specific input and output requirements such as forms of data input, how data is to be summarized, and report formats; ¨ Supports all web application services, servers, databases and related technologies which are utilized by or integrated with the web environment; ¨ Reviews computer system capabilities, workflow and scheduling limitations to determine if requested program change is possible within the existing system; ¨ Supports maintenance and upgrades related to web services and applications and service technologies in use by the firm; ¨ Web application development, server and web software upgrades or project services as assigned; ¨ Basic knowledge and experience with server hardware and software installation, configuration and maintenance; ¨ Manages/maintains Microsoft SQL databases and ensures all database servers are backed up according to the business Recovery Point Objectives (RPO): Administer and maintains SQL databases for all office and Firm-wide applications; ¨ Develops SQL scripts and stored procedures; creates/maintains systems documentation; and monitors application and system integrations for data exchange; ¨ Custom Reporting and Query Development: Creates, maintains and supports custom reports, custom views and custom queries for all Firm-related application software and systems; ¨ May develop some graphic and multi-media design elements for the sites in connection with Firm sponsored projects and goals preferred; ¨ Demonstrated ability to define problems, collect information, establish facts and baselines and draw valid conclusions from complex manuals, technical materials, and processes; ¨ Documents all processes, program code, reports, and maintenance activities for each project; ¨ Strong analytical and troubleshooting skills; ¨ Flexibility in daily work schedule is required; on-call as required; ¨ Adheres to departmental/Firm goals and policies; and ¨ Other duties as assigned.

¨ Bachelor’s degree in Information Systems/Technology with an emphasis on Web and applications development; ¨ 5 + years' experience with web technologies, including .NET, Visual Basic, PowerShell and development in SharePoint 2010 and above with ASP.NET; ¨ 3 years' experience administering Microsoft Windows SharePoint, SQL and IIS server; ¨ 2 years' experience or certification in Microsoft SQL with database design and administration, SQL 2008 and above; Transact SQL; ¨ 2 years' experience with MS Visual Studio, SharePoint Services and related SharePoint technologies experience; ¨ 2 years' experience with Content Management Systems (CMS); ¨ Strong teamwork and problem-solving skills;