Sr. Oracle DBA w/ ETL

Michigan, Grand Rapids-Muskegon-

Posted: 11/14/2018 Industry: IT Job Number: 12351

We have a need for an experienced DBA preferably with ETL and Data Warehousing experience. We are looking for a short engagement - 2 to 3 weeks - where they can work with my team to review and assess some performance problems we are having with our solutions. We need someone who knows about different approaches to managing large sets of data that can help us analyze the best options to pursue to alleviate our issues. These could be database practices such as re-organizing tables, or architectural solution changes such as altering the manner and sequence of our data operations - refresh and re-load, using views, etc.

The areas I would expect this expert to address with my team over the course of a 2 to 3 week engagement include:

: Review at a high level our current ETL and Oracle database architecture as it pertains to:
o Tablespace set up
o Back-up and recovery
o Logging and auditing of sql operations
o Data movement processes - i.E., how we are inserting and merging vs refreshing and reloading, our approach to storing history, etc
o Current practices to re-org tables
: Opportunities to establish better practices are in the area of all of the above items in addition to:
o Establishing partitioning or other techniques to better manage re-orging tables and executing backups
o Exploring the most efficient way to reload sales history from the Global Data Warehouse
o Best practices in general when dealing with very large sets of data - what SQL and ETL techniques might improve the performance of our solutions AND protect our data
Apply Online
Apply with LinkedIn Apply with Facebook Apply with Twitter

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.