Sharepoint Developer / SQL Administrator

Full-time Job Description 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; 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. Qualifications 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; #J-18808-Ljbffr Prosum