Job: Systems / Database Administrator

This posting has expired and is no longer available.

Job Description

Overall Job Objective

Job Title:Systems / Database Administrator
Closing Date/Time:Fri. 09/22/17 5:00 PM Mountain Time
Salary:$2,700.00 - $3,442.31 Biweekly
$70,200.00 - $89,500.00 Annually
Job Type:Full-time
Location:Littleton Center, 2255 W Berry Ave, Littleton, Colorado
 
The City of Littleton's Information Services department has an opening for a Systems/Database Administrator. The Systems/Database Administrator (SDBA) is responsible for supporting the city's databases and ensuring their performance, availability, and security. In addition to the SDBA administering and supporting the city's database technology the SDBA is responsible for in-house, client-server and web based application development using the System Development Life Cycle. This position has technical expertise in designing, building, tuning, installing, configuring, developing, coding and troubleshooting applications and databases. The position ensures that projects are delivered on-time, within scope, and budget. 

The City of Littleton offers a comprehensive benefits package like generous vacation, floating holiday and sick time, retirement matching, a wellness program, dental and vision free for the employee and a dedicated employee clinic...to name a few!
 Essential
Duties & Responsibilities:

The following statements are illustrative of the essential functions of the job and do not include other nonessential or peripheral duties that may be required.  The organization retains the right to modify or change the duties or essential functions of the job at any time.
 
  • Provides support in architecture planning, installation, monitoring, configuration, administration, testing, evaluating, programming, and troubleshooting for all database and application technologies.
  • Collaborates with other IS team members and customers for adherence to best practices and process standardization. 
  • Monitors and ensure high availability of environment and quickly respond and problem source identification and resolution.
  • Utilizes and leverages new features of all underlying technologies. 
  • Authorizes and administers security for various applications including determining security requirements for access to critical systems and files.
  • Prepares and maintains documentation on procedures, fixes, and in-house developed applications.
  • Designs, prepares and modifies reports for multiple applications using a variety of report writers such as SQL SSRS, Crystal Reports, MS Access and other proprietary report writers.
  • Provides documentation and training for users in the use and maintenance of system applications.
  • Develops and maintains applications and databases by: evaluating client requirements, analyzing, designing, developing, testing, documenting and implementing a solution.
  • Manages projects by: leading and/or assisting in the definition of project scope and objectives; ensuring resource availability and allocation; developing a detailed project plan; managing changes to the project scope, project schedule, and project costs; managing the relationship with the client and all stakeholders; performing risk management; performing change management; and creating and maintaining comprehensive project documentation.
  • Evaluates and responds to requests for service and assistance from users and customers regarding software and database related systems.
  • Provides realistic and feasible technical solutions for the city's information technology needs. Identifies, evaluates and purchases computer software and hardware.
  • Answers telephone calls and responds to written communications. Through thoughtful and knowledgeable questioning, determines the customer needs and provides the information or assistance to satisfy the customer needs; responds to inquiries and complaints from customers.
  • Observes and follows established city and department policies and procedures in the daily conduct of the job.
  • Plans and arranges work schedule and establishes priorities to complete scheduled, assigned work within the time frame and parameters assigned by the Software Services Manager.
  • Delivers work products and services with responsiveness, courtesy and tact in personal interactions with customers. Work products and services are delivered within the assigned work schedule, as defined by the Information Services Department Flexible Work Schedule (FWS). The work schedule includes a requirement to carry a cell phone and be available to respond to significant information system problems or failures that may occur during nighttime or weekend hours, as well as during designated rotating on-call schedules. This position may need to work additional hours before and after schedule work hours including weekends to complete their work assignments.
  • Works with minimal supervision and receives general direction from the Software Services Manager.
  • Must be able to work independently or in teams on assigned tasks with a high degree of technical competence and judgment.
  • May be required to serve as an Emergency Worker.
  • Performs other assignments, projects and duties as required.
 
