Database Administrator - Lansing, United States - Integrated Resources

Description

Position: Senior Oracle Database Administrator

Location: Lancing, MI (Hybrid)

Duration: 12 Months+

Local candidates only - must be located within 2 hours of Lansing, MI.

Interview Process: Round 1 will be a virtual interview via MS Teams video. Round 2 may be held in-person. Candidates must be available for an in-person interview.

Candidates must be willing to work overtime as needed.

General Summary of Function/Purpose of Position:

As a senior Database & Services Administrator, the employee performs a complete range of information system database analyst assignments including, but not limited to, designing, developing, testing, and implementing database and related systems services for production, test, and development environments for LARA applications. A senior Database Administrator plans, coordinates, and implements a full range of professional database & services administration functions for LARA as part of the database services team. Provides analytical and technical support and leadership around specialized software for database systems, developing database structures for applications, and related services such as job scheduling/automation & print/document management. Assists clients and agency staff, application development teams, data architects, and business data stewards. This position is also responsible for the support and maintenance of numerous databases and services. Responsible for the design, installation, and implementation of physical and virtual databases. Proactively monitor, write complex scripts, do performance tuning, and troubleshooting for an environment that requires a higher support level. This position will assist technical staff in researching about patches/upgrades, identification/troubleshooting, and resolution of database issues, and work with database security & compression tools. It is also responsible for assisting the planning, design, and implementation of security measures/tools which Product access to database files and data elements.

Top Skills (required):

Oracle Database Administration (19c or higher)

RAC (required)

OEM

Perform Patching and Updates

Vulnerability Remediation

Desired Skillset:

OEM - setting up alerts, metric extensions, and other capabilities we can leverage

Data masking - Utilizing OEM or other solutions

Experience with RAC and zero downtime patching

Experience with patching - GIRU, DBRU, OJVM, JRE

Ability to follow directions and communicate effectively

MS Outlook (ability to schedule MS TEAMs meetings, calendaring of implementations, etc.)

Documentation of processes and procedures (read, comprehend, create)

Linux, vi, MoClientm (preferred)

Performance tuning, partitioning, advanced compression

TOAD and SQL Developer; other tools

Azure DevOps (preferred) or other ticketing system(s)

Vulnerability Remediation (Tenable experience preferred)

Ability to meet deadlines under tight time constraints

me may be required