Job Details

Email to Friend Save Back

Application Systems Specialist

NEWARK-07105, NJ, US
01/10/2017

-

Required Skills

T-SQL

Company

Infinity Consulting Solutions, Inc

Experience

Job Description

APPLICATIONS SYSTEMS SPECIALIST

ESSENTIAL DUTIES:

SQL

Develop and maintain a user self-serve SQL Reporting interface and platform to provide business intelligence and visibility

Assist with planning and performing SQL database consolidations and migrations adhering to best practices

Configure and maintain SQL instance and database health monitoring and respond to alerts and notifications.

Configure, maintain, and document SQL database maintenance and backup plans and schedules.

Develop and maintain reports and interfaces to allow integrating data from different database sources to be viewed and queried.

Write T-SQL queries and views to quickly respond to requests for business and data intelligence.

Document Management (iManage)

Assist with planning and performing Document management infrastructure upgrades and enhancements.

Assist with DMS projects such as archiving, Workspace restructuring, security management, and ethical wall integrations.

Develop SQL Reports to gain visibility into the state of filing health of documents and usage of existing Workspace folders.

Desktop and Application Deployment and Maintenance

Assist with application packaging and SCCM Task Sequence development, maintenance, and deployment

Build, deliver, and maintain the firm’s virtual desktops (XenApp and XenDesktop) and endpoint.

Deliver prompt quality customer support to end-users by providing support and final resolution to 2nd and 3rd level escalated Support Center tickets

Deliver high quality end-user system performance, experience, stability and security through design recommendations and system specifications

Skills, Competencies, Requirements, and Qualifications

Ability to perform SQL server migrations across environments adhering to best practices

Extensive administration understanding of all SQL Server relational database management

Strong understanding of SQL analysis services, reporting services, and integration services

Knowledge of all native SQL high-availability and disaster recovery options (Always On, mirroring, replication, and log shipping)

Expertise with SQL scripting, stored procedures, and automated integration tasks.

Expertise with SQL Server, and T-SQL

Proven design, planning and implementation experience with the IManage WorkSite DMS platform including upgrades and migration from earlier versions, including strong expertise on the following components: Worksite Server, WorkSite IDOL,

Proven expertise with document management systems (iManage), and an understanding of data warehousing, enterprise data integration methods, and other leading-edge technology.

Desktop and Application Deployment and Maintenance

Experience with configuring and maintaining Citrix XenApp, XenDesktop, and PVS environments

Experience with VMWare environments

Experience with Microsoft Systems Management (SCCM) and Deployment Toolkit (MDT)

Experience with Group Policy and Group Policy Preferences

Exceptional analytical skills and mind-set with strong interpersonal and communication
skills essential. Must be a problem-solver

Strong attention to detail thoroughness, and communication

Create positive relationships throughout the firm to support a culture of team integrity.

Embraces change, supports the vision and demonstrates commitment to change

Experience with the legal desktop applications layer including Microsoft Office, iManage, Elite, DTE/IntApp Time, LexisNexis Interaction, and New Business Intake

Knowledge of applicable Microsoft technologies including Windows 2003/2008/2012, SQL
Server, IIS, Microsoft Active Directory, and Group Policy.

Extensive application troubleshooting experience in an enterprise environment.

Demonstrated ability to write and edit technical documentation.

Experience with Application Development, Integration, and programing languages, preferably C#.

Knowledge of Citrix technologies is preferred, but not required.

Third Party Applications Not Accepted