Exemption Status:

Pay scale information is not necessarily reflective of actual compensation that may be earned nor a promise of any specific pay for any selected candidate or employee which is always dependent on actual experience education qualifications and other factors. A full review of our comprehensive pay and benefits will be discussed at the offer stage with the selected candidate.

This position is not eligible for Sponsorship.

MedImpact Healthcare Systems Inc. is looking for extraordinary people to join our team!

Why join MedImpact Because our success is dependent on you; innovative professionals with top notch skills who thrive on opportunity high performance and teamwork. We look for individuals who want to work on a team that cares about making a difference in the value of healthcare.

At MedImpact we deliver leading edge pharmaceutical and technology related solutions that dramatically improve the value of health care. We provide superior outcomes to those we serve through innovative products systems and services that provide transparency and promote choice in decision making. Our vision is to set the standard in providing solutions that optimize satisfaction service cost and quality in the healthcare industry. We are the premier Pharmacy Benefits Management solution!

Job Description

Summary

The Database Administrator IV supports database administrative activities including but not limited to database patching capacity and performance management. This position also is responsible for backup and recovery configuration and execution modeling and development support..

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

• Demonstrated experience writing complex stored procedures and queries
• Proven experience troubleshooting and solving complex databases schemas/warehouses.
• Understanding and experience of Software Development Life Cycle
• Experience in database development administration and management for PostgreSQL and Oracle
• Proven experience with integration from Oracle to Postgres and/or vice-versa
• Understanding of existing data models and ability to design new data models
• Administration and tuning of database and data models for performance
• Ability to assess database for best practices and performance
• Ability to build security and backup strategies for database
• Ensuring database is performing at optimal levels
• Collaborating with engineering teams and clients on ensuring smooth operations of database
• Performs deployments in production and non-production environments
• Responsible for evaluating patching requests communicating constraints risks impact issues and timelines for deployment
• Collaborates with engineering teams and clients on ensuring optimal operations of database
• Streamlines cloning or similar activities to build/refresh non-production environments
• Supports and enforces change management SOP including maintenance across multiple environments
• Supports IT security Audit Reporting
• Provides technical leadership and advice for the companys use of DB and related technologies. Provide leadership and guidance on large complex and cross functional projects and tasks
• Provides database back-up archiving monitoring data analysis and troubleshoots data issues
• Assists with related task planning training and technical direction of other Applications Administrators DBAs or IT software engineers and developers
• Develops documentation for the assessment and automation of repeatable processes
• Assists in maintaining plans for disaster recovery and failover capabilities and testing
• Maintains security according to company guidelines and works closely with the IT Security team to develop additional robust solutions
• Provides peer reviews for work produced by other Application DBAs and/or software engineers
• Trains other IT Application DBAs within the Information Technology department and acts as a mentor to less experienced staff
• Provides On-Call support after hours and on weekends (on a rotational basis) per the departments On-Call agreement to meet SLAs and metrics

Supervisory Responsibilities

No supervisory responsibilities

Client Responsibilities

This is an internal and external 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 accommodation may be made to enable individuals with disabilities to perform the essential functions.

Education and/or Experience

BS/BA and 8 years experience or equivalent combination of education and experience and 4 years of SME in respective areas

Computer Skills

• Experience in administering cloud-based multiuser environment with expertise in planning designing building and implementing complex database systems (Azure cloud-based Postgres database administration experience or similar database administration experience)
• Experienced with optimizing database performance through testing and ongoing real-time monitoring.
• Experience working with version control systems like GIT and used Source code management tools GitHub and Bitbucket.
• Oracle Data Migration experience including validation/testing and reconciliation.
• Create tune administer and maintain Postgres DB instances for high volume mission critical systems throughout the development test and production lifecycles
• Design and develop logical and physical database designs from customer application requirements
• Support daily administration monitoring tuning and troubleshooting in PostgreSQL clusters on Linux
• Use Flyway to apply schema updates and track the deployment process through environments
• Participate in ETL and data conversion activities from Oracle to Postgres
• Hands on Data modeling/modeler
• Hands-on experience with Linux based databases preferred
• Hands-on experience with NOSQL databases like Cosmos DB Redis preferred

Certificates Licenses Registrations

• Oracle Certified Expert
• Oracle Certified Professional
• Oracle Certified Associate
• Oracle Certified Master

Other Skills and Abilities

• Ability to work independently work as a member of and provide technical direction to a cohesive team with excellent interpersonal skills
• Strong analytical and communication skills
• Leading meetings and acting as a facilitator along with the ability to logically present and communicate ideas to work groups
• Ability to develop and execute focused infrastructure projects such as upgrades and migrations
• A solid understanding of enterprise technology stacks
• Ability to architect technology solutions and influence enterprise adoption through stakeholder management
• Incident and change management skills
• Good verbal written communication and presentation skills
• Excellent organizational attention to detail and follow-up skills
• Must be available for On-Call work as needed

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.

Mathematical Skills

• Ability to work with mathematical concepts such as probability and statistical inference and fundamentals of plane and solid geometry and trigonometry.

• Ability to apply concepts such as fractions percentages ratios and proportions to practical situations.

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.

Competencies To perform the job successfully an individual should demonstrate the following competencies:

Composure

Decision Quality

Organizational Agility

Problem Solving

Customer Focus

Drive for Results

Peer Relations

Time Management

Dealing with Ambiguity

Learning on the Fly

Political Savvy

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 accommodation 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 and talk or hear. The employee is regularly required to stand; walk; use hands to finger handle or feel and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

This position may regularly be exposed to or encounter moving mechanical parts high precarious places fumes or airborne particles toxic or caustic chemicals outdoor weather conditions risk of electrical shock or vibration. The noise level in the work environment is usually moderate (examples: business office with computers and printers light traffic).

Work Location

This position must work on-site at the San Diego Headquarters 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 the incumbent to work the hours required to fully accomplish job responsibilities and reasonably meet deadlines for work deliverables. The individual must have the flexibility to work beyond traditional hours and be able to work nights at weekends or on holidays as required. Work hours 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.

Travel

This position requires no travel however attendance maybe required at various local conferences and meetings.

The Perks:

• Medical / Dental / Vision / Wellness Programs
• Paid Time Off / Company Paid Holidays
• Incentive Compensation
• 401K with Company match
• Life and Disability Insurance
• Tuition Reimbursement
• Employee Referral Bonus

To explore all that MedImpact has to offer and the greatness you can bring to our teams please submit your resume to is a privately-held pharmacy benefit manager (PBM) headquartered in San Diego
California. Our solutions and services positively influence healthcare outcomes and expenditures improving the position of our clients in the market. MedImpact offers high-value solutions to payers providers and consumers of healthcare in the U.S. and foreign markets.

Equal Opportunity Employer Male/Female/Disabilities/Veterans

OSHA/ADA:

To perform this job successfully the successful candidate must be able to perform each essential duty satisfactorily. The requirements listed 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.

Disclaimer:

The above
statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills required of personnel so classified.