Oracle Database Administrator
Company
Labcorp
Location
Raleigh-Durham, NC
Type
Full Time
Job Description
We are seeking to hire a Oracle DBA to join an enterprise database team. Some of the technologies you will work with include Oracle 19c, Exadata, multi-tenant database, Oracle Encryption, RAC and more. Labcorp is a data-driven company where you can make a difference.
Principal Functions:
- Management of large databases on Oracle - including installation, design, configuration, backup & recovery, performance analysis, tuning, capacity planning/forecast and security.
- Collaborate with DBAs, Developers, and Architects in troubleshooting database and application errors.
- 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.
- 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 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.
- 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.
Required Skills and Experience:
Oracle DBA with 5+ years' experience in a mission critical production database environment, including:
- Oracle 11g, 12c and 19c, 21c
- Oracle Exadata (1+ years)
- Real Application Cluster (RAC), Grid Infrastructure, Oracle Clusterware. (2+ years)
- Oracle Multi-tenant architecture e.g. container and pluggable database. (2+ years)
- Strong Unix scripting and automation skills (2 years)
- 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
- Data Modeling
Preferred Skills and Experience
- Familiarity with Toad, DBArtisan and E/R Studio.
- Oracle Unified Directory/Centrally Managed Users with Active Directory integration
- AWS/RDS
- Ansible
- Liquibase
- JSON, Graph DB
- Oracle Database Appliance (ODA) administration.
- Experience in Healthcare Industry.
- Oracle Certification - OCP (19c), OCA
Labcorp is proud to be an Equal Opportunity Employer:
As an EOE/AA employer, Labcorp strives for diversity and inclusion in the workforce and does not tolerate harassment or discrimination of any kind. We make employment decisions based on the needs of our business and the qualifications of the individual and do not discriminate based upon race, religion, color, national origin, gender (including pregnancy or other medical conditions/needs), family or parental status, marital, civil union or domestic partnership status, sexual orientation, gender identity, gender expression, personal appearance, age, veteran status, disability, genetic information, or any other legally protected characteristic. We encourage all to apply.
For more information about how we collect and store your personal data, please see our Privacy Statement.
Date Posted
04/30/2023
Views
17
Similar Jobs
Senior Data Analyst - LingaTech
Views in the last 30 days - 0
The job description is for a Senior Data Analyst position that involves creating maintaining and tuning complex SQL scripts developing database soluti...
View DetailsLead Developer - Brightspeed
Views in the last 30 days - 0
Brightspeed is a company that aims to revolutionize internet connectivity in rural markets by upgrading copper to fiber optic technologies They are cu...
View DetailsAssociate Quality Control Analyst (Part Time) - DraftKings
Views in the last 30 days - 0
The text describes a job opportunity for an Associate Quality Control Analyst at a sports and entertainment company The role involves monitoring and v...
View DetailsSoftware Engineer IV (Generative AI) - Spectrum
Views in the last 30 days - 0
Spectrums Software Development Information Technology organization is seeking a Software Engineer IV to create software solutions that enhance custome...
View DetailsDevelopment Operations Engineer - Spectrum
Views in the last 30 days - 0
The text describes a job posting for a DevOps Engineer position at Spectrum a company that provides cable and mobile services to over 32 million custo...
View DetailsIBM ACE, MQ Integration Lead - Apigee (Multiple location Hybrid) - TMS LLC
Views in the last 30 days - 0
The Integration Lead role at IBM involves managing and developing IBM ACE MQ and Java production environments ensuring optimal performance and availab...
View Details