Salary : $90,754.30 – $127,056.02 Annually
Location : Brighton, CO
Job Type: Regular Full-time
Job Number: 06155
Department: IT & Innovation
Division: ITi Application Services
Opening Date: 10/23/2023
Closing Date: 11/20/2023 4:30 PM Mountain
Our Mission: At Adams County, our team members engage in top-notch opportunities to grow and expand their impact. We cultivate an inclusive and innovative culture where diversity matters! Diversity, Equity & Inclusion (DEI) is a core cultural competency at Adams County, and we actively seek and welcome applicants that bring diverse experiences and value inclusion.
Position classification: Hybrid — Job duties and expectations allow for onsite and remote work scheduled every week. Employees in this classification are regularly scheduled onsite one (1) to four (4) days per week based on the County needs and as determined by Department Director. Hybrid classified roles can be onsite more than the set minimum based on employee preference.
What Success Looks Like In This Job
Perform complex professional work in database administration, and computer applications systems development / administration in support of Adams County business objectives.
Examples of Duties for Success
- Database Administration
- Collect and analyze business, functional and technical requirements for database software purchases and implementations.
- Database design, development, implementation, quality assurance, and maintenance, including managing roles and permissions, performance monitoring, deploying updates, and ensuring availability and security.
- Database backups, restores and regular testing of backup integrity.
- Database conversions; automate database jobs such as SQL Server Integration Services Package execution and SQL Server Agent jobs, Data modeling, Data analysis, and ETL Development.
- Refine and automate regular processes, track issues and document changes, assist other members of the team with complex query tuning and schema refinement.
- Long term strategic planning for database availability, capacity, and growth
- Performs a variety of complex and technical duties in the design, programming, testing, and maintenance of an assigned set of computer applications and/or data.
- Use current programming languages and technologies, write code, complete programming, perform testing, and debugging of applications.
- Administers complex commercial off the shelf software applications.
- Maintains an advanced understanding of essential systems
- Works with end users to design application solutions with minimal supervision.
- Assists users in implementing and supporting application systems including installation, documentation, training, troubleshooting, and modifying.
- Utilizes quality assurance testing, implementation and maintenance of developed applications.
- Creates clear and functional documentation of all development projects, ensuring maintainability by other personnel.
- Adheres to all applicable security standards such as CJIS and PCI
- Solves unique and complex problems that have a broad impact on agency business
Qualifications for Success
- Strong working knowledge of industry standard database software including Microsoft SQL Server and Oracle with emphasis on MS SQL. Knowledge of open source platforms such as MariaDB and MySQL a plus.
- Ability to demonstrate thorough working knowledge of DBA principles, such as performance, disaster recovery, and security. Understands data warehousing concepts.
- Technical proficiency in programming languages and development. Thorough understanding of structured programming principles, system analysis techniques, system design, industry standards, system implementation, user training, and documentation.
- Knowledge of C, C#, C++, Java, .NET, Visual Studio
- Working business knowledge of Electronic Document Management systems a plus
- Understand and utilize best practice data protection and system security standards such as CJIS and PCI.
- Ability to effectively interact with others, work autonomously with minimal supervision, organize, prioritize and multi-task
- Strong team player, willing to support multiple teams and requirements, even outside normal area of expertise
- Ability to learn and utilize new skills and systems. Apply these new skills and systems in a manner that will benefit Adams County.
- Communicate clearly and concisely, both orally and in writing.
- Establish, maintain, and foster positive and harmonious working relationships with those contacted during work.
- Champion innovation
More Qualifications for Success
- Experience: Six (6) years professional and technical experience in a relevant field of database administration and programming.
- Education and Training: Bachelor’s Degree in Information Technology or related field
- License or Certificate: None.
Background Check: Must pass a criminal (CBI) background check
Adams County provides a comprehensive benefits package to employees that goes above and beyond what is offered at most organizations.
Click to watch our video about why Adams County is an Employer of Choice!
Benefits You Expect:
- AFLAC Supplemental Medical Insurance
- Basic Term Life & Optional Term Life Insurance
- Deferred Compensation Plan
- Dental/Vision/Medical Plans
- Generous Vacation/Sick leave
- Long-Term Disability
- Retirement Plan
- Short-Term Disability
Plus some you might not expect:
- Employee Assistance Program
- Employee Fitness Center
- Employee Health Clinics
- Flexible Work Schedules
- Recreation Center Discounts
- Training & Tuition Reimbursement Programs
- Wellness programs
- Lactation friendly certified workplace
01
Please be aware that your cover letter and resume will not be accessed in the initial screening process, so you must complete your application and supplemental questions with as much detail as possible. Any personally identifiable information (PII) such as name and address will be redacted from applications that meet the minimum screening requirements and are forwarded to the hiring manager. If the hiring manager selects you to advance in the hiring process, your cover letter and resume will then be accessible to the hiring team. Information provided on the application is used to determine if a candidate meets minimum qualifications. Only information provided at the time of the application being completed will be considered and additional information that is not listed on the application will not be considered when deciding if a candidate meets or does not meet the qualifications. Applicants are STRONGLY encouraged to include all information and details on their application. I understand and agree that only information provided at the time of my application will be used to determine if I meet the minimum requirements for this position.
- Yes, I understand and agree
- Yes, I understand but disagree.
02
Do you possess at least 6 years professional and technical experience in a relevant field of database administration and programming?
- Yes
- No
03
Do you possess a Bachelor’s Degree in Information Technology or related field?
- Yes
- No
04
What database platforms have you administered?
05
What programming languages are you familiar with?
06
Describe any enterprise wide COTS software applications you have administered.
Required Question