Database Administrator III

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, No

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

• 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 No
  
  SQL databases such as Cassandra. This role requires a deep understanding of database technologies and the ability to manage and optimize both relational and No
  
  SQL 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.
• No
  
  SQL Database Support:
• Understand the complexities of No
  
  SQL databases in scalable, high-performance applications.
• Work with No
  
  SQL databases such as Cassandra.
• Handle database patching, design, vulnerability remediation and write complex queries on Windows and Linux servers.

• Proven experience in managing Oracle RDBMS, Oracle eBusiness Suite, and/or No
  
  SQL 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.

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, Wild Fly, Oracle Fusion Middle Tier (OFM), IBM Web Sphere, Apache HTTP, Kubernetes, Docker and other types of containers, IBM MQ, Kafka, Zookeeper, Red Hat Open Shift, Rancher, Ansible, Google Cloud Platform, Microsoft Azure, Linux shell scripting, Microsoft Power Shell, JYTHON, App Dynamics, Zabbix, Solar Winds, Zabbix, Solar Winds, Neustar and Splunk.

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 Postgre

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

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.