- Review the physical model created from the logical model, ensuring that the detailed physical design of data structures and databases complies with standards, guidelines and procedures recommended for all aspects of data modeling, database design, and maintenance.
- Provide support for application staff and business areas regarding database implementations, which could include a customized in-house database and/or a third-party application package. Establish automated monitor mechanism for space and database availability conditions. Establish best practices for database and application high availability through the use of third-party technologies and through the exploitation of various database features.
- Provide applications support for staff, as well as, outside division to answer questions and resolve problems related to Yellowbrick, PostgreSQL and Teradata and computing platform such as Z/OS, UNIX, Linux, and Windows. Conduct root cause analysis to identify and resolve problems impacting application and/or database availability and service levels. Contact vendor support when necessary, to facilitate application development and client problem resolution with optimum speed and efficiency.
- Provide after hours and weekend support as required for on call responsibilities, database refreshes, testing, technology upgrades, and other off hour assignments.
- Participate in establishing and maintaining technical standards, departmental procedures, and other technical documentation as required. Assure compliance to required Corporate standards, procedures, guidelines, and processes, including audits.
- Assist in identifying, developing, and providing technology training to the application developers of the organization (formal and informal). Participate in staff training opportunities (formal and informal) relative to rules, procedures, and standards for the access and maintenance of shared data resources.
- Participate as assigned to intra and inter-departmental project initiatives. Participate as assigned in the testing and recommendation of tools and utilities to improve the effectiveness of managing and supporting the database environments.
- Maintain contacts with other DBA professionals externally in other Health Insurance/Health Care industries and/or other industries to maintain a perspective of current trends and best practices.
- Support for additional database platforms such as PostgreSQL, Mongo and/or MySQL as needed.
Preferred
• Licenses or Certifications: Vendor DBA Certifications for the relevant DBMS
• Work Experience: Health insurance business knowledge.
Required Skills
• Yellowbrick administration preferred. Candidates with this skill set will be interviewed first.
• Strong PostgreSQL administration REQUIRED
• Teradata administration Prefer
• Mongo, and/or MySQL administration
• Erwin nice to have
• Automation/scripting
• Cloud based data offerings such as GCP Bigquery nice to have