Job Description Essential Duties and Responsibilities include the following. Other duties may be assigned. Responsibilities The Database Engineer III is responsible for key areas which includes Database programming, application/operations support, rotational on-call service, issue resolution, documentation and departmental support. Additionally, this position: • Supports database management activities including production data modification requests • Gains a thorough understanding of functional requirements for new software requests. • Works with Business Systems Analysts to understand and clarify data change requests, reporting requirements, and new database development requirements. • Designs, develops and performs testing of software to meet functional requirements. • Performs process analysis and recommends data and structural changes to improve application performance. • Practices good software engineering techniques and standards to reduce coding errors and ensures robustness and efficiency of work products. • Partners with software team in the development of the software engineering processes. • Works to identify and resolves technical or product problems. • Participates in software project meetings and provides status reports. • Translates technical designs into working software. • Maintains up-to-date documentation for all supported data management processes, gathers and reports data related system statistics. • Collaborates with team members and partners with others as needed to ensure successful completion of assigned database development tasks. • Participates in code reviews and incorporates recommendations. • Applies software engineering and Object Oriented Design principles in creating UML diagrams and technical design documents for software components. • Partners with team members and technical project lead to ensure component design fits in with the overall solution. • Adopts new techniques and technologies. • Initiates attendance at job related training to keep skills current; maintains current understanding of the industry’s best practices. • Assists with mentoring and training of less experienced IT staff members. • Participates in after-hours on-call support rotation; responds to monitoring alerts; implements resolution to avoid or reduce duration of an outage; escalates issues per policy to higher tier support resources and management as necessary. Client Responsibilities This is an internal (and external to IT) client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written). One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients. Qualifications To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Education And/or Experience BS/BA and 6+ years’ experience or equivalent combination of education and experience, and 2 years of SME in respective areas. Prior PBM or healthcare experience is helpful but not required. Computer Skills - Demonstrable skills required in the following areas • Six (6) plus years of experience with Database design, data mapping between cross functional application, and best practices for data pipelines • Six (6) plus years of experience in development of database processes using functions, procedures, triggers, views in Oracle, MSSQL, PostGreSQL and Unix shell scripting • Excellent knowledge of debugging, tuning and optimizing performance of database queries • Thorough knowledge of software methodologies, distributed networking, databases, communications, and multiprocessing applications • Strong experience in designing database objects using partitioning and sharding. • Strong experience in maintaining data per data retention policy • Strong experience in in data provisioning with masking and anonymization for lower environment. • Strong ETL and data modelling experience • Strong proficiency in database interfacing and relational database management systems. • Strong technical and analytical skills Certificates, Licenses, Registrations None required Other Skills And Abilities • Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams. • Ability to appropriately schedule and prioritize multiple projects to ensure timely and effective delivery of IT solutions. • Excellent written and verbal communications skills with emphasis on translating technical concepts to non-technical audiences. • Results oriented and ability to juggle multiple concurrent projects with changing priorities and deadlines Language Skills Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public. Mathematical Skills Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rate, ratio, and percent and to draw and interpret bar graphs. Reasoning Ability Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form. Competencies To perform the job successfully, an individual should demonstrate the following competencies: • Adaptability - Adapts to changes in the work environment; Manages competing demands; Changes approach or method to best fit the situation; Able to deal with frequent change, delays, or unexpected events. • Analytical – Synthesizes complex or diverse information; Collects and researches data; Identifies data relationships and dependencies; uses intuition and experience to analyze data and relationships; designs workflows and procedures. • Business Acumen - Understands business implications of decisions; Displays orientation to profitability; Demonstrates knowledge of market and competition; Aligns work with strategic goals. • Customer Service - Manages difficult or emotional customer situations; Responds promptly to customer needs; Solicits customer feedback to improve service; Responds to requests for service and assistance; Meets commitments. • Dependability - Follows instructions, responds to management direction; Takes responsibility for own actions; Keeps commitments; Commits to long hours of work when necessary to reach goals. Completes tasks on time or notifies appropriate person with an alternate plan. • Initiative - Volunteers readily; Undertakes self-development activities; Seeks increased responsibilities; Takes independent actions and calculated risks; Looks for and takes advantage of opportunities; Asks for and offers help when needed. • Problem Solving - Identifies and resolves problems in a timely manner; Gathers and analyzes information skillfully; Develops alternative solutions; Works well in group problem solving situations; Uses reason even when dealing with emotional topics. • Technical Skills – Demonstrates required skills; Adapts to new technologies; Troubleshoots technical problems; Uses technology to increase productivity; Pursues training and development opportunities; Strives to continuously build knowledge and skills; Shares expertise with others; Exhibits ability to learn and apply new skills; Keeps abreast of current developments; Displays understanding of how job relates to others. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this Job, the employee is regularly required to sit; use hands to finger, handle, or feel and talk or hear. The employee is occasionally required to stand and walk. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus. Work Environment The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this Job, the employee is occasionally exposed to risk of electrical shock. The noise level in the work environment is usually moderate. Work Location This position must work on-site at the San Diego Headquarters or at the Tempe, Arizona site for purposes of providing adequate support to internal clients; being available for face-to-face interactions and coordination of work with other employees, colleagues, clients, or vendors; as well as for facilitation of quick and effective decisions through collaboration with stakeholders. Remote work is not an option for these purposes. Working Hours This is an exempt level position requiring one to work the hours needed to get the job done. Therefore one must have the flexibility to work beyond traditional hours and be able to work nights, weekends or on holidays as required. This may be changed from time to time to meet the needs of the business. Typical core business hours are Monday through Friday from 8:00am to 5:00pm. Required Skills : PL/SQL, Oracle databases, SQL, shell scripting