Laboratory Corporation of America Senior Oracle DBA (Raleigh / Durham) in Burlington, North Carolina
Management of large databases on Oracle -- including installation, design, configuration, backup & recovery, performance analysis, tuning, capacity planning/forecast and security.
Actively monitor the database environment to ensure optimal performance and to prevent production issues.
Administration of ASM and Grid Infrastructure for RAC, Oracle Restart, Clusterware.
Oracle Exadata deployment, administration experience. Oracle Exadata patching experience is required.
Setup, configuration, troubleshooting Data-Guard Physical/logical and Active Data Guard.
Backup and recovery and migration using RMAN, datapump and export/import.
Proactively monitor and optimize system performance using tuning, optimization, AWR, ASH, and other methods.
On-Call Support on a rotational basis -- including Off-Hours and Weekends.
Collaborate with DBAs, Developers, and Architects in troubleshooting database and application errors.
Collaborate with Data Architects on data modeling using tools such as E/R Studio.
Review Oracle SQL query, DDL, DML including stored procedure, packages before deployment.
Provide support for database/application deployments.
Design, automate and document new processes to improve efficiency of Database Services.
Provide training in areas of specialization to other team members.
Must be a team player with excellent collaboration and people skills to be able to engage in productive group discussions.
Excellent verbal and written communication along with the ability to articulate technical solutions for various levels of management and technical staff.
Ability to interface with users at all levels of the organization and good end-user support skills.
Oracle DBA with 8+ years' experience in a mission critical production database environment, including:
Oracle 11g, 12c and 19c
Oracle Exadata (2+ years)
Real Application Cluster (RAC), Grid Infrastructure, Oracle Clusterware. (4+ years)
Oracle Multi-tenant architecture e.g. container and pluggable database. (2+ years)
Strong Unix scripting skills
Oracle 19c Grid (OEM), OMS Administration
Recovery Manager (RMAN) database backup, recovery and cloning.
Dataguard Active/Passive, Physical/Logical.
Performance tuning, troubleshooting including SQL Tuning
Installs, upgrades, patching including Bundle Patches, fleet patching experience.
Preferred Skills and Experience
Familiarity with Toad, DBArtisan and E/R Studio.
Oracle Database Appliance (ODA) administration.
Experience in Healthcare Industry.
Oracle Certification -- OCP (19c), OCA
As an EOE/AA employer, the organization will not discriminate in its employment practices due to an applicant's race, color, religion, sex, national origin, sexual orientation, gender identity, disability or veteran status.