15151 E Alameda Pkwy Aurora, Colorado 80012-1555

City of Aurora, Colorado

It is an exciting time to work for the City of Aurora, we’re growing and looking for dedicated and collaborative individuals to join our team of talented and valued employees. Excellent organizations have a set of principles, or core values, that are used to implement their mission and vision. Those values represent the touchstone for the organization, guiding the decisions of the individuals and the organization. At the City of Aurora, we demonstrate our excellence by modeling the CORE 4 Values of: Integrity, Respect, Professionalism, and Customer Service, and we welcome all who share these values to apply.

Why Work for Aurora?

• Make a difference in the lives of real people every day
• Diverse community
• Competitive total compensation package
• Well-Funded General Employees Retirement Plan
• Light rail station minutes away
• On-site fitness center and overall employee well-being programs Internal educational programs to assist with career advancement
• Access to innovation workspaces

Primary Duties & Responsibilities

The Hiring range for this position is $102,080-$127,600/Annually

The deadline to submit applications is June 5th, 2025. Please note, The City of Aurora will conduct ongoing screenings of applications on a first come, first-serve basis; as soon as we determine to have a qualified pool of applicants, this position may close quickly and without notice.

THE POSITION

It is an exciting time to work for the City of Aurora, we’re growing and looking for dedicated and collaborative individuals to join our team of talented and valued employees. Excellent organizations have a set of principles, or core values, that are used to implement their mission and vision. At the City of Aurora, we demonstrate our excellence by modeling the CORE 4 Values of: Integrity, Respect, Professionalism, and Customer Service, and we welcome all who share these values to apply. All Senior Level DBAs are encouraged to apply!

A TECH CULTURE DRIVEN BY PURPOSE

In the City of Aurora’s IT department, we view business as an ecosystem rather than a competitive landscape. Our team exists with the sole purpose of serving our community and its constituents.

Our empathic culture helps us be mindful of the impact our day-to-day relationships can make on our ability to achieve our goals within the technology ecosystem we build and support.

Embracing different perspectives—in and out of the office—allows us to elevate the quality of our work and our culture as well as optimize the ways in which we deliver products and services. The work we do is valued, important and rewarding; we strive to provide a work environment that listens to, understands and trusts its employees.

Our IT Department Encourages Employees To Be

• Transitional: Constantly adapting to new technologies and the changing needs of our city
• Dedicated: Committed to making the best decisions for our city, its citizens and the community
• Optimizing: By making the most of every resource we have available
• Empathic: In our ability to understand and have compassion for the feelings and needs of our citizens, customers and coworkers

MEET THE IDEAL CANDIDATE

Our ideal candidate is dynamic, enterprising, humanistic, communicative, and a lifelong learner.

Dynamic

Do you…

• Enjoy a variety of work roles and responsibilities
• Pivot quickly between consistent/ongoing priorities and new/challenging activities
• Believe that technology problems can have more than one solution

Enterprising

Will you…

• Show initiative and drive projects to completion
• Be resourceful and find or invent a solution
• Be organized, highly focused and productive with use of time and resources

Humanistic

Are you…

• Inspired by making a meaningful difference in the lives of others
• Compassionate for and patient with coworkers and the community that COA serves
• Humble when working with others

Lifelong Learner

Have you…

• Shared knowledge with others while being open to learning from colleagues
• Relied on knowledge and expertise to a degree, but have also been inventive and imaginative when solving problems
• Proactively sought professional improvement opportunities

Communicative

Can you…

• Respect others’ time, ideas and contributions
• Act as a diplomatic, reliable source of information to internal and external constituents
• Facilitate communication and collaboration with others to solve problems

WHY WORK FOR THE CITY OF AURORA?

• Competitive total compensation package
• Well-Funded General Employees Retirement Plan
• Light rail station minutes away
• On-site fitness center and overall employee well-being programs
• Internal educational programs to assist with career advancement.

WHAT DOES THE ROLE ENTAIL?

