Epic Database Administrator III

Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin. Position Title: Epic Database Administrator III Exemption Status: Exempt Department: Information Systems Title of Manager: IS Development Manager Supervises: Non-supervisory position Requisition: 24035 Pay and Benefits: Estimated hiring range $120,000 - $145,200 / year, 5% bonus target, full benefits. www.careoregon.org/about-us/careers/benefits Posting Notes: This role will primarily focus on SQL database development with Epic experience and/or certification General Statement of Duties This position is responsible for executing and maturing the organization’s IS database system support model (plan, design, install, and maintain) in alignment with business strategies. Primary responsibilities include leading the design, implementation, and maintenance of databases, as well as playing a key role in policy administration and vendor relations. Essential Position Functions Database Systems Design

Lead the design and management of highly reliable databases and database servers, including but not limited to the Microsoft environment, enterprise applications, custom built applications, data backup systems and cloud services.

Provide expertise in application systems software/hardware technology to the company and participate in and consult on projects.

Advise other IS teams on best practices for database/processes design.

Manage the maintenance of the enterprise database portfolio and inventory.

Serve as a resource to developing administrators.

Database Administration and Operations

Execute tasks related to tickets and service requests for advanced to complex database and database server activities and provide escalation support for compute tickets.

Oversee the maintenance of databases, database platforms and server software, such as database backups, index maintenance, software updates and upgrades.

Analyze business needs; partner with leaders across the organization to research and recommend solutions which balance business needs and risk mitigation.

Oversee the configuration and customization of database systems including high availability and disaster recovery.

Define, build, and review reports on databases and database servers’ performance and event anomalies; ensure internal adjustments are made and substantial gaps documented and elevated to management.

Develop and maintain appropriate database and database administration documentation, including current design and operation.

Oversee the configuration, execution, and monitoring of quality of data protection such as databases backup.

Oversee the configuration of user account access to databases as needed.

Oversee the configuration, execution, and monitoring of database replications.

Participate in an after-hours on-call rotation.

Standards and Policy Administration

Author and serve as subject matter expert to define requirements and standards for database selection and deployment.

Monitor and continually review existing databases systems to ensure they are designed to comply with established standards and to empower business operations.

Develop and maintain support policies and procedures.

Assist with the development and management of database security policies and systems, such as SQL server security

Lead the planning for and support of disaster recovery and business continuity initiatives.

Vendor Coordination and Relations

Establish and manage relations with external partners and database vendors including installation and repair of services.

Conduct product and vendor research, and present recommendations to team and/or management.

Maintain service contracts and licensing; effectively negotiate with outside parties; escalate issues as needed.

Essential Department and Organizational Functions

Propose and implement process improvements.

Meet deadlines for completion of job tasks.

Maintain agreed upon work schedule.

Demonstrate cooperation and teamwork.

Provide cross-training on specific job responsibilities.

Meet identified business goals that contribute to departmental goals.

Perform other related duties as needed.

Required Knowledge, Skills, and Abilities

Expert knowledge, skills, and/or abilities in most or all of the following:

Enterprise database platforms, such as Microsoft SQL Server

Data replication strategy best practices, such as transactional replication and Always On

Data high availability strategy best practices, such as Microsoft SQL Server clustering

Data integration strategy best practices, such as ETL

Document management and collaboration platforms, such as Office 365

Scripting language technology, such as PowerShell and T-SQL

Compute environments, such as server hardware, storage and virtualization

Microsoft server operating systems and core services, such as Active Directory

Cloud technologies, such as Microsoft Azure and Amazon Web Services

Data protection solutions

Troubleshooting of system performance issues and root cause

Monitoring systems and best practices

Principles of system design and best practices

Knowledge of ITIL and ITSM governance concepts

Knowledge of project management practices

Expert ability to author and maintain system documentation

Strong and clear communication skills, including listening, verbal, written, customer service, meeting facilitation, and presentations

Ability to clearly articulate policies, instructions, goals, and objectives

Able to convey appropriate level of detail effectively to all levels of the organization including non-technical staff and leadership

Able to simplify and present concepts in an easily understood way

Ability to proactively and appropriately communicate status and needs

Ability to author policies, document risks, and propose solutions to information technology management and senior leadership

Possess a high degree of initiative and motivation

Ability to effectively collaborate with coworkers, staff, leaders, and executives across all departments

Able to see lead teams of people with minimal oversight

Able to see the big picture beyond a request and take appropriate holistic action, employing “systems thinking”

Strong project management skills

Strong vendor management skills

Strong organizational skills

Ability to prioritize work based on business need and direction

Strong analytical and research skills; able to see patterns in data and draw appropriate conclusions

Able to propose solutions and communicate business value

Ability to maintain a positive attitude

Understands and adheres to governance and process

Ability to mentor and assist in developing junior staff

Physical Skills and Abilities Required

Lifting/Carrying up to 10 Pounds

Pushing/Pulling up to 0 Pounds

Pinching/Retrieving Small Objects

Crouching/Crawling

Reaching

Climbing Stairs

Repetitive Finger/Wrist/Elbow/

Shoulder/Neck Movement

0 hours/day

0 hours/day

0 hours/day

0 hours/day

0 hours/day

0 hours/day

More than 6 hours/day

Standing

Walking

Sitting

Bending

Seeing

Reading

Hearing

Speaking Clearly

0 hours/day

0 hours/day

0 hours/day

0 hours/day

More than 6 hours/day

More than 6 hours/day

3-6 hours/day

3-6 hours/day

Cognitive and Other Skills and Abilities

Ability to focus on and comprehend information, learn new skills and abilities, assess a situation and seek or determine appropriate resolution, accept managerial direction and feedback, and tolerate and manage stress.

Education and/or Experience

Required

Minimum 5 years’ experience delivering database systems solutions and related services required. Experience should include most or all of the following:

Enterprise database installation, administration and upgrade

Enterprise database infrastructure design including performance management and cost metrics

Scripting and automation

Cloud and “as a Service” offerings

Microsoft operating systems and core services

ITIL concepts and practices

Concepts of Managed Care

Project management practices

Systems integration and data flow

Preferred

Epic Cogito experience

Iris experience

Certifications: ODBA 100 and/or ODBA 200

Bachelor’s degree in Computer Science, Information Systems, or a related field preferred

Advanced-level Microsoft certifications preferred

Additional experience in related technology support and/or operational positions preferred

Working Conditions

Environment: This position’s primary responsibilities typically take place in the following environment(s) (check all that apply on a regular basis):

☒ Inside/office ☐ Clinics/health facilities ☐ Member homes

☐ Other

Travel: This position may include occasional required or optional travel outside of the workplace, in which the employee’s personal vehicle, local transit, or other means of transportation may be used.

Equipment: General office equipment

Hazards: n/a

#LI-Remote #MULTICandidates of color are strongly encouraged to apply. CareOregon is committed to building a linguistically and culturally diverse and inclusive work environment. Veterans are strongly encouraged to apply. We are an equal opportunity employer. CareOregon considers all candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, disability, or veteran status. Visa sponsorship is not available at this time.