PSADMIN.org

Sr. Oracle DBA - Contract to Hire

Reference

Job Type	Contract

Job Status	Sourcing

Date Posted	Wednesday, 08 October 2008

Location	PALO ALTO

Start Date	ASAP
Duration	6 months

Company Information	MindSource Mountain View, CA Website: http://www.mindsource.com/

Job Description	ONLY GREENCARD OR CITIZENS The successful candidate will have expert level knowledge and experience in all aspects of database & system administration such as backup and recovery, performance and tuning, installation, configuration, high-availability, version upgrades, host server and storage migrations in a very large database environment with special emphasis on Data Warehousing. This person will be responsible for leading, mentoring and training a team of database administrators and application administrators and work closely with application, systems operations and Infrastructure teams. This group manages the central data warehouse with plans for integrating data from the main ERP systems - Oracle and PeopleSoft, other central systems and the Legacy data stores. The group also manages the complete set of tools, Infrastructure and processes involved in the creation and Operation of the Data Warehouse. The group enables reporting of the data through a Business Objects Portal and BRIO reports. Responsibilities * Planning, developing, coordinating and managing both application and system changes, in addition to performing system-administration tasks in an Oracle & UNIX environment. * Provide on-going system administration and technical infrastructure support for administrative systems, including the deployment of new applications; complete management reports and performance analyses. * Review the physical design of existing databases for optimal database structures, database performance tuning, security, database backup/recovery strategy, implementing high-availability, and pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues, capacity planning, monitoring data growth and system utilization, trend analysis and predicting future database resource requirements. * Establishes and enforces processes to ensure a consistent, well managed, and well integrated data warehouse infrastructure. * Develop and enforce database administration standards. Participate in the development of standards and procedures for documentation, database programming, database security, backup and recovery, and application production implementations. * Works with Data Analysts and Application DBA to support optimal physical schema setups, tuning, capacity planning. Plans and oversees the technical transitions between development, testing, and production phases of projects. * Coordinate with DBAs and server administrators for system-software upgrades and patches with minimal interruption to services * Monitor database performance and proactively identify issues that may occur using monitoring tools * Develop and maintain database backup and recovery procedures & security audits. * Make recommendations for system changes or new systems software, based on cost and/or operational needs and benefits. * Assist in the evaluation and implementation of marketplace tools and utilities that enhance the database server environment. * Integrates previous technical, business and personal experience to solve problems, develop new development protocols, etc., where there is little or no precedent to guide the search for information and/or solutions * Propose technology solutions to business problems which result in higher operational effectiveness and service to internal and external customers * Conducts in-depth qualitative or quantitative analysis to solve problems, make recommendations and/or to discover new approaches or applications * Monitor, resolve or coordinate the resolution of trouble tickets. * Provide 24x7 on-call support, in rotation. Skills and Competencies * Extensive DBA experience (5-7 years) in VLDB and Data Warehouse environments is required. * Expert knowledge of Oracle databases including 9i and 10g. * Experience implementing data replication for high-availability and disaster recovery is required. * Experience with Real Application Cluster (RAC) is desired. * Expert level experience with Performance analysis/system resource management & tuning, STATSPACK, Tracing, OS tuning, partitioning, indexes, statistics etc. * Expert-level knowledge of enterprise backup/restore mechanisms is required. Knowledge of Oracle Recovery Manager (RMAN) and Oracle Data Guard. * Proficiency in PL/SQL programming and at least one high level programming language is required (preferably Java/J2EE). * Experience with Business Objects and BRIO system administration is desired. * Experience in Unix system administration, shell scripting etc. * Knowledge and understanding of large scale network storage concepts, architecture, and operations best practices. * Experience with storage technologies (EMC, NetApps) is desired. * Ability to multi-task and work in a team environment is critical and should have excellent Communication skills. * Knowledge on Oracle Grid Control is desired * Knowledge in Sybase and data warehousing tools like Informatica, Hyperion, Business Objects, Oracle OLAP etc is a plus * Understanding of the layers/tiers of web applications and the communication protocol between the tiers * Experience with Java Virtual Machine tuning desirable * Proficiency in scripting languages in a Unix and Windows environment are required * Strong knowledge of networking protocols (TCP/IP, HTTP, SSL, DNS, FTP, etc.) * Strong troubleshooting and problem solving skills * Ability to manage multiple competing priorities and work under pressure in high stress situations * Strong accountability and follow-through * Strong organizational and analytical skills; ability to logically and systematically approach complex problems and effectively advocate sound solutions * Ability to work effectively in a team-oriented environment * Effective verbal and written communication skills Qualifications Relevant Work Experience 10 years as an IT professional in one or more of the following areas: database administration, IT infrastructure and operations, systems analysis and design, application administration or application development 5 years as a System administrator/database administrator responsible for the operation, implementation and maintenance of enterprise wide systems preferably for Data Warehouses. Education Bachelors Degree in Computer Science, Engineering or related field or equivalent experience

Qualifications	Relevant Work Experience 10 years as an IT professional in one or more of the following areas: database administration, IT infrastructure and operations, systems analysis and design, application administration or application development 5 years as a System administrator/database administrator responsible for the operation, implementation and maintenance of enterprise wide systems preferably for Data Warehouses. Education Bachelors Degree in Computer Science, Engineering or related field or equivalent experience

Highest finished education	College

How to Apply	Click on "Apply for Job"




Go back to last page