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
-
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
-
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
-
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
-
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
-
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
-
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
-
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.
-
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.
-
Bachelor’s degree in computer science or a related field.
-
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.
-
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.
-
Valid Colorado Driver’s License.
-
MS SQL Server certification is strongly preferred.
-
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.
-
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.
-
Standard business and professional tools and equipment including computers, laptop computers and mobile computing devices.
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.
GatedTalent consolidates jobs from a variety of sources. Users of the “Talentis” and “FileFinder” executive search CRMs are able to publish jobs to the site with links from inside their core business apps. These are supplemented by jobs added by our own researchers and those provided by a third party job aggregation service. Please note that GatedTalent staff are not directly involved in the recruiting process.
You don't have credit card details available. You will be redirected to update payment method page. Click OK to continue.