City of Durango
Database Administrator
City of Durango, Durango, Colorado, us, 81302
Salary:
$82,999.00 Annually
Location :
Durango, CO
Job Type:
Full-Time
Job Number:
2024-00129
Department:
Information Technology
Division:
Information Technology - 4122
Opening Date:
09/27/2024
Closing Date:
10/11/2024 11:59 PM Mountain
Schedule Details::
Monday-Friday 7:30am to 4:30pm, with frequent schedule variation for out-of-hours maintenance activities. This variation may include weekends and holidays.
Description
Shape and support the City of Durango's database infrastructure as our Database Administrator.
Working within our Information Technology (IT) Department under the broad supervision of the Business Applications Manager, you'll
maintain the resiliency and security of the City's databases . Your responsibilities will include designing, installing, configuring, and migrating data, as well as monitoring performance, troubleshooting issues, and fine-tuning databases for optimal performance. You will serve as the technical point of contact for City database users, applications, and third-party support.
In addition to your database administrative duties, you'll provide data analytical support to customers in collaboration with the IT applications team. You will also provide coverage for team members in system administration and general IT activities.Essential Job Duties
What You'll Do in This Role:
Create and maintain backups, alerts, reports, database integrity checks, and automated jobs.Perform backup recovery, clean up files, update stats, and review error logs.Monitor, audit, optimize, troubleshoot, and establish baselines using Database Management System (DBMS) tools and applications.Plan for DBMS configuration changes, system resources, and workloads.Install, configure, patch, upgrade, and manage DBMS and associated databases.Manage Structured Query Language (SQL) Server security, user accounts, permissions, and user tracking.Document configurations, security, activities, maintenance, and operations.Research, recommend, and implement new database applications and architectures.Create or support creation of reports and analytics based on user needs.Assist with building and maintaining a data warehouse system integrating data from distinct systems to support the City's Business Analyst.Assist in developing departmental Key Performance Indicators (KPIs) to provide insights and data-driven results.Plan and manage data migrations and system integrations.Minimum Qualifications
You Have:
Bachelor's degree with coursework in management information systems, database administration, computer science, or a related field.Three years of increasingly responsible experience in database systems.In-depth knowledge of SQL Server, including management studio, licensing, and security; experience with backup procedures, performance optimization, and troubleshooting.Strong understanding of .NET environment, web services, and XML open standard.Familiarity with network architectures (Client/Server, Internet/Intranet, Enterprise), LAN/WAN telecommunications (fiber optics, ethernet switches, routers, and other equipment), and system security principles.Ability to analyze data, solve complex problems, and develop logical solutions for computer applications and programming.Excellent verbal and written skills, including the ability to present technical information in a user-friendly way.Ability to work effectively with others, collaborate with the IT team, and maintain positive working relationships.Willingness to learn new technologies, adapt to changing procedures, and participate in on-call rotations for emergency support.* Successful candidates must maintain local residency (within 100 miles of Durango, CO) upon hire.Supplemental Information
What We Can Offer You:
Comprehensive medical, dental, and vision insurance.Ample personal time off (PTO) and 11 paid holidays.401(a) retirement plan and optional deferred compensation plan.Basic life insurance and accidental death & dismemberment (AD&D) coverage.Long-term disability coverage.Paid Family and Medical Leave (FMLA).Access to Employee Assistance Program (EAP).Free access to the Durango Community Recreation Center and Chapman Hill Ice Rink & Ski Area.Holistic Employee Wellness Program, addressing physical, mental, financial, and professional well-being.Free transit pass and family member discounts.Reimbursement for job-related classes to foster continuous learning.Sixteen hours of volunteer time off per year to support local non-profit organizations.
To view the full job description,
click here.
Belong at the City of Durango:
We believe in creating an inclusive workforce that
welcomes diversity of thoughts, viewpoints, and experiences.
The City of Durango is an Equal Opportunity Employer. We do not discriminate on the basis age 40 and over, color, disability, gender identity, genetic information, military or veteran status, national origin, race, religion, sex, sexual orientation or any other applicable status protected by state or local law. It is our intention that all qualified applicants be given equal opportunity and that selection decisions are based on job-related factors.
We offer a complete benefits package to full-time employees including medical, dental & vision insurance, retirement, deferred compensation plans, flexible spending accounts, life insurance, long-term disability, holidays, and paid time off.
To learn more details, visit our
01
Do you have a bachelor's degree with coursework in management information systems, database administration, computer science, or a related field?
YesNo
02
Do you have three years of increasingly responsible experience in database systems?
YesNo
03
Do you have any relatives who currently work for the City of Durango?
YesNo
04
If you answered yes, provide your relative's name, the department they work in, and their relationship to you.
05
Have you been previously employed by the City of Durango?
YesNo
06
If you answered yes, provide previous City positions and approximate dates for those positions.
07
Have you ever been convicted of a crime, including misdemeanors, deferred sentences/judgements?
YesNo
08
If you answered yes to having been convicted, you are REQUIRED to provide DATE(S) and DESCRIPTION(S) of offense(s) below.
Required Question
$82,999.00 Annually
Location :
Durango, CO
Job Type:
Full-Time
Job Number:
2024-00129
Department:
Information Technology
Division:
Information Technology - 4122
Opening Date:
09/27/2024
Closing Date:
10/11/2024 11:59 PM Mountain
Schedule Details::
Monday-Friday 7:30am to 4:30pm, with frequent schedule variation for out-of-hours maintenance activities. This variation may include weekends and holidays.
Description
Shape and support the City of Durango's database infrastructure as our Database Administrator.
Working within our Information Technology (IT) Department under the broad supervision of the Business Applications Manager, you'll
maintain the resiliency and security of the City's databases . Your responsibilities will include designing, installing, configuring, and migrating data, as well as monitoring performance, troubleshooting issues, and fine-tuning databases for optimal performance. You will serve as the technical point of contact for City database users, applications, and third-party support.
In addition to your database administrative duties, you'll provide data analytical support to customers in collaboration with the IT applications team. You will also provide coverage for team members in system administration and general IT activities.Essential Job Duties
What You'll Do in This Role:
Create and maintain backups, alerts, reports, database integrity checks, and automated jobs.Perform backup recovery, clean up files, update stats, and review error logs.Monitor, audit, optimize, troubleshoot, and establish baselines using Database Management System (DBMS) tools and applications.Plan for DBMS configuration changes, system resources, and workloads.Install, configure, patch, upgrade, and manage DBMS and associated databases.Manage Structured Query Language (SQL) Server security, user accounts, permissions, and user tracking.Document configurations, security, activities, maintenance, and operations.Research, recommend, and implement new database applications and architectures.Create or support creation of reports and analytics based on user needs.Assist with building and maintaining a data warehouse system integrating data from distinct systems to support the City's Business Analyst.Assist in developing departmental Key Performance Indicators (KPIs) to provide insights and data-driven results.Plan and manage data migrations and system integrations.Minimum Qualifications
You Have:
Bachelor's degree with coursework in management information systems, database administration, computer science, or a related field.Three years of increasingly responsible experience in database systems.In-depth knowledge of SQL Server, including management studio, licensing, and security; experience with backup procedures, performance optimization, and troubleshooting.Strong understanding of .NET environment, web services, and XML open standard.Familiarity with network architectures (Client/Server, Internet/Intranet, Enterprise), LAN/WAN telecommunications (fiber optics, ethernet switches, routers, and other equipment), and system security principles.Ability to analyze data, solve complex problems, and develop logical solutions for computer applications and programming.Excellent verbal and written skills, including the ability to present technical information in a user-friendly way.Ability to work effectively with others, collaborate with the IT team, and maintain positive working relationships.Willingness to learn new technologies, adapt to changing procedures, and participate in on-call rotations for emergency support.* Successful candidates must maintain local residency (within 100 miles of Durango, CO) upon hire.Supplemental Information
What We Can Offer You:
Comprehensive medical, dental, and vision insurance.Ample personal time off (PTO) and 11 paid holidays.401(a) retirement plan and optional deferred compensation plan.Basic life insurance and accidental death & dismemberment (AD&D) coverage.Long-term disability coverage.Paid Family and Medical Leave (FMLA).Access to Employee Assistance Program (EAP).Free access to the Durango Community Recreation Center and Chapman Hill Ice Rink & Ski Area.Holistic Employee Wellness Program, addressing physical, mental, financial, and professional well-being.Free transit pass and family member discounts.Reimbursement for job-related classes to foster continuous learning.Sixteen hours of volunteer time off per year to support local non-profit organizations.
To view the full job description,
click here.
Belong at the City of Durango:
We believe in creating an inclusive workforce that
welcomes diversity of thoughts, viewpoints, and experiences.
The City of Durango is an Equal Opportunity Employer. We do not discriminate on the basis age 40 and over, color, disability, gender identity, genetic information, military or veteran status, national origin, race, religion, sex, sexual orientation or any other applicable status protected by state or local law. It is our intention that all qualified applicants be given equal opportunity and that selection decisions are based on job-related factors.
We offer a complete benefits package to full-time employees including medical, dental & vision insurance, retirement, deferred compensation plans, flexible spending accounts, life insurance, long-term disability, holidays, and paid time off.
To learn more details, visit our
01
Do you have a bachelor's degree with coursework in management information systems, database administration, computer science, or a related field?
YesNo
02
Do you have three years of increasingly responsible experience in database systems?
YesNo
03
Do you have any relatives who currently work for the City of Durango?
YesNo
04
If you answered yes, provide your relative's name, the department they work in, and their relationship to you.
05
Have you been previously employed by the City of Durango?
YesNo
06
If you answered yes, provide previous City positions and approximate dates for those positions.
07
Have you ever been convicted of a crime, including misdemeanors, deferred sentences/judgements?
YesNo
08
If you answered yes to having been convicted, you are REQUIRED to provide DATE(S) and DESCRIPTION(S) of offense(s) below.
Required Question