REPORTING RELATIONSHIPS & SUPERVISORY DUTIES:
This Position Reports To:  Software Services Manager
This Position Has Supervisory Responsibility For:  None
 Education, Formal Training & Experience:
  • Bachelor's Degree in Computer Science or Information Technology, related field or equivalent work experience.
  • 3+ years of increasing responsibilities in computer application, client server, and web development and database administration.
  • 3+ years of increasing responsibilities in Microsoft SQL Application Development and Database Administration. 
  • 3+ years of proven independent support in a complex SQL database environment.
  • 3+ years designing, building, tuning, installing, configuring and troubleshooting database interfaces, data import / exports tools, and report writing tools.
  • Project management certification would be a plus.
  • Change management certification would be a plus.

 Knowledge, Skills, Abilities:
  • Experience supporting and developing in house and web applications.
  • Experience with server administration and troubleshooting.
  • Application analyst experience. 
  • Project Management experience.
  • Change Management experience.
  • GIS experience.
  • Knowledge of Relational database concepts, modeling, design, creation and maintenance.
  • Experience in programming languages such as JavaScript, Html, ASP.Net, MS MVC, C#, VB.net, Python, SQL, TSQL, SSIS, and Shell Scripts. 
  • Working knowledge of Windows Operating Systems (desktop and server editions).
  • Proven troubleshooting and problem solving skills for critical database, application, networking and system administration issues.
  • Experience with other RDBMS systems such as IBM's DB2 would be a plus.
  • Ability to prioritize workload effectively and work effectively under pressure and with a high degree of independence. Effective in meeting deadlines.
  • Strong knowledge of business intelligence concepts and technologies. 
  • Ability to fully document technical specifications and related project or systems-level documentation. 
  • Ability to interface effectively and collaborate with customers, peers, and management to troubleshoot issues, develop solutions and ensure stakeholder buy-in. 
  • Critical thinking skills, ability to accurately analyze information and make sound decisions. 
  • Must be versatile, flexible, and proactive when resolving technical issues. 
  • Ability to handle diverse situations and rapidly changing priorities with deadlines.
  • Expert knowledge of the Microsoft Office Suite; solid knowledge of security techniques; basic knowledge of e-mail systems, internet browsers; and the skill and ability to apply that knowledge to perform the essential duties and responsibilities of the position. 
  • Requires expert knowledge and understanding of, and the ability to stay current with, the changing field of information technology, including its applications and current practices and uses.
  • Requires emotional stability and maturity, sound judgment, understanding, empathy and the ability to: apply knowledge, logic and reasoning to make prompt and effective decisions and act on those decisions with decisiveness and assertiveness; quickly and effectively evaluate alternative courses of action and select the most appropriate alternative. 
  • Requires writing skills necessary to write clear, concise documents explaining procedures, fixes, and modifications to applications, reports, installations and other operations.
  • Requires the skill and ability to: establish and conduct verbal communications through speaking, talking and hearing; effectively communicate and interact with individuals (e.g. vendors, technical support, co-workers and customers) or groups of individuals of varying social, cultural, economic, professional and educational backgrounds, including the ability to effectively deal with individuals who may be 
  • angry, argumentative or disagreeable; the ability to act with tact, good judgment and discretion; and maintain the confidentiality of matters, as appropriate.
  • Requires the ability to read, understand and interpret English language manuals and other written materials including, but not limited to: application manuals, systems documentation and application reference manuals; and the skill and ability to apply knowledge and information gained from these materials to effectively perform the essential functions of the position. 
  • Requires the ability to: maintain composure and perform effectively in stressful situations; and manage conflict effectively; efficiently and effectively deal with constant interruptions and requests for assistance; effectively prioritize work efforts to separate tasks which are urgent in nature and deal with them immediately and schedule the remaining requests for subsequent resolution while continuing to work on the task at hand.
  • Requires possession of a valid Colorado driver's license appropriate for the type of vehicle to be operated and the ability to safely and effectively operate a personally-owned or city vehicle when used for city business; requires a qualifying driver's history as prescribed by the city.

MATERIALS AND EQUIPMENT DIRECTLY USED:
  • Position uses: a personal computer with assigned software; telephone, photocopier, cell phone; and a personal vehicle or city vehicle, when required for city business.
  • Position operates program applications on: Microsoft Windows operating systems, Microsoft Office, Google Apps for Government, and Microsoft SQL.

WORKING ENVIRONMENT & PHYSICAL ACTIVITIES:
  • Physical activities include: visual discrimination, color vision and field of vision; talking, and hearing; lifting, carrying, pushing or pulling objects weighing up to 40 pounds; occasional climbing, balancing, stooping, kneeling, crouching, crawling, reaching, handling, and feeling. 
  • Long periods of sitting, standing or walking may be required.
  • Environmental conditions encountered in this position include: constant exposure to light noise associated with humming of computer and cabinet fans.
  • The following mental abilities are needed to perform the essential duties of this position: alertness, precision, ingenuity, problem-solving, analytical ability, tactile discrimination, speaking ability, memory, concentration, judgment, reasoning, initiative, patience and visual discrimination; other mental abilities needed include spatial perception, creativity, and writing ability;

 

 

If you want to express interest in future roles with City of Littleton, please submit your information here.

Volunteer Interest Card