Expert Database Administrator

Job Locations IN-Bangalore
Posted Date 1 month ago(1/17/2018 3:11 PM)
Requisition ID
Software Development




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 worldclass 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.


  • Estimates effort for self and agrees on schedules with Project Manager
  • Creates and maintains appropriate documentation (Database, Architecture, etc.)
  • Analyzes and diagnoses problems reported to the help desk, escalate support issues
  • Discusses issues/requirements with client
  • Works with the development teams in the data modelling and database design of product and efficient SQL for fast application performance
  • Effectively supports Sales, BSG and Professional Services
  • Researches and identifies third party tools / software that improves development process
  • Installs and configures 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
  • Implements, periodically tests and reviews appropriate data access and security measures, including access control, audit, backup/restore and system rebuild & recovery processes
  • Implements and continuously improves the database infrastructure environment. Provides fast and value-added services to the development organization
  • Participates 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
  • Stays current with the DB technology. Performs 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
  • Provides an ad-hoc support service to users of all computer systems, troubleshooting and resolving database problems
  • Carries 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 seeks and acquires technical training, vocational training and market and product awareness such that skills remain current, relevant and valued within Allscripts
  • Accurately estimates effort for self and agrees schedules with manager
  • Liaise with manager; keeps manager informed of progress
  • Trains, coaches, and mentors junior team members
  • Provides leadership to the Team
  • Helps recruit to build the organization with the right talent


  • Experience in SQL Server 2008/2012/2014/2016, Advanced SQL and PL/SQL, application development experience in a SQL Server environment, data modeling/relational database design.
  • Experience in performance monitoring and measurement, optimizing queries and improving performance.
  • Experience in normalization, isolation levels and performance tuning especially complex queries & indexing & partitioning and multi-tenancy.
  • Proficiency in writing & debugging complex SQL scripts.
  • Knowledge of system architecture stacks, database design, etc.
  • Experience creating and implementing physical databases from Logical Data Models.
  • Work with the development team for data modeling and database design of product and in developing efficient SQL for fast application performance.
  • Analyze and diagnose performance problems in the database.
  • Install and configure database system software plus third-party system tools, applications and products.
  • Stay current with the DB technology. Pro-actively acquire technical training, vocational training and market and product awareness such that skills remain current, relevant and valued.
  • Perform reviews on database design and Code.
  • Analyze, consolidate and tune database for optimal efficiency.
  • Oversee backup, clustering, mirroring, replication and failover.
  • Restore and recover corrupted databases.
  • Provide support for critical situations.
  • Evaluate and recommend new database technologies.
  • Experience with working in Agile teams.
  • Excellent problem solving skills.
  • Ability to make decisions on technology and frameworks.
  • Ability to participate in as well as promote a team environment.
  • Strong interpersonal skills to resolve problems in a professional manner, lead working groups, negotiate and create consensus.
  • Ability to work on multiple projects with tight deadlines.
  • Strong verbal and written communication skills.
  • Ability to lead code reviews and technical design meetings.

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.


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.