The Joint Commission

Returning Candidate?

Database Administrator II

Database Administrator II

Job ID 
2018-3521
# of Openings 
1
Job Locations 
US-IL-Oakbrook Terrace
Category 
Information Technology

More information about this job

Overview

Looking for a self-motivated individual responsible for database administration and database object maintenance for the Enterprise application data model, both on-premise and in the Azure Cloud. Ensures DBA team procedures, methodologies and standards are maintained across the application teams. Performs database promotions to all servers per Service Level Agreements. Provides necessary daily production problem resolution to support departmental server up time goals. Assists with SQL Server upgrades to the Enterprise.

 

PRINCIPAL DUTIES AND RESPONSIBILITIES

 

  • Provides login and security maintenance.
  • Monitors database performance.
  • Supports and provides tables and triggers in a timely manner to several application development teams in a multi-tasking environment.
  • Reviews stored procedures and insures that The Joint Commission database standards, guidelines, proper naming conventions and T-SQL coding techniques for optimal performance are enforced.
  • Creates logical and physical data model diagrams using 3rd party tools.
  • Rotates on-call 24/7 production support.
  • Provides TQA and Production promotions in a timely fashion according to SLA.
  • Monitors database integrity in a proactive manner.
  • Performs SQL Server installs and upgrades.
  • Supports the Disaster Recovery tests under supervision.

Qualifications

PREFERRED KNOWLEDGE, EXPERIENCE AND SPECIAL SKILLS

 

  • Three to five years’ experience in relational database systems.
  • Experience with implementing SSIS / SSRS.
  • BS, BA degree in computer science or equivalent experience.
  • Knowledge of a scripting language, preferably PowerShell or JSON.
  • Demonstrated knowledge of relational database concepts and modeling, with a high technical aptitude in database management.
  • Experience in the use of SQL and T-SQL for query and transaction processing.
  • Working knowledge of a programming environment (i.e. .Net Framework, Entity Framework).
  • Excellent oral and written communication skills.
  • Excellent troubleshooting and performance tuning skills.
  • Ability to use Profiler and DMV.
  • Experience with data modeling tools.
  • Familiarity with SQL Azure.

 

This job description is intended to describe the general nature and level of work performed by an employee assigned to this position.  This description is not an exhaustive list of all duties, responsibilities, knowledge, skills, abilities and working conditions associated with this position.

 

The job description does not state or imply that the statements above are the only duties and responsibilities assigned to the position.  Employees holding this position will be required to perform any other job-related duties as requested by management.  All requirements are subject to possible modification to reasonably accommodate individual with disabilities.

Connect With Us!

Not ready to apply? Connect with us for general consideration.