Allscripts

Database Administrator

IN-Baroda
3 weeks ago
Requisition ID
2017-12061
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 install, design, implement, upgrade, and optimize the performance of databases required to operate Allscripts software solutions.

Responsibilities

Mandatory skills:-

  • 2-5 years of experience in administrating SQL server Environment
  • Ready to work in 24*7 working enviornment
  • Must have SQL Database Administration experience in SQL Server 2005, SQL Server 2008 & SQL Server 2012.
  • Experience with Clustering/Mirroring always on & Replication
  • Experience with DTS/SSIS Packages, T-SQL, stored procedures, triggers, views, constraints and cursors.
  • Experience with SQL backups, T-SQL, SQL Security, and SQL installations.
  • Strong verbal and written communication skills with a demonstrated ability to work cooperatively with all levels of staff.
  • Strong understanding of all significant components of an overall IT architecture (infrastructure, applications, data management & redundancy

Responsibilities:-

  • Estimate effort for self and agree on schedules with Project Manager
  • Create and maintain appropriate documentation (Database, Architecture, etc.) 
  • Analyze and diagnose problems reported to the help desk, escalate support issues
  • Discuss issues/requirements with client
  • Work with the development teams in the data modelling and database design of product and efficient SQL for fast application performance
  • Effectively support Sales, BSG and Professional Services
  • Research and identify third party tools / software that improves development process
  • Install and configure database system software plus third-party system tools, applications and products
  • Performance Optimization
  • Performance monitoring, measurement and capacity planning of Production Software solutions, recommending changes to Allscripts products and "standardized" System configurations
  • Implement, periodically test and review appropriate data access and security measures, including access control, audit, backup/restore and system rebuild & recovery processes
  • Implement and continuously improve the database infrastructure environment. Provide fast and value-added services to the development organization
  • Participate in the process of ensuring that identified Business Continuity measures are implemented, documented and regularly tested to enable continue operations of systems identified as requiring such protection in accordance with the corporate Disaster Recovery program
  • Stay current with the DB technology. Perform software upgrades and new software installation both pro-actively and in response to requests from users of systems, including any necessary patches to database systems and applications to ensure continuing stable and secure operation
  • Provide an ad-hoc support service to users of all computer systems, troubleshooting and resolving database problems
  • Carry out prescribed programs of computer system performance management and capacity planning for systems as designated by Management to ensure the necessary system capacity and performance is available as required
  • Pro-actively seek and acquire technical training, vocational training and market and product awareness such that skills remain current, relevant and valued within Allscripts
  • Accurately estimate effort for self and agree schedules with manager
  • Liaise with manager; keep manager informed of progress

Qualifications

Academic and professional qualifications

  • Successful completion of a Bachelor’s Degree or relevant database experience

Experience

 

  • 2-5 years of experience in administrating SQL server Environment
  • Ready to work in 24*7 working enviornment
  • Must have SQL Database Administration experience in SQL Server 2005, SQL Server 2008 & SQL Server 2012.
  • Experience with Clustering/Mirroring always on & Replication
  • Experience with DTS/SSIS Packages, T-SQL, stored procedures, triggers, views, constraints and cursors.
  • Experience with SQL backups, T-SQL, SQL Security, and SQL installations.
  • Strong verbal and written communication skills with a demonstrated ability to work cooperatively with all levels of staff.
  • Strong understanding of all significant components of an overall IT architecture (infrastructure, applications, data management & redundancy

Travel requirements

  • Depends upon the project/program needs

Working arrangements

  • Hours required to complete projects/assignments

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.

 

We are an Equal Opportunity Employer. No job applicant or employee shall receive less favorable treatment or be disadvantaged because of their gender, marital or family status, color, race, ethnic origin, religion, disability or age; nor be subject to less favorable treatment or be disadvantaged on any other basis prohibited by applicable law.

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.