Postgres Database Administrator III

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

Postgres Database Administrator III

$92,036 - $127,700 - $163,364

“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!

The Scoop:

The Postgres Database Administrator 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.

What You Get To Do:

• 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 company’s 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 DBA’s 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 department’s On-Call agreement to meet SLA’s and metrics

Supervisory Responsibilities

This job has no supervisory responsibilities.

Education and/or Experience

For consideration candidates will need:

• Bachelor’s degree (or equivalent combination of education and experience)
• Five (5) to eight (8+) years’ related experience
• PBM or healthcare related industry experience a plus

Computer Skills

• PostgreSQL Database administration
• 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 lifecycle
• 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

None required, but any DB certifications is a plus.

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 after-hours and weekend work as needed

Travel

This position may require domestic travel as well as attendance at various local conferences and meetings.

The Perks:

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

This position is eligible for Employee Referral Bonus at Level I

To explore all that MedImpact has to offer, and the greatness you can bring to our teams, please submit your resume to www.medimpact.com/careers

MedImpact, 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.

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 www.medimpact.com/careers

MedImpact, 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.