Provides primary support in the maintenance, installation, configuration of Microsoft SQL Server and other relational, line of business database services. Reporting development/support, reporting databases, developing packages and triggers along with procedures to improve application performance. Establishes and maintains DEV/TRAIN/PROD instances. Interacts with other IT Divisions and City employees.

WHAT ARE THE DAY-TO-DAY EXPECTATIONS?

• Primary support for all lines of business Microsoft SQL Server instances, including all upgrades and migrations to new versions when necessary. Provides support as required for other databases.
• Administers production SQL Server Reporting Services, Integration Services, and SQL Agent Jobs.
• Responsible for the configuration and management of production SQL Server (Always on Availability groups/Mirroring/Replication), ensuring a highly available SQL Server production environment.
• Assist with the deployment of SQL products and services in development and COTS application deployment as required.
• Ensure all database servers are backed up and tested to meet the business’s Recovery Point Objectives (RPO).
• Performs database services such as job processing, tuning, archiving, and installing upgrades to test and production database environments.
• Co-Lead the future implementation of Business Intelligence, Data Lakes, Data Warehouses, Business Analytics, as resources and funds allow.
• Responsible to ensure that the SQL Server environment meets established security requirements.
• This position may serve as the lead on specific projects or initiatives.
• Performs additional duties as assigned.

Education

MINIMUM QUALIFICATIONS & WORKING CONDITIONS

• Bachelor’s degree in computer science or a related field.

Experience

• 5 years of experience as Database Administrator of Microsoft SQL Server 2008 or higher.
• 2 years of Windows Server administration, including experience in Web application implementation in a Microsoft SQL Server environment.

Knowledge

• Working knowledge of Windows Server and Desktop .
• Advanced knowledge in administration and tuning of a Microsoft SQL Server and other relational databases.
• Experiencing support cloud and, especially, virtualized on-site instances using tools such as DH2i’s DxEnterprise or Nutanix’s NDB.
• Documentation of technical procedures.
• ITIL Foundation qualification.
• Skill in technical writing desired.
• Knowledge of migrating SQL to cloud or virtualized platforms is a plus.
• Familiarity with SSRS or other reporting tools.
• Ability to work with customers to elicit and help them define their requirements.

Licenses Or Certificates Required

• Valid Colorado Driver’s License.
• MS SQL Server certification is strongly preferred.

WORKING CONDITIONS

Physical Demands

• Light physical work requiring ability to life a maximum of 50 pounds, including lifting 25 pounds overhead.
• Regular lifting and carrying of computer equipment.
• Moderate walking and standing.
• Vision to read and interpret reports and other written documents.
• Hand/eye coordination for operation of computer keyboard.
• Frequent speech communication and hearing to maintain communication with managers, employee users and citizens.

Work Environment

• Normally works in a clean, comfortable environment.
• System support issues may require working outside the office environment and in or around emergency response vehicles.
• This position generally is remote but must be able to come to the Office as needed. Employee must be in Colorado.

Equipment Used

• Standard business and professional tools and equipment including computers, laptop computers and mobile computing devices.

For Veterans preference: Please show all of your employment history, including military service and related documentation (DD214) on the application.

The City of Aurora is an equal opportunity employer. We are required by state and federal agencies to keep certain statistical records on applicants. It will not be used in any way to discriminate against you because of your sex, race, age, sexual orientation, creed, national origin, disability or military status, gender identity, unless related to a bona fide occupational qualification as defined by the Colorado Civil Rights Commission and the Equal Opportunity Commission.

Despite the changes in Colorado law, the City of Aurora maintains a drug-free workplace. A positive test of marijuana is grounds for disqualification and ineligibility for employment with the city for one year or termination once hired.

Drug Testing, Thorough Criminal Background Check, And Employment References

As a condition of employment, all applicants selected for employment with the City of Aurora must undergo a thorough criminal background check and drug screening. Employment references will be conducted on finalists for City of Aurora vacancies.