University of Colorado at Boulder University of Colorado CU Home Search A to Z Index Map

Lead Database Administrator

Posted on: Feb 27, 2014

The Laboratory for Atmospheric and Space Physics (LASP) at the University of Colorado Boulder invites applications for the position of Lead Database Administrator. LASP is a full-cycle, space institute, combining all aspects of space exploration through our expertise in science, engineering, mission operations, and scientific data analysis. The position furthers the LASP science mission by working closely with scientists, engineers, and other personnel to develop, deploy, manage, troubleshoot, and optimize relational databases that contain large amounts of scientific and non-scientific data in a production environment. LASP is a large, multidisciplinary research institute located in the rapidly developing CU-Boulder East Campus. 

Duties include server and database creation and maintenance, technical support, troubleshooting, software installation, and upgrades of LASP’s database systems, which primarily include Oracle, Sybase ASE, and Microsoft SQL Server. MySQL and PostgreSQL are used to a lesser degree at LASP, but will likely receive increasing use in the future. An interest and ability in database interface and application development is also desirable.

 Job Duties:

•Perform broad database administration duties for multiple relational database systems, including Oracle, Sybase, MySQL, and PostgreSQL.
•Architect, design, implement, maintain, monitor, and troubleshoot database systems and schema used for managing scientific and engineering data.
•Monitor database usage and performance, working with end users to evaluate and optimize as necessary.
•Develop and test SQL queries and stored procedures.
•Proactively assess and recommend appropriate tools and hardware/software upgrades
•Participate in the design and ensure the implementation of database API’s that balance developer needs and enterprise-level availability
•Work closely with scientists and engineers to translate needs into solid solutions and reliable results.
•Recommend and deploy tools and/or techniques for performing database promote/demote activities and maintaining short-term and deep archives.
•Present work at meetings and reviews; give oral presentations in both formal and informal settings.
•Supervise one or more student employees to support database administration tasks.

Requirements:

•Bachelors degree or higher in a physical science, computer science, or related field
•At least 5 years experience in enterprise database administration, and strong interest in applying experience to scientific and engineering applications
•Demonstrated experience with Oracle installation, setup, administration, usage, and troubleshooting in a UNIX/Linux environment. Experience with Sybase, SQL Server, MySQL, and/or PostgreSQL is a plus.
•Experience with database replication technology (e.g. SharePlex) is highly desirable
•Experience with large databases (over 500GB in size) is highly desirable
•Experience writing, optimizing, and troubleshooting SQL code and unix scripts.
•Applicable experience with configuration management processes and tools.
•Ability and willingness to prioritize and manage multiple simultaneous job tasks
•Ability to work within a team environment, but highly self motivated and able to work independently with minimal supervision
•Demonstrated ability to engage and work closely with colleagues and end-users
•Excellent written and verbal English communication skills. 

Applicants must complete the Faculty/University Staff and EEO Data (application) form, and upload the following required documents:
1 – Cover Letter
2 – Curriculum Vitae/Resume
3 – List of 3 References, including all contact information (NOTE: hiring unit will request an official letter of recommendation when appropriate in order to fulfill the requirements for the hiring dossier)
4 – Proof of Highest Degree Earned

The University of Colorado is an Equal Opportunity Employer committed to building a diverse workforce. We encourage applications from women, racial and ethnic minorities, individuals with disabilities and veterans. Alternative formats of this ad can be provided upon request for individuals with disabilities by contacting the ADA Coordinator at hr-ada@colorado.edu

The University of Colorado Boulder conducts background checks on all final applicants being considered for employment.

 

TO APPLY PLEASE CLICK HERE: http://www.jobsatcu.com/postings/79003

 

Due to ITAR restrictions, only US Citizens and Permanent Residents may apply.