Posted: 08/23/2011
UNAVCO, a non-profit membership-governed consortium located in Boulder, Colorado, facilitates geoscience research and education using geodesy.
Position overview
As a Database Analyst you will provide critical support to the Geodesy Data Archive functions while serving as the Database Administrator for multiple databases running on a variety of database engines (Oracle, Postgres/PostGIS, MySQL). You will collaborate with software engineers and scientists on schema requirements and design, and you will develop web tools and reports supporting distribution of data and metadata to our global network of researchers and data centers. We have opportunities for special projects to utilize your unique set of skills to help us build the next generation of tools for leveraging geodetic science to the next level.
Summary
The Database Analyst is responsible for database administration, schema design and maintenance for one or more company databases; standalone applications and web-based software to populate databases; and web applications and reporting tools to present information in databases. Depending upon experience, the Database Analyst may perform the role of lead Database Programmer and lead Database Administrator.
Essential Job Functions
· Serves as Database Administrator for the UNAVCO GNSS Archive Oracle database.
· Serves as Database Administrator for the UNAVCO SAR Archive MySQL and Postgres/PostGIS databases.
· Supports, modifies, and enhances the Oracle Forms tools used to populate metadata.
· Supports, modifies, and enhances a suite of PHP based web pages for data and metadata distribution.
· With other database staff, supports UNAVCO meetings, community, project, equipment, and financial databases and tools that utilize SQL Server RDBMS.
· Collaborates and consults with the Web Team on Web interface corporate standards, user-experience design, and Web site integration.
· To support database management system software, may install or coordinate with System Administration staff to install database management system software, new releases and upgrades, and supporting products. May manage software licenses. Creates and manages database schemas and objects. Depending upon experience, may establish database standards and procedures.
· Performs requirements gathering for moderately complex database schemas and applications. Designs and implements moderately complex database schemas and related applications.
· Designs, programs and implements web application and form access, data entry, and reporting tools for multiple databases. The applications and tools may be available to internal and external users.
· Continually works to acquire and improve skills relevant to program.
· Keeps abreast of current best practices and trends affecting database management systems and database applications software.
Skills and Knowledge
· Proficient in Oracle 10g database administration; proficient in Postgres/PostGIS 8/9 database administration.
· Proficient in SQL and its procedural extensions, especially PL/SQL.
· Proficient in Oracle Forms development.
· Experienced with spatial databases and spatial queries.
· Proficient in database schema design and relational database principles.
· Highly proficient in at least one primary programming language and knowledgeable in another.
· Proficient with integrated development environment and source code control systems.
· Proficient at establishing priorities and solving complex problems independently within a context of broadly-defined programmatic requirements; skilled in directing the tasks of others within a team.
· Excellent problem solving skills with all aspects of database administration, schema design and implementation, and applications development.
· Good interpersonal skills working with peers, supervisors, and in planning team-oriented projects.
· Desired: Experienced with Object-Relational Mapping techniques.
· Desired: Proficient in PHP and JavaScript development.
· Desired: Experienced with Subversion, ASP and jQuery.
· Desired :Knowledge of GPS, Geodesy, or Geology/Geophysics.
Education and experience
· Bachelor’s degree in Computer Science or Information Systems and four years DBA and Database Programmer experience OR equivalent combination of education and experience.
For nearly three decades, UNAVCO has spearheaded the utilization of cutting-edge technology while providing robust operational support for researchers exploring tectonics (earthquakes, volcanoes, plate tectonics), the deformation of ice, the Earth's response to ground water, sea level, and aspects of the hydrosphere, and atmosphere. Our instrumentation toolbox includes high-precision GPS, LiDAR (Light Detection and Ranging) for Airborne Laser Swath Mapping and Terrestrial Laser Scanning, InSAR (Interferometric Synthetic Aperture Radar), and more. We host the NSF’s Geodesy Data Archive and provide cyberinfrastructure to support the full data life cycle and interoperability with national and international Earth science Data Centers.
Our long-term success depends on development of a forward-looking, diversified workforce that draws on and cultivates talent across the demographic spectrum of gender and ethnicity, across international boundaries, and across scientific disciplines.
UNAVCO is an Equal Opportunity Employer committed to employing a highly qualified staff that reflects the diversity of our nation. UNAVCO does not discriminate on the basis of age, sex, sexual orientation, race, color, religion, national origin, veteran status, or disability where reasonable accommodations can be made.
All qualified applicants are encouraged to apply on-line at [url=http://www.unavco.org]http://www.unavco.org[/url]
