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

Participate in the design, development, implementation, monitoring, and maintenance of new and existing databases; Lead the development of standards and procedures to maximize performance, data integrity and recoverability; On call and support DBAs during Priority I and II issues; Database installation, patches, and upgrades; Create and modify database objects; Export, transform, and load data; Monitor database alerts, performance, replication, and resource utilization; Assist with forecasting and budgeting for database resources and licenses; Ensure compliance with database licensing; Validate integrity of database objects; Audit database, operating system, ETL, and HA logs; Perform and monitor database backups; Validate backup plans to ensure they meet stated recoverability goals; Perform database recovery; Provide analysis of database failures and identify corrective action; Perform database tuning; Ensure databases meet stated uptime objectives; Plan and implement database high availability when needed; Document database modifications according to Change Control Policy; Develop and document tools, scripts, and processes; Develop and review documentation for database functionality; Review changes made by DBA I and DBA II and assist with peer review of changes; Facilitate knowledge transfer of database skills to team members; Coach and mentor new associates; Assist with application evaluation, implementation, testing and validation; Assist programming staff in script tuning programs to access data efficiently; Environment planning and management; Advise Leadership/Executives of technology trends; Create database SLAs and verify that databases meet existing SLAs including backup, uptime and recoverability; Independently and proactively manage all aspects of the responsibilities listed above

Requirements

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; Fluent English - Read, write, understand and speak English; Knowledge of SQL Business Intelligence, SQL Analysis Services, SQL Reporting or Integration Services; Knowledge of SAP Business Objects; Familiarity with Data-warehousing concepts; Knowledge of EPIC Chronicles

Nice to have

Bachelors Degree in Computer Science or related field; Master's Degree in Computer Science or related field; Experience in hospital or Healthcare environment; Experience with UNIX, AIX or Linux OS; Certification on SQL Server or Cache database technology