VU Study: [Outsource:51077] Urgent Need – Oracle Data Warehouse DBA @ IN for 6 months

Friday, May 13, 2011

[Outsource:51077] Urgent Need – Oracle Data Warehouse DBA @ IN for 6 months

Trust you are doing well.

Please send resume to Christine@tammina.com only.

Indianapolis IN

6 months

This position reports to the Manager-Enterprise Databases, and will be responsible for the design, build and run support of large data warehouse Oracle databases (10gr2 and 11g). Will work closely with DWH project team and take up tasks that include, but are not limited to - database environment builds, code deployments, database backups, clones, and performance tuning, etc. Will provide expertise on database and code performance tuning, and will ensure developers and application teams have optimum environment in which to deliver applications.

. Responsible for 10g and 11g data warehouse environments' design-build-support.

. Responsible for performance tuning of data warehouse databases as well as provides guidance to developers/DW team by participating in performance tuning of code.

. Provide 24x7 production support.

. Participate in project meetings, understand deliverables and expected schedules, and deliver to schedule.

. Provide progress status reports on weekly basis to Manager.

. Responsible for database backup and restore, clone and environment refresh.

. Responsible for support activities like data loads and code deployment.

. Follow all relevant Standard Operating Procedures e.g. Change Management, Incident Management, etc. when performing tasks.

. Coordinate database system upgrades with DW/IT Teams.

. Develop, publish and maintain database operations documents under revision control.

. Perform other related duties as assigned.

REQUIREMENTS

. Bachelor's degree or related and an expert understanding and experiencing with Virtual Private Databases (VPDs), star schemas, CDC, Oracle Streams, use of Materialized views, partitioning

. Good knowledge and experience with ETL processes and tools, Oracle datapump

. Good working knowledge of 10gR2, 11gR1 and 11gR2 on UNIX/Linux platforms

. Good working knowledge of using Grid Control for monitoring and alerting

. Good working knowledge of ETL and Reporting tools like Business Objects

. Should be able to diligently follow build/deployment documents, standard operating procedures including build standards, run support, change control, and incident management

. Should have a good understanding of complex database architectures on UNIX and LINUX

. Should have proven capability in root cause analysis and reporting on the same

. Should have experience working on large projects interacting with senior application and project managers

. Should have excellent verbal and written communication skills

. Should have high energy level and a go getter attitude

Education/Qualifications Bachelor's degree or related

Experience Required

. Expert understanding and experiencing with Virtual Private Databases (VPDs), star schemas, CDC, Oracle Streams, use of Materialized views, partitioning