*Hi,*
*Reply back to [email protected] <[email protected]> for further process.* *Job Title: Oracle DBA - Onsite Contract.* *Duration: 2-3 Weeks Engagement * *Location: Grand Rapids MI * 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 Amway 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. -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/corptocorp. For more options, visit https://groups.google.com/d/optout.
