Oracle DBA - PLSQL

Role: Oracle DBA PLSQL

Location: OFallon St. Louis MO Day1 Onsite

Hire Type: Contract

Mandatory Required Skills:: L7 Oracle DBA with PLSQL development skills

Job Description:

• Install configure upgrade and manage Oracle database systems Oracle 12c 19c
• Strong Experience in managing large databases partitioning Data warehouse experience
• Configure / Troubleshoot Oracle replication (Oracle GG)
• Handson knowledge in Oracle DB Migration
• Monitor servers through Oracle OEM
• Proficient in backup & restore methodologies Tuning databases refreshes Reorgs and script writing.
• Apply patches Proficient in managing RAC cluster and DataGuard databases.
• Coordinate with various teams and customer to schedule database activities
• Maintain detailed documentation of DBA processes and procedures.
• Experience in executing DR activities database upgrades and patching along with all the regular database maintenance activities.
• Accountable for performance and capacity management for databases
• Should have worked with backup appliance zfs & zba configuration.
• Experience with Linux OS
• Remediation of Security Vulnerabilities
• Developing PL/SQL packages functions and procedures for data loading transformation and extraction
• Implementing procedures to install and deploy large numbers of Unix/Linux servers.
• Using database objects to improve applications troubleshoot and optimize database performance.
• Creating and maintaining database objects using SQL
• Designing and developing database schemas functions stored procedures and triggers using PL/SQL