Database Administrator - IT Application Services

Full Salary Range:                       $88,200 - $123,500 Annually
Anticipated Hiring Range:       $88,200 - $105,850 Annually

Why do I see two salary ranges?
The City of Greeley in compliance with Colorado state law, includes a salary range for all positions posted.  This law is intended to improve wage transparency.  The City of Greeley, in support of wage transparency, posts both the full salary range for each position (what you might anticipate your earnings could be if you work for the City of Greeley for some time), as well as the anticipated hiring range (the range within which the City anticipates making an offer).  The actual offer extended will be based on your years of relevant experience, education, certifications and potentially other factors.

City of Greeley's Total Rewards
The City of Greeley is proud to offer a robust benefits package in addition to your wages.  This package includes health and wellness, retirement savings, discounted access to Greeley facilities and more. 

Benefits: This position is benefit eligible. Please view our benefits guide here.

City of Greeley:  Work, Live, and Play in Greeley:  https://youtu.be/hX-4F0pG0OY

Job Summary:

The City of Greeley is seeking a Database Administrator to join our Application Services team in IT.  This position reports to the Application Services Manager and will enhance database performance, perform restores, implement recovery procedures, handle performance tuning, and conduct regular system backups, while ensuring technical and functional designs meet business requirements. This position is responsible for configuring, maintaining, managing, monitoring, and supporting various City departmental databases and applications including SQL Server Database, Community Development, Laserfiche, SalesTax, RecTrac, and FullCourt.

Furthermore, you will maintain, troubleshoot, tune, secure, support, and design servers and databases, while collaborating with others to resolve technology issues. This includes communicating with customers, evaluating business processes and requirements, organizing, communicating, and following through on goals, deadlines, and expectations.

Experience, Knowledge, Skills:

Minimum Requirements

• Bachelor's degree.
• Typically requires a basic understanding and application of theoretical or scientific principles, acquired through college education or advanced vocational skills strengthened by three to five (3-5) years of on-the-job experience.
• Experience with complicated IT practices and precedents.

OR 

• Any combination of related education, experience, certifications and licenses that will result in a candidate successfully performing the essential functions of the job,

AND 

• Possession of a valid driver’s license.

Preferred

• Knowledge of computer hardware and software, including processors, internal hardware dynamics, applications and programming.
  • Specifically, SQL, SQL Server Management Studio, SQL Server Profiler, database monitoring tools, server monitoring tools, collaboration tools, Confluence Jira, BitBucket SQL Server, SQL Server Integration Services, SQL Server Reporting Services, Kanban vSphere, and VMWare.

Knowledge, Skills, and Abilities

• Knowledge of information technology service management (ITSM) principles and best practices.
• Knowledge of cybersecurity and privacy principles and best practices.
• Knowledge of common computer operating systems.
• Knowledge of computer networking fundamentals.
  Technical computer skills, including the ability to assess complex data, utilize common operating systems, learn new software programs, and understand programming languages.
• Computer programming skills, including the ability to evaluate and solve problems, stay organized, be cognizant of and address details, and utilize common programming languages (e.g., SQL, SQL Server Management Studio, SQL Server Profiler, database monitoring tools, server monitoring tools, collaboration tools, Confluence Jira, BitBucket SQL Server data tools, SQL Server Integration Services, SQL Server Reporting Services, Kanban vSphere, VMWare, etc.).
• Ability to collect and document business needs and translate the information collected into technical specifications.
• Ability to write technical documentation and specifications with the intention that it be easily understandable to the target audience.
• Ability to translate and explain technical concepts and vocabulary in common terms to non-technical audiences.
• Ability to learn and apply new technologies.
• Ability to prepare reports and briefings that can be understood by a variety of technical and non-technical audiences.
• The nature of the tasks typically requires a specialized field of knowledge within the IT field.
• Knowledge of the business and organizational structure of Colorado municipalities.
• Collaboration skills, including the ability to work with others from different areas and backgrounds to reach a common goal.
• Computer skills, including the ability to utilize Microsoft Office programs (i.e., Word, Excel, PowerPoint, Outlook, etc.) and learn and experiment with new software and systems.
• Interpersonal skills, including the ability to facilitate interaction, communication, and teamwork between others.
• Oral, written, and listening communication skills, including the ability to accurately interpret what others are saying and convey messages, information, concepts, and details accurately and clearly.
• Organizational skills, including the ability to set and meet goals and deadlines, manage appointments, create schedules, coordinate and facilitate meetings, and make decisions.
• Ability to work under pressure, manage multiple concurrent and competing tasks and responsibilities, and adapt to changing priorities while maintaining personal effectiveness.
• Ability to prioritize work, meet deadlines, and stay on task when completing special projects and daily assignments.
• Ability to work independently with minimal supervision and reliable professional judgment, as well as collaboratively with a team to achieve desired results.
• Ability to maintain a strong work ethic, positive problem-solving attitude, and enthusiasm for the work performed.
• Ability to self-start and take initiative in completing daily tasks and special projects.
• Ability to focus on activities that have the greatest impact on meeting work commitments.
• Ability to communicate and work effectively with individuals from diverse backgrounds, cultures, and ages.
• Ability to navigate a complex political environment.

