Database Administrator III

Seneca Resources Company, LLC; Virginia (MN); Remote; USD 90,000 - 130,000; Full time

Job summary

A leading resource management firm is looking for an experienced Database Administrator III to manage complex database systems, including Oracle RDBMS and NoSQL databases. The role involves troubleshooting, maintenance of high-performance environments, and managing upgrades. Candidates should have at least 4 years of DBA experience, excellent problem-solving skills, and must be flexible to work on-call including weekends. This position offers remote working options and requires a degree in a relevant field.

Qualifications

• Minimum of 4 years of Oracle production support DBA experience, including RMAN and RAC.
• Experience with large multi-node RAC databases and Oracle 19c.
• Flexibility to work on-call, including weekends and overnights.

Responsibilities

• Manage and maintain Oracle RDBMS and NoSQL databases in high-performance environments.
• Troubleshoot and resolve issues related to Oracle eBusiness Suite.
• Support middle tier technologies, including containers and cloud platforms.

Skills

Oracle RDBMS Management

NoSQL Databases Management

Database Design

Problem-Solving Skills

UNIX Proficiency

Windows Operating Systems

Education

Degree from an accredited College/University

Tools

Oracle Fusion

Kubernetes

Docker

Oracle eBusiness Suite

Job description

Overview

Job Title: Database Administrator III
Location: Remote
Resource: 1
Submission Slots: 3
Must be submitted in ITS Resume Template

Must be flexible and willing to work on-call, overnights and weekends as needed.

Summary
Experienced in problem resolution and efficient operation of a multi-computer site that supports database administration, analysis, and report production; data dictionary administration; and system development. Under general direction, provides highly technical expertise and guidance in the design, implementation, operation and maintenance of database management systems (DBMS). Designs, implements, and maintains complex databases with respect to JCL, NoSQL, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. Evaluates and recommends available DBMS products after matching requirements with system capabilities. Defines required database administration policies, procedures, standards, and guidelines. Prepares and delivers presentations on DBMS concepts.

Responsibilities

• Database administration - Work hours will be determined by USPS requirements, including off-shift and weekend hours for patching and production builds.
• The successful candidate will be responsible for performing complex functional activities in support of Oracle RDBMS products and services, Oracle eBusiness Suite, and/or NoSQL databases such as Cassandra. This role requires a deep understanding of database technologies and the ability to manage and optimize both relational and NoSQL databases in high-performance environments.
• Key Responsibilities:
• Oracle RDBMS Support:
• Upgrade, install, patch, and remediate vulnerabilities in Oracle RDBMS products and services on Linux servers.
• Manage and maintain a complex Oracle RDBMS production environment.
• Oracle eBusiness Suite Support:
• Upgrade, install, patch, and remediate vulnerabilities in Oracle eBusiness Suite applications on Linux servers.
• Ensure the integration and performance of Oracle eBusiness Suite with other systems.
• Troubleshoot and resolve issues related to Oracle eBusiness Suite.
• NoSQL Database Support:
• Understand the complexities of NoSQL databases in scalable, high-performance applications.
• Work with NoSQL databases such as Cassandra.
• Handle database patching, design, vulnerability remediation and write complex queries on Windows and Linux servers.

Qualifications

• Proven experience in managing Oracle RDBMS, Oracle eBusiness Suite, and/or NoSQL databases.
• Strong understanding of database design, optimization, and query writing.
• Proficiency in UNIX and Microsoft Windows operating systems.
• Excellent problem-solving skills and attention to detail.

Middle Tier Administration

Work hours will be determined by USPS requirements, including off-shift and weekend hours for patching and production builds. The successful candidate will be able to support USPS implemented middle tier technologies, including web and application servers, containers and container management technologies, messaging technologies, cloud platform and services, automation tools, scripting languages and monitoring tools. Current technologies in use include Apache Tomcat, WildFly, Oracle Fusion Middle Tier (OFM), IBM WebSphere, Apache HTTP, Kubernetes, Docker and other types of containers, IBM MQ, Kafka, Zookeeper, RedHat OpenShift, Rancher, Ansible, Google Cloud Platform, Microsoft Azure, Linux shell scripting, Microsoft PowerShell, JYTHON, AppDynamics, Zabbix, SolarWinds, Zabbix, SolarWinds, Neustar and Splunk.

Additional Requirements

Minimum of 4 years of Oracle production support DBA experience; specifically, RMAN, OEM, and RAC. Experience with LARGE multi-node RAC databases. Proven experience with Oracle 19c databases. Knowledge or experience with PostgreSQL. Must be flexible and willing to work on-call, overnights and weekends as needed.

Education

A minimum of eight (8) to twelve (12) years relevant experience. A degree from an accredited College/University in the applicable field of services is required. If the individual\'s degree is not in the applicable field, then four additional years of related experience are required.