| |
Position: Scientific Data Administrator
Position ID: AD-A122-488
The Samuel Roberts Noble Foundation is seeking a Scientific Data Administrator to be responsible for identifying database and data warehousing requirements, creating implementation plans, and developing solutions which support the computational and storage needs of the scientific staff. Plan, recommend, and support data warehouse analysis, design, development, and deployment projects in a cross-functional team environment. Design end user interfaces and reports. Develop tools, applications, and best practice guidelines for data loading and extraction into and out of the warehouse. Monitor system performance and capacity management attributes. Support underlying storage infrastructure and database environment.
Minimum Requirements
•B.S. in Computer Science or related field.
•5+ years relevant work experience in data warehousing or ETL technologies with direct responsibilities for providing system designs and implementations.
•Database infrastructure design, data validation, and performance tuning in a warehousing environment.
•Systems management skills for related devices and technologies such as NAS devices, and SANs.
•Detailed understanding of one or more leading data warehousing solutions (Oracle, SAS, SAP, etc.).
•Experience with data modeling, dimensional modeling, and data mining processes/technologies.
•Prior application of biological data standards such as MIAME, MIAPE, and MSI in a database or data warehouse based environment.
•Experience with software development practices and tools (IDEs, source code control systems, etc.).
•Programming experience in C, C++, PHP, ASP.NET, or Java.
Preferred Requirements
•M.S. or Ph.D. degree in Computer Science.
•7+ years work experience in data warehousing or ETL technologies.
•Experience in developing biologically-focused database or data warehouse systems.
Application Instructions: Applicants are requested to apply online by completing the application and submitting a resume, copy (s) of college transcripts, contact information for three references (excluding relatives), and a cover letter explaining interest in the position and career goals. If applicant does not have the ability to upload the additional documents they can be faxed to (580) 224-6240 (please include position number), but the application should be completed and submitted online. Applications will be accepted until a candidate is hired. Interested applicants should apply immediately.
The Samuel Roberts Noble Foundation, Inc.
Human Resources Department
Position Number: AD-A122-488
P.O. Box 2180
Ardmore, OK 73402
Website: http://www.noble.org/
The Samuel Roberts Noble Foundation, Inc., is an Equal Opportunity Employer and will consider all qualified applicants for employment, regardless of their race, color, creed, gender, national origin, age, disability, or veteran status.
|
| |
Job Summary
Responsible for identifying database and data warehousing requirements, creating implementation plans, and developing solutions which support the computational and storage needs of the scientific staff. Plan, recommend, and support data warehouse analysis, design, development, and deployment projects in a cross-functional team environment. Design end user interfaces and reports. Develop tools, applications, and best practice guidelines for data loading and extraction into and out of the warehouse. Monitor system performance and capacity management attributes. Support underlying storage infrastructure and database environment.
Essential Functions (95%)
Database and Data Warehouse Design and Development (75%)
•Partners with cross-functional development team members to develop database and/or data warehouse solutions
oTranslates scientific requirements into technical requirements
oDevelops implementation plans
oCreates test plans; reviews post-test activities for plan compliance
Works with management and technical staff to outline acceptance criteria
oDevelops software solution/system which meets design and performance needs of scientific staff
•Employs best practices in database design, software development, and capacity management
•Develops system and end-user documentation
Storage Infrastructure Management and Support (25%)
•Manages configuration, operation and system software support for NAS devices supporting the data warehouse
oCreates storage aggregates/pools
oManages underlying drive allocations
oUpgrades operating system software
•Interfaces with systems administration staff for SAN-related support activities
•Cooperates with end users, system administration and Scientific Computing staff to resolve functional and performance issues
Non-Essential Functions (5%)
•Other duties as assigned
Organizational Relationships
Reports to: Director of Information Systems
Supervises: None
Requirements
Education: Bachelor’s degree in Computer Science or related field.
Experience: 5+ years.
License/Certification: None required
Other Knowledge, Skills and Abilities
•Excellent written and verbal communications skills.
•Detailed knowledge of database and data warehouse related technologies.
•Detailed knowledge of database design and data modeling standards.
•General knowledge of enterprise software systems such as MS Exchange and MS SQL.
•General knowledge of networking hardware and protocols.
•Broad knowledge of industry standards and practices.
Physical and Mental Requirements
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The requirements below refer to regular, daily activities.
Physical Requirements
Lifting & Carrying: Must be able to lift up to 50 lbs.
Pushing & Pulling: Must be able to push and or pull carts with computer equipment of up to 100 lbs.
Body Positions: The job requires physical conditioning to sit for prolonged periods of time. Must be able to walk and stand for short periods of time.
Body Movements: Must be able to bend, stoop and reach.
Hand Use: Will use fingers to make precise coordinated movements when using a computer keyboard.
Senses: Will use vision to read computer screen, reports, instructions, etc.
Hearing: Must be aware of and able to hear noises associated with computer malfunctions.
Vision: Must possess visual acuity for doing complex computer processing and see detail at close range.
Work Environment: Work is regularly performed in an indoor office setting and the noise level is moderately quiet.
Mental Requirements:
Mathematics: Analyze and solve problems; Use math and mathematical reasoning
Language ability: They will regularly communicate with others to convey or receive information and express ideas; therefore, they must understand the speech of another person, and speak clearly so others can understand.
Reasoning: Employees in this classification must apply principles of logical or scientific thinking to define problems, collect data, establish facts, and draw valid conclusions. Work requires that employees deal with several abstract and concrete variables and order information into a logical sequence.
Other Requirements:
• Must interact with others in the spirit of teamwork, cooperation and helpfulness.
• Must be able to track several tasks simultaneously, complete tasks promptly.
|