Essential Functions:

• Database administration including designing a database infrastructure to ensure system scalability, performance, and reliability; configuring, implementing, maintaining, troubleshooting, tuning, upgrading, securing, monitoring performance statistics, coding, reporting, and migrating data.
• Project management, including identifying the appropriate stakeholders and resource needs.
• Leads stakeholders to ensure that the scope and business requirements are met.
• Monitors the progress of the project by communicating and following through on project deadlines and expectations.
• Designs databases including gathering business requirements from customers, coordinates with the application developers, and designs databases that will meet both the technical needs of the developers and the business requirements of the customers.
• Identifies, analyzes, and resolves technical issues regarding organizational server infrastructure and server performance.
• Designs, configures, implements, tunes, upgrades, and secures servers.
• Performs business integration and reporting services which includes consulting with customers to identify their processes, reporting and integration requirements, designing, coding, developing, maintaining, and supporting reporting, extraction, transformation and loading processes to integrate organizational systems and to consolidate or import data that can be used for creating customer and system reports.
• Creates, edits, and maintains technical documentation and instructions for servers, databases, applications, and processes.
• Consults with customers to identify appropriate technical solutions, develops standards and guidelines, and communicates technical actions and expectations to a diverse audience of both technical and non-technical users.
• Collaborates with other Development staff to determine database requirements for new applications that they are developing.
• Gathers information about business processes and needs, communicate technical requirements that are needed to support business expectations.
• Organizes and facilitates planning meetings, monitors and follows through with customers to assure that deadlines and expectations are met.
• Contacts vendors to get technical specifications and quotes for software and hardware to assure that the technical requirements that have been stated by City of Greeley project teams are being met.
• Gathers information about the departments business metrics and determine how they needs to view their data.
• Collaborates with departments to develop reports that meet their business requirements.
• Collaborates with other Systems Administrators to design and develop a server infrastructure to ensure system scalability, performance, reliability and to makes recommendations to upper management regarding the technical and financial resources that are needed to support technology.
• Consults with vendor to troubleshoot technology issues with software and/or hardware.
• Problem solves and performs decision making: Work is defined by policies, principles, and departmental objectives.
• Performs other duties as assigned.

Supervisory Responsibilities:  N/A

Travel:  Approximately 10% flexible, local travel required.

Work Environment and Physical Requirements:

Work Environment

• Work is primarily performed in an office environment.

Physical Requirements

• While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear.
• Vision enough to read computer keyboards, reference books and other written documents.
• Minimal physical effort typically found in clerical work.
• Primarily sedentary, may occasionally lift and carry light objects.
• Walking and/or standing as needed and minimal.

EOE Statement: The City of Greeley provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

ADA Statement: We are committed to an inclusive and barrier-free search process. We provide accommodations for applicants requesting accommodation through the search process such as alternative formats of this posting.  Individuals with disabilities in need of accommodations throughout the search process should contact the ADA Coordinator at: HR@Greeleygov.com .

Conditions of Employment: Candidates must successfully complete all pre-employment screenings and employment eligibility verification. Pre-employment screenings include a drug test, a background and national sex offender search, a motor vehicle record search, and for some positions, a physical demands evaluation. For more information about City policies and practices during the recruitment process, including but not limited to EOE, Reasonable Accommodation, and pre-employment screenings, please visit our career page HERE.  

Salary : $88,200 - $123,500