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;