Oracle DBA

Atria Group LLC
Monroe, United States of America
2 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 100K

Job location

Monroe, United States of America

Tech stack

Query Performance
Data analysis
Databases
ETL
Data Warehousing
Database Design
Oracle Exadata
Metadata
Microsoft SQL Server
Oracle
Oracle Applications
Oracle Rac
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).

Apply for this position