Hi Partner, Please reply to [email protected] <[email protected]>
*Position : Sr. Oracle Datawarehouse DBA * *Duration : 1 year* *Location : Atlanta, GA * *Market Rate* * * Seeking an experienced professional for the position of Senior Oracle Data Warehouse Database Administrator to support the Data Warehouse Project. This incumbent to this position will work with the business analyst to design and implement processes for sourcing data from various internal as well as external sources leveraging Operational Data Store and Data Mart concepts to facilitate timely, reliable and secure delivery of Data driven reports and analytics. * * *Qualifications**:* · Minimum *8 years Oracle database experience*, with at least 2 years in supporting data warehouse environment · Must have excellent understanding and skills in relational database modeling · In-depth knowledge of star and snowflake schemas/dimensional modeling and data warehouse methodology · Must have hands-on experience in data warehouse schema design and implementation · *Oracle 11G* experience is required · *Must have experience in Oracle Warehouse Builder, ODI and OBIEE * · Advanced PL/SQL skills are required · Demonstrated experience with applying CPUs and Patch Sets · Demonstrated experience with Unix shell scripting · Desired experience upgrading from Oracle Warehouse Builder to ODI · Demonstrated experience involving strong communications skills (written and verbal), proven ability to effectively interact with individuals across multiple teams · Must be self-motivated, have a strong team orientation, learn quickly * * *Duties and Responsibilities* · 24*7 support for mission critical production Oracle databases · Working closely with development team to clearly understand the business applications and databases supporting the applications · Logical design of the warehouse: schema design, ETL processes, data archival, etc. · Physical design and implementation of the warehouse on Oracle 11G, with clustering · Knowledge in database replications (Golden Gate or streams) · Good Knowledge in partitioning and materialized views. · The Oracle warehouse database administration including monitoring, backup/recovery, performance tuning, changes, and capacity planning, etc. · Support the ETL group in their efforts to implement and maintain ETL procedures and schedules to ensure the accuracy and timeliness of data in the data warehouse · Ensure the quality, consistency and security of the data warehouse systems following a defined set of procedures and policies (change control, security procedures, backups, etc.). · Assist report writers in query performance tuning as requested. Help identify inefficient queries and suggest alternatives. Write PL/SQL packages and stored procedures as needed · Participate in database schema design sessions with other production DBAs to ensure seamless coordination of changes between production databases and data warehouses. · Actively address business unit requests, clearly communicating commitments, issues, completion dates and status with the requestor and with management. Please send the updated resume of the consultant along with the rate, location and contact information. Please make sure the Consultant's skills match the requirement. After reviewing the resume I will contact you if I need more information. *Thanks & Regards…* * * *Anand Bandarupally* *Direct: 703 463 9044 | Fax: **866 594 4637** StanSource Inc. **22375 Broderick Drive, Suite 135******, **Dulles****, **VA **** **20166*** *[email protected]** | **www.stansource.com* <http://www.stansource.com/> ** *.**http://www.inc.com/inc5000/profile/stansource*<http://www.inc.com/inc5000/profile/stansource> *** **Fastest-growing private companies of US : #445 | IT services : #49 | Washington DC: #*46* * * * *We respect your Online Privacy. If you like to receive only hot list please reply Hot-List in subject. If you like to receive only Requirements please reply Reqs in subject. If you like to receive Hot list and Requirement please reply Both in subject. IF you don’t like to receive mails please reply REMVOE. We are sorry for the inconvenience. Please don’t unsubscribe let us update our list for mutual benefit.*** -- You received this message because you are subscribed to the Google Groups "SAP ABAP" 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 http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/groups/opt_out.
