Database Administrator III

The DBA III will participate in the design, development, implementation, monitoring, and maintenance of new and existing databases. The position will also lead in the development of standards and procedures to maximize performance, data integrity and recoverability. The ideal candidate is team oriented, experienced in the design and deployment of complex and very large databases (VLDB). The DBA III is the subject matter expert on database technologies and will work closely with Data Architecture, Business Intelligence, Software Engineering and Data Warehousing teams.

Responsibilities and Essential Job Functions

• Competent in the areas of critical thinking, interpersonal relationships, and technical skills.
• On Call and supports DBA’s during Priority I and II issues
• Database installation, patches, and upgrades
• Creates and modifies database objects
• Export, Transforms, and Loads data
• Monitors Database Alerts, Performance, Replication, and Resource Utilization
• Assist with Forecasting and Budgeting for Database Resources and Licenses
• Ensures compliance with Database licensing
• Validate integrity of database objects
• Audits database, operating system, ETL, and HA logs
• Performs and monitors database backups.
• Validates backup plans to ensure they meet stated recoverability goals
• Performs database recovery.
• Provides analysis of database failures and identifies corrective action.
• Performs database tuning.
• Ensures databases meet stated uptime objectives.
• Plans and implements database high availability when needed
• Documents database modifications according to Change Control Policy.
• Develops and documents tools, scripts, and processes
• Develops and reviews documentation for database functionality.
• Review changes made by DBA I and DBA II and assist with peer review of changes
• Highly skilled with new database version and functionality.
• Facilitates knowledge transfer of database skills to team members.
• Coaches and mentors new associates.
• Assists with application evaluation and implementation
• Assists with application testing and validation
• Assists programming staff in script tuning programs to access data efficiently.
• Environment planning and management
• Advising Leadership/Executives of Technology Trends
• Able to independently resolve most issues that may arise.
• Creation of database SLAs and verification that databases have met existing SLAs including backup, uptime and recoverability.
• Independently and proactively manages all aspects of the responsibilities listed above.
• Must be able to perform the professional, clinical and or technical competencies of the assigned unit or department.
• These statements are intended to describe the essential functions of the job and are not intended to be an exhaustive list of all responsibilities. Skills and duties may vary dependent upon your department or unit. Other duties may be assigned as required.

• High School Graduate
• Twelve (12) years of Database Administrator experience with SQL 2012 - SQL 2016 in a production environment or Epic Intersystems Cache Database server.
• Experience with SQL Always On technologies.
• Experience with AIX and Windows server platform.

Preferred Education and Experience

• Bachelors Degree Computer Science or related field OR
• Master’s Degree Computer Science or related field
• Experience in hospital or Healthcare environment.
• Experience with UNIX, AIX or Linux OS.

Preferred Licensure and Certification

• Certification on SQL Server or Cache database technology.

Required Language Skills

• Fluent English - Read, write, understand and speak English

Knowledge Requirements

• SQL Business Intelligence, SQL Analysis Services, SQL Reporting or Integration Services.
• SAP Business Objects.
• Familiarity with Data-warehousing concepts.
• EPIC Chronicles

• Employment with the health system is contingent upon, among other things, agreeing to the health-system-dispute-resolution-program.pdf and signing the agreement to the DRP.