Allscripts

MS System Support Engineer

IN-Pune
2 weeks ago(11/29/2017 5:59 PM)
Requisition ID
2017-13289
Category
Information Technology

Overview

home-header-logo

 

Welcome to Allscripts! Our Mission is to be the most trusted provider of innovative solutions that empower all stakeholders across the healthcare continuum to deliver world-class outcomes. Our Vision is a Connected Community of Health that spans continents and borders. With the largest community of clients in healthcare, Allscripts is able to deliver an integrated platform of clinical, financial, connectivity and information solutions to facilitate enhanced collaboration and exchange of critical patient information.

 

The primary purpose of this role is to

Responsibilities

  • Installation, Administration and Maintenance of SQL Server Instances. (Installing SQL Server)
  • Setup Test, Dev, Staging and Production Environments. (Installing SQL Server)
  • Create Users and assign permissions based on the level of database access the user would need. (Security)
  • Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc. (Security and General Administration)
  • Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)
  • Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)
  • From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)
  • Setup High-Availability as part Disaster Recovery Strategy for the Databases. (Failover Clustering, Database Mirroring, Log Shipping and Replication)
  • Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))
  • Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)
  • Documenting major changes to the SQL Servers. (General)
  • Apply Service Packs. (General)
  • Experience in writing T-SQL stored procedures in MS SQL Server 2005/2008/R2/2012 or later
  • Experience in developing reports using MS SQL Server Reporting Services (SSRS) preferable
  • Experience in developing MS SQL Integration Services (SSIS) packages preferable
  • Excellent communication skills required
  • Should be a collaborative team player and willing to learn new technologies
  • Sound analytical and logical skills to deal with complex databases
  • US Healthcare domain knowledge preferable
  • .NET or programming exposure preferable

Qualifications

Academic and Professional Qualifications : Graduation 

 

Experience : 3+ Years of experience

 

Working Arrangements:

 

Work is performed in a standard office environment with minimal exposure to health or safety hazards

 

At Allscripts, our greatest strength comes from bringing together talented people with diverse perspectives to support the technology needs of 180,000 physicians, 1,500 hospitals and 10,000 post-acute organizations across the globe. Allscripts offers a competitive total rewards package, including holidays, vacation, and medical, disability and life insurance.

 

Allscripts’ policy is to provide equal employment opportunity and affirmative action in all of its employment practices without regard to race, color, religion, sex, national origin, ancestry, marital status, protected veteran status, age, individuals with disabilities, sexual orientation or gender identity or expression or any other legally protected category. Applicants for North American based positions with Allscripts must be legally authorized to work in the United States or Canada. Verification of employment eligibility will be required as a condition of hire.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with Allscripts for future communications and career opportunities.