IT Database Specialist

Job description / Role

Aviation, Airlines & Aerospace

Position description

Troubleshoots issues related to Oracle ERP functionality and performance. Works with Oracle support on Oracle service requests (SR's).

Major areas of responsibility

Audits the current environments to ensure ERP application security. Defines metrics to monitor policies, procedures, and standards relating to database management.

Creates and maintains Oracle databases for test and development as well as production environments. Analyzes, tests, and implements physical database design supporting Oracle 12i applications.

Implements system requirements relative to database and server needs, analyzes transactions and data volumes, and designs and develops complex databases and applications.

Serves as the technical expert in eBusiness Suite applications, liaises with the functional and user teams.

Works with Oracle customer support on critical issues and ensures the operational uptime of the Oracle ERP applications systems.

Reviews technical documents for completeness, correctness and accuracy.

Develops quality entity relationship diagrams, database normalization schemas, logical to physical database mapping, data table parameters and other database architecture.

Monitors file system space, database allocation, and data integrity; verifies efficient use of disk storage, reclaims dead space, optimizes space allocation and avoids out-of-space conditions.

Maintains a backup and recovery strategy for all databases.

Provides daily Oracle ERP and database technical administration and support, including processing change management requests, monitoring, performance tuning and database cloning.

Performs software upgrades and patches of Oracle ERP applications and Oracle. Strategizes and plans the installation and configuration of Oracle tools including Oracle Enterprise Manager (Grid Control), Oracle Real Application Cluster (RAC), Automatic Storage Management (ASM).

Provides periodic reviews of database engine performance and monitoring levels and takes appropriate action to rectify problems. Strategizes and plans performance enhancements and improvements using best practice ERP hardware and software implementations as a guideline.

Participates in the evaluation and recommendation of DBA tools and new DBMS technologies.

Develops database documentation and standards.

Maintains current knowledge of Oracle ERP and IT database trends and methodologies.

Performs controlled change management for databases in a multiple hardware/software/network environment.

Assists with sizing of server hardware, network, database and storage based on specific environment conditions.

Assists with documenting Oracle environment configurations (software versions, custom code versions and applied patches).

Formulates Oracle ERP security architectures for internal and public facing server components.

Performs Oracle application printer setup.

Assists with monitoring and tuning of other non-Oracle databases.

Assists in database and application troubleshooting as needed.

Supports critical systems after hours, nights and weekends as needed.

• Designing and implementing load balancing of form servers and database server.
• Maintaining, patching and upgrading Oracle ERP Applications 12i and Oracle 11g.
• Configuring SSL in Oracle ERP Applications.
• Enterprise Manager (Grid Control), Oracle Real Application Cluster (RAC), Advanced Storage Management (ASM) and Oracle Data Guard tools.
• Oracle OEM including tuning pack, change management pack and diagnostics pack.
• E-Business applications system administration and application security: user accounts, custom menus, custom responsibilities, printer setup and concurrent managers.
• Database application, architecture and tools including state-of-the-art concepts, design, deployment, recovery techniques, performance monitoring and tuning, structured query language, PL/SQL, relational database design techniques, RDBMS-specific monitoring tools, and cross-platform networking in a TCP/IP environment.
• Infrastructure components necessary to maintain and monitor applications such as operating systems, storage units and networks including AIX/Linux operating system, PL/SQL, Windows OS, OLTP/DSS design and tuning, RAC, Data Guard, J2EE persistence solutions and XML, NAS/SAN, Toad, Oracle reporting techniques, shell scripting, identity management, provisioning and enterprise SSO concepts, BI and OLAP.
• Multi-tiered application architecture of Oracle E-Business Suite.
• Relationship development skills with both technical and non-technical personnel.

• 3 to 5 years experience in Oracle Database Administration with hands-on experience in Oracle Database 10/11g RAC administration.
• Oracle e-Business Suite 12.1.3, Hyperion version 11.1.2.3.
• Administration of Oracle applications 12.1.3.
• Significant advanced level experience in design, administration, installation, and support of Oracle.

Apply Now