Database Admin IIIIIIV

Job Description:

Summary:

The Database Administrator will provide enterprise-wide administration and production support for corporate databases. This position will be responsible for installing testing configuring monitoring performance tuning security and developing evaluation plans education programs corporate policies and procedures. This role will demonstrate a high-level of responsibility and consistency by contributing to the timely response and closure of incidents received via the corporate incident tracking system. The Database Administrator will work to identify functionality to empower users. This key individual frequently interacts with multiple departments to advocate for customers projects and incidents and providing timely responses.

Essential Accountabilities:

Level I

Plans tests and implements new database software releases patches upgrades maintenance or enhancement initiatives.

Monitors and manages existing systems to provide pro-active support to users such as:

oGrowth of data files database objects and space usage alerting and reporting

Supporting the Application development project lifecycle activities may include but are not limited to:

oImplements database objects and/or database object modifications to support application maintenance or enhancement release initiatives such as tables indexes procedures

oMigration of database physical structures from development through production

oMigration of data from one environment to another

Protects the integrity of the database through effective behaviors relating to security overall policies/procedures audits and documentation.

Configuration of database backups and ensures backup completions are successful.

Accurately prepares all documentation to comply with change management controls.

Participation in Disaster Recovery and 24x7 on-call support.

Consistently demonstrates high standards of integrity by supporting the Lifetime Healthcare Companies mission and values adhering to the Corporate Code of Conduct and leading to the Lifetime Way values and beliefs.

Maintains high regard for member privacy in accordance with the corporate privacy policies and procedures.

Regular and reliable attendance is expected and required.

Performs other functions as assigned by management.

Level II (in addition to Level I Accountabilities)

Monitors and manages existing systems to provide pro-active support to users such as:

oDevelopment and implementation of database metrics alerting and reporting

oMonitoring of databases and associated hosts using various performance monitoring tools

oCommunicates existing and/or potential performance issues to appropriate support groups

Supporting the Application development project lifecycle activities may include but are not limited to

oPlanning coordination and implementation of database objects and/or database object modifications to support application maintenance or enhancement release initiatives

oSupporting timeframes defined by project management process

Provides problem recognition and resolution support to appropriate support groups and internal/external customers.

Develops tests and implements database backups that ensures recoverability within negotiated customer specifications.

Assists in database tuning such as configuring database parameters performing database reorganizations and statistics.

Monitors execution of controls to ensure compliance (i.e. Segregation of Duties). Defines and implements the process to maintain application security. Communicates existing and/or potential security violations to management.

Level III (in addition to Level II Accountabilities)

Reviews new database releases and determines impact to current systems. Creates and evaluates standards for new database software releases patches upgrades maintenance or enhancement initiatives.

Independently leads platform teams and works with teams to meet business technical and people goals.

Leverages a strong ability to integrate database knowledge with application support

Evaluates recommends and implements performance improvements across corporate database systems. Identifies poorly performing SQL patterns and recommend changes to improve performance.

Support of the Application development project lifecycle activities may include but are not limited to

oProvides technical consultation for applications development on data manipulation and data migration

oApplies application patches when required

oGuides application team promoting corporate policies and sound code promotion practices

Defines creates and maintains database disaster recovery plan. Coordinates database recovery efforts with appropriate support groups and affected business units.

Level IV (in addition to Level III Accountabilities)

Acts as trusted advisor to the management team.

Emphasizes technology cost optimization when designing new solutions. Provides technical consultation for Applications Development.

Recognizes designs administers or arranges continuing education programs for users.

Serves as mentor for peers. This includes 24x7 on call escalation for incidents.

Proactively generates relevant ideas for new and improved use of technology based on knowledge of the corporate business products and systems and customers business needs. Leads business critical projects efforts for IT infrastructure.

Leads internal strategic efforts and collaborates with peers. Participates in the selection of the database management system & other related software.

Minimum Qualifications:

NOTE: We include multiple levels of classification differentiated by demonstrated knowledge skills and the ability to manage increasingly independent and/or complex assignments broader responsibility additional decision making and in some cases becoming a resource to addition to using this differentiated approach to place new hires it also provides guideposts for employee development and promotional opportunities.

