Database Development & Administration Lead

Visa Sponsored Job:

Relocation Assistance Eligible:

Job Location:

Position Type & Term:

Salary Range $109,097 - $136,370

*Final salary and rates are based on education, experience, skills relevant to the role.*

Job Location:Boulder, Colorado

Application Deadline: This position will be posted until 11:59 PM on Friday, August 22nd.

Required application materials: (preferably in PDF Format)

Resume/CV

Cover Letter - Please address how your skills and experience meet the needs of this position (for more information, please refer to the Key Responsibilities and Knowledge, Skills, and Abilities sections of this job posting). Additionally, please respond to the following questions within your cover letter. Applications that do not address these questions will not be eligible for further consideration:

• This position includes supervisory responsibilities. Please describe your approach to managing and mentoring technical staff. How have you supported the professional development of your team, particularly in areas such as systems integration, data management, and application support?
• Briefly describe a successful technical project you led recently. How did you communicate complex data concepts to non-technical stakeholders, collaborate across functional teams, and ensure alignment with broader enterprise IT objectives?

Background Checks: Conducted for candidates selected for hire. Learn more.

Work Location: Regardless of flexible work arrangements, UCAR requires ALL positions to be performed within the U.S., excluding U.S. Territories.

Here is a brief summary of what one would expect to be generally responsible for in this role.

• Technical lead on project teams to support functional design, document and understand database requirements for data and integration related projects.

• Lead the creation of processes, procedures, and scripts to migrate data and/or perform ETLs using integration software

• Maintain coding standards, a consistent code base in conjunction with best practices and with the use of source control for all data objects

• Lead the development of data integrations between cloud applications and internal data hub for use with internal applications

• Lead data architecture initiatives to support analytics and reporting requirements

• Design and develop efficient, functional data structures and data processes for data migrations to cloud platforms

• Team with application developers for scheduling/design of API data integrations via Mule

• Production monitoring and support of data-related jobs

• Provide ongoing supervision, development, coaching, mentoring, and learning experiences for the database integration team.

• Lead database integration team meetings and 1:1 meetings with staff

• Provides daily direction and prioritization of support related tasks including data system tasks

• Sets goals, delegates tasks, monitors productivity, and provides feedback and coaching.

• Ensures application support goals and objectives are met.

• Train users on developed models, answer and respond to user support questions.

• Backup DBA support and maintenance tasks on SQL Server / SSIS ETL platforms.

Successful candidates will ensure their application materials speak to the following criteria:
Education and Experience (Required/Desired):

• Bachelor's degree in computer-related field and extensive and progressive relevant experience, which is typically gained by eight to twelve years of experience in database administration including experience in developing integrations and related applications and writing scripts, or an equivalent combination of education and experience.

Desired, but not required:

• Knowledge of financial accounting systems and their relational database structures and concepts.
• Knowledge of financial and business environments, including fund accounting and contract/budget monitoring environments.

Knowledge, Skills, and Abilities (Required/Desired)

• Advanced skills and experience in relational and multidimensional DBMS on SQL Server

• Demonstrated skill and experience with ETL tools such as Microsoft SQL Server Integration Services

• Advanced skill and experience with data warehouse methodologies, design and analysis

• Advanced data migration, data conversion and cloud application migrations

• Experience with source control technologies such as Github

• Ability to convey complex concepts to others of various technical backgrounds.

• Strong communication and team building skills with all levels of project teams, technical and non-technical

• Solid database programming skills in TSQL including design and implementation of complex stored procedures, views for use in meta data driven processes

• Strong skills and experience in preparing data for use in reporting writing tools such as Cognos, Power BI, or Workday Report Writer

• Understanding of data interface characteristics and complex database management

• Strong ability to prioritize tasks at the team level to meet objectives

• Demonstrated supervisory skills including providing coaching, mentoring, and performance feedback to direct reports

UCAR affirms its commitment to employees through competitive benefits. In addition to medical, dental, vision, retirement, and life insurance, UCAR offers a variety of programs focused on work-life balance and professional, and personal development. These include:

• Tuition Assistance, time off allowance to attend classes, and other professional development opportunities

• UCAR contributes 10% of your eligible pay into your retirement account; 100% fully vested on day one

• Starting minimum accrual of 20 days of personal time off each year (prorated for less than full-time positions)

• 10 paid holidays

• 10 days of sick leave each year

• 12 weeks of paid parental leave

• Short-term medical leave paid at 100% of your regular salary

• EcoPass for local Colorado residents to use the Denver and Boulder-area transit system at no cost

Applicants are not required to provide age or age-related information and may redact information related to age, date of birth, or dates of attendance at or graduation from an educational institution from any submissions during the initial application process.

At NSF NCAR| UCAR | UCP, you will work alongside a dedicated team of professionals conducting critical research and community outreach to solve complex Earth system science problems including climate change, air pollution, extreme weather, floods, drought, wildfires, and space weather, all with the goal of improving human life and reducing economic loss. Each of us, from scientists to the professionals who support their work, serves the public and a collaborative community of scientists in our mission to understand the complex processes that make up the Earth system, from the ocean floor to the Sun's core.

Flexible Work

At UCAR, we are committed to supporting our mission by giving staff the flexibility to find the schedule and location that works best to maintain their own work-life circumstances and reach their full potential as professionals. Many positions within our organization are eligible for fully on-site, hybrid (three days per week) and/or flexible work hours.

Equal Opportunity Employer

UCAR is committed to providing equal opportunity for all employees and applicants for employment and does not discriminate on the basis of race, age, creed, color, religion, national origin or ancestry, sex, gender, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or pregnancy.Whatever your intersection of identities, you are welcome at UCAR.

Export Control

All positions are required to comply with U.S. export compliance regulations work location requirements regarding access to facilities and research systems.

Visa Wait Times

Please consider the length of visa procurement when applying for this posting, understanding that you will not be able to begin employment until you are able to get a visa and enter the U.S.

Work Location

UCAR requires ALL positions to be performed within the U.S., excluding U.S. Territories.

AI Software

ChatGPT and similar AI software are powerful tools that are changing theway society receives, processes, and leverages information promptly. While we acknowledge its benefits and do not restrict leveraging it with job applications, we highly encourage a majority of the applicant material to be original work.