Tennessee Hospital Association

Database Administrator

Tennessee Hospital Association

Apply

Job Summary

EOE:  race/color/religion/sex/sexual orientation/gender identity/national origin/disability/vet

This position is responsible for the development and maintenance of THA’s data infrastructure. Works to ensure high availability, reliability, and security of all data assets. Proposes and implements enhancements to improve the performance of the systems.

Job Responsibilities

ESSENTIAL FUNCTIONS OF THE JOB: (listed in order of importance)  List your principal accountabilities; identify what you do, what end results you are accountable for, and how you measure your success.

  1. The ability to adapt to a changing work environment and meet challenges presented throughout the day
  2. Database design and modeling for new databases
  3. Maintain all database instances across development and production environments
  4. Create and manage ETL processes using SSIS, Alteryx, or SAS
  5. Develop, analyze and optimize complex SQL queries using TSQL
  6. Implement appropriate controls, auditing, authentication, and encryption on protected datasets (HIPAA)
  7. Create and manage SQL objects (tables, views, functions, stored procedures, triggers, etc.)
  8. Create and manage SQL jobs to automate routine procedures
  9. Manage database backup processes, storage space, and capacity planning
  10. Database performance tuning as necessary (managing indexes and optimizing queries)
  11. Manage user database access (logins, connection strings, and permissions)
  12. Manage SQL environment, including version upgrades/migrations
  13. Must be available in the office during regular office hours unless job responsibilities require otherwise, or hybrid work arrangement is in place.

MARGINAL JOB FUNCTIONS:

  1. Provide guidance and support to application developers and data analysts
  2. Create and maintain documentation for processes and changes

DIMENSIONS:

 

Volume: 

  • Database servers:  5
  • Databases:  25+
  • Direct Database Users:  8

ORGANIZATIONAL STRUCTURE:  (Positions reporting directly to you, if any, and their areas of responsibility)

None

GUIDANCE & DIRECTION:  (Policies, precedents or procedures that guide your work)

  • Health Insurance Portability and Accountability Act (HIPAA)
  • THA Information Security Policies and Procedures
  • THA Data Release Policy
  • CMS UB-04 Manual

Qualifications

Educational and experience Requirements Needed to Perform the Duties of the Job:

Bachelor’s degree with 2+ years of SQL development experience or at least 2 years of experience working in a similar database administrator role

Skills Required to Perform the Duties of the Job:

  1. Strong interpersonal skills and ability to communicate effectively
  2. SQL Server 2012, 2014, and 2016+ administration
  3. SSIS, SSAS, and SSRS
  4. Strong skillset and experience in developing and maintaining ETL processes
  5. Windows Server 2012+
  6. Microsoft Office (Word, Excel, and Visio)
  7. Healthcare experience (HIPAA, administrative claims data, etc.) a strong plus
  8. Familiarity with SAS a plus
  9. Familiarity with Alteryx a plus
  10. Familiarity with Microsoft Azure SQL a plus
  11. Experience with PowerBI development a plus
  12. Excellent organization skills and the ability to carry out multiple projects concurrently

Additional Information

Benefits

medical, dental, vision & life insurance

401(k)

PTO

How to Apply

Please submit your resume and apply through https://recruiting.paylocity.com/recruiting/jobs/Details/747438/Tennessee-Hospital-Association/Database-Administrator

Details

  • Date Posted: September 30, 2021
  • Type: Full-Time
  • Job Function: Information Technology
  • Service Area: Health (Physical, Mental)
  • Salary Range: 80,000-$90,000 annually
  • Working Hours: 38.75 hrs/wk: M-F, 8:00am - 4:45pm