All Levels

Associates degree in Computer Science Information Technology Business Analytics or relevant lieu of degree three (3) years of related work experience required. Bachelors degree preferred.

Basic knowledge of database management systems administration. Examples may include but are not limited to:

oRelational Database Management Systems (Oracle SQL Server MySQL)

oNon-Relational Database Management Systems (Azure Cosmos)

oCloud Infrastructure Services (AWS Azure OCI Google)

Platform as a Service

Database as a Service

Basic knowledge of structured systems analysis and design with special emphasis in systems administration project management user relations data integrity and data gathering techniques.

Basic knowledge of relevant operating system. Examples may include but are not limited to:

oOn premise hardware (Windows OS Unix/Linux OS)

oCloud Infrastructure Services (AWS Azure Oracle Cloud Infrastructure Google)

Infrastructure as a Service

Basic knowledge of programming/scripting languages. Examples may include but are not limited to:

oPowerShell Bash YAML Liquibase

Basic knowledge of security compliance and audit policies/procedures.

Clear and concise communication in both written and verbal form.

Ability to prioritize and organize workload manage multiple tasks and deadlines.

Level II (in addition to Level I Qualifications)

Two (2) years of related work experience.

In-depth knowledge of database management systems administration.

Requires thorough knowledge of relevant operating system.

Experience with IT computing resource management and optimization.

oAdministration of Database Monitoring Tools such as Idera Oracle Enterprise Manager (OEM)

oBasic knowledge of Enterprise Monitoring Tools such as Dynatrace Azure Log Analytics Workspace (LAW)

Intermediate experience of Disaster Recovery.

Basic knowledge of Automation Systems. Examples may include but are not limited to:

oAnsible

oAzure DevOps

Intermediate knowledge of security compliance and audit policies/procedures.

In-depth knowledge of structured systems analysis and design with special emphasis in systems administration project management user relations data integrity and data gathering techniques.

Ability to support Application Development initiatives through research design and implementation.

Level III (in addition to Level II Qualifications)

Four (4) years of related experience.

Advanced experience with database management systems administration and related database tools.

Advanced experience of Disaster Recovery and High Availability solutions.

Advanced experience with database security.

Independent database technical resource on application projects.

Ability to provide internal mentorship within team.

Level IV (in addition to Level III Qualifications)

Six (6) years of related work experience.

Demonstrated competence in team leadership/technical leadership facilitation and project leadership.

Demonstrated experience generating innovative approaches and solutions to complex problems.

Possesses extensive knowledge of technologies outside of core administration job function.

Experience improving the quality of processes used by the Data Platform team.

Professional certification in job-related technology preferred.

Physical Requirements:

Ability to complete work in a traditional office environment under fluorescent lighting.

Ability to work while sitting at a desk viewing a computer and using a keyboard and mouse for three (3) or more hours at a time.

Ability to work in a home office for continuous periods of time for business continuity.

Ability to travel across regions.

Willingness to provide 24x7x365 support some weekend work.

************

In support of the Americans with Disabilities Act this job description lists only those responsibilities and qualifications deemed essential to the position.

Equal Opportunity Employer

Compensation Range(s):

Leve I: Grade E2: Minimum: $62400 - Maximum: $84000

Level II: Grade E4: minimum: $65346 - Maximum: $117622

Level III: Grade: E7: Minimum: $87766 - Maximum: $157978

Level IV: Grade: E8: Minimum: $98297 - Maximum: $176935

The salary range indicated in this posting represents the minimum and maximum of the salary range for this position. Actual salary will vary depending on factors including but not limited to budget available prior experience knowledge skill and education as they relate to the positions minimum qualifications in addition to internal equity. The posted salary range reflects just one component of our total rewards package. Other components of the total rewards package may include participation in group health and/or dental insurance retirement plan wellness program paid time away from work and paid holidays.

Please note: The opportunity for remote work may be possible for all jobs posted by the Univera Healthcare Talent Acquisition team. This decision is made on a case-by-case basis.

All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability or status as a protected veteran.