Database Administrator

$100,770 - $141,079/Yr

Unclassified - Loveland, CO

posted 2 months ago

Full-time - Mid Level
Remote - Loveland, CO
501-1,000 employees

About the position

Our Database Administrator contributes to the overall mission and values of the City of Loveland's Information Technology Department by providing high quality service, with an innovative perspective, aligning City initiatives with service delivery methods as a partner to users. This is accomplished by configuring, maintaining and supporting the City's relational database client/server software along with creating reports based on data within the City's databases. The position plays a central role in the Information Technology Department's culture of collaboration, coordination and accountability using effective communication and problem solving skills. The salary range for this position is $100,770 to $141,079 annually, with a hiring range of $100,770 to $120,924 annually. This is not a remote work opportunity. This is an Onsite position. All functions of this job will be performed primarily in office. This opportunity will be available until Friday, September 6, 2024 at 3:00pm MT. A current resume is required, and a cover letter is preferred. This is a great opportunity to be part of a thriving technology team, responsible for a large portfolio of applications that provide support for a broad range of city services. This position will be the City's primary Database Administrator for the organization's enterprise and departmental applications. Our Database Administrator will work across the whole organization, serving a variety of departments and customers, including Finance, Human Resources, Water, Wastewater, Electric, Public Safety, and Pulse, creating a varied and exciting work environment.

Responsibilities

  • Collaborates with other Department representatives to provide technology services.
  • Maintains and supports all SQL Server relational databases city-wide through multiple product lifecycle environments, from development to mission-critical production systems.
  • Configures and maintains database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Performs scheduled maintenance and supports release deployment activities, often after hours.
  • Has experience supporting systems as a technical lead or systems analyst.
  • Integrates data from other sources such as MS Access, MS Excel, CSV files, text files, etc. into databases.
  • Independently analyzes, solves, and corrects issues in real time, providing problem resolution end-to-end.
  • Provides backup and recovery processes on relational databases.
  • Performs services such as batch processing, tuning, archiving, installing upgrades to test and production database environments.
  • Assists others with complex query development and schema refinement.
  • Automates and refines regular processes, tracks issues, and documents changes.
  • Maintains database integrity in accordance with City standards.
  • Administers database level security.
  • Maintains appropriate levels of licensing for assigned software and systems.
  • Coordinates contacts with departments, vendors, and/or IT staff regarding database performance, access and security.
  • Evaluates user/application needs in relation to database enhancement/modifications and coordinates implementation with staff or vendors.
  • Conducts research and performs needs assessments related to databases.
  • Recommends database upgrades related to hardware and software.
  • Prepares detailed database system specifications and Requests for Proposal requirements.
  • Works with IT staff to upgrade existing and install new line-of-business database applications.
  • Shares domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Performs other duties as assigned.

Requirements

  • 4 Year / Bachelors Degree in Information Systems or related field.
  • 6 years of extensive experience in information technology, with a focus on supporting and managing technology environments with larger, interconnected applications and systems in mid to large organizations.
  • 2 years of experience in administering Microsoft SQL Server.
  • 2 years of experience in developing enterprise reports, preferably using SSRS (SQL Server Reporting Services).
  • MCTS/MSCA and MCITP/MSCE certifications are desired.
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Experience with backups, restores and recovery models.
  • Ability to develop and support reports created in SQL Server Reporting Services (SSRS).
  • Intermediate to advanced knowledge of SQL Scripting Language.
  • Ability to code and alter code in SQL.
  • Ability to work with, assist and sometimes train other team members in areas related to database structures and SQL code manipulation.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
  • Experience working with Windows Server, including Active Directory, and Windows Updates.
  • Experience with Power BI.
  • Experience with scripting languages.
  • Demonstrated experience in application support up to the Systems Analyst level.
  • Experience with Microsoft Access application development.
  • Organize and plan work independently.
  • Work in a rapidly changing environment, flexible, team player.
  • Multi-task and context-switch effectively between different activities and teams.

Nice-to-haves

  • Experience with Power BI.
  • Experience with scripting languages.

Benefits

  • 401(a)
  • AD&D insurance
  • Dental insurance
  • Disability insurance
  • Employee assistance program
  • Flexible spending account
  • Health insurance
  • Paid vacation
  • Paid holidays
  • Medical leave
  • Life Insurance
  • Short-term and Long-term disability
  • Voluntary Critical Illness Coverage
  • Retirement 401a, 457, Roth (pre-& post tax) and company match
  • Comprehensive Employee Assistance Program
  • Voluntary 529 College Invest program
  • Tuition Reimbursement
  • Personal and Professional Development opportunities
  • Discounted recreation passes
  • Employee recognition program
  • Exceptional work-life balance
  • Market based pay & regular performance reviews
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service