Data Warehouse DBA

Data Warehouse DBA Job Number 08793 2 positions availableProgrammer Analyst Spec, band G - exemptCornell Information Technologies (CIT)/Information Systems (IS)Reports to: Data Warehouse DBA Team LeadOverviewThe Cornell Information Technologies (CIT) Data Warehouse Database Administrators (DW DBA's) Team is responsible for data warehouse technical architecture planning and implementation for Cornell University.  Job DescriptionWe are looking for demonstrated experience in data warehouse design, deployment and support with a focus on the DBA role.  Provide leadership in Oracle RDBMS technology, performance tuning, and establishing best practices. Work with analysts and business area subject matter experts, including managers and executives to translate operational, decision support and EIS information requirements into logical and physical data models.  Plan and manage the implementation of data marts and data warehouses that satisfy those requirements.  Support the evolution of those data repositories as business information requirements change.  Mentor less experienced staff in best practices.QualificationsBS or equivalent experience. Demonstrated experience in data warehouse design, deployment and support with a focus on the DBA role. Position does participate in a 7x24 on call rotation.  Candidate must have minimum 5 years of Oracle DBA experience, Oracle RAC experience desirable.   Able to interpret customer specifications and implement project plans for satisfaction of requirements.   Maintain currency on industry best practices, and apply them to projects at Cornell.  Work with analysts both within and external to CIT to develop solutions for the university.   Provide leadership in Oracle RDBMS technology, performance tuning, and establishing best practices. Using Oracle technologies provide proactive monitoring to ensure high availability, performance, and throughput for data warehouse environments.  Candidate should have experience with Oracle datawarehouse technologies, implementation projects, SQL tuning and replication technology.  Candidate should have a good understanding of physical database design.  Candidate should have experience with data modeling and Kimball methodology.Strong oral and written communication skills including ability to obtain and convey complex technical/service information to others of varying levels of technical knowledge and responsibility essential. Must be able to work effectively and proactively in a dynamic, deadline driven, complex, team-based environment with multiple competing priorities. Must be able to demonstrate ability to work well with team members and assume individual responsibilities within a team. Must have strong documentation skills, being able to clearly and concisely explain complex technical issues in written and diagram format. Must have well-developed problem-solving abilities, analytical, reasoning and judgment skills. Responsibilities require tact and diplomacy with a flexible and positive approach. The person in this position will be expected to consistently model CIT's values (Respect, Community, Integrity, Innovation, and Results).No visa sponsorship is available for this position. Located in Ithaca, N.Y., Cornell University is a bold, innovative and inclusive teaching and research university of academic distinction and public service where staff, faculty, and students alike are challenged to be active citizens of the world.Cornell University is an equal opportunity, affirmative action educator and employer.

This position has been posted to the CU recruitment site. Interested applicants, please apply on-line at http://www.ohr.cornell.edu/jobs . Hard copy materials are no longer accepted. Click on the Staff (non-academic) and Librarian positions link.  To assist you in locating this position on-line, please note job number listed above.