Database Administrator III
KHS reasonably expects to pay starting compensation for the position of Database Administrator III in the range of $41.08- 53.27 hourly.
Our Mission.. Kern Health Systems is dedicated to improving the health status of our members through an integrated managed health care delivery system.
*Hybrid Position*
About us
Kern Health Systems is dedicated to improving the health status of our members through an integrated managed health care delivery system.
About the role
The Database Administrator III is responsible for the integrity of all databases that support business processes with the added responsibility of comprehensive database systems support, and a comprehensive knowledge of the data stored. This includes database design; table definition design and creation; ETL (Extract Translate and Load) design and development; database maintenance, tuning, backup, and upgrades. Collaborate and mentor application and database development staff with database design, automation, and validation of data load routines involving application databases. Architect, create, and document database designs, schemas, and data flow diagrams. Manage the data warehouse design, setup, and maintenance to include extracts and data schemas. Participate as a stakeholder in the project management methodology as it applies to database technology, storage, or warehousing. Work closely with senior members of the team.
Essential Duties and Responsibilities
- Organized individual that demonstrates responsibility, good judgment, initiative, and resourcefulness, and is able to work under the leadership of senior team members.
- Provide database leadership to junior team members, and oversight or mentoring skills to other technical team members related to data.
- Leads technical and business discussions with internal and external business partners and management for data collection, data analysis, methodology, and documentation.
- Engage in technical discussions with individuals or groups to accumulate information to apply critical thinking skills in order to increase system performance, mitigate risk, or perform gap analysis.
- Independently able to architect or design ETL and templates that are used to collect and store the data from external sources so that data can be accessed by internal or external business and technology partners or users.
- Perform code review, develop, or modify other supported languages, in development of custom database packages and maintain code repository in Azure DevOps.
- Support and troubleshoot a single data environment such as Microsoft SQL Server, or other relational database and its supporting Windows Server, UNIX, or Linux Operating Systems (OS).
- Ensure that routine or special database software upgrades, maintenance, security audits, and patches are performed.
- Manage database server administration including but not limited to data and database backup and recovery, system performance, system monitoring, and database security.
- Work with the team to establish best practices to govern database server users, roles, or permissions.
- Provide leadership in the overall database designs and setup in support of the KHS and industry standards.
- Design, create, or modify database tables, indexes, constraints, links, stored procedures, and functions.
- Expert level understanding of ANSI SQL (T-SQL preferred).
- Provide direction and methodology for the data warehouse design, creation, and maintenance to include data schemas and associated ETL in conjunction with business needs.
- Establish standards for data integrity in the KHS data warehouse through data reconciliation techniques, data analysis, or ETL design issues.
- Mentor and proactively support the database needs of the application development teams.
- Provide design and structural recommendations for database application tuning and performance enhancements to development team.
- Actively attend webinars and conferences as they pertain for database maintenance, direction, and industry standardization.
Employment Standards:
Bachelor?s degree in computer science, Mathematics, or related field from an accredited school or equivalent and six (6) years progressive experience in a Database Administration or Database programming position for a medium to large size organization with a structured IT department preferably in healthcare.
OR
Ten (10) years progressive experience in a Database Administration or Database programming position for a medium to large size organization with a structured IT department preferably in healthcare.