Job Opening: Sr. Database Administrator

Company
APPLICATION ENGINEERING GROUP, INC.
Location
Saint Louis, MO
Posted on
April 21, 2024

Design, administer, upgrade and maintain large Oracle database in HP-UX, IBM-AIX and Linux environments with Oracle RAC/ASM. The specific duties include: (1) Perform physicaldatabase design, database space needs and growth analysis; and load data from flat / XML files to temporary tables in Oracle database using Perl, SQLPlus and SQLLoader; (2) Create,maintain and refresh required instance for development, test and production; (3) Monitor security breaches, error logs, database / log space, user activity and resource utilization; (4)Perform SQL coding and assist developers with PL/SQL procedures including areas of functionality and performance; (5) Manage database structure, storage allocation, table/index androll back segments, constraints, database access, roles and privileges; (6) Design and implement effective hot backups using RMAN / recovery strategy for database / archive logs / logicalbackups; (7) Create different types of indexes and partitions on different tables; (8) Monitor objects / events throughout the database using TOAD and Oracle Enterprise Manager (OEM) to maintain peak performance; (9) Perform database import/export to transport various objects, changes and updates across environments using DATAPUMP; (10) Coordinate with Linuxsystem administrators for OS patches / servers maintenance; and (11) Write complex Linux Shell scripts to manage and automate Oracle environment and application process.

This data is delivered by an API from CareerOneStop external site, sponsored by U.S. Department of Labor, Employment and Training Administration. Job postings come from NLx external site, by the National Labor Exchange, which is co-sponsored by the Direct Employers Association external site and the National Association of State Workforce Agencies external site.