Oracle DBA

Atria Group LLC

Monroe, LA, United States

4 days ago

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Compensation

$90,000.0 - $100,000.0

Working hours

Regular working hours

Job source

jobs.smartrecruiters.com

Tech stack

Query Performance Data Analysis Databases Extract Transform Load (ETL) Data Warehousing Database Design Oracle Exadata Metadata Microsoft SQL Server Oracle Databases Oracle (Applications) Oracle Rac

+6 more

Shell Script PL-SQL Grid Packaging Techology Change Data Capture Star Schema Sql Tuning

Job description

Lead in the team effort to design, develop, implement or maintain databases to accommodate user needs. Consult and collaborate with multiple teams to design database solutions, convert logical design into physical database, perform problem determination and resolution, and perform database design process and reviews.

Requirements

Bachelor degree or equivalent education and relevant experience required.
7 + years related experience. Required skills:
Both Oracle and SQL Server experience.
Basic development DBA experience.
Hands-on development DBA experience in the DWBI space.
Experience implementing DWBI large scale databases (2-10 TB or larger): ETL, DW Data Staging, DW Marts, and BI Tools/Analytics.
Experience with both Relational and Dimensional Data Modeling/Star schema and storage requirements based on the size of the data.
Experience defining and supporting table partitioning/sub partitioning options to support both business query performance and data roll off/archiving.
Experience implementing and supporting Oracle RAC 11g.
Experience administering 10g and 11g Enterprise Manager Grid Control environment.
Experience with PL/SQL and shell scripting.
Experience creating and reviewing project deliverables.
Proven SQL tuning skills.
Desired experience supporting databases on Oracle Exadata.
Desired experience with Informatica products (PowerCenter, Enterprise Grid, Change Data Capture, Metadata Manager).