Database Engineer

Summary: The Database Engineer III works within the cross functional Application Development & Support teams to provide complex database programming for new software and maintenance for existing software, as well as ad-hoc support of key departmental initiatives which drive business functions. The Database Engineer III receives general instructions on new projects and works autonomously to complete deliverables.

The position works within Data Management Engineering team and designs, builds, and maintains database systems, ensuring data integrity, security, and efficient performance, while also developing and implementing data pipelines and managing data storage and retrieval.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

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.

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

Bachelor’s degree (or equivalent) and 5+ years’ related experience in the essential job functions listed. Prior PBM or healthcare experience is helpful but not required.

Computer Skills - Demonstrable skills required in the following areas

• Five (5) plus years of experience with Database design, data mapping between cross functional application, and best practices for data pipelines
• Five (5) 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

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
• Familiarity with PBM business model (plans, programs, and practices) as well as pharmaceutical practices (nomenclature, medications) helpful.