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.
Duties and 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:
o Upgrade, install, patch, and remediate vulnerabilities in Oracle RDBMS products and services on Linux servers.
o Manage and maintain a complex Oracle RDBMS production environment.
Oracle eBusiness Suite Support:
o Upgrade, install, patch, and remediate vulnerabilities in Oracle eBusiness Suite applications on Linux servers.
o Ensure the integration and performance of Oracle eBusiness Suite with other systems.
o Troubleshoot and resolve issues related to Oracle eBusiness Suite.
NoSQL Database Support:
o Understand the complexities of NoSQL databases in scalable, high-performance applications.
o Work with NoSQL databases such as Cassandra.
o 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 Post Gres SQL
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 is required.
Never miss an opportunity! Create an alert based on the job you applied for.
